Protecting a Report's Data Session

  • Article

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

  1. Browse the table containing the graph.
  2. Double-click the general field to display the graph.
  3. Double-click the graph to open Microsoft Graph and display the Microsoft Graph toolbar.
  4. 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