Forum Discussion
paginated reports interactive parameter dropdown lists not displaying data
Microsoft has advised they are working to correct the issue.
A work-around that appears to be working for us is the following:
When you select the parameter, do not use the type ahead feature, but instead scroll through the list to the item you want to select and click on it. When you do this the parameters are used as designed.
Same issue with my paginated reports. We had our first reported issue on 3/31/2022.
Select Item from Parameters list; report runs but the data returned is incorrect (not limited to the paramters selection made -- almost like the parameters is null when it gets to the stored procedure).
The stored procedure runs correct with manually declaring the paramter choice.
The loal RDL files runs correctly.
The published report does not run correctly and the embedded report does not run correctly.
FYI I've opened a ticket with Microsoft to see if we can resolve the issue. I'll update with any new information I get.
Microsoft has advised they are working to correct the issue.
A work-around that appears to be working for us is the following:
When you select the parameter, do not use the type ahead feature, but instead scroll through the list to the item you want to select and click on it. When you do this the parameters are used as designed.