Protecting a Report's Data Session
To prevent your report's data session from being affected by the global data session as a result of changes made in other designers, you can set the report's data session to Private.
To set a private data session
- From the Report menu, choose Private Data Session.
If you want to display your query results in a graph, you can use the Graph Wizard, the Query Designer, or a SELECT - SQL command. To use the Query Designer or a SELECT - SQL command, follow the steps below. You need to include at least one numeric field in your result set to create a graph. After completing the query, you can select one of six types of graphs, each with two variations.
To modify the graph
- Browse the table containing the graph.
- Double-click the general field to display the graph.
- Double-click the graph to open Microsoft Graph and display the Microsoft Graph toolbar.
- Modify the graph in Microsoft Graph.
See Also
Adding Reports and Labels | Refining Page Layout | Using Expressions and Functions in Field Controls | Setting the Data Environment | Data Environment Designer | Programming for Shared Access | Graph Wizard | Query and View Designers | SELECT - SQL