Referrals by Category generates error on custom reports

Modified on Tue, 21 May 2013 09:40 by CAREWare Help Desk — Categorized as: FAQ

Referrals by Category generates error on custom referral report type. Error occurs when added to filter. The field will work as a field selection. Error being generated is: 

Conversion from type 'jReportFilterCriterion' to type 'String' is not valid. at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value) 
at jMultiTier.jReportMultiTier.jReportFilterCriterion.createAndAddStringParameter(Object value) 
at jMultiTier.jReportMultiTier.jReportCritReferralsByCategory.SQLCalculation(String piiTableName) 
at jProgBusiness.jBusiness.jSQLSelectHelper.jWhereOrHavingSection.get_SQLPart() at jProgBusiness.jBusiness.jSQLSelectHelper.WhereClause() 
at jProgBusiness.jBusiness.jSQLSelectHelper.firstPassCommand(IDbConnection Connection, Int32 XMLHandle) 
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)

This bug was found in build594
This bug was fixed in build#
TTP #1972

Back to Bugs

Back to Frequently Asked Questions