Sub Report with Multiple Colums

[Blorf]

Hi.

Is there a way to have a report with multiple columns stay that way when you use it as a sub report?

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[dhookom]

Set the columns to display across then down.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MaggieLeatherman]

Hello, I too needed to know how to print columns in a sub report "down then across"... Does anyone know how to accomplish this.. Any help will be greatly appreciated!

Maggie

 

[dhookom]

How hard do you want to work at this? This simplest method is to set the size of the subreport to not allow it to grow. You can also create a column in the report's record source that calculates a number that can be used to sort the record across then down but appear to the user as down then across.

The final alternative is to use multiple copies of the same, single column subreport displaying the first half of the records in the left subreport and the last half of the records in the right copy of the subreport.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lamarw]

Hi everyone,
I've got a question that I can find no usable answer for. I am creating a report that has two records worth of information in the same detail section.
In the table there records for regions 'North' and 'South'. In my report I want to display North's information in the left half of the detail section and South's information in the same detail section but on the right half. I want to display two records worth of information before the report CRLF's. A CRLF will occur only when the MyDate field changes closing the format for that section and printing that part of the report (MyDate is one of the field names on the report in both halves of the detail section).
When I select the data I am Ordering it by Date then Region.
When I'm done printing It will "appear" to be in columns, North on the left and South on the right (it will be more like spreadsheet columns rather than word processor columns, spreadsheet output is not neccessarily what I'm looking for though). Where one or the other is missing a record then the area will just remain unused(blank).
So, my question is: Can I force the read of another record (i.e. movenext) before I leave the formatting of the detail section? Or, can I keep the format of the detail section open while the report gets the next record?
I plan on going outside the report to a function during report detail format to individually load the textboxes based on the region in the record.
(I hope this is clear...)

 

[dhookom]

Is there more than one record per date per region? Is there always at least one record per date per region?

If there are multiples, I would use two of the same subreport in the detail section of a report that contains only dates and regions.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lamarw]

Q:Is there more than one record per date per region? Is there always at least one record per date per region?
A: One record per Date/Region. However, there will be two records per date but the differentiating factor is the region, therefore, always one record per date/REGION.

 

[dhookom]

I would create a report based on a query like:

SELECT MyDate
FROM tblNoNameGiven
GROUP BY MyDate;

Add two text boxes to your detailed section:
Name: txtNorth
Control Source: ="North"

Name: txtSouth
Control Source: ="South"

Then create a subreport based on your table and place two copies of this subreport side-by-side in the detail section of your report and Set the Link Master/Child of one to:
Master:txtNorth,[MyDate]
Child: [Region],[MyDate]
and the other
Master:txtSouth,[MyDate]
Child: [Region],[MyDate]
The records in the subreports should then be filter as required.


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lamarw]

Hi dhookom,
Thanks for the suggestion. I will try that approach. Just to ask a theoretical question, doesn't the report create a separate detail section per record (like a continuous form)? and if so then how does the report know not to create a new detail section when the next record is read?

Lamar

 

[dhookom]

Your main report will have only one record per date. This allows you to add two subreports that are limited to a single date and then to the region value.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]