Navigation¶

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

Crosstab report with custom field filter generates error when run with no date span

Source:  - An error occurred while attempting to run the custom report.

If the problem persists, please contact technical support.
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
   at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value)
   at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value)
   at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb)
   at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
   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.tempTableProcessing(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, Boolean hidePIIFields)
   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, Boolean hidePIIFields)

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, Boolean hidePIIFields)
   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.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, Boolean hidePIIFields)
   at Client.CustomReportSetup.fetchReport()
An error occurred while attempting to run the custom report.