From: mike on

I've had two occurrences of this happening. This last time I realized
I forgot a field in my stored procedure so I went and added it into
the proc.
When I got back to the report builder and execute the proc from the
Data tab my new field shows up

When I go the the Layout tab it doesn't see my new field. I tried
typing it in manually but I get an error when I try and run the
report.

I looked at the rdl file and there is a list of <Fields> listed in
the <DataSet> tag.
Is there a way to have this refreshed as the proc changes or do I
have to add this field in manually?

thanks
mike
From: Uri Dimant on
mike
Right click on the dataset and then Refresh


"mike" <themusiclistener(a)gmail.com> wrote in message
news:c8b38b71-f076-4643-9f41-65170fb4cb5e(a)z3g2000prd.googlegroups.com...
>
> I've had two occurrences of this happening. This last time I realized
> I forgot a field in my stored procedure so I went and added it into
> the proc.
> When I got back to the report builder and execute the proc from the
> Data tab my new field shows up
>
> When I go the the Layout tab it doesn't see my new field. I tried
> typing it in manually but I get an error when I try and run the
> report.
>
> I looked at the rdl file and there is a list of <Fields> listed in
> the <DataSet> tag.
> Is there a way to have this refreshed as the proc changes or do I
> have to add this field in manually?
>
> thanks
> mike


From: Toni on
I have this same problem, refreshing the dataset doesn't help.

Does anyone know of another solution to this?

Thanks
Toni

"mike" wrote:

>
> I've had two occurrences of this happening. This last time I realized
> I forgot a field in my stored procedure so I went and added it into
> the proc.
> When I got back to the report builder and execute the proc from the
> Data tab my new field shows up
>
> When I go the the Layout tab it doesn't see my new field. I tried
> typing it in manually but I get an error when I try and run the
> report.
>
> I looked at the rdl file and there is a list of <Fields> listed in
> the <DataSet> tag.
> Is there a way to have this refreshed as the proc changes or do I
> have to add this field in manually?
>
> thanks
> mike
> .
>