smitha

smitha

  • NA
  • 5
  • 0

Passing Values to sub reports

Mar 6 2009 2:22 AM

Hi ,

I am working with ASP.Netand CrystalReport XI R2.

 

I have a Main report which has 5 sub reports in it.

 

The main report just act as a place holder for the sub reports.it doesn’t have any tables or fields.

 

The Main report just has one parameter(Parameter Name :-ShowReports) which takes multiple values.

 

This parameter is used in the Main report to decided which all sub report to display according to the users selection in the UI.

 

Regarding the Sub reports:-

 

a)      3 Sub reports has one parameter each with same value(Parameter Name :- Handle)

b)      2 Sub reports has 3 parameter each with same value(Parameters are :- id1,id2,id3)

 

So in total even though I have 10 Parameter, I need to pass values only to 5 Parameters.

 

Ie for ShowReports     Used in Main report(Multiple Values)

          Handle            -    Used in 3 Sub Reports(Discrete Value)

          id1,id2,id3       -    Used in 2 Sub Reports(Discrete Values)

 

As I was going through the samples code available in different sites ,I noticed that, to pass the value to a parameter in subreport I need to mention the name of the Subreport.

But in my case I cant do so, because the same parameters are used across different sub reports.

 

When I run the crystal report manually it ask only for 5 parametrs and it is working fine.

But when I try to do with asp.net it is giving an error saying that “Missing parameter values”

 

When I saw the report Properties I could see that the parameter count is 10.

 

To conclude i have two issues

 

   1.Passing values to subreports in above mentioned scenario

   2.How to pass both discrete and Mutiple Values together as parameters to a single report.

 

 Could please help me on this ?

 

Please let me know if you require more detail information on this issue.

 

Regards,

Smitha.


Answers (2)