Difference between revisions of "Capitalising report generator output"

From Catalyst
Jump to: navigation, search
m (Reverted edits by Richard Green (talk) to last revision by Les Ward)
Line 7: Line 7:
 
Just substitute {{DataValue|A03}} for any Report Generator text variable.
 
Just substitute {{DataValue|A03}} for any Report Generator text variable.
  
{{Note|title=PLEASE NOTE|text=&nbsp;<code>$LOSTR{}</code> will do the same in the other direction, forcing lower case.}}
+
{{note|text=<code>$LOSTR{}</code> will do the same in the other direction, forcing lower case.}}
  
 
== See also ==
 
== See also ==
* [[:Category:Getting Started|Getting Started]]
+
*[[REF:rprgflostr|$LOSTR - Convert a string to lower case]]
* [[:Category:Report Generator|Report Generator]]
+
*[[REF:rprgfupstr|$UPSTR - Convert a string to upper case]]
* [[:Category:Master Class|Master Class Tips]]
 
* [[REF:rprgflostr|$LOSTR - Convert a string to lower case]]
 
* [[REF:rprgfupstr|$UPSTR - Convert a string to upper case]]
 
  
{{KB_Tags|capitalise, upper case, $UPSTR, $LOSTR}}
+
{{MClass}}{{KB_Tags|capitalise, upper case, $UPSTR, $LOSTR}}{{KB_RGen}}
{{MClass}}{{KB_RGen}}
 

Revision as of 16:26, 29 August 2013

Summary

Sometimes it is useful to have the output of the Report Generator to be in a certain case ('UPPER' or 'lower' case). For example Royal Mail suggest it is good practice for computer printed addresses to be in capitals to help the sorting machines.

Method

$UPSTR{A03} would output the Account Name (A03) in upper case. Catalyst Computer Systems would become CATALYST COMPUTER SYSTEMS.

Just substitute 'A03' for any Report Generator text variable.

$LOSTR{} will do the same in the other direction, forcing lower case.

See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
capitalise, upper case, $UPSTR, $LOSTR