ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Hide filters in SQL Reports with User Filter Value
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

juliom

Costa Rica
36 Posts

Posted - 11/12/2008 :  14:44:09  Show Profile  Reply with Quote
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.

marco

Netherlands
588 Posts

Posted - 11/13/2008 :  05:30:56  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page