In This Article:

    Report Wizard: Creating a Report from an Advanced Query

    In This Article:

      The Report Wizard allows customers to run an Advanced Query within the Word Processor and then use the output of that query to print a formatted report.

      1. From the main Salsa CRM menu, choose Manage, Documents, and then Word Processor.
      2. From the Word Processor menu, choose Query Wizards and then Display Report Wizard.
      3. The Report Wizard will display on the right side of your screen and guide you through the necessary steps of generating a report.
      4. Choose the Open or run a Query button at the top of the Report Wizard panel.
      5. See the Queries section of Help for instructions on setting up and running a query. Note: The order of the query options output is how the information will appear on the final formatted report.  Sort the information in the query as to how you want it to appear in the final report.
      6. On the last step of the query, choose the Finish You will return to the Word Processor screen. Below the Open or Run a Query button will be the number of records your query returned.
      7. At the bottom of the Report Wizard panel, choose Next and then Next
      8. Insert the desired variables for your report. Instead of typing things like today's date, double click on Today's Date under Common Variables. Salsa CRM will insert {{Today's Date}} at the location of your cursor. When you print the report the variable {{Today's Date}} will be replaced by the actual date.
      9. To include all of your query data into one large formatted table insert the variable {{All Data With Border}} or {{All Data Without Border}} at the beginning of the report and the information will be displayed with or without a border. 
      10. To sum a column of data using the Grand Total function place the variable {{Grand Total Columns}} on its own line, and every column variable placed after it on that line will be summed in the last row of the table.
      11. To break your report into sections based on groupings of any column (such as City, State, Zip Code, Group) use the Control Break  Place the variable {{Control Break Fields}} on a line by itself, and every field listed after it will be part of the grouping criteria. Grand Total Columns also works in conjunction with Control Break reports, and the totals will display at the end of every group. A Grand Total Amount will be displayed for every column specified at the bottom of the document.
      12. The above variables will create the following report:  
      13. After you have inserted all of the information for your report, select
      14. Select View Report in Browser and an image similar to the above report will appear.
      15. Right-clicking in your browser allows you to print the report or copy to Excel.
      Was this article helpful?
      0 out of 0 found this helpful
      Have more questions? Submit a request

      Comments

      0 comments

      Article is closed for comments.