How to filter repeatative values in the report to get distinct values.Example: In any database we can use distinct command But My Report source is flatfile.Therfore,I cann\'t manipulate source system. Is there any command or function to filter repeating records/values in the report.Advance,Thanks.BO-Nath

  • Interview Candidate
  • 4
  • 22787

Showing Answers 1 - 4 of 4 Answers

reddeppa

  • Feb 3rd, 2006
 

In the Query pannel ..we have tab "Options"..

click there to get "eliminate dupicate"..enable this options..

its may help u..

  Was this answer useful?  Yes

rahul

  • Feb 15th, 2006
 

Using the eliminate duplicates option is one way.

In a clightly different scenario, duplicates could come up due to the design structure of the report. e.g.

In some specific cases, one may want to display a value in one field (say in a folded report) but multiple values come up (which could give you a COMPUTATION ERROR). To avoid such situation, one can define a variable which would e the max of the original field required. That ways the same value is fetched and also only one value is returned.

Omkar Paranjpe

  • Mar 18th, 2006
 

Hi,

One other way possible is by doing "No Duplicates" radio button in the Options of the data provider in the Definition(the black cube)

But sometimes in free-hand sql reports it is not possible.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions