Have Geek Brain

Reporting Services Implementation

I am using VS.NET 2005 and SQL Server 2005 . My development computer is running Windows XP SP2 . SQL Server 2005 and Reporting Services run on Windows 2003 .

My business requirement is to design and deploy a report that contains rich text ( RTF ) stored in the database ( datatype = TEXT ) and converts it to a runtime image using a custom assembly (source can be found here http: // blogs .digineer.com / blogs / jasons / archive / 2006/10/03 / 520.aspx ). I can generate and view a dynamic image containing RTF on my local (i.e. developer) machine using the ReportManager web interface and using the Render method . When I deploy this to our test server, I get an error.

To repeat, I took the following steps.

Created a custom assembly using VS.NET 2005 that converts RTF to bitmap. A custom assembly has a strong name.

On the local developer machine

  • Copied custom assembly in C: \ Program Files \ Microsoft Visual Studio 8 \ Common7 \ IDE ** PrivateAssemblies **.
  • Modified C: \ Program Files \ Microsoft Visual Studio 8 \ Common7 \ IDE \ PrivateAssemblies ** RSReportDesigner.config ** enable CodeGroup that provides FullTrust for custom assemblies on StrongNameMembership ( NOTE : The ReadMe.txt does not mention adding an entry to this file) ...
  • Modified C: \ Program Files \ Microsoft Visual Studio 8 \ Common7 \ IDE \ PrivateAssemblies ** ** RSPreviewPolicy.config file to include the CodeGroup that provides FullTrust for custom assemblies on StrongNameMembership ( NOTE : The ReadMe.txt does not mention adding an entry to this file ).

Modified report using VS.NET 2005 as follows

  • Added link for custom assembly and System.Drawing.
  • Added image control with type = Database , MimeType = image / bmp , Value = call custom assembly Method ; method is passed the value of the database field containing the RTF.
  • Expanded report.
  • The report was viewed successfully both via HTML and the Render WebService method using EXCEL as the output format. HTML for imageReserved.ReportViewerWebControl.axd ReportSession = ohj0pjaplbl5h255phlplz45 &? ControlID = 883e299f22ca4413b398a024cec134b2 & Culture = 2055 & UICulture = 7 & ReportStack = 1 & OpType = ReportImage & StreamID = ed4b4d3b-d54d-4043-9fea-1c06f153f9a1

On the local developer machine and server

  • Copied custom assembly in C: \ Program Files \ Microsoft SQL Server \ MSSQL.3 \ Reporting Services \ ReportServer \ Bin
  • Modified C: \ Program Files \ Microsoft SQL Server \ MSSQL.3 \ Reporting Services \ ReportServer ** ** rssrvpolicy.config file to include CodeGroup that grants FullTrust for custom assemblies on StrongNameMembership ( NOTE : Source code specifies permissions to be granted based on UrlMembership ).
  • Expanded report.
  • Unsuccessful view of the report via HTML and using the Render WebService method using EXCEL as the output format. HTML for image

Initially I was getting export to Excel error messages on the "data missing" lines, but these seem to have been addressed by granting permissions in the .config files that we did not mention in ReadMe.txt. I didn't have the strength to try and end this. I am convinced that the solution has something to do with permissions as it works on my computer but not the server.

Thanks in advance for any thoughts or suggestions.

Hello,

Bill

0


a source to share


1 answer


Have you granted your assembly the necessary permissions to access the database on the test server? (Looks like you did it.)



If so, then check if you are actually creating the image on the test server. If not, then it's a write permission issue. If it is created but cannot be viewed then it is a read permission issue.

0


a source






More articles:


All Articles