Crystal Reports Web application

[Former Member]

Hi, I have had a requirement for us to display crystal reports in our web page. These crystal reports are written in there own builders by the customer themselves and can be different user to user. They want to integrate with our web pages which are dynamic and customizable but i wanted some advice as to how this has been done before. i have found lots of material about building crystal reports in vis studio but thats not what they want to do. They want to build there own. upload the rpt to a table and run the report from a webpage without the need for credentials etc. can anyone point me in the right direction?

[DellSC · Accepted solution]

Is the data local to the customer or is it stored on your network? Is the application running local to the customer or are you providing it as SaaS?

As long as the web server and the data are on the same network, you could have a page where they would upload the report and then display it in the .net or java web viewer.

The challenge is going to be setting the credentials. Crystal does NOT save the database password as part of the report so you would have to know from in your application how to set the credentials for the report.

-Dell

[Former Member · Accepted solution]

the application and data are held on azure.

I dont think it would be an issue to provide a win form solution called by the app if needed.. but not sure how this is normally handled. im gussing as they own the builder and report they dont need to license anything else.

[DellSC · Accepted solution]

They would have to have at least one license for SAP Crystal Reports.

-Dell

[Former Member · Accepted solution]

yes they own the builder. is this different to the sap crystal reports license?

in what way is this normally handled? web or win form when end user is designing there own reports?

[DellSC · Accepted solution]

Crystal for VS will run reports that are created with Crystal Reports - whether from the full version of the tool or the more limited one that is provided with Crystal for VS. So, your users don't have to have VS to create reports.

How this is handled is dependent on the software application. I have worked with several clients that allow users to upload custom reports - the app saves the report to an internal folder and metadata about the report to a database. It then use that metadata to show the user a list of reports that are available. When the user selects one, it then knows from the DB where the report is located so that the application can load it into a viewer.

-Dell

[Former Member · Accepted solution]

sounds exacly like what i want to do. Is this done in web form or win form?

[DellSC · Accepted solution]

You can do it either way.

-Dell