How to pass a data parameter paginated report

[mp390988]

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.

[mp390988]

Come on man 57 views thus far and no one knows how to do this?

[v-hjannapu]

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) | Mi...

Hope this helps if you have any queries we are  happy to assist you further.
Best Regards,
Harshitha.

[v-hjannapu]

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.

[v-hjannapu]

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.

[v-hjannapu]

Hi @mp390988,

I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.

Regards,
Harshitha.