I have a report with trend showing water production, this report had been working fine until there is request to change the timescale from Auto to calculated using script (just simple select case statement). However due to issue with the trend being unreadable (the lines were jumbled up - see attached ) I decided to change it back to Auto.
In visual studio, I can preview with actual data everything looks fine but when I deploy to live system, the jumbled lines are still there.
The only way I could fix it is by uploading a very old rdl to replace the report in live system, but I need to implement the current version which has other changes.
Has anyone encountered this? How do you go about fixing the issue?
thanks - Asumu