Re: Multiple Column Report - esp for Duane Hookom

Duane

One step forward, one step back -

1) Re data structure, I realized given the nature of my data I can "have my
cake and eat it too".

The DB contains historical financial statements for Special Districts, and
in the 5 years I've paid attention the State Controller has never changed the
data after its annual report.

So - without describing how (not important I think), I now have both the
470K record [TAa1-AllAccts] with its related [TYa1_ChartofAccts] table, AND a
[WaterIS - Residential; Irrigation; etc.] table that has a separate field for
each row in the Water District Income Statement. I realize this is redundant
and is probably not good practice generally, but in this specific case with
extremely stable data it seems OK to me - each data structure supports
different purposes.

So - having built the [WaterIS - Residential; Irrigation; etc.] table, I
used it in the KB article's procedure and GLORY BE I now have most of what I
wanted - the first column has account names, the 2nd through 4th columns have
values for the past 3 fiscal years.

That's the step "forward" (I think). Here's the step back.


2) Here's how I'd like the report to look:


Revenues and Expenses
Name of Special District
Name of County

2005 2004 2003

Residential $20,000 $19,000 $18,000
Irrigation 6,000 7,000 5,000
etc.

So - seems to me this is a subreport inside a report. I set up a report for
the "headers" - Title of Report, District Name, County Name. I then put the
KB-style multicolumn report in the detail section as a subreport.

The problems now are:

a) only the column of account names "prints";
b) a second page of account names prints next if there is a 2nd FY record,
and a 3rd page of account names prints if there is a 3rd FY record. However,
the "headers"

S0 - I think relevant questions are:

A) Can a KB-procedure multicolumn subreport be embedded in a master report
in this general layout?

B) If so, what would you need to know to see what I'm "doing wrong"?

Thanks

John D

How close do you get if you use OrgID and AcctNo as the Row Headings, FY as
the Column Heading, and Sum of AcctValue as the Value?

.

Relevant Pages

  • Re: Multiple Column Report - esp for Duane Hookom
    ... first column has account names, the 2nd through 4th columns have ... The DB contains historical financial statements for Special Districts, ... Here's how I'd like the report to look: ... KB-style multicolumn report in the detail section as a subreport. ...
    (microsoft.public.access.reports)
  • Re: Count and Update
    ... The problem lies in your data structure. ... The number of accounts per area code is automatically calculated in ... the small table for Report X contains account numbers in one ...
    (microsoft.public.access.queries)
  • Re: Multiple Column Report - esp for Duane Hookom
    ... annual total for that account - it's already in essense a "sum". ... Income Statement - and for my users it needs to. ... ACC2000: How to Print Labels on the Left Margin of a Report: This is the ... The State Controller (SCO) produces Annual Financial Reports for all Special ...
    (microsoft.public.access.reports)
  • Re: Print a field only if value is true
    ... but your data structure is unnormalized. ... show only the problems (exactly what you describe for your report). ... On this tab, is subform "sfrmRoof". ... If a checkbox is left unchecked, ...
    (microsoft.public.access.reports)
  • Re: Need help creating a report in access
    ... to generate a report for work and require the following information to ... account#, name, address, etc. ... invalid account number ... Create a query using the wizard. ...
    (microsoft.public.access.gettingstarted)