Click here to Skip to main content
15,900,258 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Generalsending email Pin
Cristian_Dior22-Jul-03 1:00
Cristian_Dior22-Jul-03 1:00 
GeneralRe: sending email Pin
Cristian_Dior22-Jul-03 2:37
Cristian_Dior22-Jul-03 2:37 
GeneralCrystal Reports Pin
Emile Jacobs21-Jul-03 2:35
Emile Jacobs21-Jul-03 2:35 
GeneralRe: Crystal Reports Pin
Ian Darling21-Jul-03 2:44
Ian Darling21-Jul-03 2:44 
GeneralRe: Crystal Reports Pin
Martin Gibson29-Jul-03 13:04
Martin Gibson29-Jul-03 13:04 
GeneralRe: Crystal Reports Pin
Nic Rowan22-Jul-03 3:10
Nic Rowan22-Jul-03 3:10 
GeneralRe: Crystal Reports Pin
Emile Jacobs22-Jul-03 3:18
Emile Jacobs22-Jul-03 3:18 
GeneralRe: Crystal Reports Pin
Nic Rowan22-Jul-03 3:32
Nic Rowan22-Jul-03 3:32 
Ohhh ok so you're having a problem with you're SQL statements. The way I use crystal is that I point to a stored proc on my SQL database and pass the parameters to the stored proc. I'm guessing you're building the SQL statement in the crystal report itself. You're going to have to make a parameter and pass that to your SQL statement:

e.g.


CREATE PROCEDURE spGetUsers<br />
@Letter VARCHAR(1)<br />
<br />
AS <br />
<br />
SELECT [Columns] FROM [Users] WHERE[Surname] LIKE @Letter + '%'


Should work - You just have to pass that @Letter varchar to the statement.

Hope this helps - if you need any more help just ask. Isn't there a lecturer at Tukkies? Smile | :)



Beware the chickens, for in their silence, they plot...


Life is too short to be taken seriously.
-- Oscar Wilde



Generalshuffle cards Pin
Gozorr20-Jul-03 16:18
Gozorr20-Jul-03 16:18 
GeneralRe: shuffle cards Pin
Ian Darling21-Jul-03 2:36
Ian Darling21-Jul-03 2:36 
GeneralRenaming a file Pin
Anonymous20-Jul-03 16:02
Anonymous20-Jul-03 16:02 
GeneralRe: Renaming a file Pin
Heath Stewart21-Jul-03 3:01
protectorHeath Stewart21-Jul-03 3:01 
Question&quot;Find a phrase&quot; and display it. How to?? Pin
Anonymous20-Jul-03 1:23
Anonymous20-Jul-03 1:23 
AnswerRe: &quot;Find a phrase&quot; and display it. How to?? Pin
Nick Seng20-Jul-03 16:02
Nick Seng20-Jul-03 16:02 
GeneralCalling convention Pin
Abel18-Jul-03 4:46
Abel18-Jul-03 4:46 
GeneralRe: Calling convention Pin
Nick Seng20-Jul-03 15:59
Nick Seng20-Jul-03 15:59 
GeneralRe: Calling convention Pin
Abel20-Jul-03 20:52
Abel20-Jul-03 20:52 
Generalvb.net ListBox Click Pin
Lyle Hunt17-Jul-03 22:41
Lyle Hunt17-Jul-03 22:41 
GeneralRe: vb.net ListBox Click Pin
Nic Rowan22-Jul-03 3:42
Nic Rowan22-Jul-03 3:42 
QuestionHow to test for Path Too Long? Pin
JWhizzz17-Jul-03 17:00
JWhizzz17-Jul-03 17:00 
AnswerRe: How to test for Path Too Long? Pin
Garth J Lancaster17-Jul-03 17:42
professionalGarth J Lancaster17-Jul-03 17:42 
GeneralGet folder and filename in CD ROM Pin
Hoang Dung17-Jul-03 7:29
Hoang Dung17-Jul-03 7:29 
GeneralRe: Get folder and filename in CD ROM Pin
Wayne Phipps17-Jul-03 8:35
Wayne Phipps17-Jul-03 8:35 
GeneralRe: Get folder and filename in CD ROM Pin
Hoang Dung21-Jul-03 18:45
Hoang Dung21-Jul-03 18:45 
QuestionRun VB app without .NET installed? Pin
jpg000217-Jul-03 5:04
professionaljpg000217-Jul-03 5:04 

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.