Display the number of records in Crystal Report 9

[nasreen]

Hi All,

Is there any idea to display the number of records in Crystal Report 9 (CRViewer91).

In crystal Repot 6, it is shown in the tool bar by default.

But in Crystl Repot 9 there is no such faciltiy.

Can anybody suggest a solution to display in the umber of record in report or in tool bar for Crystal Report 9.

Wit regards,

Nasreen

[RobDog888]

Its been a while but you can create a running sum formula and add it to your report.

[shakti5385]

Read Crystal report tutorial at my signature, See the last Post.

[nasreen]

Hi shakti5385,

Can u pls give me the link to the Crystal report tutorial at your signature

With regards,
Nasreen

[shakti5385]

http://vbforums.com/showthread.php?p=2645742

[nasreen]

Hi shakti5385

Thanks for your prompt reply

Here I use Crystal Repot 9 (CRViewer91) in VB6

I can't see a property or method as .RecordsPrinted under Crystal repot 9

Here is my exact VB code

Private Sub CmdPrnt_Click()
 
Dim CrystApp As CRAXDRT.Application
Dim CrystRpt As CRAXDRT.Report
Dim MyFrmDtlRpt As New FrmRptViewr 'Form with CRViewer91 to view the report 
Set CrystApp = New CRAXDRT.Application
Set CrystRpt = CrystApp.OpenReport("Reports\EBLStlRpt.rpt")
 
CrystRpt.DiscardSavedData
 
MyFrmDtlRpt.CRViewer91.ReportSource = CrystRpt
MyFrmDtlRpt.CRViewer91.Refresh
MyFrmDtlRpt.CRViewer91.ViewReport
 
MyFrmDtlRpt.Show
 
Set CrystApp = Nothing
Set CrystRpt = Nothing
 
End Sub

How can I display the number of records in my this report.

With regards,

Nasreen

[nasreen]

Hi Mr. RobDog888

Your rpelay

Its been a while but you can create a running sum formula and add it to your report.

Can u pls describe me how can I run the sum formula as you think. Which field I can use for sum. ?

With regards,
Nasreen

[shakti5385]

Crystal report control has a .RecordPrinted Property you can pass the value of this property using the parameter in the crystal report.
http://vbforums.com/showpost.php?p=2647344&postcount=3

[nasreen]

Hi shakti5385

Thanks,

But your idea is only applicable for Crystal Report OCX control, which is no longer available all new features of crystal report 8 and onwards

Even the Seaget crystal report team doesn't suggest to use this control more after the release of Crystal Report 8. They suggest to use The Report Designer Component (RDC) as a better method.

And we cannot open a report designed in Crystal Report 9 using .Action method of this Crystal Reprot OCX control. If we try, a run time error Unable to load report. will come.

Overall, if we use this OCX control for a reprot designed in Crystal Report 6, the number of records will be displayed on the tool bar of the report by default, the case already I indicated in my first question.

But as I think your this idea is not applicable for crystal report 9, especially for (RDC) method.

So if you have an idea which is alo applicable for crystal report 9, pls help in this regards.

With regards,
Nasreen

[RobDog888]

Hi Mr. RobDog888

Your rpelay




Can u pls describe me how can I run the sum formula as you think. Which field I can use for sum. ?

With regards,
Nasreen

Inside CR you can select the menu item to Add a field to your report. In htat window is the various types of fields to add. A formula field is one of them. Click create new.

[shakti5385]

Ok that’s fine
If you do not want t use the OCX control then best idea is that you can use parameter in the crystal report, using the parameter you can pass the value of the total printed record (you can get them from the SQL query).