Hi All,
I have lurked on these boards for quite some time now and they have always been useful for finding answers- thanks to everyone! I am finding myself stumped on this issue- and I can't seem to find anyone who has encountered a similar problem. Basically I have two separate reports, lets call them Report 1 and Report 2, with their own queries named uniquely. For example:
Report 1 would have:
-Query A
-Query B
-Query C (a union between A and B, A U B)
Report 2 would have:
-Query D
-Query E
-Query F (a union between D and E, E U F)
*note that query A, B, D, E are all based on the same data source with the same columns.
Basically what I am encountering is Report 1 and 2 will run fine individually on their own. However, if I try to merge the two reports into one (not changing any of the queries or layout- simply appending queries and layout one beneath the other) Cognos will give the following error: RQP-DEF-0182 The queries for the set operation are incompatible.
When I merge the reports- I change nothing. But its like Cognos can't run both sets of queries in the same report....??
Any help or suggestions would be greatly appreciated!! Thanks!
If you view tabular data for each underlying query - A, B, D, E - does this return expected results? What then happens if you view tabular data for query C and query F - do you get the same error from one/both/neither?
Regards,
MF.
Hi MFGF,
Thanks for your answer. Individually the queries all run as expected and none return any errors. The unions C and F run as expected as well without any errors. It seems the error only comes when trying to run the whole report together. Worst case scenario I can always maintain these as two separate reports- but it would be nicer for users to receive one report instead of two. I guess I am not understanding why these reports work separately but won't work together-- frustrating.
Thanks,
J
Very odd! What layout objects are referencing the queries? Do they have anything advanced such as variables/conditional highlighting which may not have copied across from the original report and could be causing odd behaviour?
If you temporarily remove the layout objects and replace them with simple lists, does the error still occur?
MF.