June 11, 2014 at 8:30 am
We have run into a problem with a data driven subscription. The end user has a requirement that states when a metric is at 100%, they need to see four decimals like: 100.0000%. And if the score is less than 100, they want to see fourteen decimals like this: 98.59843590198127%.
To meet this requirement, we have added this expression:
=Format(Last(Fields!MonthlyServiceAvail.Value, "DataSet1")*100, "#.0000##########")& "%"
The report is saved as PDF. This works fine when we run the report in Visual Studio, and export to PDF. It also works when we manually run the report on the web server. The problem occurs when we schedule a data driven subscription, and have it save the PDF files to a network folder. When using the subscription, the value 100.0000% appears as .0000% (the 100 before the decimal is cut off).
We have already tried making the font smaller, and increasing the size of the field to a huge amount just to see if the number was being hidden / wrapped, or something else. It just isn’t there when this report is called from a subscription.
Can anyone think of a reason (and hopefully a solution) to why this renders differently from a subscription?
thank you
June 11, 2014 at 10:22 am
Sounds like an issue because the report is initially rendering to pdf when running the subscription instead of rendering to html and then exporting to pdf as in VS. What happens if you use url rendering to render directly to pdf like this:
http://server/ReportServer?ReportPath/ReportName&rs:Format=PDF&rs:Command=Render&Parameter1=1&Parameter2=2
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply