Maximum of fields in a report

[jeanulrich00]

Hi

I am building a report and I face a problem

On the reportI have many fields and when I want to see it, a message
pop telly me taht I have too many fields.

I made a search about maximum of fields authorised in a report and
smewhere I saw 255 as the limit. So I search in this group and I
found somebody saying 742 including labels.

Including labels my report should be somewhere around 320 all
together. As suggested in a discussion i did not used the wizard (in
fact I never used it). and I built it manually, copiinf fields from a
previous report to a new one. The same message pop "too many defined
fields".

Is there something I am doinw wrong ? Is there an option that I have
to check to aloud more fields on my report ?

Thanks for helping

 

[KARL DEWEY]

Try doing a compact and repair. If you have create a label and then removed
it, Access still has it lingering around until you compact and repair.

 

[Douglas J. Steele]

Actually, the limit on the number of controls is lifetime. Compacting has no
effect.

It may be necessary to create a new report and copy-and-paste from the
existing one.

 

[jeanulrich00]

Actually, the limit on the number of controls is lifetime. Compacting has no
effect.

It may be necessary to create a new report and copy-and-paste from the
existing one.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)







- Show quoted text -

I did a new report starting from scratch and still the same problem

In this report I need 52 labels and 36 text field containing formulas
in the page header, in the detail section I have 85 text field in
the first level footer 85 in the second level footer 85 again and in
the report footer another 85

Right now the report works with all header labels, all detail's text
fields, footer of first level is ok and when i try to copy text fields
of the first level footer to the second level footer....niet (too many
fields). So I did it one by one. and It stop at 72 fields that I could
add in the second level footer

So If I resume : 90 objects (label or text field) in thepage header,
96 in the detail section, 85 in the footer of the first level footer
and 72 in the footer of the second level + 8 tinny vertical line

So I need to add 13 text field in the footer of the second level and
85 text field in the ffoter of the report.

When I was at the limit with Text field, I try to add more labels and
I could so it seem that the problem comes from text fields only. and
between all objects I have on my reports, if I take out labels I am
very close to the 255 fields limit. I think that the limit is for
calculated fields because the same problem happened to me when i was
building a query that was joigning 3 croostab query

I have try to compact ....no effect at all

I have try a new report starting from scratch .........not working

I have try a new report and copy fields from a previous
report ......not working

So I am realy starting to think that I cannot have more than 255
calculated text fields

What is your opinion about that and do you see a solution; maybe sub
report in the report

I am stuck

Realy need help

 

[Douglas J. Steele]

Sounds as though you've got more than 255 fields in total

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Actually, the limit on the number of controls is lifetime. Compacting has
no
effect.

It may be necessary to create a new report and copy-and-paste from the
existing one.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)







- Show quoted text -

I did a new report starting from scratch and still the same problem

In this report I need 52 labels and 36 text field containing formulas
in the page header, in the detail section I have 85 text field in
the first level footer 85 in the second level footer 85 again and in
the report footer another 85

Right now the report works with all header labels, all detail's text
fields, footer of first level is ok and when i try to copy text fields
of the first level footer to the second level footer....niet (too many
fields). So I did it one by one. and It stop at 72 fields that I could
add in the second level footer

So If I resume : 90 objects (label or text field) in thepage header,
96 in the detail section, 85 in the footer of the first level footer
and 72 in the footer of the second level + 8 tinny vertical line

So I need to add 13 text field in the footer of the second level and
85 text field in the ffoter of the report.

When I was at the limit with Text field, I try to add more labels and
I could so it seem that the problem comes from text fields only. and
between all objects I have on my reports, if I take out labels I am
very close to the 255 fields limit. I think that the limit is for
calculated fields because the same problem happened to me when i was
building a query that was joigning 3 croostab query

I have try to compact ....no effect at all

I have try a new report starting from scratch .........not working

I have try a new report and copy fields from a previous
report ......not working

So I am realy starting to think that I cannot have more than 255
calculated text fields

What is your opinion about that and do you see a solution; maybe sub
report in the report

I am stuck

Realy need help

 

[smw2340]

Any suggestions on other alternative programs to use when the total fields in
the report is over 255?

 

[Douglas J. Steele]

Sorry, no.

If you've really got that many fields, odds are your tables aren't properly
normalized. Normalized tables are normally narrow (but have many rows).

 

[smw2340]

Actually - i have 4 tables that have many rows and have 48 columns. each
table represents either the Current Month (CM) and YTD expense or the
Forecasted expense. What i'm trying to do is build a report that shows the
actual expense, compared to the total while also showing the % of that
expense compared to total expenses as well as $$ variance from forecast and %
variance from Forecast. Basically, for each line of expense i want to show
the following for CM and YTD:

Expense Label >Actual Amt>% Total Expense>Forecast Amt>% Total> $$ Variance>
% Variance (repeat previous using YTD amounts).

 

[jeanulrich00]

Actually - i have 4 tables that have many rows and have 48 columns.  each
table represents either the Current Month (CM)  and YTD expense or the
Forecasted expense.  What i'm trying to do is build areportthat shows the
actual expense, compared to the total while also showing the % of that
expense compared to total expenses as well as $$ variance from forecast and %
variance from Forecast.  Basically, for eachlineof expense i want to show
the following for CM and YTD:

Expense Label >Actual Amt>% Total Expense>Forecast Amt>% Total> $$ Variance>
% Variance (repeat previous using YTD amounts).






- Show quoted text -

Hi

I Have try many options, but all the time I am stuck with the 255
limits.

I can of have the same problem then smw2340.

I know that my tables are ok. I think the main problem is my boss who
wants to see too much calculated fields at the same time.
For me it is a program that produce an MFL (Man Forecast Leveling)
like 200 records for 36 periods (Planified, Actual, Forecast + sum for
each level ...that's a lot of calculated fields

Anyway I do not have any answer for this problem yet

 

[John W. Vinson]

Any suggestions on other alternative programs to use when the total fields in
the report is over 255?

The limit on the number of *CONTROLS* in a report is much larger - 700 or more
as I recall. There's a (hard) limit of 255 fields in a Table or Query.

The limit on controls is cumulative, however; adding a control and deleting it
uses up a slot, even changing the datatype of a control does so. Copying and
pasting controls into a new report will "reset the clock" however.

 

[smw2340]

how do you find out how many controls you have in the report already?

 

[John W. Vinson]

how do you find out how many controls you have in the report already?

I don't know of any way to do so. It's just a couple of minutes work to create
a new report and copy the controls - and unless you have over 758 controls
already, that should work for you.

You will need to do a lot of your calculations in the Report textboxes, rather
than in calculated fields in the Query to get around the 255 field limit *in a
Query*.

 

[jeanulrich00]

how do you find out how many controls you have in the report already?








- Show quoted text -

I just count them