Click here to Skip to main content
12,896,826 members (58,615 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# VB ASP.NET VB.NET , +
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 22:33pm
Updated 9-Mar-11 3: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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170424.1 | Last Updated 9 Mar 2011
Copyright © CodeProject, 1999-2017
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