Jump to content
Sign in to follow this  

Print two tables on one report

Recommended Posts

I've created a database that automatically complies an invoice for time worked. I'm loving how it's working.

When trying to generate a report I need the report to include two sets of information (from two different tables), ideally in two separate parts:

- TimeCard table
- Reimbursements table

Both tables are linked to a primary table called Invoicing by the InvoiceID.

Creating a report that displays the information individually is easy - I select either the TimeCard or Reimbursements table the Layout Setup window, set to view as list, place the desired fields within the body part setup, and bam.

Is there a way to do this without the use of a portal to display the second set of information? Ideally the report resizes itself based on how much related data is being displayed. I don't want to account for 10 portal rows to display related reimbursements if there are no reimbursements.

Thanks :)

Share this post

Link to post
Share on other sites

This is a well-known problem.

The easy solution is to use a portal (as you did) and set it to slide up. That will remove any unused portal rows.

The "correct" solution is to use a printing table, where both TimeCards and Reimbursements will be sibling records. You can populate such table either by importing or using a "virtual list".

  • Like 1

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.