Announcements
Hello everyone,
In an SSRS report, I have a fetchXML query that is dependent on the parameters that the users will choose form the UI that are defined in the report:
The parameters that I have are the below:
The companyParam is based on the dataset of the fetchXML and will populate the list of the companies' names.
The quarterParam is a list of options that are not based on the dataset.
When trying to publish the report I got the below error:
Knowing I am passing the param as per the above query and the company column name that I am querying against is of type text and not GUID:
\
I hardcoded the company name in the query it works perfectly and in the parameters, it populates the list of the companies in the UI. However, when I pass the param in the fetchXML nothing happens as the CompanyName in the UI display null values.
Could you please support solving this issue? I have spent 3 hours changing in query with no result.
Resources that I found:
SSRS - Community Dynamics
Stack overflow - SSRS param
Any help is greatly appreciated.
Best regards,
EBMRay
Hi ,
Thanks for sharing the above.
After the investigation, I realized that I had not created another dataset to retrieve the list of companies, so I configured the parameter to get the values from this new dataset, and this fixed the issue.
Best regards,
EBMRay
Hi EBMRay,
Maybe you can refer the following links:
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156