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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL expression field to avoid memo in formula
I have a VARCHAR2(366) field called TERM_TEXT in an Oracle Database that when it is displayed in Crystal Reports 8 is shown as a memo field. I want to write a formula find the number of occurances of the character "X" in this field. I've looked at previous answers to this problem and...- GaryFrost
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Totals of if statement formulas
My report consists of the following. I am using 3 tables : Schools, Pupils and Parents A School has many pupils an a pupil has 0,1or 2 parents The report looks as follows Group Header 1 Schools Group Header 2 Pupil Details Pupil details and Parent details @IsFather @IsMother Group Footer 2...- GaryFrost
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Crystal (from VB) & Windows 2000 problems
I have the following piece of VB code rptComp.ReportFileName = gsRptComparator rptComp.RetrieveDataFiles f = rptComp.PrintReport rptComp.ReportFileName = "" rtpComp is a Crystal Report ActiveX control on the form gsRptComparator is just a string variable containing...- GaryFrost
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 3 Integrate
-
OLEDB.4.0 vs OLEDB.3.51
I used to have code that looks like the following cnnConnection.Provider = "Microsoft.Jet.OLEDB.3.51" cnnConnection.Open gsDatabaseName lsSQL = "SELECT * FROM BLAH WHERE [Keyfield] = '" & lsSelectedKey & "' " rstRecSet.Open lsSQL, cnnConnection, adOpenDynamic...- GaryFrost
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
