Force new Column in Report??

[Mal]

Hello..

Is there a property to force a new column in a report.

I've looked at moveLayout, newRecord...and am thinking that some
combination of those might do it...but how???

I want to test for a condition (IF...then)
and force a new column if its true.

ideas??

Mal.

[Salad]

Re: Force new Column in Report??

Mal wrote:[color=blue]
> Hello..
>
> Is there a property to force a new column in a report.
>
> I've looked at moveLayout, newRecord...and am thinking that some
> combination of those might do it...but how???
>
> I want to test for a condition (IF...then)
> and force a new column if its true.
>
> ideas??
>
> Mal.[/color]
Yes. You need to create a grouping first. From the menu select
View/Sorting & Grouping. Let's say you have a report with a sort group
of Code and Name. Codes are A-Z. You want a new column started with
the code changes. Create a footer for Code. Dbl-Click on the footer
band. Select New Row or Column from the property sheet.

[Mal Reeve]

Re: Force new Column in Report??

Actually, I'm not testing against the data.
Can I test for how many lines have been printed on the page and then push a
new column.
ie. After 6 lines a new column
or after 8 lines etc.

Mal.


"Salad" <oil@vinegar.co m> wrote in message
news:hzYcc.424$ A_4.128@newsrea d1.news.pas.ear thlink.net...[color=blue]
> Mal wrote:[color=green]
> > Hello..
> >
> > Is there a property to force a new column in a report.
> >
> > I've looked at moveLayout, newRecord...and am thinking that some
> > combination of those might do it...but how???
> >
> > I want to test for a condition (IF...then)
> > and force a new column if its true.
> >
> > ideas??
> >
> > Mal.[/color]
> Yes. You need to create a grouping first. From the menu select
> View/Sorting & Grouping. Let's say you have a report with a sort group
> of Code and Name. Codes are A-Z. You want a new column started with
> the code changes. Create a footer for Code. Dbl-Click on the footer
> band. Select New Row or Column from the property sheet.
>[/color]

[Salad]

Re: Force new Column in Report??

Mal Reeve wrote:[color=blue]
> Actually, I'm not testing against the data.
> Can I test for how many lines have been printed on the page and then push a
> new column.
> ie. After 6 lines a new column
> or after 8 lines etc.
>
> Mal.
>
>
> "Salad" <oil@vinegar.co m> wrote in message
> news:hzYcc.424$ A_4.128@newsrea d1.news.pas.ear thlink.net...
>[color=green]
>>Mal wrote:
>>[color=darkred]
>>>Hello..
>>>
>>>Is there a property to force a new column in a report.
>>>
>>>I've looked at moveLayout, newRecord...and am thinking that some
>>>combinatio n of those might do it...but how???
>>>
>>>I want to test for a condition (IF...then)
>>>and force a new column if its true.
>>>
>>>ideas??
>>>
>>>Mal.[/color]
>>
>>Yes. You need to create a grouping first. From the menu select
>>View/Sorting & Grouping. Let's say you have a report with a sort group
>>of Code and Name. Codes are A-Z. You want a new column started with
>>the code changes. Create a footer for Code. Dbl-Click on the footer
>>band. Select New Row or Column from the property sheet.
>>[/color][/color]
I would check out http://groups.google.com
I would check out http://support.microsoft.com

Maybe you'll find some solutions there.

Perhaps you can use the Label wizard instead.

Personally, I'd see if I could figure out a way to set up a grouping in
the query and let the program operate normally.