Too Many Fields in a Report?

[Kgwill85]

Has anybody ever had this problem? I have a table with a lot of
fields in it. I'm trying to be able to pull up a report with my
table's values in it. When I go to "create report by using wizard" I
select all the fields for the table that I want it to display. Go
through the rest of the set up. The report has to be in the "Tabular"
layout. (that part is important for what I'm trying to produce).
Then I go to generate the form and this error comes up..."The wizard
is unable to create your form or report because you chose too many
fields; please try again with fewer fields".

I have tried to modify the set up for the report and the same message
comes up. The report seems to have a limit for the tabular layout
which is mandatory for this report's format. It will let me make the
report in justified and columnar but I am not looking for that
result. I need all the information in the tabular layout.

Is there a way around this? This error message is foreign to me
because I have never knew that there was a limit to the amount of
fields that can be populated in a report.

Thanks in advance.

 

[Steve]

Access is trying to alert you that the design of your table structure may
not be normalized. You say you have a table with a lot of fields in it. My
first suggestion before you go further with your database is to examine your
table design. Typical tables have two to ten fields. A small percentage of
tables have between ten and twenty five fields. It is extremely rare for a
table to have more than twenty five fields.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Rick Brandt]

Has anybody ever had this problem? I have a table with a lot of
fields in it. I'm trying to be able to pull up a report with my
table's values in it. When I go to "create report by using wizard" I
select all the fields for the table that I want it to display. Go
through the rest of the set up. The report has to be in the "Tabular"
layout. (that part is important for what I'm trying to produce).
Then I go to generate the form and this error comes up..."The wizard
is unable to create your form or report because you chose too many
fields; please try again with fewer fields".

I have tried to modify the set up for the report and the same message
comes up. The report seems to have a limit for the tabular layout
which is mandatory for this report's format. It will let me make the
report in justified and columnar but I am not looking for that
result. I need all the information in the tabular layout.

Is there a way around this? This error message is foreign to me
because I have never knew that there was a limit to the amount of
fields that can be populated in a report.

Thanks in advance.

The limit you have hit is for the wizard only. Just build the report
manually and don't use the wizard.

 

[missinglinq via AccessMonster.com]

Rick's exactly right, it's merely a limit of the Wizard. You'll find the same
thing happens with the Forms Wizard when the underlying query/table has a
large number of fields.

 

[Kgwill85]

Access is trying to alert you that the design of your table structure may
not be normalized. You say you have a table with a lot of fields in it. My
first suggestion before you go further with your database is to examine your
table design. Typical tables have two to ten fields. A small percentage of
tables have between ten and twenty five fields. It is extremely rare for a
table to have more than twenty five fields.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)









- Show quoted text -

If I could take out some of the fields I would just to make it fit.
But I can't because the report is suppose to mimmick an already
existing spreadsheet so that when people view it they are already
familiar with the set up and layout.

 

[Kgwill85]

The limit you have hit is for the wizard only. Just build the report
manually and don't use the wizard.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com- Hide quoted text -

- Show quoted text -

Okay, I'll try this. Is there a way to get to the field's list for
the table that I am using though? Or do I have to input everything
manually?

 

[Kgwill85]

Rick's exactly right, it's merely a limit of the Wizard. You'll find the same
thing happens with the Forms Wizard when the underlying query/table has a
large number of fields.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted viahttp://www.accessmonster.com

I'm trying to do it manually now, but I can't figure out how I can get
to the field's list for the table so I can just drag them in side the
detail of the report.

 

[Rick Brandt]

I'm trying to do it manually now, but I can't figure out how I can get
to the field's list for the table so I can just drag them in side the
detail of the report.

Set the RecordSource of the report to the desired table or query.

 

[Kgwill85]

Set the RecordSource of the report to the desired table or query.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com- Hide quoted text -

- Show quoted text -

Okay, I got to that part. The field's list comes up. Which is great,
but I don't think it matters if I'm using the wizard or not. This
table has like 50 to 75 fields and in the design view for the report
it only lets me stretch it 22inches which isn't long enough. I guess
this can't be done like the way I want it to be.

 

[Rick Brandt]

Okay, I got to that part. The field's list comes up. Which is great,
but I don't think it matters if I'm using the wizard or not. This
table has like 50 to 75 fields and in the design view for the report
it only lets me stretch it 22inches which isn't long enough. I guess
this can't be done like the way I want it to be.

Yep, 22" inches of width is the limit.

Just curious. If Access DID allow you to create a tabular report wide
enough for 50 to 75 fields how would you expect a user to view it? By using
lots of horizontal scrolling? Sounds like a pretty unfriendly report to
use anyway. What if they wanted a hard copy?

 

[Kgwill85]

Yep, 22" inches of width is the limit.

Just curious. If Access DID allow you to create a tabular report wide
enough for 50 to 75 fields how would you expect a user to view it? By using
lots of horizontal scrolling? Sounds like a pretty unfriendly report to
use anyway. What if they wanted a hard copy?

I feel the same way that you do. If it was up to me I wouldn't make
it so long. I guess if they wanted to print it up the text would
have to be real small... as a matter of fact that gives me an idea.

I have another question about this report. How do I get it to display
in the tabular layout manually?

 

[Rick Brandt]

I feel the same way that you do. If it was up to me I wouldn't make
it so long. I guess if they wanted to print it up the text would
have to be real small... as a matter of fact that gives me an idea.

I have another question about this report. How do I get it to display
in the tabular layout manually?

Place labels across the Page Header and then TextBoxes below them in the
detail section. Size the detail section so it is only tall enough for your
single row of TextBoxes.

While it can be difficult to do the labelling you can of course use more
than one row of TextBoxes so that the report need not be so wide.

 

[Kgwill85]

Place labels across the Page Header and then TextBoxes below them in the
detail section. Size the detail section so it is only tall enough for your
single row of TextBoxes.

While it can be difficult to do the labelling you can of course use more
than one row of TextBoxes so that the report need not be so wide.

Thanks. It won't be that difficult to label each one because I'm just
going to cut and paste them in the header section. Hopefully this
presents and easier way to work around this problem.

 

[A a r o n K e m p f]

you need A c c e s s D a t a P r o j e c t s

 

[Kgwill85]

you need A c c e s s D a t a P r o j e c t s









- Show quoted text -

I'll keep that in mind. But I can only use what's here at my
workstation.

 

[Guest]

Don't know if you got it to work yet, but try this...

Create the report manually and size the 50-75 fields to a small width (it
doesn't matter - you won't need to see the data in Access). When the report
is created, go to preview mode - the output won't be pretty, but here's the
kicker...click the export button at the top of the screen to export the
results to Excel.

Once in Excel, click the blank cell above Row "1" and to the left of Column
"A" to select all cells and then double-click the border between any two
columns (ex: between "A" and "B") - the output will now be visible in tabular
format (probably extremely wide, but visible - you can adjust the visibility
by zooming in and out). You can then save as a PDF (if you have Adobe) for
distribution via e-mail or some other file format.