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 gkittelson 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
- 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
-
prompts question
Did you tried using cascading prompts? Looking at the description you provided it seems cascading prompts will do the work.- tektipscognos
- Post #2
- Forum: Cognos solutions
