You're not doing any joining on the S/N field, are you? Perhaps write a Formula on the S/N field and use the formula in your report instead of the raw field.Â
Something like:
IF {SERIAL NUMBER} <> "" THEN {SERIAL NUMBER} ELSE "NO S/N"
This way, you'll always have "something" in that field. Feel free to email me directly your XML and RPT and I'll take a looksee.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, June 23, 2014 10:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal grouping question
I have built a BAQ report to print conformance certifications. One of the report results is the serial number. Not all of the shipdtl lines coming down will have a serial number. My problem is this- I can see in Crystal that all the detail lines are coming down properly whether they have a serial number or not. But when I pull the data into the report, the only lines that will print are the ones that have a serial number.
I am grouping my report by pack number and pack line. Any ideas - is my grouping wrong?
Thanks-
Pat