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

 

<!-- #ygrps-yiv-405697330 _filtered #ygrps-yiv-405697330 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-405697330 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-405697330 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-405697330 {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-405697330 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-405697330 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-405697330 #ygrps-yiv-405697330 p.ygrps-yiv-405697330MsoNormal, #ygrps-yiv-405697330 li.ygrps-yiv-405697330MsoNormal, #ygrps-yiv-405697330 div.ygrps-yiv-405697330MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-405697330 a:link, #ygrps-yiv-405697330 span.ygrps-yiv-405697330MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-405697330 a:visited, #ygrps-yiv-405697330 span.ygrps-yiv-405697330MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-405697330 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-405697330 code
{
font-family:“Courier New”;}
#ygrps-yiv-405697330 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-405697330 tt
{
font-family:“Courier New”;}
#ygrps-yiv-405697330 span.ygrps-yiv-405697330cat
{}
#ygrps-yiv-405697330 span.ygrps-yiv-405697330ct
{}
#ygrps-yiv-405697330 span.ygrps-yiv-405697330HTMLPreformattedChar
{

font-family:“Consolas”, “serif”;}
#ygrps-yiv-405697330 p.ygrps-yiv-405697330attach, #ygrps-yiv-405697330 li.ygrps-yiv-405697330attach, #ygrps-yiv-405697330 div.ygrps-yiv-405697330attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-405697330 p.ygrps-yiv-405697330bold, #ygrps-yiv-405697330 li.ygrps-yiv-405697330bold, #ygrps-yiv-405697330 div.ygrps-yiv-405697330bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-405697330 p.ygrps-yiv-405697330green, #ygrps-yiv-405697330 li.ygrps-yiv-405697330green, #ygrps-yiv-405697330 div.ygrps-yiv-405697330green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-405697330 p.ygrps-yiv-405697330replbq, #ygrps-yiv-405697330 li.ygrps-yiv-405697330replbq, #ygrps-yiv-405697330 div.ygrps-yiv-405697330replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-405697330 p.ygrps-yiv-405697330ad, #ygrps-yiv-405697330 li.ygrps-yiv-405697330ad, #ygrps-yiv-405697330 div.ygrps-yiv-405697330ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-405697330 p.ygrps-yiv-405697330underline, #ygrps-yiv-405697330 li.ygrps-yiv-405697330underline, #ygrps-yiv-405697330 div.ygrps-yiv-405697330underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-405697330 span.ygrps-yiv-405697330yshortcuts
{}
#ygrps-yiv-405697330 p.ygrps-yiv-405697330ad1, #ygrps-yiv-405697330 li.ygrps-yiv-405697330ad1, #ygrps-yiv-405697330 div.ygrps-yiv-405697330ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-405697330 p.ygrps-yiv-405697330ad2, #ygrps-yiv-405697330 li.ygrps-yiv-405697330ad2, #ygrps-yiv-405697330 div.ygrps-yiv-405697330ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-405697330 p.ygrps-yiv-405697330underline1, #ygrps-yiv-405697330 li.ygrps-yiv-405697330underline1, #ygrps-yiv-405697330 div.ygrps-yiv-405697330underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-405697330 span.ygrps-yiv-405697330yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-405697330 span.ygrps-yiv-405697330yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-405697330 span.ygrps-yiv-405697330EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-405697330 .ygrps-yiv-405697330MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-405697330 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-405697330 div.ygrps-yiv-405697330WordSection1
{}
#ygrps-yiv-405697330
_filtered #ygrps-yiv-405697330 {
}
_filtered #ygrps-yiv-405697330 {

font-family:Symbol;}
_filtered #ygrps-yiv-405697330 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-405697330 {

font-family:Wingdings;}
_filtered #ygrps-yiv-405697330 {

font-family:Wingdings;}
_filtered #ygrps-yiv-405697330 {

font-family:Wingdings;}
_filtered #ygrps-yiv-405697330 {

font-family:Wingdings;}
_filtered #ygrps-yiv-405697330 {

font-family:Wingdings;}
_filtered #ygrps-yiv-405697330 {

font-family:Wingdings;}
_filtered #ygrps-yiv-405697330 {

font-family:Wingdings;}
#ygrps-yiv-405697330 ol
{margin-bottom:0in;}
#ygrps-yiv-405697330 ul
{margin-bottom:0in;}
–>

Bring up your crystal form drop down menu Database/Database Expert then the LINKS tab double click on the link between ShipDtl and Serial Number Table and make sure it’s an Outer Join.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, June 23, 2014 09:11
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