regarding the distinct values

[subhash]

hi,

  i have a date prompt in my report. when i run the report i am getting duplicate rows into the prompt. i.e i am getting the date value repeated multiple times. but i want it to get only one time. how this can be done.

thanks
subhash.

[Suraj]

Cognos automatically displays distinct values.
It'll repeat the values only if the data it is querying has distinct row combination.
Try using a separate query for the date prompt that has only date query item.

[almeids]

The problem may be that you are just displaying the date portion of a date/time value.  Use Cognos or database functions to strip the data item down to just the date portion.