Crystal Reports Next and Previous 1

[pamela22]

My Problem: A particular product has multiple invoice lines but the product name only appears on the first Invoice Line. How can I show the Product Name of the first Invoice Line on Invoice Lines 2,3,4...

Here's what my report looks like now:
Invoice# InvoiceLine Product# Product Name
1234 1 9999 Green Apples
1234 2 9999
1234 3 9999
1234 4 9999

Here's what I want it to look like
Invoice# InvoiceLine Product# Product Name
1234 1 9999 Green Apples
1234 2 9999 Green Apples
1234 3 9999 Green Apples
1234 4 9999 Green Apples

It’s important to note that Product Code 9999 is not always "Green Apples". So I always want the lines following the first to display the value of the first line.

Any help would be greatly appreciated.

Thank you!!
Pam.

 

[lbass]

Try a formula like this instead of the product field:

whileprintingrecords;
stringvar x;
if {table.line} = 1 then
x := {table.productname} else
x := x;

-LB

 

[pamela22]

Thank you!!! That did the trick!!

 

[NKOS13]

Try Lbass formula it might work .l also have a close question to yours if you can see my post.