Click here to Skip to main content
11,428,004 members (59,192 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET VB.NET
hello!

I want to design cross tab report in crystal report. but the problem is that when a started to create i can't get the desire report.i want subject name in column and below each subject i want to enter marks like mid term,final and assignment marks etc.
i tried many times to display the report as I want but it can't. and 2nd in a same tab in row wise i just want to enter Names, Roll# and Reg#.

How can i do This....
Posted 12-Oct-12 21:56pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You can go with this one
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

refer link,
A
Customized Crosstab Report
[^]

tips for sub columns effect
e.g.
    subjects
----------------
Math | Eng | Sci 

then query data should like this

MastColId SubjId SubjNm Marks StdId StdNm
1         1      Math   90     1    abc
1         2      Eng    91     1    abc
1         3      Sci    92     1    abc
1         1      Math   70     2    xyz
...

if you not have MastColId simply add it
select 1 as MastColId, subjid,subjnm... 
now, in crosstab
Columns       = MastColId, SubjId
Rows          = StdId, StdNm
SummaryField  = Mode(Marks)

Happy Coding!
Smile | :)
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.150428.2 | Last Updated 15 Oct 2012
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