OraFAQ Forum: Reports & Discoverer » Water Mark on Reports(Urgent!)

Home » Developer & Programmer » Reports & Discoverer » Water Mark on Reports(Urgent!)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Water Mark on Reports(Urgent!) [message #208049]

Thu, 07 December 2006 23:38

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

khans.jak@gmail.com

Dear Forum Members,
Today my Team Leader ask's me wether it is possible to put a Water-Mark on Reports or not,I tried it Out with Putting a Big Label Behaind all Frame in Gray Color as"DUPLICATE", But the thing is that they actually want it to be Diagonal and it is not possible to rotate a Label in Report Diagonally So i Then Used a Image(Please Refer PDF Attached).But again problem...with Size without the Image it was 68 KB and after it goes 1,112KB Please Suggest me Some wise way to get rid of that Problem.

Jak

Attachment: POL_COVER.pdf
(Size: 30.60KB, Downloaded 6405 times)

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #208090 is a reply to message #208049]

Fri, 08 December 2006 02:22

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Create a formula column which would return CHARACTER value: 'DUPLICATE'. Use it in the Paper Layout so that it is NOT displayed as a field, but using the ampersand (&) sign (for example, &cf_1). This will allow you to rotate it - in the toolbar, click the Rotate button, click and drag a handle. Adjust size, color, whatever, and that's all.

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #208114 is a reply to message #208090]

Fri, 08 December 2006 04:23

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

khans.jak@gmail.com

Thanks LF,
Thanks for ur prompt Reply...Its really worth a million Doller Solution. Yor Genius.

Jak

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #208119 is a reply to message #208114]

Fri, 08 December 2006 04:48

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Yes! I'm rich! /forum/fa/1602/0/

/forum/fa/1602/0/

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #208146 is a reply to message #208119]

Fri, 08 December 2006 05:42

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

khans.jak@gmail.com

Yeah U R....Hey U wanna see the Report Now how its Looking. here it is. and u know what its only increased by 1 or 2 KB.

Attachment: POLFR.pdf
(Size: 11.24KB, Downloaded 5228 times)

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #208217 is a reply to message #208090]

Fri, 08 December 2006 11:53

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi LF,

Really that is great I did that and output is generated as required . but I did not use the function I added just TEXT item in the report.

So i think that is another way to do ?

Bye
Ashu

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #208332 is a reply to message #208217]

Sat, 09 December 2006 10:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Obviously it is; depending on requirement, watermark text could be passed as a user parameter to the report. Or, it could be "calculated" using a formula (if some_condition then watermark = 'THIS TEXT' else watermark = 'ANOTHER TEXT'), or ...

My example was only one solution of the problem. As usually, there's more than one way to do it.

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #208397 is a reply to message #208090]

Sun, 10 December 2006 05:18

skhawar03
Messages: 10
Registered: August 2006
Location: Muscat

Junior Member

Littlefoot wrote on Fri, 08 December 2006 12:22

Create a formula column which would return CHARACTER value: 'DUPLICATE'. Use it in the Paper Layout so that it is NOT displayed as a field, but using the ampersand (&) sign (for example, &cf_1). This will allow you to rotate it - in the toolbar, click the Rotate button, click and drag a handle. Adjust size, color, whatever, and that's all.

Hi LF,
I can't understand this
<Use it in the Paper Layout so that it is NOT displayed as a field, but using the ampersand (&) sign (for example, &cf_1).>

what I am doing is first define a formula column with &Name of columns but report didn't allow me to do so it says, it does not fullfil the Sql naming standard. will u plz, explain me in detail what wrong I am doing.
Many Thanks
Khawar

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #208418 is a reply to message #208397]

Sun, 10 December 2006 15:22

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Ampersand is NOT to be used while defining a formula column, but in Paper Layout (editor which is used to "draw" columns on the screen). See the attached sample report.

Attachment: watermark.rdf
(Size: 52.00KB, Downloaded 5260 times)

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #208435 is a reply to message #208418]

Sun, 10 December 2006 21:59

skhawar03
Messages: 10
Registered: August 2006
Location: Muscat

Junior Member

Hi,
Thanks a lot, its a good addition in my knowledge.
Khawar

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #356786 is a reply to message #208049]

Sun, 02 November 2008 07:20

dillango
Messages: 145
Registered: January 2008

Senior Member

Hi All,

How to print image (say my company logo) item as a water mark in every page?

Ilango

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #379841 is a reply to message #208049]

Thu, 08 January 2009 02:09

jolly_makkar
Messages: 63
Registered: March 2008

Member

1.edit your pic ..give it watermark effect in some adobe photoshop
2.open your report and go to paper editor
3choose edit margin
4import your pic.....
5format it acco to your need

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #380364 is a reply to message #208049]

Sun, 11 January 2009 06:49

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

khans.jak@gmail.com

And if you'r not getting how to Create Water Mark. Create in Microsoft Office.How? Here How I use to Create...
The watermark commands are available only in normal, print layout, and outline views.
1. On the Format menu, point to Background, and then click Printed Watermark.
2. Do one of the following:
o To insert a picture as a watermark (watermark: Any graphic or text, such as "Confidential," that when printed appears either on top of or behind existing document text.), click Picture Watermark, and then click Select Picture. Select the picture you want, and then click Insert.
o To insert a text watermark, click Text Watermark, and then select or enter the text that you want.
3. Select any additional options that you want, and then click Apply.

After That take take a Print Screen Paste in MS Paint Crop with the Size and Save your Happy Water Mark.

Javed

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #380365 is a reply to message #356786]

Sun, 11 January 2009 06:53

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

khans.jak@gmail.com

Dear,

1.Open Report Builder
2.Select Image Press F4
3. In Property Pellet Select "Print Object On"
4. Make it "All Pages"
5. Compile
6. Run
7.Enjoy

Javed

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #666814 is a reply to message #208418]

Mon, 27 November 2017 01:16

Prabhavathy
Messages: 1
Registered: November 2017

Junior Member

hi, the same is working in ORACLE Reports 6i but not in ORACLE Reports 11g. Can you help me on this please??

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #666815 is a reply to message #666814]

Mon, 27 November 2017 01:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm sorry, but I don't have Reports 11g so I can't try it myself. Perhaps someone else will be able to assist.

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #668176 is a reply to message #208418]

Sun, 11 February 2018 08:23

UsterSa
Messages: 8
Registered: November 2016

Junior Member

Hi
Kindy help me for the watermark in 10g.. I looked at the comments here and I tried to do exactly what u guys explained.. the function is returning the value however the positioning and the font are the problem. Can you please advice how I can achieve this in 10g.

Thanks

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #668180 is a reply to message #668176]

Sun, 11 February 2018 11:58

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What does it mean, "the positioning and the font are the problem"? You should describe that problem.

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #668182 is a reply to message #668180]

Sun, 11 February 2018 22:36

UsterSa
Messages: 8
Registered: November 2016

Junior Member

hi

apologies for unclear information. the attached document explains how the report should look like. I am struggling to print that in a report. I made the text to be bold so that you can be able to see it.

thanks

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #668183 is a reply to message #668182]

Sun, 11 February 2018 22:41

UsterSa
Messages: 8
Registered: November 2016

Junior Member

spec

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #668184 is a reply to message #668183]

Mon, 12 February 2018 00:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There's no attachment; don't use "Quick Reply". Instead, click the "Reply" button in the upper right corner of a message. In there, you'll see an option to upload a document.

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #668186 is a reply to message #668184]

Mon, 12 February 2018 00:46

UsterSa
Messages: 8
Registered: November 2016

Junior Member

I saw the upload button however when I click 'preview message' button the attachement is not there. the fomart is PDF so it should be fine.

[Updated on: Mon, 12 February 2018 00:51]

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #668188 is a reply to message #668186]

Mon, 12 February 2018 01:27

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Don't worry; it won't be visible, but we'll be able to download it. Or, alternatively, upload a screenshot - it will be a JPG (or some similar format) which will be visible if you insert it into message body.

Report message to a moderator

Re: Water Mark on Reports(Urgent!) [message #675888 is a reply to message #668176]

Sat, 27 April 2019 05:34

Satheeshkumar.P
Messages: 4
Registered: June 2018
Location: Namakkal

Junior Member

In 10g we have have a option for water mark setup.
1. create label what you want.
2. then go to layout menu and click sent to back option it act like water mark.

[Updated on: Sat, 27 April 2019 05:35]

Report message to a moderator

Previous Topic:	Difference of dates in days
Next Topic:	email report using 'MAIL' DESTYPE parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 17:19:13 CST 2025