Crystal Report Combine field

25 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following