HI IFS Community,
Could you help me with the following problem?
I created a BR report with one Design Row. When I run the report, I get an error message: "Maximum number of rows to retrieve during statement execution" has been reached. The parameter "Maximum number of rows to retrieve during statement execution" is set to 65,000.
The report fetches data from a Quick Information Source, which contains much more than 65,000 records. To solve this problem, I split the records in the Quick Information Source into two sets. For one set, the DESIGN_ROW_NO column has a value of 1, and for the other set, it has a value of 2. Each set of records contains fewer than 65,000 records.
In the report, instead of one Design Row, I created two Design Rows. One shows records that meet the condition DESIGN_ROW_NO = 1, and the other shows records that meet the condition DESIGN_ROW_NO = 2. But when I run the report, I still get the error message: "Maximum number of rows to retrieve during statement execution" has been reached.
On the Debug/Data Set Info tab, it shows that for the first Design Row, there is a condition QFACT_EQUIPMENTTECHSPEC.DESIGN_ROW_NO = 1, and for the second row, there is a condition QFACT_EQUIPMENTTECHSPEC.DESIGN_ROW_NO = 2. But then there is a section:
Compressed Sets:1 of 2
Compressed to: 1(4)
and there is a condition:
QFACT_EQUIPMENTTECHSPEC.DESIGN_ROW_NO IN 1,2
It looks that the system is combining these two queries into one.
My question is: Is there any way to block this so that the system does not combine these two queries into one?
Best regards,
Adam