Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Viewing a finished scheduled report

Status
Not open for further replies.

curiousgally

Programmer
Jul 5, 2010
3
US
Hi,

I need to implement scheduling crystal reports in j2ee app which uses crystal reports xi as reporting server.
I could able to schedule a report through info view to an unmanaged disk location ( like "C:/schedule/....) and the status is shown as success. Now I would like to fetch the finished report from the above mentioned location and show it in the application. How do I achieve this? I mean how do I fetch the finished report from the unmanaged disk and display it? do I need to query the infoview for that or can I fetch it directly and pass it to the viewer since it is on unmanaged disk?

Thanks in advance
 
If it's in an unmanaged disk location, you can just fetch it and display it from there without logging in to Infoview. However, be aware that when you schedule to "C:/..." the report will be on the C drive of the server where it is run, NOT on the C drive of the machine that was used to schedule it (the user's computer.)

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
thanks hilfy for the response,

I tried Ftp ing the completed rpt file to the server on which my web app was running..it worked but now i need help on opening that rpt file in the web application without logging into Infoview..

Thanks in advance..
 
You have a couple of options:

1. There is a Crystal Report viewer available for Java. I'm not a Java programmer, so I'm not sure how you would use it.

2. Instead of exporting the file to a .rpt, export to PDF. Opening the file in Acrobat is then handled by the browser.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Hi hilfy,

Exporting it to PDF will remove of the drill down capability. To retain drill down capability need to save it in .rpt format. As you said there is Crystal Report Viewer for Java which is set of java API to process crystal reports. But the api has methods which process reports present on the Crystal Server but not any .rpt file.i.e Viewer can be used to send a request to crystal server which would give the report to the viewer which then renders it for you. But what I wanted is a way to open .rpt files located on my disk within a WEB application without contacting the Crystal Server. Please let me know if this is possible at all in the first place. I'm able to open the .rpt file on my disk using the CRystal REports Designer software installed on my disk and able to drill down etc..
So I feel it must be possible in WEB application also (designer doesn't have server details to open it from server which means its rendering the .rpt as a standalone file). Correct me If Im wrong.

The whole point in trying to achieve this is, we don't have control on reports run and saved on crystal server(like SAP has some max. number of instances/report restriction ). By saving to local disk I don't need to worry about that.

Thanks.

Hope I made it clear.. :)
 
I suspect you're looking at something like the OpenDocument API, which required a connection to the server. There is also just a plain viewer component that will open .rpt files without that connecting to the server. If you were using .NET, I'd know exactly how to tell you to do that. However, you can go to the old developer site here:
Click on "Viewers SDK" in the panel on the left to get to samples for how to use the viewer in Java.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top