Here's how you do it.
Assume you have one table (Table1) with two fields (field1, field2). You have four records that look like:
field1 field2
a c
d a
c b
b d
Use the following UNION query to accomplish sorting both fields and giving you eight rows:
SELECT...
When trying to export a crystal report to XLS, I get the following error message:
CRAXDRT Error Occurred on Server 20692: Error in File
D:\FolderName\MyReportName.rpt
Invalid export DLL or export format.
Exporting to RTF justs hangs. . .
I'm using Crystal Reports 8.5 and read somewhere to try...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.