Issue with report data grouping / table layouting

[gwoo]

Hello,

I have some problems to accomplish following report layout with Table/Tablix/Matrix control in report designer?

I simplified my issue to following easy scenario. Let's say I have data like this in my dataset:

How can I design a report that groups and layouts the data in a way like:

I have tried this with different groupings as well as a subreport for the centered "extra line"-productgroup, but I can't do it. Would be awesome if you have an idea!

best regards

[Mahendran Shanmugam]

Hi Gert, 

 

Yes, we can able to create the report with your requirement. Please find the below example for your reference. 

1.Created the dataset with below column. 

a.DepartmentID 

b.Name 

c.GroupName 

d.ModifiedDate 

 

2.Created the table with below columns as shown in below snap. 

a.DepartmentID 

b.Name 

c.ModifiedDate 

 

 

3.Created the group with GroupName as shown in below snap. 

 

 

4.Delete the GroupName column with “delete column only” option as shown in below snap. 

 

 

5.RightClick the detail row, select the insert Row button and choose the Outside Group – above option as shown in below snap. 

 

 

5. Add the GroupName in center column as shown in below snap. 

 

Output: 

 

 

We have prepared the simple RDL file for your reference and it can be downloaded from below location. 

RDL: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Grouping960628638.zip 

 

Regards, 

Mahendran S. 

[gwoo]

Wow, thanks a lot for that fast help. That trick does the job!

Tried it first in WPF designer, which did not work. After creating in web designer it worked, also when viewing the file from the web designer with the WPF viewer... strange

Another short question: Any chanc to alternate the background color of the detail row? =IIf(RowNumber(NOTHING) MOD 2, "","LIGHTGRAY") doesn't seem to work, maybe because of the grouping?

cheers

[Mahendran Shanmugam]

Hi Gert, 

Thanks for your update. 

Could you please confirm are you asking how to set the expression for background color in web report designer. If yes please find the below step how to set the expression for textbox. 

1.Click the textbox, go to the property panel and click the check box of the background as shown in below snap. 

 

2. Choose the expression and provide expression as shown in below snap. 

 

If we misunderstood your requirement then could you please share some additional details to validate this issue. 

Regards, 

Mahendran S. 

[gwoo]

Yes it's about setting the background color by expression, but my problem ist not the setting itself - it is the correct setting/expression for alternate row colors.

Related to your appreciated example from above, i would like to have alternating row background colors of the department rows.

Something like this:

[Vinoth Srinivasan]

Hi Gert, 

 

Sorry for the inconvenience caused. 

 

Currently we don’t have multiple selection for Tablix rows. So, could you please pass the expression for all columns in rows separately as shown in below snap. 

 

 

 

Output snap: 

 

We have prepared the simple RDL file for your reference and it can be downloaded from below location. 

RDL: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Grouping1816817793.zip 

 

Regards, 

Vinoth S.