Re: Flatten Detail Rows in "Crosstab" Calendar Report

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

On May 21, 3:12 pm, zwestbrook <zwestbr...@xxxxxxxxx> wrote:
I have data that includes dated events classified by type. I am
creating a crosstab/calendar style report the will display at a glance
the events for the year by month and type. I went the crosstab query/
report route but that only gives me the number of events by type per
month...I want to see the actual event title and date in that field,
not the count.

I have been able to create something very close to what I want but
cannot format correctly. I have 12 fields (1 for each month) in the
Detail row with each one only showing events for the corresponding
month. Data is showing, but the report only displays 1 record per row.
How can I merge down or flatten the detail sections?

What I want:
Person A
----------------- jan  feb  mar  apr
type 1         XXX       XXX  XXX
type 2         XXX XXX XXX
tyep 3                            XXX

What I am getting:
Person A
----------------- jan  feb  mar  apr
type 1         XXX
                              XXX
                                     XXX
type 2         XXX
                             XXX
                                     XXX
tyep 3                            XXX

Ok, found out how to flatten the detail section (add Me.MoveLayout =
False in the onFormat event of the Detail) but now my records for the
months print on top of each other (some months may have multiple
events).
.

Relevant Pages

  • Flatten Detail Rows in "Crosstab" Calendar Report
    ... creating a crosstab/calendar style report the will display at a glance ... Detail row with each one only showing events for the corresponding ...
    (microsoft.public.access.reports)
  • SV: problem with sum calculation report
    ... I do this with a query before running the report and LOOKUPcall in the ... > which I want to sum is on a group header level. ...
    (microsoft.public.fox.programmer.exchange)
  • problem with sum calculation report
    ... I tried to obtain an automatic sum with the calculation option in one of my ... the problem is that the report sums the field for every row of the detail ... which I want to sum is on a group header level. ...
    (microsoft.public.fox.programmer.exchange)
  • Creating a Report with Vertical Columns
    ... I'm using Crystal 10 to create a report based on an XML dataset that I ... properly and seems to duplicate the subreport data once for every ... detail row in the subreport. ...
    (microsoft.public.vb.crystal)