Displaying a Text 'REPRINT 'on the 2nd 3rd etc.. times

Hi everyone I have a requirement from customer, they want to show text 'Reprint' or 'Copy' when they print same Official Receipt in 2nd, 3rd.... times. In first time they don't want to show this text. Please suggest me how to do this option in Reports Builder (Paper layout) or should i do it on Oracle EBS.

Thanks you so much.. i will appreciate all your answers.
johnpaul RañisesAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark GeerlingsDatabase AdministratorCommented:
We had this same requirement some years ago when we had a custom system (not Oracle EBS) that used Oracle Reports.  We were able to get the word "Reprint" to be printed on documents only when they were actually reprinted.  We did this by modifying the Paper Layout to include to include this word only if the printed_date in the table this report was based on was already filled in with a date.  Normally in our system, the first printing of an invoice filled in this date after it printed the invoice once.

We don't know how to answer this question from you: "should I do it on Oracle EBS?"  Is your system an Oracle EBS system, or not?  If yes, that is more complicated.
johnpaul RañisesAuthor Commented:
I mean Oracle Application
or should i put a query on my paper layout.?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark GeerlingsDatabase AdministratorCommented:
You will need a query or a function item in the report that checks a date and/or status on one of the records being printed to know whether the word "Reprint" should be printed, or not.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

johnpaul RañisesAuthor Commented:
how should i start sir.? I'm just only a beginner with this.
can you give a  code sir.?

Mark GeerlingsDatabase AdministratorCommented:
In a custom system, with just Oracle Reports, this is quite easy.  In Oracle Applications though, almost everything is quite complex.  If you don't have experience making configuration changes or modifications in Oracle Applications, I recommend that you hire a consultant who has experience in Oracle Applications to guide you and assist you with this.
johnpaul RañisesAuthor Commented:
not solved
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.