Avoid counting Line.Text with RecordNumber line numbers
Avoid counting Line.Text with RecordNumber line numbers
(OP)
Hello everyone, I have a Crystal Report document that is an Order and below the product lines sometimes a simple line of text is added below that is linked to the one above, I wanted to know if it is possible that the RecordNumber field that count the lines avoid counting when there is a line of text and only count the products.
this is how it comes out right now
1 CODE DESCRIPTION PRICE
2 TEXT.LINE
3 CODE DESCRIPTION PRICE
4 CODE DESCRIPTION PRICE
5 CODE DESCRIPTION PRICE
6 TEXT.LINE
7 CODE DESCRIPTION PRICE
this is how i want it to appear
1 CODE DESCRIPTION PRICE
TEXT.LINE
2 CODE DESCRIPTION PRICE
3 CODE DESCRIPTION PRICE
4 CODE DESCRIPTION PRICE
TEXT.LINE
5 CODE DESCRIPTION PRICE
I do not know if it is possible with a formula, I have the RecordNumber field in the 2 lines, both in the products and in the Line.Text
If I put it only in the row of products it counts me then Odd

Thanks!
this is how it comes out right now
1 CODE DESCRIPTION PRICE
2 TEXT.LINE
3 CODE DESCRIPTION PRICE
4 CODE DESCRIPTION PRICE
5 CODE DESCRIPTION PRICE
6 TEXT.LINE
7 CODE DESCRIPTION PRICE
this is how i want it to appear
1 CODE DESCRIPTION PRICE
TEXT.LINE
2 CODE DESCRIPTION PRICE
3 CODE DESCRIPTION PRICE
4 CODE DESCRIPTION PRICE
TEXT.LINE
5 CODE DESCRIPTION PRICE
I do not know if it is possible with a formula, I have the RecordNumber field in the 2 lines, both in the products and in the Line.Text
If I put it only in the row of products it counts me then Odd

Thanks!
RE: Avoid counting Line.Text with RecordNumber line numbers
As for the formula, it is a little difficult to be specific based on the screen shot provided, and will depend whether the second report column (I've called it {Table.2ndColumnField} in the formula below) is Null or an empty string, but it would look something like this:
CODE --> {@RecordCount}
Hope this helps.
Cheers, Pete
RE: Avoid counting Line.Text with RecordNumber line numbers
RE: Avoid counting Line.Text with RecordNumber line numbers
-LB
RE: Avoid counting Line.Text with RecordNumber line numbers
Greetings from Barcelona