Focal Point Banner


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 myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Accessing Scheduled reports in WebFocus

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Accessing Scheduled reports in WebFocus
 Login/Join
 
Member
posted
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.


Regards,
Geeya.
 
Posts: 13 | Registered: October 12, 2006Report This Post
Platinum Member
posted Hide Post
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


FOCUS 7.6 MVS PDF,HTML,EXCEL
 
Posts: 115 | Location: Chicago, IL | Registered: May 28, 2004Report This Post
Silver Member
posted Hide Post
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


WebFOCUS 7.1.3 Windows Client AIX 5.2 Report Servers
 
Posts: 39 | Registered: January 26, 2004Report This Post
Member
posted Hide Post
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.


Regards,
Geeya.
 
Posts: 13 | Registered: October 12, 2006Report This Post
Member
posted Hide Post
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.


Regards,
Geeya.
 
Posts: 13 | Registered: October 12, 2006Report This Post
Gold member
posted Hide Post
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.
 
Posts: 21 | Location: Texas | Registered: October 24, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Accessing Scheduled reports in WebFocus

Copyright © 1996-2020 Information Builders