WebSite X5Help Center

 
Zeljko B.
Zeljko B.
User

Printing custom report  en

Author: Zeljko B.
Visited 587, 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
7 ANSWERS - 1 CORRECT
John S.
John S.
User

It is possible - is the fields all text?

Read more
Posted on the from John S.
John S.
John S.
User

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.

Read more
Posted on the from John S.
Zeljko B.
Zeljko B.
User
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...

Read more
Posted on the from Zeljko B.
John S.
John S.
User

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.

Read more
Posted on the from John S.
Zeljko B.
Zeljko B.
User
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.

Read more
Posted on the from Zeljko B.
John S.
John S.
User

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.

Read more
Posted on the from John S.
Zeljko B.
Zeljko B.
User
Author

Thank you very much. I am closing this topic.

Read more
Posted on the from Zeljko B.