How to return all rows when parameter report has select list?
10864May 7 2007 — edited Nov 30 2007I've been working through the parameterized report tutorial. everything works - sort of.
.
When the report page first displays, I would like all rows to display, ie the LOV is not filtering the report's query, but I can't figure it out. The only way I get rows is to make a selection in the LOV, which instantly filters the report query - not what I'm looking for.
.
I would also like a "reset" button that would clear any LOV selections and return all rows of the report query.
.
Thx for your ideas.