Unable to specify a default date range in variable.
Posted: Tue Apr 21, 2015 11:34 am
I am using Stimulsoft Reports.Web 2014.3 Trial and created a cross tab report.
I used a date range variable to filter the report and I wanted the current date to be the default range upon the initial render of the report.
So I set the following variable properties: Type = datetime - Range, Init by = Expression, From = Today, To = Today, Date Time Format = Date.
All is fine upon the initial render of the report.
However, upon filtering the report using the selected date range, the report does not actualy get filtered.
And upon exporting the report to Excel, I get the following error: "Unable to cast object of type 'System.String' to type 'Stimulsoft.Report.Range'".
When I changed to variable properties to: Type = datetime - Range, Init by = Value, From = "01/01/2015", To = "01/01/2015", Date Time Format = Date.
The report worked fine. But this does not allow me to specify a default date range.
Can you please help me on how to achieve the desired functionality?
Thanks.
I used a date range variable to filter the report and I wanted the current date to be the default range upon the initial render of the report.
So I set the following variable properties: Type = datetime - Range, Init by = Expression, From = Today, To = Today, Date Time Format = Date.
All is fine upon the initial render of the report.
However, upon filtering the report using the selected date range, the report does not actualy get filtered.
And upon exporting the report to Excel, I get the following error: "Unable to cast object of type 'System.String' to type 'Stimulsoft.Report.Range'".
When I changed to variable properties to: Type = datetime - Range, Init by = Value, From = "01/01/2015", To = "01/01/2015", Date Time Format = Date.
The report worked fine. But this does not allow me to specify a default date range.
Can you please help me on how to achieve the desired functionality?
Thanks.