We have configured our Order Entry to display in the Line Description field on the acknowledgement form the details of the order. At times the display prints perfectly fine, but other times everything comes out jumbled up. Is there a fix for this?
Can you post screenshot examples of what you are seeing? Assuming this is SSRS not Crystal?
Yes this SSRS. The attached image displays it all jumbled up. It is hit or miss with it printing the form correctly
How is the design organized can you post a screenshot of what the template editor looks like and what a printed copy should look like?
We have created a lookup UD Method with the following code:
// Enter valid C# code. This method does not require a return value.
TrailerDesc = String.Empty;
TrailerDet = String.Empty;
var TrailerInfo = (from r in Db.UD32 where r.Company == Context.CompanyID
&& r.Key1 == Key1
&& r.Key2 == Key2
&& r.Key4 == Key4
select r).FirstOrDefault();
if(TrailerInfo != null)
{
if (Inputs.TrailerModelPrice.Value == Inputs.TrailerModelUnitPrice.Value)
{
TrailerDesc =
String.Format("{0,-30}\n\t{1,-25}","Trailer Model:", Inputs.TrailerModel.Value) +
String.Format("{0,20}{1,20}{2,20:C}","....................","....................","$"+Inputs.TrailerModelPrice.Value);
}
else
{
TrailerDesc =
String.Format("{0,-30}\n\t{1,-25}","Trailer Model:", Inputs.TrailerModel.Value) +
String.Format("{0,20}{1,-10:C}{2,12}{3,18:C}","....................","$"+Inputs.TrailerModelUnitPrice.Value,"-"+Inputs.TADiscPercent.Value+"%","="+"$"+Inputs.TrailerModelPrice.Value);
};
TrailerDet =
"\n" + "Trailer Details: " + "\n" +
TrailerInfo.Character01;
};
Brakes = String.Empty;
ALWheel = String.Empty;
SpareTire = String.Empty;
STMount = String.Empty;
Decal = String.Empty;
Tritoon = String.Empty;
//Brake Lookup
if (Inputs.BrakeCheckBox.Value == true)
{
if (Inputs.BrakePrice.Value == Inputs.BrakeUnitPrice.Value)
{
Brakes = String.Format("\n{0,-30}\n\t{1,-25}","* Brakes Upgrade", Inputs.BrakePartNum.Value) +
String.Format("{0,20}{1,20}{2,20:C}","....................","....................",Inputs.BrakePrice.Value);
}
else
{
Brakes = String.Format("\n{0,-30}\n\t{1,-15}","* Brakes Upgrade", Inputs.BrakePartNum.Value) +
String.Format("{0,16}{1,15}{2,-10:C}{3,11}{4,18:C}","................","...............",Inputs.BrakeUnitPrice.Value,"-"+Inputs.TADiscPercent.Value+"%","="+"$"+Inputs.BrakePrice.Value);
};
}
else
{
Brakes = string.Empty;
};
//Alum Wheel Upgrade Lookup
if (Inputs.AlumUpgrd.Value == true
&& TrailerInfo.Character03 != "10E")
{
if (Inputs.WheelPrice.Value == Inputs.WheelUnitPrice.Value)
{
ALWheel = String.Format("\n{0,-30}\n\t{1,-25}","* Aluminum Wheel Upgrade", Inputs.AlumPartNum.Value) +
String.Format("{0,20}{1,20}{2,20:C}","....................","....................",Inputs.WheelPrice.Value);
}
else
{
ALWheel = String.Format("\n{0,-30}\n\t{1,-15}","* Aluminum Wheel Upgrade", Inputs.AlumPartNum.Value) +
String.Format("{0,16}{1,15}{2,-10:C}{3,11}{4,18:C}","................","...............",Inputs.WheelUnitPrice.Value,"-"+Inputs.TADiscPercent.Value+"%","="+"$"+Inputs.WheelPrice.Value);
};
}
else
{
ALWheel = string.Empty;
};
//Spare tire Lookup
if (Inputs.SpareTire.Value == true)
{
if (Inputs.SpareTirePrice.Value == Inputs.SpareTireUnitPrice.Value)
{
SpareTire = String.Format("\n{0,-30}\n\t{1,-25}","* Spare Tire", Inputs.SpareTirePartNum.Value) +
String.Format("{0,20}{1,20}{2,20:C}","....................","....................",Inputs.SpareTirePrice.Value);
}
else
{
SpareTire = String.Format("\n{0,-30}\n\t{1,-15}","* Spare Tire", Inputs.SpareTirePartNum.Value) +
String.Format("{0,16}{1,15}{2,-10:C}{3,11}{4,18:C}","................","...............",Inputs.SpareTireUnitPrice.Value,"-"+Inputs.TADiscPercent.Value+"%","="+"$"+Inputs.SpareTirePrice.Value);
};
}
else
{
SpareTire = string.Empty;
};
//Spare Tire Mount Lookup
if (Inputs.STMount.Value == true)
{
if (Inputs.STMountPrice.Value == Inputs.STMountUnitPrice.Value)
{
STMount = String.Format("\n{0,-30}\n\t{1,-25}","* Spare Tire Mount", Inputs.STMountPartNum.Value) +
String.Format("{0,20}{1,20}{2,20:C}","....................","....................",Inputs.STMountPrice.Value);
}
else
{
STMount = String.Format("\n{0,-30}\n\t{1,-15}","* Spare Tire Mount", Inputs.STMountPartNum.Value) +
String.Format("{0,16}{1,15}{2,-10:C}{3,11}{4,18:C}","................","...............",Inputs.STMountUnitPrice.Value,"-"+Inputs.TADiscPercent.Value+"%","="+"$"+Inputs.STMountPrice.Value);
};
}
else
{
STMount = string.Empty;
};
//Decal Lookup
if (Inputs.DecalOption.Value == "2")
{
if (Inputs.DecalPrice.Value == Inputs.DecalUnitPrice.Value)
{
Decal = String.Format("\n{0,-30}\n\t{1,-25}","* Dealer Decal", Inputs.DecalPartNum.Value) +
String.Format("{0,20}{1,20}{2,20:C}","....................","....................",Inputs.DecalPrice.Value);
}
else
{
Decal = String.Format("\n{0,-30}\n\t{1,-15}","* Dealer Decal", Inputs.DecalPartNum.Value) +
String.Format("{0,16}{1,15}{2,-10:C}{3,11}{4,18:C}","................","...............",Inputs.DecalUnitPrice.Value,"-"+Inputs.TADiscPercent.Value+"%","="+"$"+Inputs.DecalPrice.Value);
};
}
else
{
Decal = string.Empty;
};
//Tritoon Lookup
if (Inputs.TritoonUpgrd.Value == true)
{
if (Inputs.TritoonUpgrdPrice.Value == Inputs.TritoonUpgrdUnitPrice.Value)
{
Tritoon = String.Format("\n{0,-30}\n\t{1,-25}","* Tritoon", Inputs.TritoonPartNum.Value) +
String.Format("{0,20}{1,20}{2,20:C}","....................","....................",Inputs.TritoonUpgrdPrice.Value);
}
else
{
Tritoon = String.Format("\n{0,-30}\n\t{1,-15}","* Tritoon", Inputs.TritoonPartNum.Value) +
String.Format("{0,16}{1,15}{2,-10:C}{3,11}{4,18:C}","................","...............",Inputs.TritoonUpgrdUnitPrice.Value,"-"+Inputs.TADiscPercent.Value+"%","="+"$"+Inputs.TritoonUpgrdPrice.Value);
};
}
else
{
Tritoon = string.Empty;
};
You may want to consider adding the ‘Trailer Details’ into the sales order comments, that is how we show our customers the pricing breakdown of options selected.