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.
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