This is what appears in the comment dialog box. The dimension contains a single quote.
GetComment() - Unclosed quotation mark after the character string ''. Incorrect syntax near 's'.; SQL: SELECT Comment FROM ReportComment WHERE ReportId = '344' AND Tupple like '![PendCodes!].![Pend Flag!].&![Pends!], ![PendCodes!].![Pend Descr!].![All!], ![PendCodes!].![Pend Descr!].&![Auth is New; Refer to Med Services!], ![PendCodes!].![Pend Descr!].&![By Report!], ![PendCodes!].![Pend Descr!].&![Default Benefit - Hold for Configuration!], ![PendCodes!].![Pend Descr!].&![Electronic Claim; review!], ![PendCodes!].![Pend Descr!].&![Hold for examiners review!], ![PendCodes!].![Pend Descr!].&![Hold for Supervisor review!], ![PendCodes!].![Pend Descr!].&![Medical Director's Review!], ![PendCodes!].![Pend Descr!].&![Medical Records needed for review!], ![PendCodes!].![Pend Descr!].&![Not authorized to Approve based on user's approval limit!], ![PendCodes!].![Pend Descr!].&![Pend EDI- Claim Detail Line Issue!], ![PendCodes!].![Pend Descr!].&![Pend EDI- Claim Header Issue!], ![PendCodes!].![Pend Descr!].&![Pend EDI- Member Issue!], ![PendCodes!].![Pend Descr!].&![Pend EDI- Prov Hospital Matching Issue!], ![PendCodes!].![Pend Descr!].&![Pend for Checkrun processing!], ![PendCodes!].![Pend Descr!].&![Provider Ineligible!], ![PendCodes!].![Pend Descr!].&![Provider Pend!], ![PendCodes!].![Pend Descr!].&![Referral or Authorization not on file for these services!], ![PendCodes!].![Pend Descr!].&![Referred to CCS, poss eligibility!], ![PendCodes!].![Pend Descr!].&![Visits or Days Exceed Referral/Auth Visits or Days!], ![ClaimType!].![ClaimType!].![All!], ![LOB!].![LOB Xpress!].![All!], ![PendCodes!].![Pend Code Descr!].![All!], ![RunDate!].![Date Name!].&![2010/09/18!], ![Measures!].![Total Claims!]' ESCAPE '!'
Report Portal
Cell Comment
Posted - 09/28/2010 : 12:40:16
