• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

unique column in crystal reports

Hi Everybody

Somebody asked me in interview - How a unique column looks in crystal reports ? I told him that just like other columns, because it is unique it wont display any duplicates- is this right ?

Please clarify me?

Thanks in advance
0
syamsundar
Asked:
syamsundar
  • 3
  • 2
1 Solution
 
mlmccCommented:
I don't find anything that refers to UNIQUE COLUMNS in the CR documentation.  I suspect what you answered is what he was epecting but it is the only reference to unique I can find in CR is to distinct or unique records.

mlmcc
0
 
syamsundarAuthor Commented:
yeah  i told him the same answer as above but he is not satisfied , i checked in CR documentation  nothing special in there?

Thanks mlmcc
0
 
mlmccCommented:
I have written over 100 CR reports, searched the CR web site extensively, looked at numerous "experts" pages on CR, searched CR documentation, etc and have never seen anything about UNIQUE COLUMNS.  The only reference is to using DISTINCT in the SQL statement to as you said ensure no duplicate records.

Leave this question open for a few more days, maybe somebody will be able to shed light on this.

mlmcc
0
 
syamsundarAuthor Commented:
Thank you mlmcc, i stick to the same answer whcih we both discussed.
0
 
mlmccCommented:
glad to help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now