Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C# ASP.NET VB.NET Reports , +
I have a question about using Crystal Reports.
I need to display records in multiple columns with a Header, and I have done it with
(Right click on Section Expert.. >>
In the Section Expert, highlight Details >>
select Format with Multiple Columns >>
Layout tab and set the Width >>
Set the Horizontal and/or Vertical )

Example: Suppose, I have 5 records and display in 2 columns per row
UserID Name UserID Name
1 User1 2 User2
3 User3 4 User4
5 User5
My requirement is to display the Header only when record exist in second column
Scenario like:
If I have only one record then it should like this: (don't display header in right section)
UserID Name (automatically supress header from here...)
1 User1

Any suggestion would be appreciated!
Posted 8-Mar-11 23:33pm
Edited 9-Mar-11 4:28am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I have done using following steps:
1. I have added Count Field of each section.
Right click >> Insert Summary >> Select Field
2. Suppress Column Header based on condition (right side column)
3. Checked Suppress
4. Click on x+2 button
5. Add Formula
if (Count ({rep_rd1.AppField_Position}, {rep_rd1.SORT_ORDER}) = 1) then true
6. Run the Report
CSharplex at 22-Sep-14 16:23pm
Hi Emad, I need your kind help. I had been going crazy with this thing to be able to display records from left to right in 3 columns. I've followed your and others same suggestion but its not displaying multiple column neither in design nor in run time! I'm trying with Crystal report in visual studio 2012.
I need to print something like this:
1 XXXX 24 2 AAAA 30 3 BBB 34
4 CCCC 20 5 BBBB 23 6 MMM 24

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Peter Leow 255
1 Mika Wendelius 235
2 CHill60 200
3 Zoltán Zörgő 178
4 Rob Philpott 170
0 Sergey Alexandrovich Kryukov 8,658
1 OriginalGriff 6,591
2 Peter Leow 3,982
3 Zoltán Zörgő 3,604
4 Richard MacCutchan 2,510

Advertise | Privacy | Mobile
Web03 | 2.8.150123.1 | Last Updated 9 Mar 2011
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100