ACROSS ACROSS1 AS '' COLUMNS 'STATUS' AND 'Primary Fulfillment Location' AND 'Price Type'
ACROSS ACROSS2 AS ' '

We have the above two lines of code in our report. While execution of these two line is taking more CPU utlization. It is causing issues.

What will be reason?

How to overcome this issue?

Thangam, does your code actually ever finish execution and give you what you want?
Can you run with just ACROSS ACROSS1 ACROSS ACROSS2
on a small sample of data and get results?

It is not giving any result. It hangs while executing these two lines of code. No o/p is returned to report.

It is hangine with small amount of data itself. We have few records(less than 100) in the test database at present. If it is the case, it will be a lot of problem in production database.

We need to sort as present in the code.

Any solution?

Any Alternative for the above query? Can someone help me?