Underline, overline, and double-underline for financial columns - Reports - A2000

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: L Mehl (mehl_at_cyvest.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 12:43:55 -0800

Hello --

Some of the reports in my application present columns of financial
information which contain values, subtotals of those values, and totals of
subtotals.

Column widths in a given report vary, and it takes a while to set up each
column. I want to find a technique to simplify making headings, numbers,
underlines overlines, and double-underlines be the same width, align and
look good, as in the crude representation below (all of the headings,
values, and lines in the second column are right-justified):

              coltitle <--textbox containing coltitle
              -------- <--underline
group1 name
rowname1-1 value1-1 <--textbox containing col value
rowname1-2 value1-2
...
              -------- <--overline
group1name subtotal1
              -------- <--underline

group2 name
rowname2-1 value1-1
rowname2-2 value1-2
...
              -------- <--overline
group2name subtotal2
              -------- <--underline
biggroup1 Grand total
              ======== <--double underline

Does anyone know of a technique for Reports to make the widths of such lines
be the same as the width of the related textboxes containing names or
numbers, and to adjust automatically if I change the width of a related
textbox?

Thanks for any ideas.

Larry Mehl 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.637 / Virus Database: 408 - Release Date: 3/20/2004

Relevant Pages

  • Re: errors in Crystal Reports .NET subtotals and grand totals
    ... incorrect values if you have "Keep Group Together" set on your group. ... > has anybody else experienced arithmetic errors in .NET Crystal Reports ... > totals and subtotals? ... the grand total does not match the sum of the subtotals... ...
    (microsoft.public.vb.crystal)
  • Re: Underline, overline, and double-underline for financial columns - Reports - A2000
    ... >information which contain values, subtotals of those values, and totals of ... >Column widths in a given report vary, and it takes a while to set up each ... >Does anyone know of a technique for Reports to make the widths of such lines ... There many related report properties that can be set to ...
    (microsoft.public.access.reports)
  • errors in Crystal Reports .NET subtotals and grand totals
    ... has anybody else experienced arithmetic errors in .NET Crystal Reports ... totals and subtotals? ... i have two examples of reports where a subtotal for a low-level group, ... the grand total does not match the sum of the subtotals... ...
    (microsoft.public.vb.crystal)
  • Access XP/2003 & Subforms challenge
    ... I have a subform with dollar values, ... subtotals and totals are calculating correctly. ... whenever I run queries or generate reports, ...
    (microsoft.public.access.forms)
  • Re: Need help with form
    ... We will be entering the data by cost center, then by expense element. ... all of the user's tables into one common table, run queries and reports. ... I have made a totals query from the main input table and grouped by the cost ...
    (microsoft.public.access.formscoding)