Hi,

I am new to Oracle reports, So i need you help ofcource if you can....

We send one file to mainframe daily and I need a report before that. Everything I can select from tables but there is one thing I need to put in report by myself, ie. batch number(or ID),

Is there any way I can put sysdate prefix with ABC in a new column in Oracle reports like ABC23092003.....So that when ever client run's the report sysdate appears after ABC. There is no record for batch currently stored in any table at the moment.

Thanks