Hello, Telerik Team.
I've created three reports, following the guidelines of your Master-Detail Report article. My master report contains one sub-report. This subreport also contains one subreport, as I present my data in the following format:
The following screenshots demonstrate what my problem is. The interactive layout presents the format I want for my report, albeit with repeated subcategories, and thus, repeated detail values; the print preview on the other hand, presents a category and its subcategories in a single page, and the details in a separate page.
Each subreport has a separate datasource, and the parameters sent are dependent on values from the upper reports. So the details shown are only those from the subcategories and the specific profile that contains those values, while the subcategories shown are only those from its upper category and the specific profile that has such subcategories in it.
What can I do to avoid my subcategories being repeated the same amount of times the detail values it contains, and how may I keep all these detail values in a single page?
I've attached an image of a diagram that demonstrates how the tables I'm using for my reports are related, if perhaps I am not explaining myself clearly.
EDIT: I am using C# and this is a WinForm application, if there is a programmatic solution for this.
I've created three reports, following the guidelines of your Master-Detail Report article. My master report contains one sub-report. This subreport also contains one subreport, as I present my data in the following format:
- Profile
- Category
- SubCategory
- Details
The following screenshots demonstrate what my problem is. The interactive layout presents the format I want for my report, albeit with repeated subcategories, and thus, repeated detail values; the print preview on the other hand, presents a category and its subcategories in a single page, and the details in a separate page.
Each subreport has a separate datasource, and the parameters sent are dependent on values from the upper reports. So the details shown are only those from the subcategories and the specific profile that contains those values, while the subcategories shown are only those from its upper category and the specific profile that has such subcategories in it.
What can I do to avoid my subcategories being repeated the same amount of times the detail values it contains, and how may I keep all these detail values in a single page?
I've attached an image of a diagram that demonstrates how the tables I'm using for my reports are related, if perhaps I am not explaining myself clearly.
EDIT: I am using C# and this is a WinForm application, if there is a programmatic solution for this.
2 Answers, 1 is accepted
0
Anton
Top achievements
Rank 1
Rank 1
answered on 01 Nov 2013, 10:46 PM
Okay, I've fixed the values so that they do not repeate themselves by making an elaborate GROUP BY SQL Clause. The main problem though, has not been fixed. The details from the subcategories are still appearing in a separate page, contrary to how subcategory do show up nicely below their respective categories.
0
Anton
Top achievements
Rank 1
Rank 1
answered on 04 Nov 2013, 02:29 PM
Fixed everything. Setting the docking property to "Bottom" for the subreport fixed the problem. This way the detail values are appearing correctly together with the subcategories.