asked on compare two fields slightly different
Ok, in one table I have the route numbers 03, 04, 05, 06 and so on. In the other table those route start with a 1 so it would be 103, 104, 105, 106 and so on. How would I set it up so that 03 would recognize 103 as the same driver?
Crystal Reports
Last Comment
Jared_S
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
One other possible suggestion is you bring the data from one table into the report and write a formula against it so that it matches the format of the field from the other table. Then, use the other table in a subreport and link the main and sub from the formula to the field in the subreport. Please note, you generally only want to do this with a subeport in a group, page or report header/footer - not in a detail section, if you can help it.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I am getting this error now
The data types varchar and char are incompatible in the '&' operator.
How do I fix that? I'm using
ON '1' & INVW.Warehouse COLLATE DATABASE_DEFAULT = BTWarehouseHistory.RouteNo
The data types varchar and char are incompatible in the '&' operator.
How do I fix that? I'm using
ON '1' & INVW.Warehouse COLLATE DATABASE_DEFAULT = BTWarehouseHistory.RouteNo
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.