"Retrieve Column" button in Report Designer
Posted: Thu Feb 15, 2007 9:46 pm
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
to start with (so I have "stockcode" and "description" as my columns) and change it to
Then push "Retreive Column", it still have "stockcode" and "description" there!!
Thanks
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
Code: Select all
Select stockcode FROM stock_items
Thanks