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.
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.
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.