Search results for query: *

Hi, I just wanted to post a solution that I have regarding setting access to tables when a report is run. This would alos work for those requiring to fire a procedure or command before the main report. I created a report with a procedure, in the procedure I put the SQL command {SET ROLE...

Hi, I just wanted to post a solution that I have regarding setting access to tables when a report is run. This would alos work for those requiring to fire a procedure or command before the main report. I created a report with a procedure, in the procedure I put the SQL command <i>{SET ROLE...

Hi, I'm running CR-v9 on Oracle 8i with IIS. We need to set a READ Only Role when they login to our Report Intranet. The reason we need each users login is so that they only see sensitive data relevent to their department, which is derived from our security table. Interestingly you...

Hi, It sounds like you have a group inyour report, with a 'New Page Before' Option in the section. Right click on the Top level group, select SECTION, then make sure 'New Page Before' or 'New Page After' is de-selected.

Hi, We have some reports in our Intranet. We have granted all users a role to read tables in our Oracle Environment, but it is not their default role. So, when I logon to the Reports, I need to be able to SET ROLE TRLMREAD so that they can retrieve data for that session. Any idea how I may...