I have created my first SSRS report. It is a weeding report that includes series information. This report is intended for a large library, so I’ve included a query for them to select collection(s) from a drop-down. It works just fine in SSRS, but it doesn’t work from the Polaris tool bar. Other custom reports are working fine from the toolbar, but they do not have a query, and I published them from SimplyReports. Is there a trick to get a report with a query to work, or is this something I cannot do?
Can you be more specific about what part doesn’t work? Does the report not produce the expected output? Are you unable to see the parameter prompts? Can you include any screenshots?
IMHO Getting people used to using SSRS is not a bad thing, that is the way people run reports if they’re using Leap.
I have also noticed this issue. I think it’s related to the “select multiple values” option being checked, because it doesn’t happen for me on reports with parameters that don’t have multi-select enabled (i.e. users would manually enter a string, or pick a date, or choose one option only from a dropdown).
I do have a report from a predecessor that doesn’t run into this issue. Instead of getting values from a query, it specifies values (see first screenshot below - this is laborious when listing branches and I imagine it would only be more annoying when working with collections). In Reporting Services, multiple options can be selected from a dropdown like in the video you sent. In the client, I can get it to work but only by entering the values manually one at a time - the dropdown doesn’t appear and entering multiple values separated by commas doesn’t generate a result.
One of the other options on the “Choose the available values…” screen is to Get values from a query. You could then run a query to return all collection codes in the database and use that to populate the drop down.
