We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Issue with report data grouping / table layouting

Thread ID:

Created:

Updated:

Platform:

Replies:

145252 Jun 13,2019 05:41 PM UTC Jun 17,2019 06:16 AM UTC Report Platform 5
loading
Tags: Report Designer
gwoo
Asked On June 13, 2019 05:41 PM UTC

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 [Syncfusion]
Replied On June 14, 2019 07:23 AM UTC

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. 
 
Regards, 
Mahendran S. 


gwoo
Replied On June 14, 2019 09:01 AM UTC

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 [Syncfusion]
Replied On June 14, 2019 11:31 AM UTC

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
Replied On June 14, 2019 12:08 PM UTC

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 [Syncfusion]
Replied On June 17, 2019 06:16 AM UTC

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. 
 
Regards, 
Vinoth S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon