SSRS 2000 Dataset vs. Fields List

[seequal]

Hello,

I have created a report that has four datasets all looking at the same stored procedure using the StoredProcedure Command type. All are parameterised by a single date.

The difference between the four is a static integer parameter that I have manually set in the Parameter tab for each Dataset.

The first two Datasets return the correct information (they return the same data structure from the SP). With the second two however, they work fine when I "run" the Dataset in the Data Tab, but I can't get the Field List to match what is being returned here. The Fields remain the same as in the first two Datasets.

Can anyone help?
Thanks

 

[xlbo]

Click the "Refresh Fields" button in the dataset design area

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question