Print layout with line condition

Misset Vincent

Hi,

I created a layout of label based on receipt from production.
This layout has to be printed or not according to a condition contained in every line of recording (but there will be only one line recording by receipt from production).

I tried to pass by 'Visible' condition but I obtain a white label, what I don't wish.

I just want not printed the layout according to my condition but because it's a line condition, I'm not sure that is possible...

Could you help me ?

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-file-uploads/vincentmisset/Production label.rst]Production label.rst[/url]

Martin Cerasuolo

You can try to move the visibilty criteria
DocumentRow("RowRowItems.ItmsGrpCod")<>"646"
to the detail named DocumentRowDetail.
Otherwise a criteria must be added in the printdefinition to not to print the lay-out....

Please let me know if it works?

Martin Cerasuolo

Misset Vincent

Hi Martin,

If I'm go on that way, I obtain a with label.

So, the right way I think is added criteria in the printedefinition, but I don't know how can I do ?

Thanks for your answer

Philipp Knecht

Hi Vincent, hi Martin

I would solve that with a copy query (remember you have to return a value 0 if you would like to skip the layout) and put it into the copy column in the printdefinition.

hth

Martin Cerasuolo

Hello Phillip,

Is there a description to apply the "copy query" ?

Daniel Ebi

Hello,

you can create a query in SBO an then save it in category "SWA_LD_Copy". After that you can use it in the layout. I think that's what Philipp means.

I have created the following query for activities:
SELECT CASE WHEN [%CntctType]=3 THEN 1 ELSE 0 END AS NumOfCopy

Kind regards

Daniel