Thursday, June 07, 2012 8:19 AM
In a table on my report I have predefined rows and columns and for each cell I use the LOOKUP function to bring back specific data from a dataset which corresponds to that row and column.
When the report is run and viewed using the report viewer the table shows correct values but surprisingly when converted to PDF the values change to '#ERROR'. Does anyone know any workaround?
Saturday, June 09, 2012 7:50 AMModerator
Based on your scenario, if you create the report in Report Designer in Business Intelligence Development Studio, I suggest that you also try to export the report to PDF format from Report Designer or report manager.
Meanwhile, I suggest update the ReportViewer and your Reporting Services with SQL Server updates. You can find the download information from the links below:
Hope this helps.
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Wednesday, June 13, 2012 12:57 PM