Printing custom report
Author: Zeljko B.
Visited 822,
Followers 1,
Shared 0
Please instruct me if it is possible to print (create) a custom report.
I would like to print the database table content. In PDF is possible.
Also I would like to create a custom report.
Please advise me if that is possible.
Kind regards!
Posted on the
It is possible - is the fields all text?
Maybe the easiest for you is to export the database table content to a csv file - and then import that file into a spreadsheet and from that, format the data as you wish and then print the sheet to a pdf-file.
Author
Of course the fields are not all text.
Is there a control that read the content of DataViewer? Or, is there a way to filter records and send them to Report?
However, seeing data in DataViewer without an option to print records is just for viewing purposes.
Please instruct...Thanks!
P.S. Having the possibility to print data is getting my app into the world of web data app...
There are several ways to achieve what you want, but X5 does not offer such things - it is a web-builder tool - not a database tool.
1 - The dataviewer can be set to allow export to a csv-file. You can then filter and style the data in a spreadsheet and then print to a PDF. THis is the most handy method.
2 - You can also make a PHP script that access the database, make a query that filters and sorts the data, and then print data to a PDF. I have an example here: http://eksempelsite.dk/udstillinger/Emner02.php
3 - You could use a database tool like AppGini - the example in 2 is coming from a table in such a database. Example here: http://eksempelsite.dk/udstillinger/Emne_view.php?filterer_Udstilling=2&
Click on "Print preview" and then print to a PDF. The example is not meant for printing.
4 - You could use a report tool like the free and advanced REPORTICO for reports and printing.
5 - I guess there are more ways - scripts and so. But I am familiar with 1-4 and can recommend you use one of these.
Author
Suggestion No.:
1 - not suitable
2. - visited the example, I didn't see any option to print except "right click on the site->print"
3. - actually I have paid version of AppGini but I don't like the fact that I cannot modify GUI and CRUD operations
4. - if I create reports, how to pass parameters from websitex5 to report (what to print, filter parameters...)
Please advise.
2 - use Ctrl+P
3 - You can use hooks for the CRUD and you can style the views https://appgini.bizzworxx.de/appgini/styling-a-detail-view-a-step-by-step-example/ and there is many themes.
4 - in the documentation it is described how to pass parameters from one system into REPORTICO.
If you are having problems also the REPORTICO has a good forum. And the author is very helpful.
I think this is as much advice I can give you. Hope you find a proper solution.
Author
Thank you very much. I am closing this topic.