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



Answer this question

June CTP - Passing NULL value to a Sub-Report Parameter

  • fundu_itguy

    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.


  • BenJoldersma

    Did you set 'Allow Nulls' on the parameter in the subreport



  • Tim Higgison

    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";



  • June CTP - Passing NULL value to a Sub-Report Parameter