On Oct 25, 2:50 pm, beener <rmp_c...@hotmail.com> wrote:
> I'm working on SSRS 2000 to start off with. I have a subreport that
> takes one parameter. It worked beautifully until I had to change my
> result set to include records that did not always have the necessary
> value for the parameter so my parameter went from..
>
> parameter = fieldname
>
> To
>
> parameter = IIF(fieldname <> "", fieldname, 0)
>
> My problem went from Error: Subreport could not be shown for the
> records without the field value to showing the error message for those
> that do have a valid value in the field.
>
> I assume that I must be missing something rather simple, either it is
> our altitude affecting my brain or I haven't gotten over the shelling
> my baseball team took last night.
>
> Please help!
>
> TIA
>
> Renee