Lexical Reference Sample Report

Post by **admin** » Fri May 05, 2006 7:04 am

I have developed a sample report to show how we can use lexical references in our reports. Please change the code in after parameter form trigger.

Lexical references are placeholders for text that you embed in a SELECT statement. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.

[img]/images/icon_zip.gif[/img] Attachment: Lexical 6i.zip ( 6975bytes )

najm · Post by **najm** » Mon May 08, 2006 6:21 am

Mr Admin you are absolutely superve but i a have a little objection if you don't mind if any job have a null entry then what can i do becoz when i select any null entry there is no record show but I want only null records.
Like when I select Manager in a parameter form all the Employees whose job is manager are selected and when I select All it shows All the Employee but when I delete a job of any employee and then select null entry there is no record show please Customize this report I want to see null record.

Najm

Post by **admin** » Mon May 08, 2006 6:28 am

Thanks. Dear reports is just to show a way to use lexical not to cover all scenarios. You can change the code as per your requirement(s).

mirza_rehan · Post by **mirza_rehan** » Thu May 11, 2006 1:55 am

Here is another example of lexical reference in which dynamically ordering report.

[img]/images/icon_zip.gif[/img] Attachment: lexical 6i.zip ( 8121bytes )

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

Kashif · Post by **Kashif** » Sat May 20, 2006 2:57 am

Dear Mr. Admin.
your Sample report is very good and helpfull.
But please if u explain the following line of code

Code: Select all

'Nvl(job,''^^//'''||') = ''' || Nvl(:v_job,'^^//') || '''';

i shall be very thank full. bcz i want to use this sample in my report.

Best Regards.

Muhammad Kashif

mirza_rehan · Post by **mirza_rehan** » Sat May 20, 2006 3:09 pm

Assalam-o-Alaikum

Dear Kashif " 'Nvl(job,''^^//'''||') = ''' || Nvl(:v_job,'^^//') || ''''; " use for handle null values

if any confusion please ask in detail

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

Kashif · Post by **Kashif** » Mon May 22, 2006 3:54 am

Assalam-o-Alaikum

Dear Rehan sb

Thanks.
acually i was confused with this ''^^//'''||') = ''' .

I was thinking that these are some special Character used in Lexical References.

Thanks again.

Best Regards.

Muhammad Kashif

Post by **admin** » Mon May 22, 2006 5:46 am

There is no special character(s) I don't know why these are appearing here. Better is to get help in Reports builder and see the example there.thanks

mirza_rehan · Post by **mirza_rehan** » Sat Jul 22, 2006 6:33 am

Sorry Kashif i was not see this thread for a long time

I always use special character like this ''^^//'''||') = ''' because such code never enters in data

If i use Nvl(job,''J'''||') = ''' || Nvl(:v_job,'J') instead of Nvl(job,''^^//'''||') = ''' || Nvl(:v_job,'^^//') if value 'J' exist in database and i pass Null it shows that value tooo

i think you understand it.

Sorry for late reply

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

ERPstuff - Oracle EBS Community

Lexical Reference Sample Report

Lexical Reference Sample Report

Who is online