As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
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.
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.
WebFOCUS 7.1.3 Windows Client AIX 5.2 Report Servers
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.
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.