Incorrect Parameters population in SSRS

0
votes

My report has multiple parameters where the data populated in the dropdown does not show proper data. My parameter is suppose to populate 3 values(Say A, B, All). My parameters are populating just the ALL value in the drop down. I have checked the query in the HANA Studio and the query is absolutely fine and gives A, B and All in the output but the same wont work in SSRS.

  • SSRS Version: 2017
  • Data Source : SAP HANA

The parameter works absolutely fine in the dev environment but gives the above mentioned issues in other environment. How can I get all the 3 values in the parameter drop down?

1
reporting-serviceshanassrs-2017
It sounds like your other environments don't have the data populated for A and B. Can you run the query against the other environments? - Hannover Fist
I ran the query on the HANA Studio on all the environments and the output is what I want but the SSRS Parameter wont give the drop down with proper data. - Priyanka2304
Make sure your SSRS data source has the correct credentials to the production server. - Russell Fox
It does. Tested the connection. - Priyanka2304
Is the data source a shared data source? Is the dataset that fills the parameter dropdown a shared dataset? Verify the settings of the deployed report in "Report Server Portal". - Wolfgang Kais

1 Answers

0
votes

Use this in the expression in your Query parameter when you are dealing with multi value parameters:

join(Parameters!<your param name>.Value,",")