How to pass Parameters from the crystal query to the web server 1

[Hm786]

Hi!,

I need help on solving the problem with the crystal report. I created a qurey with four parameters(parameters are created by the using crystal query designer). This report works fine when I access through crystal report designer, but when I try to access through the web server I get a error message saying error in the file: cannot open sql server. Can any one help me how to solve this problem.


Thanks,
Hamida

 

[vechalapu]

Hi,

Please make sure whether your login information to SQL Server is correct. Try to create DNS for SQL Server and use DNS in your Crystal Report and try to run your app.

Hope this helps.

 

[jermine]

in one of our recently finished projects, we used in web reporting, passing at most 3 parameters.

you may want to try using ASP

 

[Ngolem]

Hi;

Your problem is not in the passing of parameters...your problem is that queries that are developed in Crystal Sql Designer to present data to your Crystal report, ARE NOT supported by the Web Component Server.

Runs fine in Crystal 8 Report Designer but cannot be run from the Web Component Server...it is frustrating

 

[Guest_imported]

Can any one help me in configuring the Apache tomcat Configuration file, to access Crystal Report7.
Thanks

 

[mthakershi]

Hi Hamida,

Your problem is not actually in passing parameters. Please go to the last section of the message for parameters thing.

I got the same error month ago. My task was to work with reports upgraded from 7.0 to 8.5 with 8.5 runtime. Reports were having p2ssql or pdssql database driver (SQL server).

If you are using LogonServer method (with p2ssql or pdssql) to logon to the report database, it will give you this error. There might be no defects in the code but it is a cruel bug.

What you need to do is, if you can change your reports to have ODBC driver (pdsodbc.dll or p2sodbc.dll). You need to create one system DSN on the server machine and use that DSN in the LogonServer method instead of the database. Same think is working with p2soledb and pdsoledb drivers.

But if you have 8.5 runtime on the server, you can do this.


About parameters,
I do not know how to pass parameters and query from designers.

Post again if you have any further problems.

Have Fun,
Malay M. Thakershi
mthakershi@yahoo.co.in

 

[Guest_imported]

Hi! I'm italian web developer!
How i can change crystal report activex background color?
Is there some post parameter?
Thank you!