Hi guys,
I defined the parameter &sort then tried the following in my report but it didn't work
select, lastname, City
From prospect
ORDER BY &SORT; -- where &sort would be Lastname,city
when I run this I get error ORA-00936
what am I missing here?
How can I suppress empty fields in a report so that they don't appear as empty space. For instance I created a report and address Line 2 appears as an empty space. How can I suppress address Line so that it only appears when it is available? Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.