Page 1 of 1
Lexical Reference Sample Report
Posted: Fri May 05, 2006 7:04 am
by admin
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>
Posted: Mon May 08, 2006 6:21 am
by najm
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
Posted: Mon May 08, 2006 6:28 am
by admin
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).
Posted: Thu May 11, 2006 1:55 am
by mirza_rehan
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
Posted: Sat May 20, 2006 2:57 am
by Kashif
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
Posted: Sat May 20, 2006 3:09 pm
by mirza_rehan
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
Posted: Mon May 22, 2006 3:54 am
by Kashif
Assalam-o-Alaikum
Dear Rehan sb
Thanks.
acually i was confused with this <b> ''^^//'''||') = ''' </b>.
I was thinking that these are some special Character used in Lexical References.
Thanks again.
Best Regards.
Muhammad Kashif
Posted: Mon May 22, 2006 5:46 am
by admin
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
Posted: Sat Jul 22, 2006 6:33 am
by mirza_rehan
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