if isnull({tlb1.IN2}) then
{tlb1.CN} & "-" & {tlb1.IN}
else
{tlb1.CN} & "-" & {tlb1.IN2}
CN, IN and IN2 are all numbers.
When I do the preview they show up as 1001-12345 or 1001-101 now when I put it on the web and and go to the page it shows up as 1,001.00-12,345.00 or 1,001.00-101.00. I do not know where to format this. When I just add the field to the report I can tell it how to display the number but when I do it as a string it formats it different in both sections. I want it to show up as 1001-12345 or 1001-101
Thanks ahead of time.