| detail and summary report [message #623240] |
Sun, 07 September 2014 04:43  |
 |
m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman
|
Senior Member |
|
|
i have a detailed and summary report combined together in one report (rdf), the first frame containing detail data will bring all the data from table X ( machine_code,batch_no,QTY) , I created another summary query from the same table and displaying it as
summary at below page as machine_code,sum(qty) , now the problem is i want to print one batch per page and when i run the report all the batches will appear.How can i print only one batch per page
|
|
|
|
|
|
|
|
|
|
| Re: detail and summary report [message #624903 is a reply to message #623255] |
Sat, 27 September 2014 12:44  |
shahzad-ul-hasan
Messages: 640
Registered: August 2002
|
Senior Member |
|
|
I think This will help you to run Multiple reports Simultaneously.
you can run multiple reports in 6i by opening and accessing the RWRUN60 direct from the HOST command. So, it will not open the Oracle Background Engine. It will run report directly in previewer.
If i remember correctly the way will be similar to the below...
HOST('RWRUN60 MODULE=REPORT_PATH\REPORT_NAME USERID=USERNAME/PASSWORD OTHER_PARAMETERS...');
See one example below.
For mentioning username and password:
Actually while calling the report through command line it will ask for the user id and password. You can not eliminate this. And as you said that you don't want to fix the user id and password i would also prefer this. But there is an idea about this. That before calling the statement through host. Just declare two variables and get the logged in user and password through SET_APPLICATION_PROPERTY built-in and use those variables while calling the report through command line. So, it will not be fix it will be dynamic will depend on your form's login user.
Second question is can I use a parameter list name in the command line instead of defining all parameters by itself ?
I don't think you can send parameter list while calling report through command line. You will have to send individually parameters. Actually if you note it is same like when you call the report through RUN_PRODUCT built-in. There you assign all parameters in parameter list and here in this method you will pass directly. So, both the ways are same i guess.
Hope you understand.
-------------------------------------------------
Another Tickel:
Running Multiple Reports at a time
By adding this parameter , while calling your report will disable the reports
background engine and u will be able to run multiple reports in reports 6i.
Add_Parameter(pl_id, 'ORACLE_SHUTDOWN', TEXT_PARAMETER, 'YES');
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
