Alpha Video Training
Results 1 to 2 of 2

Thread: Displaying two rows of data in one row on report

  1. #1
    Member
    Real Name
    hpjchobbes
    Join Date
    Feb 2008
    Posts
    3

    Default Displaying two rows of data in one row on report

    I have an invoice in QB that has multiple line items. There are two lines using the same item that have different dollar amounts. I want to be able to get a report that shows one line per unique item, and has two columns showing the amounts for the those items. I've attached a sample invoice to show how it's stored in QB.

    This is the information that I need:
    Code:
    Name		Gross Amount	Agent Amount	Payable
    USD:MM3		2880.00		120.00		2760.00
    USD:AI7		1665.00		135.00		1530.00
    The Gross amount is equal to the first MM3 item (an underwriter type) plus the second MM3 item (the Commission type). Agent Amount is the value of the second MM3 item by itself and the Payable is the first item by itself.

    I don't know of a way to pull the information from QB that will give me two item rows into one. Any help is appreciated!

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,625

    Default Re: Displaying two rows of data in one row on report

    You can combine the 2 rows into one row, by sorting on the invoice + item and having a group footer instead of a detail region.

    In the group footer, you can use the drop down wizard to choose a value from one of the 2 records.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. Displaying data in a Report
    By johnRupert in forum Alpha Four Versions 7 and 8
    Replies: 1
    Last Post: 02-06-2008, 12:44 PM
  2. Displaying Data Horizontally rather than Vertical in a report
    By reynolditpi in forum Alpha Five Version 7
    Replies: 1
    Last Post: 10-17-2006, 11:18 PM
  3. Blank Rows in Report
    By forskare in forum Alpha Five Version 6
    Replies: 16
    Last Post: 02-16-2005, 03:12 PM
  4. Numbering Report Rows
    By Mark Campidonica in forum Alpha Five Version 5
    Replies: 4
    Last Post: 01-31-2003, 09:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •