Home > IT Answers > Business Intelligence > Crystal Report Combine field
Beginer2008
25 pts.
 Crystal Report Combine field
Crystal Reports, Crystal Reports 9, Crystal Rpeorts Combine Field
Combine different fields but same data type - "DateVar"  fields into one column and sort in ascending. Can Crystal Report 9.0 do it? Any idea do combine it? Below is scenario & output :-

Fields 1             Field 2             Field 3              Field 4

01-Apr-2010     04-Apr-2010     02-Apr-2010       06-Apr-2010

03-Apr-2010    05-Apr-2010

Output :-

01-Apr-2010

02-Apr-2010

03-Apr-2010

04-Apr-2010

05-Apr-2010

06-Apr-2010

 

Thanks in advance.

Loo

 

 



Software/Hardware used:
Crystal Report 9.0
ASKED: April 12, 2010  6:03 AM
UPDATED: April 23, 2010  12:33 AM
RELATED QUESTIONS
Answer Wiki:
I guess Crystal Reports doesn't provide a way to do that, but you can certainly base your report on a query that gets the information in that way. It is going to be an ugly query, and if you need to do something like that maybe you need to revise your database design.
Last Wiki Answer Submitted:  April 23, 2010  12:33 am  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _