asked on

HOW TO CHECK DATA FOR PRINTING

Hello Experts,
i am started to use Crystal Report 6 for vb
in my FIELD (FLDItemType) contain FN then i want to print "FINISH"
that's i take a text object and written code in

Private Sub Section1_Format(ByVal pFormattingInfo As Object)
Select Case FLDItemType.Value
Case "FN"
TxtItemType.SetText ("FINISHED GOODS")
Case "RM"
TxtItemType.SetText ("RAW MATERIAL ")
End Select
End Sub

but i don't want to print that FLDItemType in my report,
then how to code using only that field from database.
Please guied us for how to code in general crystal report 6 if any document please send mail on walips@hotmail.com

Guide us,

Brendt Hess

For this example, I will assume that you have a partially completed report, and you want to add the word "FINISH" on any line where the matching record contains "FN" in fldItemType.

In your report, insert a new Formula. For this example, we will name the formula IsFinish.

In the formula editor, your formula will look like this:

IF {MyTable.fldItemType} = "FN" Then
"FINISH"
Else
""

Insert the resulting field in your report where needed.

rhoady

Also see the question "Crystal Preview Group Tree (Change Group Name)"

Once you create the formula Bhess1 suggests here you can use that same formula to rename your group header.

Jeff

karoo

walips?

Did the sollution from bhess1work?

rhoady

Ben & bhess1

This question was asked by the same person that asked the question titled "Crystal Preview Group Tree (Change Group Name)" and the answer given here or the answer I gave there will work for either question. I suggest bhess1 post an answer to this question just as I posted an answer to the other question.

Jeff

ASKER CERTIFIED SOLUTION

Brendt Hess

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial