Mailing Label report generates error when run with a date span

Modified on Mon, 26 Mar 2012 11:07 by CAREWare Help Desk — Categorized as: FAQ

When trying to run a mailing list report with clients served in a date span the following error is generated: 

Source: jProgBusiness - Invalid column name 'cln_pk'.   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.mailingLabelReport(String LoginToken, String DomainPK, jKeyLabelPair 
selectedDomain, Boolean allClients, Boolean allActive, Boolean notCaseClosed, Boolean serviceBetween, 
DateTime dateFrom, DateTime dateThrough, Boolean addressesOnly, Boolean sortByName, Boolean hidePIIFields, String filterPK)   
at jProgBusiness.jBusiness.jBusinessRemote.RPT_Mailing_Label_Report(String SessionToken, String DomainPK, jKeyLabelPair 
selectedDomain, Boolean allClients, Boolean allActive, Boolean notCaseClosed, Boolean serviceBetween, DateTime dateFrom, 
DateTime dateThrough, Boolean addressesOnly, 
Boolean sortByName, Boolean hidePIIFields, String filterPK)
An error occurred while compiling the mailing label report.

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

Back to Bugs

Back to Frequently Asked Questions