Mailing Label report generates error when run with a date span

RSS

» Mailing Label report generates error when run with a date span

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 build	594
This bug was fixed in build	#
TTP #	1927

Back to Bugs

Back to Frequently Asked Questions

jProg is a registered trademark of Jeff Murray's Programming Shop, Inc. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to JeffMurray@jprog.com.