April 25, 2014 at 9:34 am
I have a report that looks fine when it is rendered in the browser, but when it is exported to PDF three of the numeric values in the report come out as #Error on all but the first page of the output. Curiously, the aggregated values of the same three values in the tablix footer row are fine. It is only the (Details) section values that have #Error beside them.
These values are based on calculated fields that were added to SSRS dataset and not part of the underlying query. I would blame it on this fact, but becasue the aggregated values of the same calculated fields work fine, that doesn't make sense. Nor does it make sense to me that the first page is rendered correctly but the rest of the pages have the #Error.
Has anyone else experienced unusual behavior like this when exporting to PDF?
April 25, 2014 at 11:35 am
Here's one solution I found:
On the subreport properties in the main report, there is a KeepTogether property that is set to false by default.
Once I changed that to true on all instances, everything works like a charm. Makes no sense to me, but its over and done with!
http://www.experts-exchange.com/Database/Reporting/Q_24343549.html
April 25, 2014 at 1:46 pm
In my case there is no subreport in this design, so the "Keep Together" property fix does not seem applicable to my situation.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply