SQL statement in User Prompt

Chi Fai Cheung

Hi Philippe :),

How to set an user prompt with a list of values when the user clicked on the Print-preview?


See attachment:
Is it possible to show only the selected description with the articles instead of all descriptions/articles what i have now.

Example to show this:
Description: Werk 2B

Article:
Horman
HormanLPu
Horman_ETurbo
etc.



How to set this up? Thanks in advance.

Chi Fai

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/vicichief/Selection_Description.JPG]Selection_Description.JPG[/url]

Philipp Knecht

Hi Chi Fai

Just enter the Parameters in the Parmeterform without itemid and formtype relation.

Then reopen the layoutdefinition and add those parameters to the parameters tab.

Enter a value in the input order field and for example [Y;Yes;N;No] in the Design Value Field.

After reopening the template you can use them.

hth

Chi Fai Cheung

Hi Philippe,

What i want is when i select in Trimergo a description in the tab Material (Form = TRI_PROJCT, Item = R_Materi) only the selected description must show.

What i did is i have create a new parameter (test) for the 'description' with itemid 'R_Materi'. Then add a second query in the layout-designer:
SELECT T0.description FROM trimergo.planning T0 WHERE T0.description = '[%test]'

I get a system error that (test) could not be found.

Thanks, Chi Fai

Philipp Knecht

Hi Chi Fai

Making a printdef upon selected rows only works when the item is of type Grid or Matrix. This Control seems to be a special one which is not supported for this purpose.

But you can solve it by selecting values from the paramform and use that parameter for your queries.

hth