Forum Discussion
How to pass a data parameter paginated report
Hi
I have these 2 parameters as circled in red in the following snapshot:
They come from using the Data Source called "RevenueReports_ProfitReport2":
My question is how do I pass them to my other dataset "Rates" to the Date field?
This is what I have done so far but when I execute my query I get no resuts.
Hi mp390988,
Thank you for reaching out to the Microsoft fabric community forum.In SSRS, you need to link your main report parameters (FromCalendarDate and ToCalendarDate) to your Rates dataset so the SQL query receives them. To do this, open the Rates dataset properties, go to the Parameters tab, and for each dataset parameter (FromCalendarDate and ToCalendarDate), set its value to the matching report parameter (=Parameters!FromCalendarDate.Value and =Parameters!ToCalendarDate.Value). Don’t use FORMAT() just pass the date directly so SQL treats it as a date.
kindly gothrough with the below document hope it may resolve your Issue
Dataset Properties Dialog Box, Parameters - SQL Server Reporting Services (SSRS) | Microsoft Learn
Tutorial: Add parameters to your report (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Learn
Hope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.
5 Replies
Come on man 57 views thus far and no one knows how to do this?
Hi mp390988,
Thank you for reaching out to the Microsoft fabric community forum.In SSRS, you need to link your main report parameters (FromCalendarDate and ToCalendarDate) to your Rates dataset so the SQL query receives them. To do this, open the Rates dataset properties, go to the Parameters tab, and for each dataset parameter (FromCalendarDate and ToCalendarDate), set its value to the matching report parameter (=Parameters!FromCalendarDate.Value and =Parameters!ToCalendarDate.Value). Don’t use FORMAT() just pass the date directly so SQL treats it as a date.
kindly gothrough with the below document hope it may resolve your Issue
Dataset Properties Dialog Box, Parameters - SQL Server Reporting Services (SSRS) | Microsoft Learn
Tutorial: Add parameters to your report (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Learn
Hope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.Hi mp390988,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.
