Lexical Reference Sample Report
Lexical Reference Sample Report
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.
<b>Lexical references</b> 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] <b>Attachment:</b> Lexical 6i.zip <i>( 6975bytes )</i>
<b>Lexical references</b> 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] <b>Attachment:</b> Lexical 6i.zip <i>( 6975bytes )</i>
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
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
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Here is another example of lexical reference in which dynamically ordering report.
[img]/images/icon_zip.gif[/img] <b>Attachment:</b> lexical 6i.zip <i>( 8121bytes )</i>
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
[img]/images/icon_zip.gif[/img] <b>Attachment:</b> lexical 6i.zip <i>( 8121bytes )</i>
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
Dear Mr. Admin.
your Sample report is very good and helpfull.
But please if u explain the following line of code
i shall be very thank full. bcz i want to use this sample in my report.
Best Regards.
Muhammad Kashif
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,'^^//') || '''';
Best Regards.
Muhammad Kashif
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Assalam-o-Alaikum
Dear Kashif <b>" 'Nvl(job,''^^//'''||') = ''' || Nvl(:v_job,'^^//') || ''''; "</b> 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
Dear Kashif <b>" 'Nvl(job,''^^//'''||') = ''' || Nvl(:v_job,'^^//') || ''''; "</b> 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
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Sorry Kashif i was not see this thread for a long time
I always use special character like this ''<b>^^//</b>'''||') = ''' because such code never enters in data
If i use <b>Nvl(job,''J'''||') = ''' || Nvl(:v_job,'J')</b> instead of <b>Nvl(job,''^^//'''||') = ''' || Nvl(:v_job,'^^//') </b> 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
I always use special character like this ''<b>^^//</b>'''||') = ''' because such code never enters in data
If i use <b>Nvl(job,''J'''||') = ''' || Nvl(:v_job,'J')</b> instead of <b>Nvl(job,''^^//'''||') = ''' || Nvl(:v_job,'^^//') </b> 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
Who is online
Users browsing this forum: No registered users and 10 guests