Report selection

[ridhirao22]

Using CR 2008, Oracle 10.

Create a report using command object and excel. Have a ?QuarterRange and ?State as parameters filtering in the report->Record selection->
Tbl.quarter>= ?startquarter and
tbl.quarter<= ?endquarter and
(if ?state = 'all' the true
else tbl.state = ?state)

When I look at Show query in database menu of the report,
I don't see the filter in the where clause? Is it because
the Record selection for state is check for "ALL"?
I don't see either Quarter rane or state in the where clause of show query?.
Please advice.

Thanks,
RR

 

[lbass]

Please don't start a new thread on the same topic. Did you look at my response to your other thread?

-LB