Dear Brian,

I had sent you following query on CRystalReportsBooks.com and you had replied to it. But, when I read  Chapter 17, I did not get information about passing parameters to the Stored procedure used as a dataSource of SubReport. I tried all you had mentioned in your reply but I still get the message missing Parameter value.

I give below my code. So, pl. tell me what to Do.

Background:

1. I have a Main Report whose Data source is a Stoted Procedure with two input Parameters @P_FINYEAR and @P_DEPT. These are shown by CR in Parameter List.

2. I have a sub-report(embeded in Main Report), whose data source is also a Stored Procedure with two input Parameters @P_FINYEAR and @P_DEPT . These are also shown in parameter list of SubReport.

3. The Main and sub Reports are linked based on two Fields of the Datasource viz. FINYEAR and DEPT.

4. I have been passing parameters to Main & Sub Reports as follows:

Dim ocrListTax as crListTax (which is class for my rpt file)
Dim oSubReport as new ReportDocument
ocrListTax = New crListTax
ocrListTax.SetDatabaseLogon(’abc’,'pqr’,'NS-01′,’nsdb’)

ocrListTax.SetParameterValue(@P_FINYEAR “, intFinYear)

ocrListTax.SetParameterValue(”@P_DEPT”, strDept)
oSubReport = ocrListTax.OpenSubReport(”crSubReport.rpt”)
oSubReport.SetParameterValue(@P_FINYEAR “, intFinYear)
oSubReport.SetParameterValue(”@P_DEPT”, strDept)
ocrListTax.ExportToDisk(ExportFormatType.PortableDocFormat, ‘d:FinTax.pdf’)

ocrListTax.Close()

The Problem

It still gives me missing parameter value error.
(CR2003.Net version is used by me. The error also appears in CR2005.Net)

Dilip Nagle