button in two pages: 'Library' & 'My Reports' page. Go to either of the pages using our navigation panel on the top, and click on
Name your report. Add Report Description if required, and click on 'Continue'.
Select Report Type
From the the side-bar on the left, select the Report Type, and in this case we have selected 'Product Variant'.
Select Date Range
Select your desired date range using the Date Selector tab. We have several preset date ranges to choose from, OR select your own Start and End Date as per your requirement.
For example: In this case we have chosen Last 30 days.
Select the fields you want to add to your report using 'Select Fields' tab. Use the search bar to search for the fields required for your report - Barcode (UPC), Inventory Quantity, and Price.
Finally, Save the report by clicking on the Save button. Once saved, you can access your report anytime from 'My Reports' page.
That's it. You've successfully customized your report.
Selected Fields Section
On the left, you can find all the fields that you've selected for your report.
Values Box: Shows you the Numerical fields.
ROWS Box: Shows you the text fields.
The selected fields automatically get organized on the first row. In rare cases, you might choose to organize certain fields in the first column. To do so, you can easily drag and drop the fields into the COLUMNS Box.
When you place the cursor over the field, you'll be able to view the options to edit the field.
Edit: You can edit the field name by clicking on the
Once you're done renaming the field, click on 'Okay'.
Hide: You can hide the field from the report by clicking on
button. It is useful in case you don't need a calculated field to be shown. This way you do not remove the field, but only hide it.
Remove: Click on
to remove the selected field from the report.
Additional Options: Click on the
button to access other field editing options.
Group by: You can group them according to Value(none), Row, and Column.
Aggregate type: You can add a calculating function to the numerical field. The 'Sum' aggregate '∑' is set by default on all numerical fields.
Sum - Gives you a summation of all the records in the field.
Count- Gives you a count of all the records in the field.
Count Unique - Gives you a count of all the unique records in the field.
Min - Gives you the minimum value among the records in the field.
Max - Gives you the maximum value among the records in the field.
Average - Give you the average value among the records in the field.
Date Format: You can change the date format for date fields as shown below.
The selected fields can be re-arranged according to your requirement by dragging and dropping the fields.
The arrangement from 'top to bottom' in the box corresponds to the 'left to right' arrangement in the row.
Features like Wrap Primary Records and Sub-total are designed with respect to the first column(from the left). Hence, re-arranging the field to the top(in the ROWS box) will enable you to apply the features. To know more about these features, click here.