Hello WF family,

I'm here for an advice. I need to print/display used parameters in the report.

At this moment this moment I am using it like this (don't hate me for having it wrong or like this :-) )

  
-SET &PARA='Transaction Date From:' || &TD_DATTIM_FROM  || ', ' || 'Transaction Date To:' || &TD_DATTIM_TO  || ', ' ..... many more;


-SET &FARA = TRIM_(BOTH, ' ',STRREP(&PARA.LENGTH,&PARA,8,'FOC_NONE',1 ,'-',4096,'A4096V'));
-SET &LARA = TRIM_(BOTH, ' ',STRREP(&FARA.LENGTH,&FARA,9,'_FOC_NULL',1 ,'-',4096,'A4096V'));

and then printing/displayin in the file (Excel as an example)

 
ON TABLE SUBHEAD
"<NAME "
" FILE <NAME GENERATED ON: <CAS <+0> "
HEADING
" "
-*"USED PARAMETERS: &LARA "
 

Any better solution for this?

Thanks a lot!

but getting error from reporting server

 

Reporting Server Error
The value of an amper variable exceeds the maximum length

 

Thank you very much for any feedback!

This message has been edited. Last edited by: FP Mod Chuck,

smOk

Put this line of code after your last -SET &LARA
-TYPE &LARA.LENGTH to see how big the parameter value is.

I would suggest not using A4096V.
Change it to A4096, but also do an RTRIM (Needs v8) around it to get rid of the trailing spaces.

Also you can put in the variable into the format and length of the STRREP. This will minimise the trailing spaces.

e.g.
-SET &LARA = TRIM_(BOTH, ' ',STRREP(&FARA.LENGTH,&FARA,9,'_FOC_NULL',1 ,'-',&FARA.LENGTH,'A&FARA.LENGTH|V'));

quote:

Originally posted by FP Mod Chuck:
smOk

Put this line of code after your last -SET &LARA
-TYPE &LARA.LENGTH to see how big the parameter value is.

Hello Chuck,

thank you for the input

Length is 555 and that should be fine. Ofc there can be more characters when we search for multiple parameters.

The thing is that this is not working on 8207 but on 8105 it works pretty fine. I've just discovered that on 8207 this might not be the issue but something else. I will have to dig deeper into it.

Any other ideas or ways how to do this will be appreciated.

Thank you Chuk!

quote:

Originally posted by Waz:
I would suggest not using A4096V.
Change it to A4096, but also do an RTRIM (Needs v8) around it to get rid of the trailing spaces.

Also you can put in the variable into the format and length of the STRREP. This will minimise the trailing spaces.

e.g.
-SET &LARA = TRIM_(BOTH, ' ',STRREP(&FARA.LENGTH,&FARA,9,'_FOC_NULL',1 ,'-',&FARA.LENGTH,'A&FARA.LENGTH|V'));

Hello Waz,

thank you for the input. I will give it a try!

Thanks a lot Waz