Joined: 23 May 2011
Online Status: Offline
Posts: 1
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
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
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