First I use listing report wizard to create my initial report. I can view the columns when clicking on data source editor and see the full path, i.e. equipment_eq5, and am able to run the report since I'm selecting all rows in the equipment table. Now I want to add a where with an adhoc query i.e. where :?eq5 or where :?equipment.eq5 (get an error on this one). But when I try to run the query it gives me an error, so click on the desc icon and now my column shows eq5 only and not the path. My adhoc comes up, put in the information for eq5 the report runs but only headers come out no data. When run in sqlplus get everything. Why?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
actuate textual query editor
- Thread starter dalechin
- Start date
Similar threads
- Locked
- Question
- Locked
- Question