August 12, 2016 at 11:47 am
I am completely stumped. I've been all over the web looking for a solution and nothing is working and I can't figure out what I'm doing wrong.
I have a dataset to an Oracle DB which returns a dataset that contains for example, OrgID, First, Last, EmplDept and some date fields.
I created parameters that work fine to allow the user to pick a date range for the result set. But then I want to have a dropdown parameters that lists the OrgID (Distinctly) to choose from based on the already filtered recordset.
I've followed the many solutions creating a 'DummyParam' and putting code in the report properties but I always get that I have a line error even though it's verbatim and I've backed out all spaces and even re-typed it. Here is one of them
http://mohamedakb.blogspot.com/2011/08/how-to-get-list-distinct-values-from.html
I've tried to understand the lookupset function but I don't quite get it because it looks like you need to create another dataset for that and I'd like to just use the same dataset.
Can anyone point me in a direction or solution to help me with this? I'm really new to SSRS. It doesn't seem like it should be this difficult
August 17, 2016 at 2:48 am
I hate to ask, but why can't use use a second dataset? It's extremely easy,to have effectively the same query in a second dataset that just returns DISTINCT [Field name], which you then use as a parameter.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 26, 2016 at 4:14 pm
I didn't think it would be the 'best practices' way of doing things. Especially if the dataset is big, pulling in the same dataset twice seemed like a lot of overhead.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply