By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,471 Members | 711 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,471 IT Pros & Developers. It's quick & easy.

sql statement and crystal report

P: n/a
I have a table which store data in the following format:
id number date
---------------------------
01 5 01-Aug-2003
01 2 01-Aug-2003
01 6 03-Aug-2003
..
..
01 8 31-Aug-2003
02 2 01-Aug-2003
02 7 02-Aug-2003
02 4 03-Aug-2003
..
..

can I write sql so that the data will be display in
crystal report in the following format:

id 1-Aug 2-Aug 3-Aug.......31-Aug
---------------------------------------------
01 5 2 6 .......8
02 2 7 4 .......
..
..

Thank you
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.