Hi
I created and additional table in the RMS database to store additional info about the customers. Named it "CustomerAuxiliary". I'm trying to use the RMS Active Report on that table but I keep getting an error message right after the filter screen is displayed.
The error is: The Report Data could not be loaded due to the following error (-2147217900) Incorrect syntax near 'SELECT'
I started with a customer list report and modified it for the new table:
//--- Report Summary --- //
Begin ReportSummary ReportType = reportypeMemorized ReportTitle = "Simple CustomerAuxiliary List" PageOrientation = pageorientationLandscape WordWrap = False ShowDateTimePicker = False OutLineMode = True Groups = 0 GroupDescription = "Total" DisplayLogo = True LogoFileName = "MyLogo.bmp" ProcedureCall = "" TablesQueried = "FROM CustomerAuxiliary WITH(NOLOCK)" SelCriteria = "" GroupBy = "" SortOrder = "" End ReportSummary
//--- Title Rows ---//
Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 16 Color = "Blue" End TitleRow
Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 12 Color = "Black" End TitleRow
Begin TitleRow Text = "As Of: " Font = "Arial" FontBold = True FontSize = 10 Color = "Black" End TitleRow
//--- Filters ---//
//--- Columns ---//
Begin Column FieldName "CustomerAuxiliary.SBFAccountNumber" DrillDownFieldName = "" DrillDownReportName = "" Title = "SBFAccountNumber" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1395 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName "CustomerAuxiliary.PrimaryTreatment" DrillDownFieldName = "" DrillDownReportName = "" Title = "Primary Treatment" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1395 GroupMethod = groupmethodNone ColFormat = "" End Column
Begin Column FieldName = "CustomerAuxiliary.DateOfExam" DrillDownFieldName = "" DrillDownReportName = "" Title = "Date Of Exam" VBDataType = vbDate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 915 GroupMethod = groupmethodNone ColFormat = "" End Column
Any ideas would be appreciated