Cannot run financial report for mutiple domains with custom filter

RSS

» Cannot run financial report for mutiple domains with custom filter

1. User reports in builds 517 receiving an error message while running financial report for multiple domains with custom filter.

 Source: jProgBusiness - Object reference not set to an instance of an object.
   at jProgBusiness.jReports.jReportAreaSelector.CheckForJoinedTables(jSelectTable selectTable)
   at jProgBusiness.jReports.jReportAreaSelector.WeedOut()
   at jProgBusiness.jReports.jReportOperations.financialReportNOSSDetailNoProvider(jKeyLabelPair[] 
selectedDomains, DateTime beginDate, DateTime endDate, jFundingSource[] fundingSources, String loginToken, 
jReportFilter filter, Boolean receiptsInPeriodOnly)
   at jProgBusiness.jReports.jReportEngine.financialReport(String LoginToken, String DomainPK, String DomainName, 
jKeyLabelPair[] selectedDomains, DateTime beginDate, DateTime endDate, jFundingSource[] fundingSources, Boolean 
groupByProviders, Boolean includeSubserviceDetail, Boolean includeProviderDetail, String filterPK, Boolean receiptsInPeriodOnly)
   at jProgBusiness.jBusiness.jBusinessRemote.RPT_Financial_Report(String SessionToken, String DomainPK, String 
DomainName, jKeyLabelPair[] selectedDomains, DateTime beginDate, DateTime endDate, jFundingSource[] fundingSources, 
Boolean groupByProvider, Boolean includeSubserviceDetail, Boolean includeProviderDetail, String filterPK, Boolean receiptsInPeriodOnly)
An error occurred while creating the financial report.

2. Also if a custom field is used in the filter a different error occurs:

Source: jProgBusiness - The column prefix 'fb825e6caea6e41608d37c97312c01e0801' does not match with a table name 
or alias name used in the query.
   at jProgBusiness.jBusiness.jSQLDatasetFillHelper.jTableDescriptor.FillTable(DataSet TheDataset, IDbConnection 
Connection, Int32 XMLHandle, jReportSpecification reportSpecification, jKeyLabelPair[] domains)
   at jProgBusiness.jBusiness.jSQLDatasetFillHelper.FillDataset(jServiceManager ServiceManager, ConnectionType ConnectionType, 
Boolean closeConnectionAfterUse, jReportSpecification reportSpecification, jKeyLabelPair[] domains)
   at jProgBusiness.jReports.jReportEngine.financialReport(String LoginToken, String DomainPK, String DomainName, jKeyLabelPair[] 
selectedDomains, DateTime beginDate, DateTime endDate, jFundingSource[] fundingSources, Boolean groupByProviders, Boolean 
includeSubserviceDetail, Boolean includeProviderDetail, String filterPK, Boolean receiptsInPeriodOnly)
   at jProgBusiness.jBusiness.jBusinessRemote.RPT_Financial_Report(String SessionToken, String DomainPK, String DomainName, 
jKeyLabelPair[] selectedDomains, DateTime beginDate, DateTime endDate, jFundingSource[] fundingSources, Boolean groupByProvider, 
Boolean includeSubserviceDetail, Boolean includeProviderDetail, String filterPK, Boolean receiptsInPeriodOnly)
An error occurred while creating the financial report.

This bug was found in build	517
This bug was fixed in build	580
TTP #	1707

Back to Bugs

Back to Frequently Asked Questions