Click here to Skip to main content
15,894,825 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I inherited a VB6 application that calls CrystalReport .rpt files. The reports take 4 parameters. The first three are string parameters that prompt the user for sort order fields. Each has a list of values associated with it. The last parameter is a series of primary key values.

When the report is run the code passes a string of key values to the last parameter. When the VB6 version is run the ReportViewer appears and a popup window is shown prompting for the three sorting parameter fields. (The prompting window is coming from the CR Viewer, not from the VB6 code) The report is run against a SQL Server 2012 database.

I have created a VS 2013 .Net 4.7.1 C# version of the application and I have saved the .rpt files as CR 2011 (14.0.4). Rather than prompting for the three sorting parameters, I get a CR error "Missing parameter values". Here is the detail of the error:

System.Runtime.InteropServices.COMException occurred
  _HResult=-2147217394
  _message=Missing parameter values.
  HResult=-2147217394
  IsTransient=false
  Message=Missing parameter values.
  Source=rptcontrollers.dll
  ErrorCode=-2147217394
  InnerException: 


What I have tried:

If I provide the values for those three fields the report will run, but that is not what I want. I want the CR report to prompt for the values like it does in the VB6 application and like it does if I run the report in the Crystal Report application.

Any suggestions will be appreciated.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900