473,386 Members | 1,785 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

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.
Nov 12 '05 #1
3 4488
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: James Boulter | last post by:
Dear all, I have a database in which one column is titled 'force'. Now that this has become a reserved word, virtually no commands will execute, including of course a query to change the column...
3
by: Mal | last post by:
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...
19
by: Owen T. Soroke | last post by:
Using VB.NET I have a ListView with several columns. Two columns contain integer values, while the remaining contain string values. I am confused as to how I would provide functionality to...
0
by: comp.lang.php | last post by:
I have a form that when you click the "Generate Report" submit button, it will force download a CSV file, required for this project. On the very same page you also have a "Search" submit button,...
6
by: MLH | last post by:
I am unsure how to do this. I want this tray to be used for certain print jobs - jobs that will prompt me to load the bypass tray with sheet labels. How to force this? Dunno. Its the HP LaserJet...
4
by: MLH | last post by:
I have a report and on it, a subreport control Main Report Name: rptInvoiceMain Sub Report Name: rptInvoiceSubReport SubReport Control Name: rptInvoiceSubReportCtl The...
1
by: bobykim | last post by:
Hi All, I'm using MS Access 2003 in a Windows XP environment. I've created an aging report for my department that is based on what I call the "Main query" with an IIf statement that allows the...
0
by: peter.c.bradley | last post by:
Hi folks, I have an Access report that has an unbound text box in the details section. The report also includes the standard headers and footers. The details section is populated by a query...
6
by: Brett Barry: Go Get Geek! | last post by:
Hello, I have a main report with a Record Source, a DateToday table, that has the current Month and Year. I have about 60 queries, each pulling different data via ODBC, that I am creating...
0
by: Josetta | last post by:
Here is something really bizarre that is happening...let me see if I can describe it. I have a report which has two locations on it. Primary Location and Secondary Location. I have both...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.