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.
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
0
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
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.