Thanks for the info on BOT tables. That helped.

Darryl, where am I going with this? Oil Sands are looking at incorporating a couple of financial reports onto their portal. We originally looked at providing them with a link that will run the required report. However, with the additional security within ERS (financial reporting), we needed to have them log in - which they didn't want to do. The current line of thinking is to use portlets on the Oilsands side to manage the security and for us to run the report via reportcaster and provide a link to an htm file that will contain the report. This is a more consistent approach with how they are using their portal and where they want to go.

Do you have any suggestions?

If they are going to use portlets, then they could hook into the Dashboard to retrieve the reports.

Ginny,

I tried using the portlets and it may not give us what we need, unless I'm not seeing something - I'm new to these portlets....I like the fact that it gets around the authentication problem we're having.

Here's my dilemma. I used the portlets and accessed the report of interest. If others use the URL that I gave them, it still uses my id in the SID. Mind you, without all the other level of security this would be fine. But, we don't want every Tom, **** and Harry using my id to authenticate against the dbamast because we're dealing with very sensitive information. My main issue with them was that it would be nice to pass the users id straight through and use that one.

This other approach seems to be their choix du jour now. Basically I just want to use RC to create an HTML file that I can store on the server and then provide them with a URL. Yes, I understand that we could FTP the file but that's not the most desirable option.

Methinks I need more coffee.

quote:

Originally posted by GinnyJakes:
Library reports are stored as BLOBs in one of the Report Caster admin tables, BOTLIB and BOTLDATA.

You can access the reports via the dashboard.

Ginny,

Could you please explain how to access reports in library "via the dashboard"? Or I misunderstood something?

Thank you

I would suggest that you download the MRE Admin manual and the Report Caster Admin manual and do a little reading on Report Library to see how you could use it in your environment.

Walker, to see library reports via dashboard, you need to design your dashboard to include library.
Check out building dashboard from the manual.

Thanks,
Chirag

K.Lane,
If you are content with a preset report, having your portal point to an HTML file should solve your problem.
However, if what you are driving to is having a Self-Service App. where the users can choose values for parameters and then run a report or more, then you do need to implement your security.
Here, we have done this for some of our customers. For one we implemented one-time passwords where the user sends an SMS and receives a password to be typed in within a short period of time.

Daniel,

The client is more than content on just viewing an HTML page that does not provde any interactive functionality and hence, no request to the reporting server. My issue is trying to get RC to create the HTML file that I can access. If I can do that, then I am good to go.

Ken

Thank you Ginny and Chirag for your responses.

Ken, this is an example of using JSP to retrieve a pdf. Take a look at this and make the necessary changes to retrieve a html file.

Darryl,

This worked perfectly! Thank my man!

Ken