Navigation¶

• FAQ
• Feature Explorer
• All CAREWare documentation
• All Pages
• Create Account
  

Show New Clients Only checkbox causes error

Source:  - An error occurred while attempting to run the custom report.
If the problem persists, please contact technical support.
Operand type clash: uniqueidentifier is incompatible with datetime
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, 
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, 
String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, 
CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at jProgBusiness.jBusiness.jSQLDatasetFillHelper.jTableDescriptor.doFirstPass(DataSet TheDataset, IDbConnection Connection, Int32 
XMLHandle, jReportSpecification reportSpecification, IDbDataAdapter adaptor, Int32 domainsHandle)
   at jProgBusiness.jBusiness.jSQLDatasetFillHelper.jTableDescriptor.processAggregateReport(DataSet TheDataset, IDbConnection Connection, 
Int32 XMLHandle, jReportSpecification reportSpecification, IDbDataAdapter adaptor, Int32 domainsHandle)
   at jProgBusiness.jReports.jCustomReportOperations.getCustomReport(String LoginToken, String ReportSpecPK, jKeyLabelPair[] Domains, 
Boolean showSharedServiceData, String ReportingYear, Boolean ShowNewClientsOnly, Boolean ShowSpecification, Boolean SumNumericFields, 
DateTime DateFrom, DateTime DateThrough, Boolean isCrosstab, Boolean showSharedClinicalData, Boolean enforceServiceRestriction, Boolean 
groupByProvider, jCustomReportPrimaryProvider primaryProvider, Boolean appendClientPK)
   at jProgBusiness.jBusiness.jBusinessRemote.CRO_Get_Custom_Report(String SessionToken, String ReportSpecPK, jKeyLabelPair[] Domains, 
Boolean showSharedServiceData, String ReportingYear, Boolean ShowNewClientsOnly, Boolean ShowSpecification, Boolean SumNumericFields, 
DateTime DateFrom, DateTime DateThrough, Boolean isCrosstab, Boolean showSharedClinicalData, Boolean groupByProvider, 
jCustomReportPrimaryProvider primaryProvider, Boolean appendClientPK)
Server stack trace:
   at jProgBusiness.jBusiness.jBusinessRemote.CRO_Get_Custom_Report(String SessionToken, String ReportSpecPK, jKeyLabelPair[] Domains, 
Boolean showSharedServiceData, String ReportingYear, Boolean ShowNewClientsOnly, Boolean ShowSpecification, Boolean SumNumericFields, 
DateTime DateFrom, DateTime DateThrough, Boolean isCrosstab, Boolean showSharedClinicalData, Boolean groupByProvider, 
jCustomReportPrimaryProvider primaryProvider, Boolean appendClientPK)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, 
Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, 
Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
   at jProgBusiness.jBusiness.jClientSideRemote.CRO_Get_Custom_Report(String SessionToken, String ReportSpecPK, jKeyLabelPair[] Domains, 
Boolean showSharedServiceData, String ReportingYear, Boolean ShowNewClientsOnly, Boolean ShowSpecification, Boolean SumNumericFields, 
DateTime DateFrom, DateTime DateThrough, Boolean isCrosstab, Boolean showSharedClinicalData, Boolean groupByProvider, 
jCustomReportPrimaryProvider primaryProvider, Boolean appendClientPK)
   at Client.CustomReportSetup.fetchReport()
An error occurred while attempting to run the custom report.