skills.rest
flowkraft
flowkraftCOMMUNITY
Explore all skills by this author →
GitHub

datapallas-report-generation

Guide DataPallas report generation by mapping business documents to SQL, Groovy, CSV/Excel, and template-driven outputs.

75|8|Updated Dec 20, 2023
Search Tags:#templates#pdf#report generation#sql dialect#datapallas#jasperreports#groovy scripts
One-click install
npx skills add https://github.com/flowkraft/datapallas --skill datapallas-report-generation
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: datapallas-report-generation
Source: https://github.com/flowkraft/datapallas/tree/main/asbl/src/main/external-resources/db-template/_apps/flowkraft/_ai-hub/.skills/datapallas-report-generation
Command: npx skills add https://github.com/flowkraft/datapallas --skill datapallas-report-generation

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It helps you set up DataPallas report generation end-to-end, so you can reliably turn your business data into the right document output without manually editing low-level configuration files.

Core Features & Use Cases

  • Report setup guided through the UI: Create a new report capability and configure it from the DataPallas menus, keeping XML edits out of your workflow.
  • Pick the right data source type: Choose SQL Query, Groovy Script, CSV/TSV, Excel, or Fixed-Width, including correct handling of database SQL dialects and complex transformations.
  • Choose output format + template together: Generate PDF (HTML/CSS → PDF or XSL-FO), JasperReports (.jrxml), Excel, HTML, Word, XML/JSON, or no-attachment email-only outputs.
  • Template creation support: Use a template gallery, AI-assisted template building, or custom HTML/CSS templates to match your layout needs.
  • Advanced options for real-world scale: Support JasperReports execution modes (Direct/Wrapper), large-scale generation workflows, runtime report parameters, and post-load Groovy transformations.

Quick Start

In DataPallas, go to Configuration → Reports → New, tick Report Generation Capability, then open Configuration → <ReportName> → Report Generation to configure the Data Source, Output Format, and Template.

Frequently Asked Questions about datapallas-report-generation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate PDF reports from SQL or CSV data without editing XML?▼

You can generate PDF reports by configuring a new report capability in the DataPallas UI, selecting SQL Query or CSV as your data source, and choosing an HTML/CSS or XSL-FO template. This workflow keeps XML edits out of your report generation process.

What output formats can I produce with JasperReports templates?▼

JasperReports templates support generating PDF, Excel, HTML, Word, and XML/JSON outputs. You can configure these formats alongside .jrxml templates in the DataPallas UI, selecting Direct or Wrapper execution modes based on your scale requirements.

Can I use Groovy scripts for complex data transformations before rendering a report?▼

Yes, Groovy scripts can be selected as a data source type for complex transformations, and you can also apply post-load Groovy transformations. This allows you to manipulate business data dynamically before applying your template-driven rendering.

What is the best way to create custom invoice or payslip layouts?▼

The best way to create custom invoice or payslip layouts is through the template gallery, AI-assisted template building, or custom HTML/CSS templates. You configure these visually in the DataPallas UI to achieve pixel-perfect document output.

Do I need to manually edit configuration files to troubleshoot report generation?▼

You do not need to manually edit configuration files to set up reports, as setup is guided through the UI. Configuration files are only used for read-only understanding and troubleshooting when diagnosing issues with your data source or template.

Does DataPallas support large-scale report generation with runtime parameters?▼

Yes, DataPallas supports large-scale generation workflows and runtime report parameters. You can configure these advanced options in the UI alongside your chosen data source and template to handle high-volume document production.

Related Skills

Explore More Data & Analytics Skills→
rvdbreemenrvdbreemen
199

xlsx

Repair, clean, convert, and generate XLSX/XLSM/CSV/TSV spreadsheet files.

Community
Advanced
AbildtoftAbildtoft
2

kramme:markdown-converter

Convert PDF, Word, PowerPoint, Excel, HTML, CSV, JSON, XML, images, and audio into Markdown.

Community
Basic
legoutlegout
3

polars

Manipulate large-scale datasets with Polars and Apache Arrow.

Community
Intermediate
flowkraftflowkraft
75

DataPallas Server Skill

Deploy DataPallas Server on Windows to process scheduled report files from poll/.

Community
Intermediate