Some of the fields are look ups and I ended up having the ID instead of the actual data in the print preview
For example:
CategoryName = Truck
but instead of a Truck showing I got 1 (since 1 is the ID in the table where Truck is)!
Too bad for printing
The solution I found was very simple:
If 1 is showing instead of TRUCK then the Print Preview code is like this:
Code: Select all
<%%VALUE(CategoryName)%%>
Code: Select all
<%%COMBOTEXT(CategoryName)%%>