Welcome to PcCare.com
Epicor9 Concatinating text from multiple ado.net BAQReportResult records into single Crystal Reports field
An Epicor 9 Baq consisting of a parent table attached to multiple child tables results in detail section value repititions. By grouping the repeated data into a single text field, the report can display the correct number of detail records.
In the above baq, The jobHead parent table has two child tables, serial number and jobMtl. The data generated by the baq lists a separate BAQReportResult for each jobMtl coupled with multiple copies of each serial number.
Job 97 material sequence number 20 has separate records for each serial number, each of which appear separately. If the serial numbers are concatinated into a single crystal reports field, the report diplays a single row for each job material.
DISCLAIMER: It is assumed that users are familiar with the operating system they are using and comfortable with making the suggested changes. PcCare.com will not be held responsible if changes you make cause a system failure.
Please review our Terms of Service and Privacy statement before initiating service or using this site. Microsoft® and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. PcCare Site Map. About Us