ReportServer Forum

viswac123

Member

Registered: 2021-11-15

Crystal Report details

Hi

I have Crystal report(.rpt) in Crystal report 8.5 version and 2013 version. Currently it is standalone reports fetches data from SQL Database.

Now database has been migrated to AWS SQL 2016.I want to know instead of using as standalone crystal in users local machine can we reuse the created Crystal reports in Report server and provide access to Users so that they can provide paramaters and pull reports from Report user. Please let me know the pre-requisite to do this?

Regards
Viswa

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Crystal Report details

Hi viswac123,

yes, you can use Crystal reports as described here: https://reportserver.net/en/guides/admi … l-Reports/

You can upload the .rpt file to reportserver, create parameters and depending on the permissions of your users (described here: https://reportserver.net/en/tutorials/t … rmissions/ and https://reportserver.net/en/guides/admi … nagement/) you can then let your users download/execute your reports.

Pls note that Crystal is an Enterprise feature, but you can use the trial period time for evaluation. More details here: https://reportserver.net/en/pricing/ (scroll down the page)

Regards,
Eduardo

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi Thank you for the reply.

I have few clarifications needed on the license part, do we need Crystal report license for each users when they access the Crystal reports through Report Server. Also please let me know the license cost for the Crystal report to be installed in the Repot server.

Regards
Viswa

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Crystal Report details

Hi viswac123,

For further investigation into Licensing pls. check: https://www.sap.com/documents/2015/07/3 … 511fa.html specifically page 5.

To create crystal reports ( i.e. to create .rpt files ) you need a valid crystal report license. To distribute valid crystal reports, i.e. deploy via reportserver, you have to install the SAP Crystal Reports for Java runtime components (short, the Java Reporting Component (JRC)). You'll find these, for example, on the SAP download: (You may have to register) https://www.sap.com/cmp/td/sap-crystal- … trial.html

Pls. check here for further information:

https://reportserver.net/en/guides/admi … l-Reports/

Regards,
Eduardo

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi Thank you for the reply.

I understand that we need to install the SAP Crystal report along with dependencies needs to be installed in Report server. As a end user perspective do we need to install anything in user local machine to access the Crystal report in report server. Also whether we can pass parameter for the crystal report in the report server and generate the PDF report based on parameter passed.

Regards
Viswa

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Crystal Report details

Hi Viswa,

you only have to install the dependencies in the server (mentioned in the above link: https://reportserver.net/en/guides/admi … -Reports/). The client doesn't have to install anything in order to access the reports, only an actual browser.

Yes, you can pass parameters in crystal reports analogous as in all other report types (birt, jasper, dynamic lists, etc). More information on parameters here: https://reportserver.net/en/guides/admi … arameters/  , https://reportserver.net/en/guides/admi … arameters/

Regards,
Eduardo

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

Thank you for the prompt reply, just a final thing whether we can export the Crystal report in PDF format from the report server?

Regards
Viswa

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Crystal Report details

Hi Viswa,

yes, the standard output of Crystal reports in ReportServer is pdf, so this should happen automatically.

I would recommend you to use the ReportServer EE evaluation to test and check if what you need is fulfilled by the application. As always you are welcome to ask here if you have any question/problem regarding your installation.

Regards,
Eduardo

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

Thank you, can you please direct me through the design document for the Report server includes Crystal Report option. I need to propose this to Client and explain it.

Regards
Viswa

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

Also I tried installing the Report server Windows trial version through Bitnami but after system reboot the page is not working and getting the below error  also I want to change the datasource to SQL for my application. Can you please guide me to achieve it?

Your application is not available
Your application may not be available for many reasons:

If you just launched the server, please wait a few minutes for the application to deploy. It is common behavior for Java applications.
Your application may not be working properly. Please check the application log file.
This page will automatically refresh every 15 seconds until the application is available.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Crystal Report details

Hi viswac123,

do you get this error immediately after bitnami installation ? which bitnami package did you use ? did you change something from the standard bitnami installation ?

Regards,
Eduardo

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

I am not getting immediately, after reboot my machine it is happening. I tried to uninstall and install many times but every time when I reboot my machine it is not working. I didn't do any changes. I used Installer packages Windows 64bits - ReportServer 3.7.1-6048 (64bits)

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

Thank you, can you please direct me through the design document for the Report server includes Crystal Report option.

Regards
Viswa

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

For installing the SAP Crystal report for Eclipse I understand that we need to register https://www.sap.com/cmp/td/sap-crystal- … trial.html. Do we need to buy this if we are going to install in Production server?

Regards
Viswa

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

Also If we have 3 instances in Production, do we need Report server multiple license(3) or 1 license is enough to install?

Regards
Viswa

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Crystal Report details

Hi

I am not getting immediately, after reboot my machine it is happening. I tried to uninstall and install many times but every time when I reboot my machine it is not working. I didn't do any changes. I used Installer packages Windows 64bits - ReportServer 3.7.1-6048

Hi viswac123,

let's solve this issue first so step by step. If I understand correctly , you only download the bitnami file above: Windows 64bits - ReportServer 3.7.1-6048 , then install it via "next next next", you don't change anything apart from your username and passwort, then you restart windows, and it does not work, correct ?

did you change anything regarding libraries?
did you start the services in the "services" tab of the windows package? can you pls post some screenshots? you can use http://imgbb.com for this.

Regards,
Eduardo

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

Yes you are right, unfortunately I cannot upload any images in website due to security issues. As you mentioned I never changed anything and clicked next next next. I didn't change anything in the libraries. I just started the C:\Bitnami\reportserverenterprise-3.7.1.6046-1\viswa\apache2\bin - httpd.exe for running the report.

It is fine we will look on this issue little later, can you please update on the other queries. Based on this I need to design and submit.

Regards
Viswa

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

Can you please direct me through the design document for the Report server includes Crystal Report option.

For installing the SAP Crystal report for Eclipse I understand that we need to register https://www.sap.com/cmp/td/sap-crystal- … trial.html. Do we need to buy this if we are going to install in Production server?

Regards
Viswa

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

Can you please update on the queries urgently, I need to propose it to client

Regards
Viswa

Hi

Can you please direct me through the design document for the Report server includes Crystal Report option.

For installing the SAP Crystal report for Eclipse I understand that we need to register https://www.sap.com/cmp/td/sap-crystal- … trial.html. Do we need to buy this if we are going to install in Production server?

Regards
Viswa

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Crystal Report details

Hi Viswa,

for Crystal Licensing in Production server, pls check the information I sent you above, you should find all information in the document linked.  Pls note: To distribute valid crystal reports, i.e. deploy via reportserver, you have to install the SAP Crystal Reports for Java runtime components (short, the Java Reporting Component (JRC))"

For further investigation into Licensing pls. check: https://www.sap.com/documents/2015/07/3 … 511fa.html specifically page 5.

To create crystal reports ( i.e. to create .rpt files ) you need a valid crystal report license. To distribute valid crystal reports, i.e. deploy via reportserver, you have to install the SAP Crystal Reports for Java runtime components (short, the Java Reporting Component (JRC)). You'll find these, for example, on the SAP download: (You may have to register) https://www.sap.com/cmp/td/sap-crystal- … trial.html

Pls. check here for further information:

https://reportserver.net/en/guides/admi … l-Reports/

Regards,
Eduardo

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

Thank you for the clarification.

Few more clarification needed
1. Report server supports High Availability(multiple instances) and LoadBalancer in AWS
2. Can you please direct me for the design document for the Report server?

Regards
Viswa

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Crystal Report details

Hi Viswa,

for this pls take a look here: https://forum.reportserver.net/viewtopic.php?pid=5160

Regards,
Eduardo

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Hi

Thank for you the reply. I will go through the link

Probably the final one will he Report server supports MFA, AD authentication?

Regards
Viswa

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Crystal Report details

Hi Viswa,

yes, pls take a look here for more information on LDAP authentication: https://reportserver.net/en/guides/scri … sing-LDAP/

Regards,
Eduardo

viswac123

Member

Registered: 2021-11-15

Re: Crystal Report details

Thank you. It works on AD.

Also please MFA works for Report server