Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing SQL Server sp parameter from ASP page to Report

Status
Not open for further replies.
jdub99

jdub99

Programmer
Oct 25, 2001
1
CA
I am trying to pass a parameter From an ASP page to a crystal report for opening in the ActiveXviewer. The report uses a Stored Procedure. I'm not sure that I'm passing the parameter correctly but it does get to the point where it loads the viewer, however at the top of the page it give me the message: "An Error has occured on the server in attempting to access the data source"

I have the web site set up locally on my machine and it is accessing a SQL DB located on a Server on our network. When I run the report directly within Crystal I don't have any problems with data access or anything else.

Does anyone have any suggestions on how I can resolve this problem or any approach to debugging?

thanks
 
Status
Not open for further replies.

Similar threads

s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
666
hilfy
hilfy
Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
837
Kennymc
Kennymc
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
553
Ivan Kok
Ivan Kok
Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
583
dgillz
dgillz
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
919
LyleU
LyleU

Part and Inventory Search

Sponsor

Back
Top