Adding No. Units To Crystal Reports

[lotus18]

Hello World

I have this code that displays this report


[CODE=vb]
...
With frmSchedules
rs.Open "Select * From PrintSchedule Where Courses.Title=' " & _
.lblSection.Cap tion & "' And Sections.Title= '" & .cboSections.Te xt & _
"' And Semester='" & .cboSemester.Te xt & "'", dbConnection, 1, 1
End With
With Report
.Database.SetDa taSource rs
.PaperOrientati on = 2
.PaperSize = 1
.DiscardSavedDa ta
End With
crViewer.Report Source = Report
crViewer.ViewRe port
...
[/CODE]

How can I get the current total no of units of the schedule (see image below) Summation of Lec and Lab Units (Total no. of units 31)

[QVeen72]

Hi,

Insert a new Formula Field and give this in formula editor:

Sum ({MyTable.Lec}) + Sum ({MyTable.Lab})

and place this formula wherever required..

REgards
Veena

[lotus18]

Hi,

Insert a new Formula Field and give this in formula editor:

Sum ({MyTable.Lec}) + Sum ({MyTable.Lab})

and place this formula wherever required..

REgards
Veena

Thanks veena, it worked : )

[lotus18]

Hi Veena. I want to make my total no. of units to be fixed format , it show 31.00 instead of 31.0. I tried, Fix(Sum ({MyTable.Lec}) + Sum ({MyTable.Lab}) ,1) and Rnd(Sum ({MyTable.Lec}) + Sum ({MyTable.Lab}) ,1) to the CR's formula, but nothing happens.

[lotus18]

Helloo...

Can anyone wants to help me. ~_~

[QVeen72]

Hi,

Right Click the Formula Field and Click on Format Field
>> Number Tab
Customize
Decimal = 1.0
Rounding =0.1

OK and Save

REgards
Veena

[lotus18]

Thanks again veena : )