jppinto
asked on
Crystal Report - Display records horizontal
Hello,
I've an SQL table that has the following fields:
Date
ID
Clategory
Points
Name
I would like to build a report to show the records for a specif date (each date can have the maximum of 6 records) in an horizontal way, something like the image bellow. So each big rectangle is a record with the 4 fields. The number of records can vary from 1 to 6.
Any ideas on how to acomplish this task or what is the best way to do this?
image1.jpg
I've an SQL table that has the following fields:
Date
ID
Clategory
Points
Name
I would like to build a report to show the records for a specif date (each date can have the maximum of 6 records) in an horizontal way, something like the image bellow. So each big rectangle is a record with the 4 fields. The number of records can vary from 1 to 6.
Any ideas on how to acomplish this task or what is the best way to do this?
image1.jpg
so each box represents a date?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
each box represents a record but instead of displaying row by row, I would like to display them on the same row!
jppinto please give my suggestion a try, I think it might do the trick for you.
ASKER
OK, sorry but I didn't had the change yet to look at your proposal with attention, I'm going to see now and will report on a few minutes
ASKER
You solution looks good. I'm not able to test this on the live data, only on a test project. Let me try this tomorrow at the company to see if it works and I will post back here on the next 24 hours or so. Sorry for the delay. I won't forget to give you the feedback...
Thanks,
jppinto
Thanks,
jppinto
Since you have only 6 columns(maximum) you can format the report and then pass discrete parameters to Crystal Reports from the code.
Check this example http://www.codeproject.com/KB/vb/CrystalContrl.aspx
Check this example http://www.codeproject.com/KB/vb/CrystalContrl.aspx
ASKER
Sorry, didn't had the change to test neither of the solutions. Just posting to say that I didn't forgot this...
jppinto
jppinto
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was not able to complete this using Crystal Reports but I've tryed Microsoft Reporting Services, like mentioned by jpaulino, and It worked well. Thanks to all.
ASKER
I used Microsoft Reporting Services and found this article on how to do it:
http://blogs.msdn.com/chrishays/
Look for "Horizontal Tables" part.
jppinto
http://blogs.msdn.com/chrishays/
Look for "Horizontal Tables" part.
jppinto