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

Which way is best design?

1 Answer 27 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jason
Top achievements
Rank 1
Jason asked on 13 Oct 2013, 06:01 PM
With about 60 days of Telerik reporting behind me, i have a new report to do and i'm not sure what is the best solution.  

The report is a sales report by customer.  The client wants to be able to have two date ranges for comparison.  So the report outline would be:
salesman
customer
Date Range 1  (sales, cost, margin)
Date Range 2  (sales, cost, margin)

I know it can be done with a sub-report for DateRange2 but i'm curious whether a List  or something else would be more efficient.  ( Not sure how to link a list since ReportItem object usage is flagged as obsolete)  Or maybe it's two sub-reports?

I also thought about a cube, but  date ranges will not always be the same time frame - i.e. sometimes may be a week, sometimes a month, sometimes 6 weeks.

User input (parameters) would be salesman, startdate 1, enddate 1, startdate 2, and enddate2. Input for startdate2 and enddate2 are not required (that is sometimes the report will be run with one date range and other times may be run with 2 date ranges)

The final criteria is that the margin in the newer date range should have conditional format (green if bigger margin, red if smaller margin)


Appreciate any and all comments.

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 17 Oct 2013, 09:36 AM
Hi Jason,

Depending on the data structure, you can use a Table/Crosstab/List item and bind its DataSource property to a field representing a nested collection or an expression taking the data of the container as "=ReportItem.DataObject".

In addition you can create dynamic row groups in the Table/Crosstab/List item based on the different date ranges. For instance take a look at the Crosstab demo in our local example - C:\Program Files (x86)\Telerik\Reporting Q3 2013\Examples\CSharp\ReportLibrary\Crosstab (the default installation folder).

If you need further help, please elaborate on the scenario, the data structure and desired layout.

Regards,
Stef
Telerik

Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

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