Crystal grouping question

This worked - thank you!

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