Query & controls

[elibb]

hi... im using Crystal Reports in a vb project, and im doing it like this:

CrystalReport1.SQLQueryString = mySqlQuery
Form1.Show

but it is not paying atention to my string, and its loading all the records from my database.. does anybody know why??

and another question..
i have a textbox, and a field box, but i only want them to appear when that field has something on it.. i want it invisible when the field = "", how can i control that??

thank you very much

Eli

 

[chelseatech]

To answer the second question, is the field a blank string or is it NULL?

Use a conditional suppress
IsNull({table.field}) Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[elibb]

mmm my problem is how do i refer to the field on the report??

does anybody know about the query?? please...


Eli

 

[elibb]

mm i solved the Null part.. but im still having problems with the query.. please help!!!!!

Eli

 

[Rupe]

Hmmm, have you tried setting a Record Selection Formula in your report?

Once you figure out what to put into your record selection formula you could do something like this:

Crpe1.Selection.Formula.Clear;
Crpe1.Selection.Formula.Add('Your selection criteria');

Sorry, that's the Delphi code - I don't know what the VB equivalent is.

Rupert

 

[CaptainD]

Try something like this to get the data from the text box to a string them in your select statement your "Where" condition would be Between "Date1" and "Date2"

Modified of course to fit your code.

Private Sub cmdDate_Click()
Dim date1 As String
Dim date2 As String

If Form1.txtDate1.Text <> &quot;&quot; Then
date1 = Form1.txtDate1.Text
Else: MsgBox &quot;Empty Field&quot;
End If
If Form1.txtDate2.Text <> &quot;&quot; Then
date2 = Form1.txtDate2.Text
Else: MsgBox &quot;Empty Field&quot;
End If

 

[CaptainD]

You may also need to do a &quot;CDate(Date1)&quot; to get it to work in you database otherwise you my get a type mismatch