Reporting Services 2008 R2 Export to PDF changes No Rows font
Hi All,
I have a perplexing problem. I have just converted a SSRS 2005 report to SSRS 2008 R2 and inside this report is a subreport that has a message set for the No Rows property as "No Data" in Verdana, 7pt, Red, Bold.
This comes up exactly as expected when rendered in Report Manager and also when exported to Excel, Word and MHTML, i.e. it's Verdana, red, 7pt and bold but when exported to PDF or Tif the No Rows text is turned into black and normal.
There is another section of the same table the subreport is in that also has No Rows text set and this exports just fine in exactly the same form as was set.
This works fine in SSRS 2005 so what needs tweaking in order for me to get this sorted.
Thanks
Jonathon
I have a perplexing problem. I have just converted a SSRS 2005 report to SSRS 2008 R2 and inside this report is a subreport that has a message set for the No Rows property as "No Data" in Verdana, 7pt, Red, Bold.
This comes up exactly as expected when rendered in Report Manager and also when exported to Excel, Word and MHTML, i.e. it's Verdana, red, 7pt and bold but when exported to PDF or Tif the No Rows text is turned into black and normal.
There is another section of the same table the subreport is in that also has No Rows text set and this exports just fine in exactly the same form as was set.
This works fine in SSRS 2005 so what needs tweaking in order for me to get this sorted.
Thanks
Jonathon
ASKER
Thanks Mez, we are already service packed, went on the connect site and a similar issue had already been marked as a bug but Microsoft closed it because they couldn't reproduce it.
The original description didn't mention a sub report, it looks like thats the problem, I have reopened it with the extra information the original bug lacked, I'm not holding my breath waiting for a response though.
However I may have a workaround if only I can count the records from the subreport and feed that to another cell in the same table, do you know how to count the records returned in a subreport? That way I can put the required text in a text box and hide the subreport.
The original description didn't mention a sub report, it looks like thats the problem, I have reopened it with the extra information the original bug lacked, I'm not holding my breath waiting for a response though.
However I may have a workaround if only I can count the records from the subreport and feed that to another cell in the same table, do you know how to count the records returned in a subreport? That way I can put the required text in a text box and hide the subreport.
Dont think you can count the data rows in a subreport.
You could copy the dataset/report Table from subreport into your main report and see if Export works. A subreport is just another report linked into a Main report.
You could copy the dataset/report Table from subreport into your main report and see if Export works. A subreport is just another report linked into a Main report.
ASKER
Going to give that a try, but I may have to resort to adding a field in the main report dataset to count the number of rows in the subreport. Then I will add a new row with the required text and hide/show this row and the sub report accordingly. Will let you know how it gets on.
If the Export works after removing the subreport and including its components into Main report, then you have a potential work around and will know that the pdf export problem occurs only with subreports.
If I understand your idea correctly, adding a new row to display 'No Data' based on new row count and then hiding the subreport row sounds like a secondary solution until you know for sure that pdf export problem is only related to subreports.
If I understand your idea correctly, adding a new row to display 'No Data' based on new row count and then hiding the subreport row sounds like a secondary solution until you know for sure that pdf export problem is only related to subreports.
ASKER
I've tested it and export only affects subreports and it only affects PDF and TIF, have had to get on with the other reports but I am returning to this soon, I will let you know how it gets on.
Thanks
Thanks
mm, good to know.
I use subreports alot but I havent seen any color mismatches when exporting. I do see differences when exporting PDFs with page breaks compared to browser view though so the export isnt exact all the time.
I use subreports alot but I havent seen any color mismatches when exporting. I do see differences when exporting PDFs with page breaks compared to browser view though so the export isnt exact all the time.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Best workaround I could come up with.
http://www.microsoft.com/en-us/download/details.aspx?id=30437#overview
If that doesnt do it, I would post a problem on MS Connect and report as a Bug.
http://connect.microsoft.com/SQLServer