Hi,

I've a requirement to pre-generate the report in a scheduled time and access the generated report from the web. I want to perfom drilldown, draw chart for the drilled down data etc., from the web browser. There should not be any communication with database at this point. All the drilldown, charting etc should happen on the dataset of the generated report.

The main question is how does the generated report be stored? in HTML or any other object which can render the formatted resultset.
Where does it be stored? in Reporting server or web server.

Another main question is whether I can archive the report and whether all the features like drilldown etc, will also be saved and can be used in future.

Please show some light on these.

I believe that what you want is what is called an Active Report. I believe it avaliable in 7.13. I'm not sure but I think it is an added cost option. I'm sure someone here will offer more information.

ET

Geeya,

I agree with ET. Look into the Active Report output format. The output format is supported by ReportCaster. If you use the Report Library you could take advantage of its built in archiving and version capabilities. It is an add-on feature to your Reporting Server. You can code an active report with 7.1.3 or greater but the reporting server is what will generate the output.

Jon

Thanks Jon and ET,

Jon, You have mentioned "Reporting server is what will generate the output". I need to know after the report gets generated, if we need to drill down the data or draw charts of drilled down data, do the reporting server communicates again with the database, or it stores the dataset in the reporting server space and renders the requested charts.

Let me give an example,

A report of Employee details got generated which has a drill down option on one field say salary which gives his salary history. When the user clicks the drilldown field "Salary" in the browser, does the reporting server communicates with the database again to get the salary details of the employee or it justs pre-stores the dataset including Salary in it's space and play around with the data to get the desired result.

Please help me out.

I've seen some of the technical documents of Active Report. Active report has all the functionalities to be done in client side without communicating with Server. My requirement can connect to server, but all the functionalities should be done at the server side without communicating to the database.

Ex. Drawing the chart of the drilled down data at run time upon user request, instead of generating all possible charts and drill down data as seperate HTML pages and JPEGS and store in the Reporting server space. But the data drill down and drawing charts should be done on the resultset generated by the report before hand and should not communicate with database at that time.

Correct.

Active Reports are 100% self-contained reports.

All javascript functions are delivered with the report document. All report detail data is encoded within the javascript and is available 100% offline.

Graphing, exporting, manipulation, etc.