Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error WhileReadingRecords

Status
Not open for further replies.

171171

Programmer
May 13, 2003
16
ID
Hai All,

I have new Formula in the PageHeader but the syntax not
can because Error

Why Error The Syntax ?

WhileReadingRecords;
stringVar NoPo :=IF {ApTrPoDt.cNoPo}=Previous ({ApTrPoDt.cNoPo}) then {ApTrPoDt.cNoPo}+',' else '' ;

Can You Help how can Read Previous Field in Formula
with WhileReadingRecords


Thanks

 
Where is the cursor when you get the error?

Are you getting a syntax error when you attempt to save the formula, or when you try to execute the report?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
 
Yes, The Error Getting error when I attempt to save the formula.
The Error currsor in Previous

Please Help
 
The first record has no previous value, so I would change your formula to:

WhileReadingRecords;
Not OnFirstRecord;
stringVar NoPo :=IF {ApTrPoDt.cNoPo}=Previous ({ApTrPoDt.cNoPo}) then {ApTrPoDt.cNoPo}+',' else '' ;

If this does not work, try changing your evaluation time to WhilePrintingRecords.



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
 
Why are you using "WhileReadingRecords" in your formula???

There is no sorting/grouping during this process so any references to previous records is boggus.

You should use "WhilePrintingRecords" and a formula using previous records probably belongs in a group header not a page header...tellus what you are trying to do by sample output wanted.

Jim Broadbent
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top