Solved

Original,Duplicate,Triplicate Report

Posted on 2004-08-09
4
1,681 Views
Last Modified: 2013-12-12
I want to send a report to printer 3 copies. i set the parameter copies to 3 but I want to write three different text Original,Duplicate,Triplicate over there
can someone help me?

I try a trigger but it prints only original to evert report
0
Comment
Question by:merimaheen
  • 2
4 Comments
 
LVL 47

Expert Comment

by:schwertner
ID: 11751235
Try to figure out an unique identifier for your report. Examles:
1. Number
2. Topic and date
3. Department, date
4. Customer, date
5. etc.

Create a table and create a record there with the unique identifier of the report.
In the Reports triggers (Before Report) read this table and put there logic:
1. If reports runs for first time create a record with the identifier ane save also "Original"
In a boileplate put "Original"
2. If a record for the report exists figure out the entry.
If it is "Original" change it with "Duplicate and put this in the boilerplate.
Or if it is "Duplicate' put there "Triplicate".
0
 

Author Comment

by:merimaheen
ID: 11759371
but I am looking for an option in reports only without involving database. Because a report print several times but when ever it is printed it is 3 copies like the above mentioned and also it is coplex query report so just want to do in reports.

if you can hep me.........
0
 
LVL 47

Expert Comment

by:schwertner
ID: 11759890
My idea is very simple and efective. In addition you have to delete the row in that table printing the third time.

The next idea is to call the report from forms 3 times and to pass as parameter the text you want.

You can also use multiple layout report. Look in the docs how to construct such report. Try this quick way:
Create the layout and , the second layout is alo the same , then copy all object and paste then below the existing layout objects .
0
 
LVL 8

Accepted Solution

by:
sapnam earned 50 total points
ID: 11770658
This is what I did

1. Created the layout and finalized it
2. Selected the outermost frame in Object Navigator (like M_1_GRPFR) and then went to layout editor. Used the Frame Select icon to select the frame and all its contents.
3. Copied and Pasted this after the end of the page in a new page in the layout editor and
    also did this again.  So I had three identical layouts on three pages.
4.  Within the first page main frame I put the text Original. Within the second page main frame I put the text Duplicate. Within the third page main frame I put the text Triplicate.
5. I added a user parameter P_COPIES with possible values of 1,2,3
6. In the second page main frame, I put the following format trigger
  if :p_copies < 2 then
     return (FALSE);
  else
    return (TRUE);
  end if;

7. In the third page main frame, I put the following format trigger
  if :p_copies < 3 then
     return (FALSE);
  else
    return (TRUE);
  end if;

This will work for the report copies printed in the same run.  If the reports are being printed over different points of time, you will need a table to track the copies printed
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now