"Retrieve Column" button in Report Designer

[jing]

Hi,

When I edit a datasource in the designer (ie change the sql text), if I push the "Retrieve Column" button, it will only add columns, not remove them.

eg.
If I have

Code: Select all

Select stockcode, description FROM stock_items

to start with (so I have "stockcode" and "description" as my columns) and change it to

Code: Select all

Select stockcode FROM stock_items

Then push "Retreive Column", it still have "stockcode" and "description" there!!

Thanks

[Vital]

That behavior correct. If you need fully update column list you need select "Columns" node and press on remove button.

Thank you.