Jump to content

How to update Fields when updating dataset


neil.walker

Recommended Posts

Hello,

I am using a stored procedure as my dataset. It has now changed and has different field names. If I edit the dataset via the 'dataset and query...' I can update it fine and on clicking 'Read' it gets all the new fields,etc, but it does nothing with it. When I go back to the Outline view under fields they are all the same as my original query. So how do I get the designer to update the fields with the correct ones so I can drop them into my report design, because manually deleting then manually adding is a big task.

I then thought it might have been the 'tableDataset', but updating that simply returned 'no data' on doing a preview and didn't update the fields either (so I've no idea what 'tableDataset' is or what it's meant for.

the only way I could get it to work was to create a new report, which seems a bit daft.

thanks.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...