Hello,

Is it possible to create in easy sql query with fixed text field (not table field nor special date etc). I can just add the fixed field to the report layout
for example report layout:
FFFFFFF| FFFFFFFFFFFF|FFF|text|FFFF
but is it possible also to create it as a variable to the query form, so that user can define the text field to be printed before running the query?

I'm not a script writer, just wondering if it's maybe not so complicated to create? :o

BR, Alice

Yes you can add a text field to report layout. You need to modify the report that is generated. Im not too sure about passing a variable to report

ALl you really have to do is select the text field (ex. select tirou102.opno, tirou102.txta ... etc.)and generate the report. The only thing I recall about this was that I think it defaulted the text field length to something like 10 - I just went into the report and made it longer. You might want to remember that text fields are really multiple lines so I am not sure this is what you really want.