hi
i have a report which has a code and name in one column. i want to show the code but hide the nameportionof this data element. what is the best way to hide this
regards
bunker
Can you show some example of records in that data items .
column 1 column 2 column 3
0124john location condition
4256bill
9788fred
should be
0124
4256
9788
Do you always want the first four characters of the item? If so, add a query calculation with the following expression
substring([Your Item],1,4)
Cheers!
MF.
Am completely agree with MF, for substring([column],1,4). Just for a change you can try this function of DB2
left ([name],4) for achieving the same.
Thanks
Quote from: HalfBloodPrince on 14 Dec 2011 09:35:29 AM
Am completely agree with MF, for substring([column],1,4). Just for a change you can try this function of DB2
left ([name],4) for achieving the same.
Thanks
That should only work with native functions enabled in the package and working against a DB2 database.
substring basically exists for all major RDBMS which makes is a more logical choice..