I have multiple complex SQL queries (each SQL is less than 8,000 characters). Each SQL will return about 5 rows. In database, I can easily use UNION to put all SQL queries into 1 query, and then sort the result in that 1 query.
But now I cannot create anything in database. This has to be done in Crystal report, and Crystal report only allow 8,000 characters SQL command.
How can I deal with this 8,000 characters limitation? I know sub-reports can pass value to main report. But I don't know how to merge multiple sub-reports result and then sort them.