OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » water mark

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

water mark [message #525275]

Fri, 30 September 2011 08:51

windowsdos
Messages: 29
Registered: May 2011

Junior Member

how to do water mark in oracle report 2.1
thank you

Report message to a moderator

Re: water mark [message #525295 is a reply to message #525275]

Fri, 30 September 2011 13:33

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

Senior Member
Account Moderator

Reports 2.1 ... whoa, that's an old piece of software! I didn't even know it exists. I know 1.1, 2.5, 4.5, 6i, ..., but have never heard of 2.1.

Anyway: I don't know whether the following works in that version too, but - you might try. I hope you'll be able to adjust it to your version. Here's one of previous discussions about watermarks.

Report message to a moderator

Re: water mark [message #525307 is a reply to message #525295]

Fri, 30 September 2011 15:12

windowsdos
Messages: 29
Registered: May 2011

Junior Member

but i need to put the water mark under the original report word
how can i do that

when i do the above step
the water mark is one the report word

Report message to a moderator

Re: water mark [message #525326 is a reply to message #525307]

Sat, 01 October 2011 02:37

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

Senior Member
Account Moderator

I'm not sure I understand what you are saying. Could you post a screenshot, please?

Report message to a moderator

Re: water mark [message #525342 is a reply to message #525326]

Sat, 01 October 2011 04:25

windowsdos
Messages: 29
Registered: May 2011

Junior Member

i need to put the water mark in the background of the report text (report data)

Report message to a moderator

Re: water mark [message #525349 is a reply to message #525342]

Sat, 01 October 2011 06:17

windowsdos
Messages: 29
Registered: May 2011

Junior Member

Littlefoot wrote on Sat, 01 October 2011 09:37

I'm not sure I understand what you are saying. Could you post a screenshot, please?

ineed to make water mark on my report like the following
behind the report text

http://img685.imageshack.us/img685/8525/96529365.png

[Updated on: Sat, 01 October 2011 06:17]

Report message to a moderator

Re: water mark [message #525379 is a reply to message #525349]

Sat, 01 October 2011 13:32

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

Senior Member
Account Moderator

I thought that you'll post YOUR screenshot, result of what you've done so that we'd see how it looks like. I know how watermark is supposed to look like, I don't know how your watermark looks like.

Report message to a moderator

Re: water mark [message #525381 is a reply to message #525379]

Sat, 01 October 2011 13:46

windowsdos
Messages: 29
Registered: May 2011

Junior Member

Littlefoot wrote on Sat, 01 October 2011 20:32

I thought that you'll post YOUR screenshot, result of what you've done so that we'd see how it looks like. I know how watermark is supposed to look like, I don't know how your watermark looks like.

no i need to do as the picture which i attach

when i need to do that by what i read in this topic
the water mark put on the text

but if u see the attached pic
the water mark behind (in the back) of the report text

Report message to a moderator

Re: water mark [message #525382 is a reply to message #525381]

Sat, 01 October 2011 15:28

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

Senior Member
Account Moderator

Perhaps you should send your watermark to the background (so that every other object is placed over it).

Report message to a moderator

Re: water mark [message #668166 is a reply to message #525382]

Sat, 10 February 2018 04:05

Nembezah
Messages: 11
Registered: September 2017

Junior Member

How?

Report message to a moderator

Re: water mark [message #668179 is a reply to message #668166]

Sun, 11 February 2018 11:56

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

Senior Member
Account Moderator

Navigate to the "Layout" menu. In there, you'll see
- Bring to Front
- Send to Back
- Move Forward
- Move Backward

which are to be used for such a purpose.

Report message to a moderator

Re: water mark [message #668187 is a reply to message #668179]

Mon, 12 February 2018 01:18

Nembezah
Messages: 11
Registered: September 2017

Junior Member

I added the text in layout and display the result of function &CF_1 everything is displayed correct problem is making it a background and changing colors. find attached

Attachment: Oracle report watermark.pdf
(Size: 222.82KB, Downloaded 2409 times)

Report message to a moderator

Re: water mark [message #668189 is a reply to message #668187]

Mon, 12 February 2018 01:31

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

Senior Member
Account Moderator

It seems that you put it as "&<WATER_MARK>". Well, you should remove brackets and use "&WATER_MARK only".

I explained how to move it backward (or forward).

What about its color? In order to change it, select the field (in the Paper Layout Editor) and change the color using a Color Palette in the vertical toolbar.

Report message to a moderator

Watermark in Oracle reports [message #668190 is a reply to message #525275]

Mon, 12 February 2018 01:43

Nembezah
Messages: 11
Registered: September 2017

Junior Member

I came a cross this solution when you insert a watermark in oracle report but its not working im getting lost in point 5 ,6 and 7.

1. Make your report as usual
2. Ensure report is running as normal.
3. Now in Data Model, create a formula CF_1 as character type with below code
-----------
function CF_1Formula return Char is
begin
Return('This is watermark');
end;
---------
4. In Layout screen, create a TEXT field with name '&CF_1'
5. Keep behind the Repeating frame.
6. Now move ,Size & Print Direction by ROTATE tool from tool box.
7. Select this Text and ->Arrange->Send to Back.
8.Run the Report and Enjoy.

Attachment: Oracle report watermark.pdf
(Size: 222.82KB, Downloaded 2459 times)

Report message to a moderator

Re: Watermark in Oracle reports [message #668192 is a reply to message #668190]

Mon, 12 February 2018 02:13

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

Senior Member
Account Moderator

Opening a new topic won't help much, so - as we've already begun the discussion here, I merged those two topics.

PDF you attached doesn't show the watermark itself, but a field. Is it a field? It should NOT be a field, especially not with "&<WATER_MARK>" in it. In Paper Layout Editor, choose the text tool and start typing, literally "&WATER_MARK" (as that's how you named the formula column).

Report message to a moderator

Previous Topic:	ORA-00600 internal arguments
Next Topic:	Problem to generate report of multiple pages in single PDF

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:25:39 CST 2025