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?
Can someone help me define a order by clause for my report. I found this thread in the forum and it has almost the same problem I have.
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...
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.