Access Report -- Side by Side Report Groups?

[kestefon]

My report contains three grouping levels: ReportType (there are only two values for this group), Indication, and Variable Name. Is there anyway to organize my report so that the two ReportType groups are shown side-by-side?



To illustrate, my resulting report is laid out vertically (see below) , and instead I'd like the two Report Types to be in side-by-side columns.

Current Layout:

Report Type 1
  Indication 1
      Variable A
      Variable B
      Variable C
   Indication 2
      Variable A
      Variable B
      Variable C

Report Type 2
  Indication 1
      Variable A
      Variable B
      Variable C
   Indication 2
      Variable A
      Variable B
      Variable C

And here's a screenshot of my Design view.

[June7]

Try a CROSSTAB query. The ReportType would be ColumnHeader field, Indication and Variable Name would be RowHeader fields, and [Variable Value] would be Data field.

[kestefon]

Thanks yet again!

[kestefon]

Here's a related follow-up question:

How would I add a percentage difference field to the query? Or is it better to do it within the report?

[June7]

Probably easier to calc in a textbox.

[kestefon]

I did the crosstab query for a number of tables. Most turned out fine, but one is producing a crosstab with a blank first row. Any idea what might cause that and how I could remove it?

[June7]

There is record(s) in the source data with no data in field(s) involved in the crosstab. Fix the records or filter them out. I think applying filter criteria in crosstab is different than other queries. http://allenbrowne.com/ser-67.html#Param