ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Hide filters in SQL Reports with User Filter Value

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
juliom Posted - 11/12/2008 : 14:44:09
In OLAP Reports, when you apply an User Filter Value to a Report, you have the option to hide the filter. Is there a way to do this with SQL Reports??? Of course you can apply User Filter Values, but I see no option to hide the filter from the user, so this enable the user to "skip" the filter.
1   L A T E S T    R E P L I E S    (Newest First)
marco Posted - 11/13/2008 : 05:30:56
You can use ::Filters like:

Select * from table where field = ::Filter

to show for example only the records from a table for the loged in person.

Marco

www.gmsbv.nl

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page