Complete guide to SQL-Report Studio Pro - Your all-in-one data analysis platform
SQL-Report Studio Pro is a comprehensive data analysis platform that allows you to upload data, build complex SQL queries visually, create interactive dashboards, and generate professional reports.
Upload and manage Excel, CSV, and JSON files. View and edit data in real-time with our built-in data viewer.
Build complex SQL queries without writing code. Drag tables, create joins, add filters, and see results instantly.
Create interactive dashboards with KPI cards, charts, and tables. Drag and drop widgets, customize layouts.
Generate professional reports with templates. Add headings, text, charts, and tables. Export to PDF or HTML.
Create dynamic pivot tables to analyze data. Group by multiple dimensions, apply aggregations.
Export your work in multiple formats: PDF, HTML, PNG, CSV, JSON, Excel. Share with your team easily.
Start by uploading your data files (Excel, CSV, JSON) in the Data Upload section.
Use the Visual Query Builder to explore and analyze your data without writing SQL.
Build interactive dashboards by dragging widgets onto the canvas and connecting them to your data.
Create professional reports using templates or start from scratch. Export as PDF or HTML.
Click on "📁 Data Upload" from the home page to access the data management interface.
Supported formats: Excel (.xlsx), CSV (.csv), JSON (.json)
Click "Choose File" and select an Excel, CSV, or JSON file from your computer.
For Excel files, select the sheet you want to import. For CSV files, verify the delimiter is correct.
Click "Upload" to import your data. The data viewer will display your data in a table format.
All uploaded files appear in the left panel. Click on a file to view its sheets.
Click on any cell in the data viewer to edit values. Changes are saved automatically.
Click the 🗑️ icon next to a file name to remove it from storage.
Use the search box to find specific values in your data quickly.
Multi-sheet Excel workbooks. Each sheet is imported as a separate table.
Comma-separated values. Automatic delimiter detection (comma, semicolon, tab).
JSON arrays of objects. Each object property becomes a column.
From the left panel "Tables" list, drag a table onto the main canvas area. The table will appear with all its columns.
📋 Tables
Canvas Area
Check the checkboxes next to the columns you want to include in your query results.
To combine data from multiple tables, drag another table onto the canvas. Click the "🔗" icon and select the join type and fields.
Click the "🔍 Filter" button in the toolbar. Select a column, operator (=, >, <, LIKE, etc.), and enter a value.
Click the "▶ Execute" button to run your query. Results appear in the bottom panel.
Create custom calculated columns using formulas:
Field Name: Total_Amount
Formula: [Price] * [Quantity]
Available fields dropdown shows all columns from your tables
Available functions include: SUM, AVG, COUNT, MIN, MAX, ROUND, UPPER, LOWER, LENGTH, CONCAT, SUBSTRING, COALESCE
Group results by one or more columns and apply aggregations (SUM, AVG, COUNT, MIN, MAX).
Create pivot tables to analyze data across multiple dimensions:
Click "📥 Export" to download results in multiple formats:
Returns only matching rows from both tables. Most common join type.
Returns all rows from left table and matching rows from right table.
Returns all rows from right table and matching rows from left table.
Returns all rows from both tables, with NULLs where no match exists.
LIKE operator with wildcards for partial matches: %search%Click "📊 Dashboard Builder" from the home page to access the dashboard interface.
Available Widgets
Dashboard Canvas
From the left panel, drag any widget (KPI Card, Chart, Table) onto the canvas. The widget will appear where you drop it.
Click and drag widgets to reposition them. Drag the bottom-right corner resize handle to change widget size.
Click the "⚙️" (configure) icon on each widget to connect it to your data source and set display options.
Click "💾 Save" in the header to save your dashboard layout and settings.
Display single key metrics with large numbers. Show trends with percentage changes.
Compare values across categories. Vertical or horizontal bars.
Show trends over time. Perfect for time-series data and tracking changes.
Display proportions and percentages. Show part-to-whole relationships.
Modern pie chart with a hole in the center. Great for showing categories.
Display tabular data with sorting and filtering. Show detailed records.
Show progress towards a goal. Display percentage completion visually.
Create pivot tables directly in your dashboard. Select data source, configure rows/columns, and generate dynamic summaries.
Access additional tools:
Export your dashboard in multiple formats:
Click "📄 Report Builder" from the home page. You'll see a blank canvas ready for your content.
Report Elements
Report Canvas
Quarterly Performance Analysis
Click the "📋 Templates" button to choose from pre-designed report layouts:
Drag elements from the left panel to build your report:
All text elements are editable. Click on any text to edit it directly. Tables and charts can be configured by clicking their settings icon.
Click "📥 Export" to save your report:
Click "🎲 Pivot" to create pivot tables and insert them into your report. Perfect for summary analysis.
Access the "🔧 Tools" menu for:
All content is editable:
Ctrl + Shift + R - Hard refresh (reload without cache)
Ctrl + S - Save current work (in some modules)
Ctrl + Z - Undo (in text fields)
Solution: Clear browser cache (Ctrl+Shift+R) and reload the page. Check if data was uploaded successfully in Data Upload section.
Solution: Check filters - they might be too restrictive. Verify join conditions match actual data values.
Solution: Disable popup blockers. Check browser console for errors. Try exporting smaller sections.
Solution: Delete old files from Data Upload section. Export and clear saved queries. Browser limits local storage to ~10MB.
Solution: Close other browser tabs. Reduce dataset size. Clear browser cache. Restart browser if needed.
Clean data before upload. Remove duplicates, fix formatting issues, ensure consistent data types.
Use specific columns instead of SELECT *. Add filters early. Index join columns.
Choose appropriate chart types. Use consistent colors. Label axes clearly. Avoid chart junk.
Regular backups. Clear old data. Export important results. Document data sources.
This application works best on:
Note: Internet Explorer is not supported.