Have you tried going into the your File, Report Options, and making sure your "Convert Null to default" is clicked, that way it will take any nulls and turn it into a zero. with PL/SQL if the NVL is not used on the SQL command pull to turn the Null into a specific area it is difficult to find...
You may have to create a procedure and function as an api to pull in a single item so that you don't get multiple lines. Feel free to contact me if you need an example.
GrlwBranz
KayLynn Coleman
www.iccohio.com
If you put a \ after your command and or your "tables" it will pass the user's permissions on to the tables. IF you have deeper permissions that require security on the IAL level then it must be \\ following the tables.
Hope this helps.
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.