- Home
- Forum
- Report Platform
- How to Schedule a Report with Parameters?
If you became a customer of the Syncfusion� Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion� Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion�.
For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.
Thank you for choosing Syncfusion� for your reporting needs.
For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.
Thank you for choosing Syncfusion� for your reporting needs.
How to Schedule a Report with Parameters?
My report has 2 parameters - first date and last date, and the datasets are filtered based on a date field within the dataset between those parameters. This works fine.
I want my users to be able to select specific dates, but I want to schedule a "month end" report that will be emailed out where the dates of the transactions are between the first and last day of last month. I can do this in a SSRS environment, but when i try and do it by entering default values in the parameters, it fails. The preview shows it just fine, but the report server only shows the header, and sometimes a "Specified Cast not allowed" message.
I'm also noticing that no matter what I do, if i try and filter the dataset using BETWEEN and as the expression =Parameters!sdate.Value (for the starting date) and =Parameters!edate.Value (for the ending date) the report designer ALWAYS adds the edate.value to the end of the sdate.value in the first box! No matter what i do I can't stop it from doing that - which is where the Cast error comes from. So if i add it as a <= and a separate filter as a >= it simply won't show it (no error comes up)
If i remove the default value settings - the report loads fine on the server. As soon as I have it set, the designer doesn't seem to know what to do with it so it shows preview fine, but the server can't figure out what the designer did.
So, how the heck do I get a report to run on a schedule with parameters values that need defaults entered but can't enter them in the report designer because it keeps adding the second parameter to the first?
I want my users to be able to select specific dates, but I want to schedule a "month end" report that will be emailed out where the dates of the transactions are between the first and last day of last month. I can do this in a SSRS environment, but when i try and do it by entering default values in the parameters, it fails. The preview shows it just fine, but the report server only shows the header, and sometimes a "Specified Cast not allowed" message.
I'm also noticing that no matter what I do, if i try and filter the dataset using BETWEEN and as the expression =Parameters!sdate.Value (for the starting date) and =Parameters!edate.Value (for the ending date) the report designer ALWAYS adds the edate.value to the end of the sdate.value in the first box! No matter what i do I can't stop it from doing that - which is where the Cast error comes from. So if i add it as a <= and a separate filter as a >= it simply won't show it (no error comes up)
If i remove the default value settings - the report loads fine on the server. As soon as I have it set, the designer doesn't seem to know what to do with it so it shows preview fine, but the server can't figure out what the designer did.
So, how the heck do I get a report to run on a schedule with parameters values that need defaults entered but can't enter them in the report designer because it keeps adding the second parameter to the first?
SIGN IN To post a reply.
3 Replies
VS
Vinoth Srinivasan
Syncfusion Team
January 2, 2018 11:05 AM UTC
Hi Christopher,
Thanks for your interest in Syncfusion Components.
We were not able to reproduce the problem at our end and we have validated the reported scenario by creating a report in which the data rendered based on the start date and end date parameter using query parameter filter. The data has been filtered properly based on the provided default parameter initially . Please find the report from the below location.
If you still face any issue then modify the report to reproduce the problem at our end and also please share the version details of the report designer you are using. It will be helpful for us to provide the solution at the earliest.
Regards,
Vinoth S.
CS
Christopher Scholl
January 2, 2018 09:33 PM UTC
Perhaps i wasn't clear. The report filters based on a start and ending date parameter just fine - WHEN i put the parameter into the report at run time. However, if i set a default value based on the first and last date of the last month - the filter fails on the report server. It displays fine in the report designer's preview, but won't show anything on the server when i run the report.
report designer v2.2.0.13
report designer v2.2.0.13
VS
Vinoth Srinivasan
Syncfusion Team
January 4, 2018 03:58 AM UTC
Hi Christopher,
A support incident has been created under your account and we request you to login into our Direct Trac support system for further updates on this issue. Our Direct Trac support system can be accessed from the following link:
Regards,
Vinoth S.
SIGN IN To post a reply.
- 3 Replies
- 2 Participants
-
CS Christopher Scholl
- Dec 30, 2017 05:18 AM UTC
- Jan 4, 2018 03:58 AM UTC
