Jump to content
Sign in to follow this  
madman411

Print two tables on one report

Recommended Posts

madman411    2

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
comment    1,372

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.