Crystal Reports Formula Field

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Formula Field

Author	Message
michaelwl Newbie Joined: 02 Aug 2007 Location: South Africa Online Status: Offline Posts: 11	Topic: Formula Field Posted: 06 Aug 2007 at 11:05am
	Having trouble with a formula... I have a database fields which has different values on every detail section... I want all of the values for this field concatenated and displayed on the first detail section. How can I do this? Is there a way of getting Crystal to look at the next record? Thanks, any help will be greatly appreciated!
	IP Logged

jkwrpc Senior Member Joined: 19 Jun 2007 Location: United States Online Status: Offline Posts: 432	Posted: 06 Aug 2007 at 11:22am
	CR has a function called Next. You can find an explanation in CR Help in the index section type Next. it will give the information you need. Here is the sample from the help file ------------------ If Next({file.QTY})<>0 Then {file.QTY}/2 Else {file.QTY} -------------------------------- Hope this helps. Regards, John W. www.CustomReportWriters.net
	IP Logged

michaelwl Newbie Joined: 02 Aug 2007 Location: South Africa Online Status: Offline Posts: 11	Posted: 06 Aug 2007 at 1:03pm
	Thanks, I'm gonna take a look as soon as I get to work tomorrow!
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.