I have a report that I run daily but have decided that I need to add a new field to it. The problem I am having is that I open the report in design view and then add existing fields I am shown all fields I have already placed in the report but no tables so I can add new ones. how can I bring up the available table list so I can add the field I need?
When I open the report wizard and start a new report the field list lets me see all the tables in my database and open them up to select the fields I need.