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...
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 !
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
(...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.