May 6, 2009 at 12:32 pm
Hi. I would like users to be able to filter on a data set after all values have been returned to the report.
So users run the report and all records are returned, they can then select a value (or values) from a parameter to filter the records returned.
--Main Dataset
SELECT Products.ProductId, Products.ProductDescription, Locations.LocationId, Locations.LocationDescription
FROM Locations
LEFT OUTER JOIN Products ON Locations.Location = Products.Location
--Select LocationId Dataset
SELECT LocationId
FROM Locations
I created a report then added a filter to the dataset, however when opened the report displayed no records. The user was able to select a single value from the parameter (multi-values not allowed) and records were displayed, not quite what i was looking to achieve.
Am I barking up the wrong tree?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
May 8, 2009 at 11:13 am
Sounds like you are running into what I have hit in the past. I haven't yet been able to find a way to "refresh" the report without actually running it again. If this is a report that users run on a regular basis, perhaps storing their parameters would be the way to go. That way they choose the first time and then every time they open it it will have what they chose last. If so the link below was extremely helpful to me in getting that to work. My apologies for replying without a true answer to your question.
May 8, 2009 at 12:14 pm
Thanks for taking time to review my post. I will look at the link provided.
Many Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply