Retrieving data from multiple companies

Hello everyone,

I've recently started using Jet Reports and I'm really stuck on this matter:

I need to create a report with data from all existing companies that looks like this:

Company_Name |  Column_1 | Column_2 | Column_3 | Column_4

The columns above are from the table "Approval Entry".

I can easily retrieve data from all companies with an NL for every company but unfortunately I'm hardcoding the [Company Name] column.

Is there a nicer way of doing this? I've tried the table builder where I selected the "Approval Entry" and the "Company Information" table but I didn't let me to finish it, the ok button for the table builder was grayed out.

Any help si greatly appreciated!




Please sign in to leave a comment.