Command Line / Buttons / HTML

[edogger]

Hi This is my first post here... I'm looking for some ideas... I'm trying to lock down the query reporter app a bit. I have it sitting on a Citrix server, and we have created a bunch of queries that we would like to get to the end users without them being able to log in or try anything on their own. They will basically launch a batch file to generate a report. I know we can lock the specific report, but is there any way to hide the buttons. Specifically the Log on, Open, New, and Save Report buttons. Basically we want the users to have Read Only access to run reports that have been previously created.

Also, I saw there is a command line option to display HTML in IE instead of the internal browser. I have not been able to get that to work... or am I missing somthing???

Any help would be greatly appreciated

 

[Marco Kalter]

Currently a users can always create their own reports if they have an Oracle username/password. I have added your requirement to the list of enhancement requests though.

The Viewer=IE|Internal option merely affects the way the HTML results are displayed within the Query Reporter. When IE is specified, it uses the Internet Explorer ActiveX control.

To view the report results in the Internet Explorer application, you would need to create a batch file that first runs the report, saves it to a HTML file, and launches Internet Explorer. This also prevents users from creating their on reports.

 

[Carlovski]

This is similar to what we are looking to implement. I'll post on how I get on.

 

[edogger]

Sounds good! This would be great, because i enables you to get reports to the end user from basic queries, without having to worry about that user getting access to the DB and possibly writing their own "Run Away" query.

Thanks!!!

 

[Carlovski]

BTW,
Have you had any problems running Query Reporter over Citrix?

 

[edogger]

Runs fine over Citrix. I've published it for my self and a few developers, and we've had no problems.