How to use distint? any example

[everlearner]

Hi gurus,

in my report all fields are repeating twice,
can i avoid the duplication by DISTINT? i dont aware of how to use distinct on a column.
any one explain me by an example.  thanks in adv

[MFGF]

It sounds to me like the repetition is down to inaccurate modelling in your package. Descriptive items should automatically be grouped in your report and not appear twice, unless your model is inappropriately designed. Did you build the package in Framework Manager or has someone else provided it?

Regards,

MF.

[cognosun]

1) Report Studio --> Select the 'Query' ( the query which is used for your list object ) in query explorer.

2) After selecting the query you'll see a property for that Query ( at left+down) named " Auto group and summarize"

3) That property might set to 'NO' for your reprot ( guess !)

4) Make it 'Yes'..now you should't see deplicates ( as 'Yes' applies Distinct)

In case of Query studio...the process is different to avoid duplicates.

[blom0344]

No ,that is not entirely correct.  Yes/No influences whether aggregates are used against facts.  Any query without facts (only identifiers and attributes) gets a distinct added to the SQL expression by default..

[wyconian]

I'd suggest the first thing to do is look at the underlying data to check whether there are duplicates in the source. It may be that there is a column in the data that you are not using in the query that needs to be filtered out, or there may be an issue with the join strategy (frankly there are any number of things that could be causing duplicate records).  Just specifiying auto group/summarise would at best just be hiding the issue.

Good luck :-)