Reporting Services Reports

Reporting Services Reports shows all available Reports in the system. Users can also view Reporting Services Reports in each module in the system, which will only show the Reports relatred to a specific module.

When you click on the Reporting Services Reports icon, the Reports are displayed under three possible tabs All Reports, My Reports, and My Subscriptions.

All Reports lists all the reports available in ShopEdge with the default parameters. A feature of the ShopEdge system that allows the user to save the Reports to My Reports and change the defaults to their own specific requirements. Additionally, users will be able to subscribe to specific reports which will then appear under the My Subscriptions tab.

To view Reporting Services Reports, navigate to the images/reportingservicesreports/admintab-1.jpg tab and click on the images/reportingservicesreports/reportingservicesreportsicon-2.jpg icon.

The Reporting Services Reports screen will be displayed showing all the available Reports listed under the default tab. Where applicable, you will find an Overview, Summary, and Detail level report. The Overview Report will show data in graphs. The Summary Report will show graphs combined with data, and the Detail Report will only show data. You can navigate from an Overview Report to a Summary and Detail Report by clicking on a data point in a graph.

../_images/defaultallreportstab-3.jpg

To open a Report in the Reporting Services Reports screen, simply double-click on the appropriate row.

Above the Report you can select options to perform different functions.

../_images/functions-4.jpg

images/reportingservicesreports/firstpageicon-5.jpg - First page

images/reportingservicesreports/previouspageicon-6.jpg - Previous page

images/reportingservicesreports/nextpageicon-7.jpg - Next page

images/reportingservicesreports/lastpageicon-8.jpg - Last page

images/reportingservicesreports/backtoparenticon-9.jpg - Back to Parent Report

images/reportingservicesreports/stopicon-10.jpg - Stop the Report while it is processing

images/reportingservicesreports/refreshicon-11.jpg - Refresh the Report

images/reportingservicesreports/printicon-12.jpg - Print the Report

images/reportingservicesreports/printlayouticon-13.jpg - Displays the Report in the printed layout

images/reportingservicesreports/pagelayouticon-14.jpg - Page layout

images/reportingservicesreports/saveicon-15.jpg - Export the Report

images/reportingservicesreports/zoom-16.jpg - Zoom percent

images/reportingservicesreports/input-17.jpg - Input data into the field to scan for in the Report using the images/reportingservicesreports/findicon-18.jpg and images/reportingservicesreports/nexticon-19.jpg icons

Filtering Reports and Report Parameters

Reporting Services Reports allows parameters to be selected for filtering. Reports can then be sorted and grouped with totals depending on the selection.

../_images/parameterselection-20.jpg

If no filtering, sorting or grouping is required, click on the images/reportingservicesreports/viewreportbutton-23.jpg button and the Report will be displayed.

Filters

To filter Reports, follow the steps to open the appropriate Report.

Select the fields you wish to filter by clicking on the images/reportingservicesreports/dropdownarrow-24.jpg button to make the selection. Once you have selected the appropriate filters, click on the images/reportingservicesreports/viewreportbutton-23.jpg button and the Report with the filters selected, will be displayed.

../_images/parameterselectiondropdown-25.jpg

Grouping and Group Totals

The Report can be grouped in any sequence and group totals will be displayed for the groups selected.

../_images/grouping-26.jpg

Select the fields you wish to group by clicking on the images/reportingservicesreports/dropdownarrow-24.jpg button to make the selection.

../_images/selectiondropdown-27.jpg

Select the group total by selecting True next to each “Show 1st (2nd, 3rd, etc.) Group Totals”.

../_images/trueorfalse-28.jpg

Click on the images/reportingservicesreports/viewreportbutton-23.jpg button and the Report will be displayed.

Exporting Reports

Reporting Services Reports allows Reports to be exported in the following formats: XML, CSV, PDF, MHTML, Excel, TIFF file, and Word.

To export a Report, follow the above steps on how to open a Report. Click on the images/reportingservicesreports/saveicon-15.jpg button and select the format for the Report.

../_images/formatselection-29.jpg

You will be asked where you would like the Report to be saved on your computer. Select the appropriate folder and click on the images/reportingservicesreports/savebutton-30.jpg button to save.

../_images/savetofolder-31.jpg

Saving Reports to “My Reports”

To save a Report to My Reports, click on the images/reportingservicesreports/savereportasbutton-32.jpg button once you have opened the appropriate Report.

The Save Report window will be displayed. Enter the Report Name and Description and click the images/reportingservicesreports/okbutton-33.jpg button.

../_images/savereportaswindow-34.jpg

The Report can now be used by clicking on the My Reports tab located on the Reporting Services Reports screen.

../_images/myreportstab-35.jpg

Subscribing to Reports

The system allows you to set up Report subscriptions so Reports can be delivered to your inbox in a variety of formats.

To subscribe to a Report, simply click on the images/reportingservicesreports/subscribebutton-36.jpg button at the bottom of the screen.

../_images/screensubscribe-37.jpg

This will open up the Report Delivery Schedule window, where you can enter in the Email Address(es), Description, select the Format, and configure the Delivery Schedule based on your preferences.

../_images/deliveryscreen-38.jpg

Once you have entered in the subscription information, click on the images/reportingservicesreports/okbutton-33.jpg button to save your subscription.

You can view or modify any current report subscriptions by navigating to the Reporting Services Reports screen, and clicking on the My Subscriptions tab.

../_images/mysubscriptionstab-39.jpg

Note

You can delete a subscription by highlighting the appropriate subscription row. Use your Delete key and when the system prompts you, select Yes. The subscription will be removed.