Generates Perl code for a given SQL SELECT query based on sql-ledger tables. Generated Perl code contains all standard sql-ledger report features plus a few more. Drop this code in a pl file in your sql-ledger folder, add a menu option and start using the report.

[Sales Report]
module=rp.pl
action=sales_search

1. Select/de-select columns to include in report.
2. Totals/subtotals for numeric columns.
3. Grouping on the sorted column with subtotals. (optional)
4. Summary / detail reports (optional)
5. Range (from/to) search on numbers and date columns.
6. Search boolean columns with Y/N.
7. Drop down fields on search screen for if any of the these columns is found in query: customer, vendor, parts, groups, accounts, employees, salesperson, currency.
8. CSV,TSV,XML export of report data.
9. Complete foreign language/locale support. (All sql-ledger languages are supported)
10. Save displayed report definition (search conditions, selected columns, grouping etc.) and recall with a single click.

At the heart of this report generator is an extensive data dictionary containing information about sql-ledger tables, columns data types, standard labels, sizes, relationships etc. The code generation script takes columns names from the input query and using the data dictionary generates a complete Perl report script.

To make sure this service meets your reporting requirements we offer free demo. Just send us report description or SQL query. We shall build the report for you to make sure you get what you are expecting.

1. To add a hard-coded WHERE clause, edit the generated script and replace the line “WHERE 1 = 1” with your hard coded clause.
2. To add GROUP BY/HAVING clauses, edit your SELECT query in the generated report.
3. UNION queries are not supported directly. Work around is to generate the report with one part of union query and then add the complete query by editing the generated code.
4. If you want to add a column on search screen but not in SELECT list, here is the trick:
   1. Generate your report with the column in SELECT list.
   2. Edit the generated code and remove the column name from query SELECT list and @columns array.

Q: I don't know SQL. Do you provide any help?

A: You can do one of two things:

1. Find a pre-written query from this page and add/remove columns according to your requirements.
2. Email us your requirement at support@ledger123.com, we shall write query for you and send it you.

Q: I know SQL but not familiar with sql-ledger tables and relationships? Is there any help.

A: Here is brief introduction of sql-ledger schema as well as list of all tables and columns.

Q: Do you offer money back gurrantee?

A: No. We offer free trial/demo for any number of reports so that you can make sure that this service fulfills your expectations before placing your order.

Q: I am trying to write a query to get the information I want but it seems that it is not possible with SQL. What should I do.

A:

1. Let us know your requirements. We may write a query for you.
2. If you know Perl generate a report on your main query and modify the generated Perl code.
3. As as last resort you may need our custom report development service. Email for details.