By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Force new Column in Report??

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Mal wrote:
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.

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.

Nov 12 '05 #2

P: n/a
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" <oi*@vinegar.com> wrote in message
news:hz***************@newsread1.news.pas.earthlin k.net...
Mal wrote:
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.

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.

Nov 12 '05 #3

P: n/a
Mal Reeve wrote:
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" <oi*@vinegar.com> wrote in message
news:hz***************@newsread1.news.pas.earthlin k.net...
Mal wrote:
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.


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.

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.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.