Skip to Content
0
Former Member
Jun 01, 2009 at 08:10 AM

ReportDocument.SetParameterValue problem

655 Views

Hello !

I need some advice for this problem:

I have a very simple CR2008 report used from my program (C#, VS2008, SQL2005, Northwind demo database). The report is used to generate a PDF document using Export method of ReportDocument object. It works OK.

Now I added a discrete parameter (a country) in the report to filter the result. In Crystal Report designer I can change the parameter value and see the report (preview) filtered according to the parameter. Now I need to set the parameter in my program at runtime before calling Export().

Calling

reportDoc.SetParameterValue("Country", "USA");

I get an exception at runtime which is totally unrelated to the parameter: "Code from database provider: 17. Unable to start connexion" (Translated from french so the exact english text may be a little bit different). Without that code line, the program is working OK and report is filtered with country selected in report designer.

Any help is appreciated.

Regards,

--

Francois PIETTE

http://www.overbyte.be