Alpha Video Training
Results 1 to 2 of 2

Thread: Showing individual tax rates on report

  1. #1
    Member
    Real Name
    gfong
    Join Date
    Jan 2001
    Location
    Dartmouth, Nova Scotia, Canada
    Posts
    369

    Default Showing individual tax rates on report

    In addition to a standard invoice_detail child, I have a tax child linked to my invoice parent table in a 1:N relationship. My form is comprised of fields from the parent making up the header and two browses. The first browse is the invoice_detail table which holds the individual purchased items and the second browse holds rows of sales tax rates and treatments that are used by expressions to calculate total tax. For example in the province of Quebec there are two sales tax rates one Federal and one provincial. These taxes occupy two rows. Field1 names the tax,field2 contains the rate, field3 holds the result of the total purchases times each rate. The sum of field3 is the total tax.
    The law requires that each tax be clearly displayed on the invoice and this is neatly done on a form with a browse that I stick on the bottom of the form next to the totals.
    But has anyone figured out how to do this on a report?

  2. #2
    "Certified" Alphaholic
    Real Name
    William Hanigsberg
    Join Date
    Apr 2000
    Location
    Toronto, ON
    Posts
    4,018

    Default RE: Showing individual tax rates on report

    I believe you will have to create a subreport to hold the tax records (eg. two for Quebec).

    The way I see this happening is you group the report on invoice number. The fields from the parent table will go in the group header. The invoice items will be in the report's detail section.

    Place the subreport in the group header.

    I am assuming that all the invoice items share the same tax status. That is, all the items are Quebec, or all are Ontario. Therefore, you will want to display the tax information only once per invoice.

    If this is not so you will have to approach the problem somewhat differently.

    Bill

Similar Threads

  1. Mass Configuration vs Individual
    By Scott Fisher in forum Alpha Five Version 6
    Replies: 6
    Last Post: 08-05-2005, 03:43 AM
  2. Showing time values in a report or form
    By acceptthis in forum Alpha Five Version 6
    Replies: 3
    Last Post: 06-08-2005, 05:10 AM
  3. Encrypt Individual Field(s)
    By John Gamble in forum Archived Wishlist
    Replies: 2
    Last Post: 02-24-2005, 03:38 PM
  4. Records not showing up in report
    By James Reysen in forum Alpha Five Version 4
    Replies: 7
    Last Post: 03-11-2002, 07:26 PM
  5. Sales tax rates
    By David Day in forum Alpha Five Version 4
    Replies: 13
    Last Post: 06-22-2001, 08:21 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
  •