Printing CR with footer only at the last page

[Guest_imported]

Hi!
I had this report using crystal report 7.0 and im printing data from access but the problem is i want the footer to appear only at the last page... Is it possible?

Thanks!!!

 

[nandagopal2000]

Hai

This is possible. but u write some coding (ie Formula) for it. Please Write what is ur Requirment in Detail to me.

Nandagopal.R
Analyst Programmer
SIT Pvt Ltd.,
Chennai

 

[SpeakUp]

Hi!
Thanks for the reply... actually im using the crystal report ocx in vb.
Here's my code...

Dim sBranch as String

sBranch = "{tComputers.Branch}='" & cboBranch & "'"

Cr1.ReportFileName = "\\mnlpdc\......\PCList.rpt"
Cr1.DiscardSaveData = True
Cr1.ReplaceSelectionFormula sBranch
Cr1.Action = 1

The problem is i want to print a summary in the page footer but i want it to appear in the last page not in every page of the report. How do i do that?

Thanks in advance!!!

 

[JNeave]

In the supress formula for the Page Footer Type

PageNumber <> TotalPageCount

This evaluates to TRUE on any page but the last and will suppress the Page Footer section on all pages but the last.

BUT

The section Report Footer only appears on the last page anyway, why not put the information you wish to display in there?

What are you trying to display at the end of the report?

 

[nandagopal2000]

In the supress formula for the Page Footer Type

PageNumber <> TotalPageCount

If i Reset the page number in certion contistion. at the time it will be work or not.

if it not work means i think

OnLastRecord=false

This will be work properly

Nandagopal.R
Analyst Programmer
SIT Pvt Ltd.,
Chennai

 

[SpeakUp]

Hi!

Sorry im new in crystal report... anyway i tried to put the summary (total count of PC in every branch) in report footer but its not working. Its a summary of all pc in every branches grouped into department.
How do i do that? HELP!

Regards,
Arnel

 

[JNeave]

In SQL

Select Department, COUNT(*) AS PCCount
From YourTable
GroupBy Department

In CR

In Details - [Department] [PCCount]

Hows that?

Failing that, post your SQL SELECT statement so we can see what data is coming into the Report