Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Rendering to PDF Triggers #Error messages Expand / Collapse
Author
Message
Posted Friday, April 25, 2014 9:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 25, 2014 4:20 PM
Points: 152, Visits: 448
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?
Post #1565149
Posted Friday, April 25, 2014 11:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:28 AM
Points: 268, Visits: 598
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
Post #1565202
Posted Friday, April 25, 2014 1:46 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 25, 2014 4:20 PM
Points: 152, Visits: 448
In my case there is no subreport in this design, so the "Keep Together" property fix does not seem applicable to my situation.
Post #1565240
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse