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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: tektipscognos
- Content: Threads
- Order by date
-
Count & distinct in sub select in the generated query SQL
Here is the situation. Need to get a sub-select statement generated in the generated sql within Report Studio, when a single query item (PROD_CD) or a set of query items is pulled in the report. Something similar to select count(PROD_CD) from (select distinct(PROD_CD) from T1 T1 join T2 T2...- tektipscognos
- Thread
- Replies: 1
- Forum: Cognos solutions
