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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ReportNet Query with Distinct in Crosstab

Status
Not open for further replies.
badhri

badhri

Programmer
Apr 8, 2001
56
US
Greeting,

I have a weird issue.

I try to generate a Crosstab report and Cognos generates a query with a inner query and a select columns atop of it. The Inner query has a SELECT DISTINCT due to which the amounts are all messed up.

What property that i specify makes it generate a DISTINCT.

How do i override the query generated by Cognos in ReportNet.

Thanks in Advance.

Badhri ...
 
Status
Not open for further replies.

Similar threads

tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
379
tushargaurav
tushargaurav
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
322
deborahyr63
deborahyr63
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
353
wwconslt
wwconslt
Emperatriz Stredel
  • Locked
  • Question
Two Cognos reports with two Models (Framework Manager)
Replies
0
Views
357
Emperatriz Stredel
Emperatriz Stredel
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
331
Goutham3835
Goutham3835

Part and Inventory Search

Sponsor

Back
Top