Querry too complex error

svgelacio

Registered User.
Local time
Tomorrow, 05:30
Joined
Apr 6, 2009
Messages
11
How can i solved this error? is there a limit in the number of fields that a report contain? when I tried to remove some of the fields, the report comes out without any error. but I need to reflect all these fields in my report. Please help me on this.
 
How many fields are there? Also the detail section of the report has a finite length
 
Im working on about 350 or more fields in one report. Also, this is on the report footer section im utilizing.
 
350 fields is a lot for a report. The report footer is also finite.

Have you look at grouping your fields and using subreports e.g. You have your main report then have several subreports on the main form?
 
yeah this is already one of the sub reports i did, its actually 1 of 3 pages of my weekly report, I can no longer take off some of the fields since this is already the summary. I really have to figure out how to present it if the fields are finite.
 
Have you tried concatenating similar query or table fields into one field?

example:
Select [FirstName]&" "&[MiddleInitial]&" "&[LastName] AS EMPLOYEENAME, [Address1]&" "&[Address2]&" "&[City]&", "&[State] AS ADDRESS, . . . .


that cuts down on the number of controls to place on the report

sportsguy
 
If your qry is too complex then my opinion is to "split" your basic qry and to create 2 or 3 qry's with less fields - data in it's one, binding them by the ClientsCode for Example...
 
Is there any other way like adjusting the number of fields to be accomodated in the options menu or something like that?
 

Users who are viewing this thread

Back
Top Bottom