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