kwalters110
MIS
I have made a couple of reports in Crystal Reports 8.5 Professional that use either 2 or 3 unions depending on the report. Our software vendor just upgraded the crystal viewer for all of our users to Crystal X.
All of our regular reports work just fine, however when I go to run a report that uses a UNION ALL in the end user viewer program, I get an error saying that the Union Select lists don't match. After inspection of my sql I haven't noticed anything wrong with it (If you guys want I can post it here, but I'll warn you, its long). The weird part is the report opens fine in Crystal 8.5. There is no error message and everything looks as it should.
Is there something special in the way you do UNIONS in Crystal X?
All of our regular reports work just fine, however when I go to run a report that uses a UNION ALL in the end user viewer program, I get an error saying that the Union Select lists don't match. After inspection of my sql I haven't noticed anything wrong with it (If you guys want I can post it here, but I'll warn you, its long). The weird part is the report opens fine in Crystal 8.5. There is no error message and everything looks as it should.
Is there something special in the way you do UNIONS in Crystal X?