Geek Answers Handbook

Grouping data in RDLC

I'm sorry if this seems silly, but I'm new to using Report Definition Language (RDLC) report files, and I'm looking for advice on the best "attack plan" for the report I have to create.

REPORT The report (itself) should display a data table above the corresponding set of calculations for each grouping (data). I hope to keep one group per page ... but this may not be possible, since each table can become quite long (but this is a different question for another day).

... may be from 1 to N groups

Example

  • (GROUP 1)
  • Table
  • FORM CALCULATIONS

PAGE BREAK

  • (GROUP 2)
  • Table
  • FORM CALCULATIONS

... etc.

THIS IS THE BEST WAY TO DO IT?
Put each group in SUBREPORT. Then the additional report will contain the calculation of the table and form.

... is this right or is there a better way to do this?

+4
source share
2 answers

ACTUAL ANSWER

The external RDLC contains a LIST control that contains the following controls:

  • TABLE (containing items related to the collection as a whole)
  • Subreport

SUBREPORT points to an RDLC that contains the following controls:

  • TABLE (containing row items)

(1) Use the LIST grouping property to group your 1-in-N collections.
The grouping property can be found by selecting the LIST control and then selecting Visual Studio Menu options: VIEW> PROPERTIES WINDOW.

(2) Then set the LIST data source.
This can be found by selecting REPORT, and then selecting the Visual Studio menu options as follows: REPORT> DATA SOURCES. Drag any field onto the control and the data source will automatically adjust.

NOTE:
If you cannot "see" any data sources in the Visual Studio data sources window, it is "possible" because the service links in your project cause problems ... temporarily exclude them from your project and select the RESFRESH icon in the Visual data sources window Studio (they should appear). Unfortunately, you have to do this EVERY time your data source changes.

After the LIST iteration is correct, you can add SUBREPORT and any other controls.

... I OFFICIALLY hate RDLC right now.

+10
source

personally, if I had to make this report, I will do it with two different tables. In one rdlc you can put two data sets that will display GROUP 1 Data, the second, GROUP 2 Data. The table has a Page Break option at the end of the data, which can give PAGE BREAK Between two data.
Best wishes,
Jordan

0
source

More articles:


All Articles