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

Report when every row of SQLDataSource already has the detail for that row

1 Answer 18 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Lisa
Top achievements
Rank 1
Lisa asked on 25 Jan 2013, 03:40 PM
I'm planning on creating a reportbook containing a set of  separate one-page reports, some of which contain charts.  Separate reports for each page because each page is completely different.

Handily, I have a report table already given to me containing these fields:

Report Key -- each user will only be able to see particular sets of data
Report page number: 1 to X
Report row number: 1 to about 30
Report column 1
Report column 2
Report column 3
.
.
.
etc to Report column 16.  Some pages have 16 columns across, others have fewer.  On the printed page, I have to insert literal values like:

Heading
        Subheading
                 Description      --- then the columns for row 1 
                 Other               ---- then the columns for row 2 etc

All I really have to do is transfer the columns for row 1 into row 1 of the page I'm working on, then row 2, etc.

What's the simplest way to go about this in Telerik Reports?  I'm thinking I may have to have one subreport for each row.

1 Answer, 1 is accepted

Sort by
0
Elian
Telerik team
answered on 30 Jan 2013, 02:37 PM
Hello Lisa,

Please elaborate further on your scenario. From what you have explained it sounds like you want to dynamically create the report layout according to the data. If that is the case and the data for the detail section (the 16 columns) is only text, then you can use a Table or even simple TextBoxes (depending on the layout you want to achieve. If you have a field that you can use for grouping in order to get the desired number of columns, you can use a Crosstab item. The Crosstab item will automatically create the columns for the grouping criteria that you have specified. 
Basically SubReports are used when there is some template report that can be reused with different parameters and/or data-source. 
If you give us a more detailed explanation (example) of your data-structure, we will be able to give you more concrete advice on how to proceed. 
 
Greetings,
Elian
the Telerik team

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

Tags
General Discussions
Asked by
Lisa
Top achievements
Rank 1
Answers by
Elian
Telerik team
Share this question
or