New layout

alex oosterom

hello everybody,

i want to make a new layout with item master data.
Only i don't know how to get the item data from the item as a datasource in Coresuite Designer.

In the layout, the data must come from the item that is openend.

I did make a new Printdefinition with the name Item Data. Formtype 150
Also i a new layoutdefinitition with the name Item Data, with formtype 150. As i know, there are none standard datasources. So i have to make them myself.

How do i do that, SQL Query's and Parameters?

If i am right, which query's do i have to make and so further on...


Thank you all.


Alex Oosterom

Franz Leu

Add a query to the Layout definition, i.e.:

SELECT * FROM OITM WHERE ItemCode ='[%ItemCode]'

that gets all the ItemMaster data and Use the ItemCode as Parameter.
HTH
Franz

alex oosterom

Thank you very much, i didn't know what to put in the where statement.

Thanks