×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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

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

(OP)
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



 

RE: How to pass Parameters from the crystal query to the web server

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.

RE: How to pass Parameters from the crystal query to the web server

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

you may want to try using ASP

RE: How to pass Parameters from the crystal query to the web server

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

RE: How to pass Parameters from the crystal query to the web server

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

RE: How to pass Parameters from the crystal query to the web server

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

RE: How to pass Parameters from the crystal query to the web server

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close