Report Builder

[utony]

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.

[a.gneady]

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

[utony]

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]

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]

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.