Print layout with line condition
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 ?
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-file-uploads/vincentmisset/Production label.rst]Production label.rst[/url]
Martin CerasuoloYou can try to move the visibilty criteria
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?
Misset VincentHi 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 KnechtHi 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.
Martin CerasuoloHello Phillip,
Is there a description to apply the "copy query" ?
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