TRIM function in cognos 8.2 with sybase 15

[yousuf_248]

I have created a query in a report and pulled 2 query items from one of the query subjects from the package. I applied trim function to one of the query item and checked the report output by running the query from the report. I found some records were missing. i took the query from cognos report and executed it in Db and i was getting all the records.

I removed TRIM function and checked it's giving me all the records in the report. But  i want to use the TRIM function since the query item is of CHAR type and it appends spaces at the end which looks ugly in the report output.

Is it a cognos issue or sybse issue?

Any help would be appreciated.

[Killyblame83]

hi,

have u tried to use the Vendor specific function (Sybase) in report studio?

ltrim() or rtrim() to remove leading or trailing spaces.

These functions are in the function tab where u define the expression of the query item in report studio. If u can't see these Vendor function is because u didn't selected them when u published the package from Framework manager.

bye