Forum Discussion
Post PartisanHow to pass a data parameter paginated report
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.
Post PartisanCome 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.Hi mp390988,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Harshitha.