Skip to Content
avatar image
Former Member

Creation of assembly's in web i report

Hi

Experts

Am having a Web i report on Excel as a source The following is the report format.

Mat type
Unit Amount 1 Amount2 Marble Sft 56 56200

Iron

Per tonn 38500 256400

Bricks

Per piece 6 5600 Sand Brass 1800 56890 Cement Bags 250 32500 Crushed Sand Brass 1900 59630 White Cement Bags 260 35000

The above is my current report format.

Now my requirement is to set up the assembly's in the same report.i want to make assembly based on MAT TYPE dimension. Sand,Cement,Crushed sand,White Cement are common for every table.

The following is my report requirement

Mat Type Unit Amount 1 Amount 2 Marble Sft 56 56200 Cement Bags 250 32500 Crushed Sand Brass 1900 59630 White Cement Bags 260 35000

Mat Type Unit Amount 1 Amount 2 Iron Per tonn 38500 256400 Cement Bags 250 32500 Crushed Sand Brass 1900 59630 White Cement Bags 260 35000

Mat Type Unit Amount 1 Amount 2 Bricks Per piece 6 5600 Cement Bags 250 32500 Crushed Sand Brass 1900 59630 White Cement Bags 260 35000

Mat Type Unit Amount 1 Amount 2 Sand Brass 1800 56890 Cement Bags 250 32500 Crushed Sand Brass 1900 59630 White Cement Bags 260 35000

i want like this assmebly's.

Can anybody plz reply.

help full answer must be appreciated.

Thanks & Regards

Suresh Gaddam.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Dec 30, 2014 at 08:41 AM

    Hi Suresh ,

    Why is it to repeat cement ,crushed sand and white cement in each table ?What is logic?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Suresh ,

      Apply filter on table.Mat Type not inlist Cement,Crushed Sand and White cement

      Apply break on Mat Type .Insert 3 footer rows for every value in the break.

      In first row ,

      place text : Cement

      for values : write [Amount1] where (Mattype="Cement")

      similarly to all objects.

      This solution is static and not recommended .

  • avatar image
    Former Member
    Jan 05, 2015 at 07:03 AM

    with Excel as a source, if your table is not very data intensive and not too many variations on Mat_type. You can quickly go for multiple tables with desired filters.

    Add comment
    10|10000 characters needed characters exceeded