Exporting and formatting Reports

There may be times when you wish to export a standard report to work with in other software. StoreTender allows for exporting of most reports to CSV files, which can easily be opened in your spreadsheet or other application.

 

Simply run the report you wish to work with. In the report viewer, click on the Export button, and select a filename.

 

 

Some reports, due to the way the information is stored, may not appear formatted correctly when viewed in a spreadsheet application, such as Excel. In the below example, you can see that there are spaces where there should be data. This is because we use special methods to store the information. It is easily cleaned using a few simple steps.

These steps are for Excel. Similar steps can be found in your application's user documentation.

 

1. Select the cells of the table.

 

 

2. Press "F5" to bring up the "Go To" box, and press "Special"

 

 

3. Select "Blanks", then click "OK"

 

 

4. Now that your blank cells are selected, press CTRL and minus key (-) at the same time. Then select "Shift Cells Left" and press "OK"

 

 

5. That's all there is to it. Your report is now aligned. Feel free to clean up any header breaks "-----" that you don't want.

 

Was this answer helpful?

 Print this Article

Also Read

Helix Innovations (on!) Loyalty Fund Program (Scan Data)

The Altria brand, Helix Innovations, has instituted a Loyalty Fund Program (LFP), in conjunction...

JUUL Retail Access Control Standards (RACS)

Retail Access Control Standards (RACS) are a set of guidelines set forth by JUUL Labs that...

Creating Price Signs

We're pleased to introduce the Signs printing module, included with your StoreTender Pro and Back...

Philip Morris / USSTC Loyalty Fund Program (Scan Data)

Philip Morris (PM) / USSTC has instituted a Loyalty Fund Program (LFP), in conjunction with their...

Charging Check Cashing Fees

StoreTender supports the calculation and tracking of check cashing fees that you can collect when...