Home....
Developer Network >> Visual Basic Programming >> Crystal Reports

Help with Formula

Hi All,

I am new here on this forum , i have a database of student registered for 2007-2008 with field of student names and term and i need a formula to show me distinct count of students registered for the following

1)Students registred for both fall and spring
2)Students registered only fall not for both fall and spring

Here is a sample of the record


Student Name Term
Jon Fall
Spring
Len Fall
Ami Fall
Spring
Ali Fall
Spring
Jan Fall
Spring
Ken Fall
Aco Fall
Chr Fall
Jos Fall
Spring
Skyler Fall
Alex Fall
[1002 byte] By [shefe] at [2007-11-20 11:43:25]
«« Rich Edit makes dialog close
»» Read string from binary file written in C#
# 1 Re: Help with Formula
I strongly suggest you to test fetching record using SQL tools before using formula in CR. It will make you expert to fetch data without leaning on reporting tools.
henky@nok.co.id at 2007-11-9 14:11:57 >
# 2 Re: Help with Formula
It works when i do a cross-tab but how is there a formula that counts if there a number 2 , i know it excel it is =countif(a1.a31,2) so it will count the rows that 2 only. I want to do the same thing for the people who both registered for fall and spring because the total in cross tab comes has 2.
shefe at 2007-11-9 14:12:57 >
Visual Basic Programming
Crystal Reports

Visual Basic Programming

All Classified

Visual Basic Programming New Topic

Visual Basic Programming Hot Topic