Skip to Content

Print Layout Designer (PLD) multi-condition

I need to print text or a field value in a PLD in SAP B1 based on multiple conditions like this:

If FieldA begins with TextA then TextAA else

If FieldA begins with TextB then TextBB else

If FieldA begins with TextC then TextCC else

FieldB

Using linked variables I got this to work until I needed to add the logic for the second line. In reality, TextAA and TextBB are the same thing but there's no way to link a PLD field to more than one other PLD field. I couldn't combine the logic for the first two lines into one formula. Maybe you know how to do that?

FYI: The results of this logic all print in the exact same location in the document so they are all overlaying each other. Is there some magic to how you place overlaid items on the canvas that allows them to print correctly? Maybe that's why this isn't working.

Any assistance would be appreciated. Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 14, 2018 at 08:47 PM

    its easier if you start from scratch and use Crystal Reports. I recommend you move away from PLD. Future SBO versions will not support PLD

    regards, Sotos Soteriou

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 18, 2018 at 09:22 PM

    Sotos,

    Thank you, but unfortunately the report in question is the dunning letter. I have found no instance of anyone creating one using Crystal Reports. I have 20 years experience with Crystal but could not produce a dunning letter. PLD is utterly worthless but it's the only place where I can modify this report.

    Followup question:

    Is it possible to create multiple repetitive areas (akin to the Details section in Crystal Reports) within the PLD that print based on linked data? I added a repetitive section but could not tell what determined when it repeats. The how-to guides for PLD are some of the worst documents ever written and provide almost no help when it comes to simple design problems.

    Since the dunning letter prints a line for each document, can a repetitive section be entered like a group header in Crystal? And can that section be divided into parts that print based on different data conditions?

    Further exploration with my issue seems to suggest that it's doing what I want but since there are 8 different fields on top of each other, it just doesn't print the right one. If this is the problem, how do you stack the fields so they print the right one consistently? I'm grasping at straws here...

    Michael

    Add comment
    10|10000 characters needed characters exceeded