Problem: Display data horizontally in Crystal report.
If you Want to display horizontally data in crystal report you can use Multiple columns option for example if you want to display following data horizontally
Student ID Name
C0801 Name1
C0802 Name2
C0803 Name3
C0804 Name4
C0805 Name5
Like this
Student ID Name Student ID Name
C0801 Name1 C0802 Name2
C0803 Name3 C0803 Name4
C0805 Name5 C0806 Name6
You can easily break rows into several columns horizontally according to your needs.
Solution: Displaying data horizontally in Crystal report.
For achieving multiple columns you need to create Mail Lable report in report wizard although this option is also available in Standard report Format but I found some difficulties therefore I have tested in Mail Lable and its work fine here for.
After creation you can see there is detail section that displays half as it is open in standard reports here is what we use multiple columns help us to achieve our goal.
Now right click on detail section and go to section expert here you find layout tab in which you can resize colums according to your needs.
There are four columns showing.
You can see here is options Across then Down and Down then Across on the given example I have used across then down as follows.
Student ID Name Student ID Name
------------------------------------------->>>>>>>>>
C0801 Name1 C0802 Name2
C0801 Name1 C0802 Name2
C0803 Name3 C0803 Name4
C0805 Name5 C0806 Name6
Format with multiple columns options is only available on detail section.
