Click here to Skip to main content
11,410,529 members (57,465 online)
Rate this: bad
good
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!

Thanks,
Imdadhusen
Posted 8-Mar-11 23:33pm
Edited 9-Mar-11 4:28am
v3

1 solution

Rate this: bad
good
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

Thanks,
Imdadhusen
  Permalink  
Comments
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:

ID NAME AGE ID NAME AGE ID NAME AGE
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 Sergey Alexandrovich Kryukov 8,885
1 OriginalGriff 6,915
2 Maciej Los 3,390
3 Abhinav S 3,248
4 Peter Leow 3,059


Advertise | Privacy | Mobile
Web04 | 2.8.150414.5 | 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