Please Help me....Calling Crystal reports from JSP using Query string

[venkatreddy]

Hi,
I am new to Crystl reports.First let me say what i did and what i need.
I have Crystal Enterprise 8.5, Crystal Professional 8.5 installed.


1. I created one Crystal report using Crystal Reports8.5. with parameter fields .(my database is Oracle9.0)
2. I just copied that .rpt (xyz.rpt) file to c:/inetpub/

http://wwwroot

which is my IIS sever default root.

when i call that report from my jsp using query string, its not refreshing the data.

I'm calling my report as follows.

http://servername/xyz.rpt?user=dbus...ssword&apsauthtype=secEnterprise&prompt0=xyz.

My Quesiton is:

Was i doing correct? or Does i need to do anything?
Do i need to do with Crystal Enteprise ?
Please let me know, what i have to do to get it refreshed.

Plese help me.

Thanks in Adnvace.
--Venkat

 

[Turkbear]

Hi,
If you click on the 'lightning bolt' does the report then refresh?.

While 'unmanaged' reports can be run in CE, you would have better control by publishing them and setting some default settings regarding database logins, etc in the CMC.

Since you have CE, you may as wel use its functions..

 

[venkatreddy]

Hi,

If i publish the reports using Crystal Publishing Wizard,
do i need to copy those reports to some where? If not, how can i call those reports from my jsp.

Say for example, if i logged in as Administrator, and published in a folder called 'Test', and if my reprot name is 'xyz.rpt'.

How can i call that report from my jsp?

Thank in Advance
--Venkat

 

[Turkbear]

Hi,
When published, the report is assigned a Report ID#, this can be used in the calling string - the report name is not used in the URL at all.

Read the Web Developer's Guide ( left panel of the Launchpad page)..Has sample code which will provide a guide to coding
By Default it is here:

http://yourceserver/crystal/enterprise/help/en/sdk/html/default.htm

 

[venkatreddy]

Hi,

Thank you for your reply, how can i know the report id?

Thanks
--Venkat

 

[Turkbear]

Hi,
There are several ways to determine this ( read the reference I mentioned - ( see the CSP section)

Also, in the CMC, if you hover your mouse over the report name, look at the bottom and you will see a ID # - It is also the last set of numbers before the odd long filename.

Please check out the docs..This is not a simple system to use well and the learning curve can be steep at the start.

 

[venkatreddy]

Hi,

Thank you very much.

I could able to find the reportId. But after publishing my reports in CE, and if i look at the reports un CMC, if i click on Instance, its saying failed, and error is like

Can't open SQL Server.

I think, in order to view my report, i has to success.

Can u please tell me the what might be the error?

--Venkat

 

[Turkbear]

Hi,
Check your database connection information.
If you are using SqlServer be sure the Pageserver and Jobserver services are running under an account that has permission to access the data.

 

[venkatreddy]

Hi,

How can i pass the date parameter as querystring in unmanaged reports.

Thanks
--Venkat