Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Report Studio - I need to fix a column width
A search of this yielded zip, so here goes Cognos 8 Report Studio page layout has a 1 column by 3 row table 1 cross tab in each cell i would like the first column in each report to stay fixed, or for that matter any column selectively. Positioning properties - for every cell of column 1 in...- JD1958
- Thread
- Replies: 0
- Forum: Cognos solutions
-
GROUPing BY a substring field ? how to!
ahhhh the alias ........ thats the ticket , now it works and yes i had tried your second suggestion but apparantly you can't do a substr in a group by statement ...oddly enough ! thanks !!! to all .... all is good now in db2 land ! -
GROUPing BY a substring field ? how to!
Thanks for the following advice to all , the first 2 replies seemed to have a commonality so i tried that first but for some reason its returning back the following syntax error, i will include my entire query ughh ... help !!!!! SELECT LOCDIST,COUNT(*) FROM (... -
GROUPing BY a substring field ? how to!
I'd like to group a field to which ive taken a substring of another field, but when i cant group by this substring that is in my select statement, any posible solutions ???? this is the simpliefied query with all the non essential stuff taken out SELECT SUBSTR(FIELDX,3,7),COUNT(*) FROM...
