Liveware Publishing Support Forum

I^ve got two reports in RR XBase v7.0 with the same master table and one child table in common. they both have the *EXACT* same report query. ____One report has multiple joins to various other tables and has lots and lots of fields from the tables, calculated fields etc on multiple group lines all of which i export to text and it works just fine.____the other report has only 1 join, no calculated fields, and only 1 record line which i^m trying to export, and when i do i get the error "Query is too complex, simplify and try again."____any ideas how this could be? i^ve checked the queries line by line and they are precicely the same, not the slightest difference between them...____

I am not sure why the difference but you can solve the problem by taking two of your query clauses and turning them into a single logical calculated field.____So if your query had CUST_NO equal to 123 and STATE equal to ^MA^____you would create a calculated field with expression:__CUST_NO=123 .and. STATE=^MA^____Then remove the two query clauses and instead add a single clause using__CALCFIELD is equal to .T.______Kathleen__R&R Support