How can we help you?

Grids

MYSTOCK REPORT GRID & PIVOT VIEW

myStock Report Grids provide users with powerful tools to optimize their reports by using various filters for sorting, grouping, and summarizing data based on specific needs.

  • Data Range Selection: Users can select a specific time period by setting the ‘START DATE’ and ‘END DATE’. Options include ‘TODAY’, ‘YESTERDAY’, ‘LAST WEEK’, ‘LAST MOTNH’, ‘LAST THREE MONTHS’, etc.
  • Report Customization: Users can choose whether the report should include details such as the ‘TIME OF DAY’ and ‘INCLUDE THE SALES’.
  • Drag And Drop Functionality: TallOrder Report enable users to customize the layout by sorting, grouping, and summarizing data through an intuitive ‘DRAG AND DROP’ feature.
  • Additional Headings: Users can add extra headings in the ‘DRAG AND DROP’ filter to further refine the data.
  • Reference And Invoice Numbers: All items are recorded with ‘REFERENCE NUMBERS / INVOICE NUMBERS’, simplifying the search for specific items.
  • Data Export: Users can export data to Excel or CSV formats. The exported file will retain the grouping and summaries as set by the user. For example, if data is grouped by departments, the exported file will also reflect this grouping.
  • Responsive Design: The interface is designed to ensure optimal display across various devices, including desktops, tablets, and smartphones, automatically adjusting to the screen size.

GRID VIEW DESCRIPTION

A Grid View is a data display format that presents information in a tabular, spreadsheet-like format. It allows users to view, edit, and manage data in a structured and easy-to-navigate layout, typically composed of rows and columns.

KEY FEATURES OF A GRID VIEW:

  1. Tabular Display: Data is organized into rows and columns, similar to a spreadsheet, making it easy to read and interpret.
  1. Sorting And Filtering: Users can sort, and filter data based on various criteria to focus on specific subsets of information.
  2. Customizable Columns: Users can add, remove, and rearrange columns to tailor the view to their specific needs.
  3. Pagination: Large datasets can be divided into pages to enhance performance and usability, allowing users to navigate through data efficiently.
  4. Responsive Design: Adjusts to different screen sizes and devices, ensuring that the data remains accessible and readable on desktops, tablets, and smartphones.

PIVOT VIEW DESCRIPTION

A Pivot View is a data summarization tool commonly used in spreadsheets and business intelligence software. It allows users to reorganize and summarize selected columns and rows of data in a table to obtain a desired report.

Key Features Of A Pivot View:

  1. Data Aggregation: Perform calculations like sums, averages, or counts on data subsets.
  2. Dynamic Rearrangement: Change the structure of the data by dragging and dropping fields to view different perspectives.
  3. Filtering and Sorting: Focus on specific subsets of the data by applying filters and sorting.
  4. Drill-Down Capability: Explore detailed data behind the summary figures.
  5. Grouping Data: Group data by categories, dates, or other criteria for meaningful summaries.

By using both Grid View and Pivot View, users can transform raw data into insightful and organized reports that highlight key information and trends, providing a comprehensive understanding of their data.