Report Pundit
WelcomeStart Free Trial
  • โœจWelcome to Report Pundit Documentation
  • ๐ŸกReport Pundit Website
  • ๐Ÿ’ปReport Pundit App
  • ๐Ÿ›’Shopify Testimonials
  • ๐Ÿ“ŒGetting Started
    • ๐Ÿ‘จโ€๐ŸซWalkthrough
    • โ„น๏ธNavigation Panel
    • ๐Ÿ Home
    • ๐Ÿ“”Library
    • ๐Ÿ’ผMy Reports
    • โฐSchedules
    • โš™๏ธSettings
      • ๐ŸชชAccount
      • ๐Ÿ”Data Sync Options
      • ๐Ÿ› ๏ธReport Formatting
        • ๐Ÿ“…Week Start from Sunday
        • ๐ŸŒ•Include Current Day
        • ๐Ÿ’ฒEnable Currency for Reports
      • ๐Ÿ“€FTP, Google Drive, and Google Sheets
      • ๐ŸŒ€Recent Sync History
      • ๐Ÿ“ฌCustom Email
      • ๐Ÿ‘ฅUser Management
      • ๐Ÿคตโ€โ™‚๏ธShopify staff
    • ๐ŸงฉHow to Create a Custom Report and Auto-Schedule It
  • ๐Ÿง Knowledge Base
    • ๐ŸงพReport Creation
      • Customized Reports
        • Re-arrange columns
      • Filters
        • 'Contains' & 'Not contains'
        • 'Is' & 'Is not'
        • 'Include' & 'Exclude'
        • 'is Blank' & 'is not Blank'
        • 'begins with' & 'ends with'
        • '= Equals' & '!= Not Equals'
        • '> Greater than' & '< Lesser than'
        • '>= Greater than or equal' & '<= Lesser than or equal'
      • Sort
      • ๐Ÿ–Œ๏ธCustom Fields
        • Calculated Columns (Fields)
        • ๐Ÿ›ก๏ธStatic Field
      • Data Comparison
      • Formatting Tools
      • Sharing Report Links
      • Exporting the report
      • Unique Reports
      • Staff Details
      • Other Options
    • ๐Ÿ”—App Integrations
      • Stocky
      • UpPromote
      • Yotpo
      • Sezzle
      • Square
      • PayPal
      • Google Analytics 4
      • Amazon Ads
      • Bing Ads (Microsoft Ads)
      • Facebook
      • Snapchat
      • TikTok
      • Ship Bob
      • Ship Station
      • Ship Hero
      • Bold
      • Printful
      • Printavo
      • Authorize.net
      • Recharge Payments
      • Klarna
      • Shippo
      • Returnly
      • Rich Returns
      • Seal Subscriptions
      • Google Ads
      • Stripe
    • ๐Ÿ“ฅSchedules
      • โŒšHourly
        • "N" Number of Days
        • Week to Date
        • Static Start Date
        • Custom Date Range
      • ๐ŸŒžDaily
        • Custom Time Range
        • Custom Date Range
        • Static Start Date
        • Year to Date
        • Quarter to Date
        • Month to Date
        • Week to Date
        • "N" Number of Days
      • ๐Ÿ“†Weekly
        • Year to Date
        • Quarter to Date
        • Month to date
        • "N" Number of Days
        • Static start date
        • Custom Date Range
      • ๐Ÿ—“๏ธMonthly
        • "N" Number of Days
        • Quarter to Date
        • Year to Date
        • Static Start Date
        • Custom Date Range
      • ๐Ÿ•žSchedule Modification
      • ๐Ÿ”ฝOutput Options
        • Email
        • ๐Ÿ“คFTP
        • ๐Ÿ’ฝGoogle Drive
        • ๐Ÿ—’๏ธGoogle Sheets
        • Power BI
        • BigQuery
    • ๐Ÿ“ƒReport Types
      • ๐ŸคตSales
      • ๐ŸฅกOrders
      • Inventory
      • ๐ŸŽFulfilment
      • Customer
    • ๐Ÿ”„Data Synchronization
      • How to Manage Your Data Mismatch Issue
  • โ“FAQ
    • Reports
    • Schedules
    • Data Sync
    • Billing & Sales
    • Service
  • ๐Ÿ“‹Changelog
Powered by GitBook
On this page
  • Show Grand Total
  • Show Sub-total
  • Show Grand total on top
  • Wrap Primary Records
  • Show Detailed Report
  • Report Name for PDF Header
  • Insert Currency Format
  • Select CSV Format
  1. Knowledge Base
  2. Report Creation

Formatting Tools

The reports can be altered based on your requirements using our formatting tools.

PreviousData ComparisonNextSharing Report Links

Last updated 9 months ago

Click on the 'Formatting' button to access the formatting tools.

Click on the respective buttons to enable the settings. You can enable multiple settings at a time. These are the formatting tools and their functions:

Show Grand Total

Enabling this option will give you the total of each numerical fields in the last row of the report. This setting is usually enabled by default.

Show Sub-total

When the subtotal is enabled, the report will give the total of a group of values. The grouping is based on the first column from the left and its common inputs.

Note: It only gives you the sub-total of numerical fields.

Here are a few examples.

Again, having the 'Product Name' in the first column is essential for Sub-total to work.

Show Grand total on top

Enabling this option shows the 'Grand Total' on the first row below the fields.

Note: For this option to work, you must enable "Show Grand Total".

Wrap Primary Records

When Wrap Primary Record is enabled, all data contained in the first column from the left will be grouped into its common inputs.

Here are a few examples,

Again, having the 'Product Name' in the first column is essential for 'Wrap Primary Records' to work.

Show Detailed Report

When this is enabled, the report will display detailed records by individual transaction.

For Example: In a normal report, the transactions are summarized under the respective order dates. But in a detailed report, each transaction is shown in a distinct row along with the exact time of the order.

Report Name for PDF Header

When you export the report as PDF, the report name appears on the top as the Header as shown below. This option is enabled by default.

Insert Currency Format

Select the currency format to add symbols to currency-related number columns.

Note: This is not a currency conversion tool. It is to be used only to add currency symbols to the reports.

Select CSV Format

We can enter any delimiter into the CSV Delimiter box, which acts as the separator when we export the file.

The most common delimiters are

  • Comma ( , )

  • Semi-Colon ( ; )

  • Tab ( \t )

  • Space ( )

  • Pipe ( | )

Sub-total by Order Date

Here, the order date is in the first column, which is a necessary requirement for the Sub-total feature to work. Learn how to re-arrange fields by clicking

Sub-total by Product Name

Wrap Primary Records by Order Date

Here, the order date is in the first column, which is a necessary requirement for the 'Wrap Primary Records' feature to work. Learn how to re-arrange fields by clicking

Wrap Primary Records by Product Title

๐Ÿง 
๐Ÿงพ
โœ”๏ธ
๐Ÿ“†
โœ”๏ธ
โœ”๏ธ
โœ”๏ธ
here.
here.