Dear sir, Kindly introduce complex and simple useful reporting tools for customized. Pivot the data. Do introduce Muhammad irfan

If you want your suggestion to be considered, you need to furnish much more information. What kind of reporting? What data? What do you want to accomplish with the reports? Be specific. Provide examples, if possible.

As said, the only way to have a full reporting is to have access to the datab(for examble via ODBC) in order to use one of the many BI tools that are there on the market (ie qlikview, power BI, jedox). I don’t think that @lubos can face the needs of every single sector and it’s not even the scope of…

Kindly furnish sales report with its detail as we draw custom fields to extract data from software. Sales with salesline item Quotations with quotationline item Salesorder with salesorderline item Purchaseorder with purchaseorderline item Purchaseinvoce with purchaseline item Delivery order wi…

I agree with Davide, once we have full access to the data at every level via ODBC, extracts can be made into any form and then presented to simple tools such as Excel or more complex BI tools.

@theeley except that’s too technical for 99% of users. I think simpler way to summarize data is needed anyway. As @Tut has mentioned, it is now possible to summarize sales invoice totals by item, customer or custom field. There is no reason why this couldn’t be applied to other types of documents. T…

YES… Please make it simple. :sweat_smile: , we’re not IT savvy in terms of jargon and command linesssssss Sincerely, Simpleton user.

I hereby request to furnish simple reporting using custom filter option for all vouchers to extract data

Hi Lubos I would really appreciate if you are able to make the database available to ODBC, I am very familiar with ODBC access for reporting having used SQL, Excel, Access, QlikView, QlikSense, Crystal reports to name a few and ODBC would make life so much more simple for me to extract the data and…

Hi Lubos, is there any update on ODBC? Failing that, would you please provide a list of the tables available via the Custom report query tool. That way I can at least get a dump of the data per table and work with this. Cheers

Custom reporting tools for simple and complex reporting

Tut October 21, 2017, 12:45pm 5

A sales invoice total by custom field report was just added: [17.10.42] Added three new sales reports

Topic		Replies	Views
Custom Reports	72	17151	May 17, 2018
ODBC Connection	3	558	August 6, 2019
[18.9.60] Improved custom reports (added visual query builder)	90	6054	November 11, 2018
Querying Manager	1	613	February 20, 2021
Custom Reports (a work in progress)	13	1583	September 7, 2018

Custom reporting tools for simple and complex reporting

Related topics