Adding No. Units To Crystal Reports

[lotus18]

Hello World

I have this code that displays this report

...
        With frmSchedules
            rs.Open "Select * From PrintSchedule Where Courses.Title='" & _
            .lblSection.Caption & "' And Sections.Title='" & .cboSections.Text & _
            "' And Semester='" & .cboSemester.Text & "'", dbConnection, 1, 1
        End With
        With Report
            .Database.SetDataSource rs
            .PaperOrientation = 2
            .PaperSize = 1
            .DiscardSavedData
        End With
        crViewer.ReportSource = Report
        crViewer.ViewReport
...
 

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 : )