June CTP - Passing NULL value to a Sub-Report Parameter
Passing NULL value to a Sub-Report Parameter fails with this message - "A parameter or data source credential is missing a value. Prompting for this value has been disabled. Supply a value or enable prompting."
Anyone else seen this?
Thanks
[252 byte] By [
KKaps] at [2007-12-16]
I did set 'Allow Nulls' for the parameter. However, this sub-report accepts multiple parms and one of those parm is required and hence I had not set 'Allow Nulls' for this parm. When I did set allow nulls for the required parm, the sub-report displayed correctly. I made sure that NULL was never passed to this parm. Just to confirm what I just saw, I went and unchecked 'Allow Nulls' again for the required parm and the sub-report still displays correctly. The end result is that the sub-report is now displaying as expected, but I am not sure what made it work.
Paas the parameter to subreport .
Syntax is
paramField.ReportName="Transferee";
paramField-->ParameterField
Transferee--> Sub report name
Total Syntax is
paramField =
new ParameterField(); discreteVal=
new ParameterDiscreteValue(); paramField.ParameterFieldName = "@CustId";
discreteVal.Value = 2463;
paramField.CurrentValues.Add(discreteVal);
paramFields.Add(paramField);
paramField.ReportName="Transferee";
