Dynamic database connection problem (Crystal Reports + c#)

[pquilty]

Hey All,

OK this is my first post but anyways here is the story... I am creating a c# program that allows you to run a crystal reports...(easy right)

what I need to do:
1. pass a connection string to the crystal reports (IE: userid, password, server and database)
2. pass on average 5 parameters to the report.

Ok here is what is messing me up...the crystal report is tied to a stored procedures. Also i can not change the report in any way so please take that into consideration.

Presently i have a sample application rigged up but when i pass the connection string to the report, the report errors out and says:

"This field name is not known.
error in File ...:
Error in formula <Title>.
WhilePrintingRecords;
This field name is not known"

This report was working fine with another program (No Source Code) and I did not change it before bringing it over to my program, so there can't be an error in the report.

Please Help...I am ripping my hair out trying to get this

Cheers,
Paul

 

[jmeckley]

try the crystal forums.
forum767
forum766
forum768
forum149

when i work with crystal and .net I always use a datatable as the reports datasource to abstract the db away from the report.

Jason Meckley
Programmer
Specialty Bakers, Inc.