report builder passing parameter

[mp390988]

Hi,

I have a paginated report as below and I want to pass the two Parameters FromCalendarDate and ToCalendarDate to the Date field in my Rates dataset. 

My Rates dataset is coming from the below mySQL script and you can see where I have highlighted in yellow is the name of the 2 parameters I want to pass.

I have formatted the value of my parameters so that it is in the format YYYY-mm-dd because when I run the mySQL directly as shown below, you can see I had to hardcode the dates in that format for it work:

and my query validates succesfully:

But when I run the report, my tablix that is linked to my Rates datasouce is coming back empty even when I have set the From and To date as you can see from the snapshot below:

You can also see I have an expression that prints what the From and To are but don't understand why mySQL script returns nothing?

Any help will be appreciated, thanks

[v-nmadadi-msft]

Hi @mp390988 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @mp390988 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @mp390988 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft · Accepted solution]

Hi @mp390988 
Thanks for reaching out to the Microsoft fabric community forum.


Please verify weather the Data type for the parameter is correct

To do that, you could right click on parameter and then on parameter properties

Additionally, test the query in MySQL with parameter values, copy your dataset query into MySQL Workbench, then replace @FromCalendarDate and @ToCalendarDate with the exact values captured from the report’s text box output. Run the query to confirm it returns rows; if it doesn’t, check for possible issues such as incorrect date formatting, missing single quotes around date values, or mismatches caused by any SQL command.

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[MohamedFowzan1]

Hi @mp390988 

The approach used seems correct.

Steps:

• Set Correct Data Type – Use the Date/Time type for report parameters instead of text.
• Format Dates for MySQL – Map parameters in the dataset with expressions like=Format(Parameters!FromCalendarDate.Value, "yyyy-MM-dd")
  to match MySQL’s expected format.
• Check Query & Parameter Mapping – Ensure parameter names match in the query and dataset mapping, and use proper syntax (e.g., BETWEEN @FromCalendarDate AND @ToCalendarDate).
• Debug – Display formatted parameter values in the report to verify correctness before passing them to the query.