September 14, 2016 at 7:38 am
Is there a way to query the report's dataset in order to get a list of values for the parameter?
September 15, 2016 at 7:16 am
Hi Nineiron,
Not really.
You can use your dataset to populate available values for a parameter which is set to filter a report item, e.g. a tablix.
This will populate the parameter and allow you to select a value to filter the tablix by before the report is rendered. Big drawbacks are it populates the parameter with the duplicates - i.e. it's not a distinct - and also using filters in this way means you pull the entire unfiltered dataset into memory on the SSRS server which can mean performance is poor (although this could be mitigated with report snapshots which is where this type of filtering is required).
Bottom line is you can't filter an actual dataset by itself and parameter lists aren't made distinct by SSRS.
Far better to create a separate dataset using a select distinct to populate the parameter.
HTH
September 15, 2016 at 7:29 am
Thanx.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply