Re: Dynamic reports

Omar,

I haven't got the original message on this thread (i'm browsing via Google Groups, seems to have lost the thread!) so i'm working off memory.

You will need to edit the format trigger for the field (just select the field, right click and select the PL/SQL editor *i think*)

Setting fields TRUE and FALSE should work. You may also want to try setting the field value by using SRW.Set_Field_Char and setting it to ' ' for a NULL.

I haven't got Reports on my maching so I can't take you through any more detail. You may want to try a user manual at www.oracle.com.

HTH, Mark

"Omar Malik" <obNOSPAMmar_at_hotmail.com> wrote in message news:<9hig160c0g_at_enews3.newsguy.com>...
> Thanks for your help Mark
> I understand what you told me to do. I need to know what report trigger to
> use for hiding the columns. And I also tried to return false if a field is
> to be hidden and true otherwise but its not effecting the layout. Please
> tell me a little bit more about the hiding/unhiding code for the columns if
> you can.
> Thanks again
Received on Mon Jul 02 2001 - 03:07:09 CDT