Top

 

 

 

 

 

 

 

 

 

Saving and Using Queries

You can save your report criteria in a query, storing report setups for later use.  By selecting a saved query and clicking Reset, all options, chains, divisions, and so on that were previously set up re-display.  Then you can run the report "as is" or modify the criteria to meet your immediate needs.  

You can also select and use queries that other Brand Representatives have created.  Although only the user who created a query can modify or delete it, you can make your changes and then save it as a new query under your name.

Note:  If a distribuLink user is removed due to change of assignment or other reasons, all queries created by that user are automatically deleted.

Where are the saved queries found?

You can create and save a query, and select from the list of saved queries, from the Call Point Pricing, Consolidated Chain Pricing, and Distributor Pricing Report windows.

See the following steps to save, use, or delete a query.

 

To save a new query:

  1. Enter your report criteria and name your query

  2. Save your query

 

To use a saved query:

  1. Select the query

  2. Click Reset and make changes

  3. Run the report

To delete a saved query:

  1. Select the query

  2. Click Delete

 

 

Save a new query

A.

Enter your report criteria and name your query

From the distribuLink tab:

  1. Open the desired Report window.

  2. If desired, enter a different name in the Report Name field.  

This will be the e-mail subject line.  If the report is held for downloading, this name will appear in the download list.

If you run an RTF format report, this will be the report title.

  1. This will be the title of the report, and will appear on each page of the report.

Note: Leave the Selected Query drop-down list at Not Selected when you are saving a new query.

  1. Enter a name for your new query in the Name for New Query field.

  2. Change the report criteria to the settings you want to save.

_________________________________________________________________

B.

Save your query

  1. Click Save when your settings are complete.

Important: Do this before running the report.

  1. If you wish to run the report now, click Report or Display. Otherwise, click Back to return to the main distribuLink window.

_________________________________________________________________

Top

 

Use a saved query

A.

Select the query

From the distribuLink tab:

  1. Open the desired Report window.

  1. Click the arrow by the Selected Query drop-down list to display a list of saved queries.

Note: The list includes all queries saved by Coors Brewing Company employees.  The list displays the query name, the Username of the person who created it, and the date and time it was last modified.  The list is sorted by 1) Username, 2) query name, and 3) date/time.

  1. Select the query from the list.

_________________________________________________________________

B.

Click Reset and make changes

  1. Click Reset. The window re-displays with the settings that were saved in the query.

  2. Make any desired changes to the report settings.

Note: If you make changes, you can save them as a new query.  Enter a Name For New Query and click Save.

_________________________________________________________________

C.

Run the report

Click Report or Display to run the report.

_________________________________________________________________

Top

 

Delete a saved query

A.

Select the query

Note:  Only the individual who created a query can delete it.  If a distribuLink user is removed due to change of assignment or other reasons, all queries created by that user are automatically deleted

From the distribuLink tab:

  1. Open the desired Report window.

  1. Click the arrow by the Selected Query drop-down list to display a list of saved queries.

Note: The list includes all queries saved by Coors Brewing Company employees.  The list displays the query name, the Username of the person who created it, and the date and time it was last modified.  The list is sorted by 1) Username, 2) query name, and 3) date/time.

  1. Select the query from the list.

_________________________________________________________________

B.

Delete the query

  1. Click Delete.

  2. At the prompt, select Yes.

_________________________________________________________________

Top

 

 

Updated 2/28/2006