cancel
Showing results for 
Search instead for 
Did you mean: 

Addition of Command based Custom table removes 'Distinct' keyword in Query

Former Member
0 Kudos

Hi,

I use 'Command' Object in 'Datbase Expert' to create 'Custom Tables' and use these tables to fetch LoVs. Addition of 'Command' Object is changing the existing Query and the only change is 'Distinct' in the Query got eliminated and showing 210 recirds instead of Just 10. I did not link this Custom table with any of the tables. If I delete this again the query showing only distinct values eliminating duplicates. Please help.

Edited by: Nanda Kishore B on Jul 16, 2010 12:36 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Nanda,

My guess would be that you've placed one of the fields from the LOV Command somewhere on your report. The fact that the LOV Command isn't linked to any of the other tables will cause CR to create a Cartesian join if any of the Command fields are used outside of the parameter's LOVs.

HTH,

Jason

Answers (1)

Answers (1)

Former Member
0 Kudos

Can some one help