Hi. I am creating reports, both with the wizard, and I have noticed that when a table is added to the report’s data sources, all of it’s fields are added to the query, even if only some are selected to be visible. Is there any way to remove the additional fields from the query, as it seems a bit unnecessary to pull all the data from a given table when only one or two fields are needed. Thanks Matt
Hi On the “fields” node of the datasource table, you can specify the property “Dynamic”. If you set it to “No”, you can delete fields from the datasource.
Thanks! Exactly what we were looking for [:)]