August 4, 2013 at 3:36 pm
Hi All,
I have a report in development that every now and then expands a row to a height that stretches in hight by about 5 cm. Normal heigh is around 1cm. The strange thing is it doesn't do this all the time for all rows returned, it does it for a few records only in the report. Also each run of the report can give a different result. i.e. I can run the report once and the row grows, run a second time and for the same record it doesn't. Yet a different one might.
I have the row auto growth set to false and cannot think of anything else I can look at. Just wondering if anyone out there has come across this or has any suggestions?
Thank You
Eliza
August 5, 2013 at 6:26 am
Eliza,
Check to make sure each cell in the row has the Can Grow property set to false also.
Did you also check the source data to see if there are any carriage returns in a field?
August 11, 2013 at 1:46 pm
Does this report behaves differently for same records or differently when different records? Try using TRIM()
August 11, 2013 at 1:56 pm
Did you try using something like REPLACE(REPLACE(YourField,CHAR(10),''),CHAR(13),'') to modify the field from within the report query?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply