Page 1 of 1

"Retrieve Column" button in Report Designer

Posted: Thu Feb 15, 2007 9:46 pm
by 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

"Retrieve Column" button in Report Designer

Posted: Fri Feb 16, 2007 3:28 am
by Vital
That behavior correct. If you need fully update column list you need select "Columns" node and press on remove button.

Thank you.