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!

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

Search results for query: *

  • Users: jrs11
  • Order by date
  1. jrs11

    Problem when using NT AUthentication

    I have a small system that is written with a VB 6.0 front end which accesses Crstal. The database used is SQLServer 7.0. The sytem works fine with the ODBC data source specifies SQL server authentication. However, when we try to switch to NT authentication, the system blows up when it tries...
  2. jrs11

    Crystal Reports with VB 6 and SQLSERVER 7 - blow up

    I have a small system that is written with a VB 6.0 front end which accesses Crstal. The database used is SQLServer 7.0. The sytem works fine with the ODBC data source specifies SQL server authentication. However, when we try to switch to NT authentication, the system blows up when it tries...
  3. jrs11

    Display not found message in crystal

    I can get the not found message to conditionally suppress when not isnull, but I cannot get it to print out when isnull condition is met. I just get a blank report...no sections show up at all. What am I missing?
  4. jrs11

    Display not found message in crystal

    Hi..I have a small problem that I assume can be easily fised. I have a vb front end which passes parms to crystal and retrieves data. However...if data not found the crystal report shows up blank, which is correct, but my users want to have a message printed out. I know I can change the vb...
  5. jrs11

    Crystal report formula

    "({@fSSN}) = '0123456789'" is what is contained in the sCriteria before it is passed to cr
  6. jrs11

    Crystal report formula

    here is the vb code I use to pass to CR sCriteria = "" For i = 0 To gResults.ListCount - 1 If gResults.Selected(i) Then sCriteria = sCriteria & "({@fSSN}) = '" & Left(gResults.List(i), 10) & "' or " End If Next sCriteria = Left(sCriteria...
  7. jrs11

    Crystal report formula

    Formula is a very simple field: {T_Emp_Basic_Info.SSNO} Using selectionformula code in VB to pass social security number to CR However....this process scans the whole table versus when a parameter prompt is used in CR, I get a direct hit.
  8. jrs11

    Crystal report formula

    Hi. I am having trouble getting a formula to work via ASP to crystal. I am passing a parameter, but when the parameter is passed it scans the whole SQLServer table verus a direct hit on the keyed field. Any suggestions???

Part and Inventory Search

Back
Top