Selection Criteria in Reports

[Dennis Hancy]

I have a report whose selection criteria currently occupies six lines
of the Query Builder grid.

I now need to add two more criteria which will be "and-ed" with the
current six lines. As a result, I will need 12 lines for the
criteria.

However, I only have nine lines allocated for the criteria in the
grid.

Is there any way to increase this number?


Dennis Hancy
Eaton Corporation
Cleveland, OH

 

[John Spencer (MVP)]

Yes, just click on any row in the criteria and then select Insert: Row from the menu

 

[John Spencer (MVP)]

Is that the exact message? As far as I know a query can have approximately
64,000 characters in it.
A cell (in the grid) is limited to 1,024 characters.
A maximum of 40 ANDS in the where Clause.

Can you post the SQL statement even though it is failing?

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message