Selection Criteria in Reports

  • Thread starter Thread starter Dennis Hancy
  • Start date Start date
D

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
 
Yes, just click on any row in the criteria and then select Insert: Row from the menu
 
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
 
Back
Top