Does anyone know how I can pre-select the columns in a Report Builder (formerly QueryBuilder) query? We have many users who do not realize that they have to select all of the columns they wish to see in the resulting report and just select the column with the criteria in it. Is there a way to have the criteria page render with all of the columns checked and have the user uncheck the columns they don't want to see?
Create a "saved report" for each with columns checked (and possibly criteria selected / entered).
Convenience and confusion reduction: Capture the URL of the saved report and post elsewhere (e.g. in a guidance document). User selects the URL and is immediately in the Saved Report. To get the URL you may have to fool a bit with F11 (in iE) to get it to show.