Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: How to display records in multiple columns Post Reply Post New Topic
Author Message
Savitha Hareesh
Newbie
Newbie


Joined: 23 May 2011
Online Status: Offline
Posts: 1
Quote Savitha Hareesh Replybullet Topic: How to display records in multiple columns
    Posted: 23 May 2011 at 3:40am
Hi all,
I am new to this forum. I have a table that store the datas as below
Admno Subject MarkScored
1001   English 24
1001   Maths   23
1002   English 24
1002 Maths 23
1003 English 24
1003 Maths 22
I want the crystal report as
Admno English Maths
1001 24       23
1002 24       23
1003 24       22
Pls help me


Thank you
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 23 May 2011 at 8:05pm
one of the way:

1. you can use two variables:
    xEnglish:
       if {tbl.field}='english' then mark_score else 0

    and xMaths:
       if {tbl.field}='maths' then mark_score else 0


2. Group the 'Admno'
3. make Sum for variable xEnglish and xMaths and put it based on the Group.
4. put the sum same line for the Group
5. hide for section detail


hope it help.

Emir W
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.000 seconds.