Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select Distinct in Subreport not working in VB

Status
Not open for further replies.
marabou

marabou

IS-IT--Management
Jan 12, 2001
86
GB
Hi
I have a report which runs nicely in vb, but have recently been asked to change the subreport within it, so as to only display distinct values within the subreport.

Having done this from the menu option in crystal I get everything displayed as it should be if I view the report in Crystal. However, calling the report from VB makes the SELECT DISTINCT not work. Please help, I have a deadline here and I'm completely stuck.

Thanks in advance
 
Status
Not open for further replies.

Similar threads

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
149
SoftwareRT
SoftwareRT
K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
210
hilfy
hilfy
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
260
hilfy
hilfy
socalvelo
  • Locked
  • Question
Mouse Clicks not Working in Sections Area
Replies
2
Views
214
socalvelo
socalvelo
VHDN
  • Locked
  • Question
Using Special File in Command
Replies
5
Views
184
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top