Modified: 2018/03/07 11:41 by EricCrocker - Uncategorized

Edit

Reports Sand Garden

back


Edit

Introduction

Reports Sand Garden is going to show you a few reports that have been created by you the user in your day to day or week to week need. Show you how they were created and the steps we used.

We want to show the versatility and usefulness of the Reports pages.

Edit

Due Diligence

When you load up a report for the first time it is in its base form. If you have made changes it will be in an "As you left it" stage. This is in there to save your entries for further use. If you adjust it for another reason, you will have to go back and forth between the custom reports you make or you can try and use another base report. If you think that you messed up the report you're trying to adjust, don't forget that you can reset it to the base settings.

There is nothing like an "oops" moment where you remove too much:



Main Menu, View, Reset:

Yes, it's starting over, but it's starting over at the base report.



Edit

Filtering, Basic

Basic manipulation within reports is in the context menu:

Right click anywhere in the Columns Bar(Yellow Box):



And you will open it up:

• Sort Ascending A-Z - Sorting alphabetically A to Z.
• Sort Ascending Z-A - Sorting alphabetically Z to A.
• Clear Sorting - Undo the sorting you may have used.
• Hide Group-by box - Removes the Group-by box. (The bar within the green box in the picture above).
• Show Group-by box - Brings back the Group-by box it is missing.(The bar within the green box in the picture above).

• Remove this Column - Removes the column you have your cursor over.

• Column Chooser - Opens up the extra Columns box on the report page.

• Best Fit - Will try and resize the column you have your cursor over.
• Best Fit (all columns) - Will try and resize all of the columns.
• Filter Editor - For advanced filtering.

You will be using two of the above more often than the rest. Remove this Column and Column Chooser. The columns choices depend on what report your in. If you want a more detailed list of what columns are in what reports. See Reports. Any column you remove goes back into the column chooser so if you remove the wrong one you can get it again.





Edit

First Sample

Starting with the base report on Aging:

Remove the Customer group-by button at the top (In the Group-by Bar).
Right clicked and remove "Applied" and "Detail" columns.

Added "Sales Person" column from the column chooser.
Dragged (Held down left click) the "Total" column to the front.

It's Now done.

Here I add the "Last Payment Received" column as others have added it to this report'



Edit

Second Sample

For this one, we are going to show how we can manipulate the Contracts Report to Sort by Product and Comment. There may not be a lot of you that will sort by both, but we have seen a few and we wanted to show off the "Group-By" feature as well as highlight the byproduct of adding a Product Type and Comments to your contracts.

• Drag Customer tab down from Group-By Bar to Column Bar.
• Right-click > Context Menu > Column Chooser and add:
  • Comment Column.
  • Product Column.
  • Revenue Source Column.
  • Revenue Type Column.
  • Station Column.
  • Salesperson Column.

• Close Column Chooser.

Then...

• Drag Product Column up to Group-By Bar.
• Drag Comment Column up to Group-By Bar.

Finished Report...








Edit

Report Templates

If you find that you don't like making detailed reports over and over may we recommend the Report_Templates add-on? Yes, this is a shameless plug for an add-on, but we have quite a few Traffic Managers as well as Sales that tell us they cant work without it. The loudest reason we hear is that with the ability to save a self-made report, is that they are able to build from those self-made reports to an even more detailed report to gather the info they need.

The Best thing I've heard concerning this add-on is the quote;

"If I have to make a report twice, I save it".



Edit

FAQ

Edit

Additional Information