OraFAQ Forum: Reports & Discoverer » How to set visible property to false on report triger

Home » Developer & Programmer » Reports & Discoverer » How to set visible property to false on report triger

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

How to set visible property to false on report triger [message #281993]

Tue, 20 November 2007 05:33

senganga
Messages: 15
Registered: November 2007
Location: South Africa

Junior Member

I have the following sql and I need to set my parameters (visible property to false)I need to this before the report runs. This is because I will calculate these parameters and populate them in my "before parameter function" and I do not want the user to see or change them when the report start to run... the user can only see these on the output.

SELECT DISTINCT
ord_line.attribute2 "Route",
mti.concatenated_segments || '-' ||
mti.description || '-' ||
ord_line.attribute1 || '-' ||
cph.ISSUE_DATE_ALIAS "Publication",
to_number(wsh.SHIPPED_QUANTITY,9999) Supply,
:p_Bundles,
:p_Loose_copies,
:p_Label_supply,
:p_Bundles_pack,
:p_Roll_pack,
:p_label,
wsh.NET_WEIGHT "Weight per KG",
ord_line.SCHEDULE_SHIP_DATE
FROM
mtl_system_items_kfv mti,
oe_order_lines_all ord_line,
oe_order_headers_all ord_hdr,
XXPUB_CALENDAR_PLAN_HDR cph,
wsh_delivery_details wsh,
bom_bill_of_materials_v bom,
bom_inventory_components_v bom_inv

Report message to a moderator

Re: How to set visible property to false on report triger [message #282011 is a reply to message #281993]

Tue, 20 November 2007 06:45

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

Senior Member
Account Moderator

Quote:

I need to set my parameters (visible property to false) before the report runs

Where do you see those parameters now? As soon as you start the report (i.e. on report's Parameter Form)? If so, you'll have to create your own Parameter Form and display only those parameters you'd like to see. All the others should be left off the Parameter Form.

It means that you'll probably have to delete parameters written by Reports Builder (and it did it by default), but never mind - just show required parameters, and leave the others out of it.

Report message to a moderator

Re: How to set visible property to false on report triger [message #282023 is a reply to message #282011]

Tue, 20 November 2007 07:39

senganga
Messages: 15
Registered: November 2007
Location: South Africa

Junior Member

I am now getting bad bind vareable error... I think its because I deleted them from my user parameters.

Dont you think that just hiding them from the parameter form ("first screen") may work. It that is true... what "set paramer" statement should I use to hide these fields?

Report message to a moderator

Re: How to set visible property to false on report triger [message #282024 is a reply to message #282023]

Tue, 20 November 2007 07:47

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

Senior Member
Account Moderator

Delete them from the Parameter Form, not from User Parameters list!

P.S. As far as I know, there's no "SET_PARAMETER (invisible)" or anything like that. The only way not to display parameters created by default by Reports Builder is to remove them from the Parameter Form.

[Updated on: Tue, 20 November 2007 07:50]

Report message to a moderator

Re: How to set visible property to false on report triger [message #282025 is a reply to message #282024]

Tue, 20 November 2007 07:56

senganga
Messages: 15
Registered: November 2007
Location: South Africa

Junior Member

where do I find this "parameter form"? cos I can not see it, I just see it when I run the report

Report message to a moderator

Re: How to set visible property to false on report triger [message #282027 is a reply to message #282024]

Tue, 20 November 2007 08:06

senganga
Messages: 15
Registered: November 2007
Location: South Africa

Junior Member

ok thank for you help I will keep looking and figure out how to delete them... Hope it works.

Report message to a moderator

Re: How to set visible property to false on report triger [message #282031 is a reply to message #282024]

Tue, 20 November 2007 08:21

senganga
Messages: 15
Registered: November 2007
Location: South Africa

Junior Member

Hey thanks man... I was able to remove them just as you adviced Razz

Report message to a moderator

Previous Topic:	Pre-printing style
Next Topic:	Report property setting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 03:16:36 CST 2025