This is a migrated thread and some comments may be shown as answers.

Programmatic creation of report based off of dynamic complex data.

1 Answer 16 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jason
Top achievements
Rank 1
Veteran
Jason asked on 13 May 2017, 12:13 AM

Hello,

Please see the attached image for a mockup of the desired report in Excel.

What I would like to do is have invoice data set up in a grid, and the data is grouped by company sites (the grey headers that say "Acme Construction" etc are separating the invoice data for each company site.

The areas would be variable height (1 or 2 items per company site in come cases, 10-30 for others)

There are variable amounts of company site per report (each report would contain sites for only one company)

I am new to reporting in general, somewhat new to Telerik, but fluent in programming and C# in general.

How would I go about doing this?

Ps. I have read that when saving to PDF, having different headings on first page vs following pages is a bit problematic. Thoughts?

1 Answer, 1 is accepted

Sort by
0
Accepted
Katia
Telerik team
answered on 15 May 2017, 01:24 PM
Hi Jason,

Below is the reply from the support ticket # 1108893 that you opened on the same question:
"The attached design can be achieved when aggregating the data in groups - Grouping Data. You can add the group to the report as described in this help article. Content placed into Group Header or Group Footer section wil be repeated once for the group and can contain aggregated information for the group (subtotals). The content placed inside the Detail section will make the main body of the group.

As an example of how the grouping works in reports you can review ProductCatalog report located in Telerik Reporting installation folder: 
[installation folder]\Telerik\Reporting [version]\Report Designer\Examples (to be opened in Standalone Designer)
[installation folder]\Telerik\Reporting [version]\Examples\CSharp\ReportLibrary\ProductCatalog (to be opened in Visual Studio Designer)."


Our recommendation is to use DataSource components to connect the report to data.

In order to have different heading on the first page you can place the content into Report Header section which is repeated in the beginning of the report only or show/hide content in page sections with expressions and bindings. Using PageNumber global object in expressions will help you to determine the current page number.


Regards,
Katia
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Jason
Top achievements
Rank 1
Veteran
Answers by
Katia
Telerik team
Share this question
or