Master Report can be saved anywhere in the package. We need to save "Patient Visit Analysis Report - Detail" report under _lib_dir_ with name "visit_detail".

REPORT DOES NOT WORK, Getting the following error:

QE-DEF-0030

Expression parsing error.

Details

QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[ICD Group Name]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Encounter ID]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Patient Account Number]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Patient Name]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Encounter Date]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[ICD Group Delete Flag]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Visit Status]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Visit Type]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Appointment Provider Name]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Facility Name]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[ICD-9 Code]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[ICD Group Name]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Facility Name]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Encounter ID]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Patient Account Number]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Patient Name]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[ICD-9 Code]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Appointment Provider Name]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Encounter Date]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[ICD Group Name]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Visit Status]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[Visit Type]' that does not exist. QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[Diagnosis Rx Reporting].[Diagnosis Object With ICD Codes Group].[ICD Group Delete Flag]' that does not exist. RSV-SRV-0042 Trace back: RSReportService.cpp(747): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(217): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_Request RSASyncExecutionThread.cpp(690): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(204): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_Request RSASyncExecutionThread.cpp(740): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_Request RSQueryMgr.cpp(1475): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1462): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1437): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQFSession.cpp(186): QFException: CCL_RETHROW: RSQFSession::DoRequest QFSSession.cpp(604): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(602): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(551): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(788): QFException: CCL_RETHROW: QFSConnection::GetParameters QFSQuery.cpp(273): QFException: CCL_RETHROW: QFSQuery::GetParameters CoordinationQFSQuery.cpp(4045): QFException: CCL_THROW: CoordinationQFSQuery::RectifyMandatoryParameters

Hi,

Iam also facing same issue , please let me know if you had fixed this issue.

ravisankaru@sify.com

The new updated Xml has been uploaded here. This will be available as a canned report also in eBO V5 as well.

Will this report be compatible with MS SQL? When I run it I get an error: request.[Microsoft][ODBC SQL Server Driver][SQL Server]Operand data type varchar is invalid for sum operator. This is usually a issue with sql compatibality between My sql and MS sql.

The error is only in MainQuery1 and when I remove the 'total(Group 1)' data item I am able to run the report. Hope that helps. Otherwise, the report looks great! I plan to use the ICD 9 data in a report i am currently working on. I hope you plan to expose this the metadata in v 5.0 :)