Report Builder

The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
Post Reply
utony
Veteran Member
Posts: 109
Joined: 2020-04-03 18:37

Report Builder

Post by utony » 2024-06-26 14:19

Good day all, I am seeking a solution "possible Plugin" to generate a reort based on multiple data tables. Right now I can connect the child tables with the parent table, but it is not pretty. I want to be able to have all the data fields as options so I can layout the final report much cleaner with sections etc. Right now I have full range to manupliate the parent table fields, but I seem very limited to the child data fields. Can someone point me in the right direction to work on this request? I have a huge need to build a parent table with about 20 child tables that are related to the parent, what I need is the options to display all the data, no matter how many child tables, in a nice clear output report for my customer. Looking forward to your suggestion, third-party options, or possible custom options.

User avatar
a.gneady
Site Admin
Posts: 1308
Joined: 2012-09-27 14:46
Contact:

Re: Report Builder

Post by a.gneady » 2024-06-27 14:41

If I understand correctly, you want to see a report that shows a record and all its child records from all child tables, right? If so, AppGini already provides a built-in way to do this. See this example screenshot: https://cdn.bigprof.com/images/dvp-with ... -24.14.png

The above screenshot is the print-preview page of a record from the employees table from the Northwind demo app: https://northwind.demos.appgini.com/emp ... lectedID=5 (click "Print preview", then scroll down and toggle the child tables you want to include in the page)

To configure this behavior, please refer to parent/children settings documentation
:idea: AppGini plugins to add more power to your apps:

utony
Veteran Member
Posts: 109
Joined: 2020-04-03 18:37

Re: Report Builder

Post by utony » 2024-06-27 17:19

Thank you for replying. I am aware of the child view on the print preview (DPV) page, however where I am running into a issue is my child table has about 30 data columns and the print preview from the parent only displays 8-10 columns cutting off a bunch of needed information I need to display in the report. What do you recommend to be able to get all the columns from the child record to display. I know how to update and customize the parent DVP but if you could point me in the right direction to manipulate the child record data that would awesome!

utony
Veteran Member
Posts: 109
Joined: 2020-04-03 18:37

Re: Report Builder

Post by utony » 2024-06-27 17:42

I enjoy working with the DVP pages and I like to customize the outputs for the parent tables by manipulating the html and data tags, it’s the child output that seems limited for me. When I started to work with the generated child table code, things went sideways quick. Maybe this is easier than I think, you are the master of AppGini! Thanks for your guidance.

mark
Posts: 4
Joined: 2024-09-14 13:17
Location: USA

Re: Report Builder

Post by mark » 2024-09-30 05:59

This post was made before I joined so just now seeing it as I have similar interests in a good report writer for AppGini.

I have used BiRT reporting tool in the past and was impressed with its robustness. It does require a Java server like Tomcat to run the reports on a website but you can also run the reports on a PCor Mac if needed.

I’m hoping it will work well with the tables from an AppGini app.

Post Reply