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...
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...
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?
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...
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...
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.
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???
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.