Dynamics Community Forum Thread Details

SSRS - The report parameter has a defaultValue or a ValidValue that depends on the report parameter

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:
2068.ReportError.png

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

Quick Links

Leaderboard