Error generated when creating Mailing List report (582-584)

RSS

» Error generated when creating Mailing List report (582-584)

When trying to run a Mailing List report from within a Provider domain, if you select a date span for the report get this error:

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.

When other criteria are selected instead of date span, the report appears but is blank -- no labels.

This bug was found in build	582
This bug was fixed in build	#
TTP #	1914

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.