Click here to Skip to main content
15,896,557 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Populating the Treeview control in VB Pin
ratbags21-Apr-10 0:23
ratbags21-Apr-10 0:23 
GeneralRe: Populating the Treeview control in VB Pin
DaveAuld20-Apr-10 3:49
professionalDaveAuld20-Apr-10 3:49 
QuestionMS Word and VB Webservices Pin
RossouwDB20-Apr-10 0:19
RossouwDB20-Apr-10 0:19 
AnswerRe: MS Word and VB Webservices Pin
Michel Godfroid20-Apr-10 0:53
Michel Godfroid20-Apr-10 0:53 
GeneralRe: MS Word and VB Webservices Pin
Michel Godfroid20-Apr-10 0:56
Michel Godfroid20-Apr-10 0:56 
QuestionCan visual basic be inserted in Dreamweaver? Pin
josephong19-Apr-10 22:11
josephong19-Apr-10 22:11 
AnswerRe: Can visual basic be inserted in Dreamweaver? Pin
Michel Godfroid20-Apr-10 0:38
Michel Godfroid20-Apr-10 0:38 
QuestionHelp in Crystal Report Selection Formula Pin
anandbpsri19-Apr-10 21:09
anandbpsri19-Apr-10 21:09 
Hi Friends,
I am developing an application with VB 6.0 and Crystal Report 7,I need the code to use distinct keyword in crystal report selection formula.

for example: suppose i have a Table name "community". Its fields are S.No, Name, DOB,Community.
Then a person can be member of more than one community (Which shown below)

S.No|Name | DOB | Community
-------------------------------------------------------
0001|Anand Kumar |18/08/1985| Delhi IT Proo
0002|Amit Kumar |14/06/1984| Delhi IT Proo
0003|Anand Kumar |12/01/1981| Delhi Computers
0004|Rishu Mehra |17/08/1986| Delhi IT Proo
0005|Shivendra |11/05/1982| Delhi IT Proo
0006|Mahendra Kumar |09/02/1988| Delhi IT Proo
0007|Anand Kumar |31/04/1983| Delhi MCA
0008|Rishu Mehra |13/09/1984| Delhi Computers

Now i want to print the distinct names from Community table with serial no only (Other fields not required), Please tell me any selection formula on Name field, So that when crystal report open it'll display only DISTINCT names ignoring other details, only distinct!

That means Result would be...

S.No|Name
0001|Anand Kumar
0002|Amit Kumar
0004|Rishu Mehra
0005|Shivendra
0006|Mahendra Kumar

Can some body help me with this? Pz Plz pLz plZ plz


With regards
Anand Srivastava
anandbpsri@yahoo.co.in
anandbpsri@gmail.com
anandbpsri@hotmail.com
Anand Srivastava

QuestionCrystal report help Pin
anandbpsri19-Apr-10 21:05
anandbpsri19-Apr-10 21:05 
NewsCode Protection Pin
Oguz Bastemur19-Apr-10 13:50
Oguz Bastemur19-Apr-10 13:50 
GeneralRe: Code Protection Pin
Dalek Dave19-Apr-10 13:56
professionalDalek Dave19-Apr-10 13:56 
GeneralRe: Code Protection Pin
Oguz Bastemur19-Apr-10 14:52
Oguz Bastemur19-Apr-10 14:52 
GeneralRe: Code Protection Pin
_Damian S_19-Apr-10 15:56
professional_Damian S_19-Apr-10 15:56 
GeneralRe: Code Protection Pin
Paul Conrad20-Apr-10 6:51
professionalPaul Conrad20-Apr-10 6:51 
RantRe: Code Protection Pin
Ashfield20-Apr-10 9:07
Ashfield20-Apr-10 9:07 
QuestionSilverlight and VB.Net and VB Express question Pin
jerryj19-Apr-10 11:35
jerryj19-Apr-10 11:35 
AnswerRe: Silverlight and VB.Net and VB Express question Pin
Dalek Dave19-Apr-10 14:09
professionalDalek Dave19-Apr-10 14:09 
QuestionNew Application Advice Pin
programmervb.netc++19-Apr-10 8:15
programmervb.netc++19-Apr-10 8:15 
AnswerRe: New Application Advice Pin
programmervb.netc++21-Apr-10 11:57
programmervb.netc++21-Apr-10 11:57 
QuestionProblem with FormClosing event Pin
Yosh_19-Apr-10 5:39
professionalYosh_19-Apr-10 5:39 
AnswerRe: Problem with FormClosing event Pin
TheComputerMan19-Apr-10 6:03
TheComputerMan19-Apr-10 6:03 
GeneralRe: Problem with FormClosing event Pin
tmalbon22-Apr-10 16:53
tmalbon22-Apr-10 16:53 
QuestionDraw a arrow on a line Pin
JR21218-Apr-10 21:20
JR21218-Apr-10 21:20 
AnswerRe: Draw a arrow on a line Pin
Dave Kreskowiak19-Apr-10 3:51
mveDave Kreskowiak19-Apr-10 3:51 
GeneralRe: Draw a arrow on a line Pin
JR21219-Apr-10 23:08
JR21219-Apr-10 23:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.