Creation of assembly's in web i report

[Former Member]

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.

[Former Member]

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.

[sateesh_kumar1]

Hi Suresh ,

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

[Former Member]

Hi sateesh

Logic might be there, user have some calculations based on this assembly breaks.i also exactly don't know the logic behind that. plz help me how to do it in web-i.it is very important and urgent also. plz reply

Thanks & Regards

Suresh

[sateesh_kumar1]

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 .