Error when no recordset returned

I get the following error for five of my fields on my report when no
recordset is returned. They all happen to be items that are being pulled from
another table. So it seems that if there are no IDs to link to the other
table, I get this error. Can anyone tell me how I can get around this to show
a blank report instead of an error message? Thanks.
d:\reports\ProblemReport.rdl The value expression for the textbox
â'LocationNameâ' refers to the field â'LocationNameâ'. Report item expressions
can only refer to fields within the current data set scope or, if inside an
aggregate, the specified data set scope.Please disregard the previous message...apparently I was not too smart
earlier today :)
"Mike Collins" wrote:
> I get the following error for five of my fields on my report when no
> recordset is returned. They all happen to be items that are being pulled from
> another table. So it seems that if there are no IDs to link to the other
> table, I get this error. Can anyone tell me how I can get around this to show
> a blank report instead of an error message? Thanks.
> d:\reports\ProblemReport.rdl The value expression for the textbox
> â'LocationNameâ' refers to the field â'LocationNameâ'. Report item expressions
> can only refer to fields within the current data set scope or, if inside an
> aggregate, the specified data set scope.
>|||Hi Mike,
I am facing the same problem in one of my reports.
Can you please post the solution (or work-around) to do away with this error
message ?
Your help would be highly appreciated.
Regards,
Zayeem.
"Mike Collins" wrote:
> Please disregard the previous message...apparently I was not too smart
> earlier today :)
> "Mike Collins" wrote:
> > I get the following error for five of my fields on my report when no
> > recordset is returned. They all happen to be items that are being pulled from
> > another table. So it seems that if there are no IDs to link to the other
> > table, I get this error. Can anyone tell me how I can get around this to show
> > a blank report instead of an error message? Thanks.
> >
> > d:\reports\ProblemReport.rdl The value expression for the textbox
> > â'LocationNameâ' refers to the field â'LocationNameâ'. Report item expressions
> > can only refer to fields within the current data set scope or, if inside an
> > aggregate, the specified data set scope.
> >