| how to connect different db reports to one menu [message #145981] |
Mon, 07 November 2005 23:43  |
sirishay
Messages: 40
Registered: August 2005
Location: Hyderabad
|
Member |
|
|
hai all,
i am using forms 4.5 and reports 2.5. i have a query regarding menu, we have 3 reports based on different database users and we have to attach them to a single menu. how to access those reports with those respective db users with a single menu?
for eg: system - db user
demo - db user
scott - db user
we have 3 reports based on these db users. and we have to attach these to single menu.
thank u,
siri.
|
|
|
|
|
|
| Re: how to connect different db reports to one menu [message #146182 is a reply to message #146134] |
Wed, 09 November 2005 01:22  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
| djmartin wrote on Wed, 09 November 2005 01:53 |
How aboutbegin
if user = 'SYSTEM' then
run_report ('system_rpt');
elsif user = 'DEMO' then
run_report ('demo_rpt');
elsif user = 'SCOTT' then
run_report ('scott_rpt');
end if;
end;
You will have to put in your own 'run_report' procedure.
David
|
Or even:BEGIN
RUN_REPORT(USER||'_rpt');
END;
MHE
[Updated on: Wed, 09 November 2005 01:23] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
