On page 154 the book tells me to un-comment code in the RSReportDesigner.Config and the RSReportServer.config

Since I did not have this code block in either file I added it. I may or may not have put it in the correct place ( I put the code as the last item inside the outermost set of tags ).

I created a new class project which I called Report_Formats in which there is a class (also called report_Formats). I then went through the steps as outlined on page 155 to add the reference to the compiled dll (which I put in the reporting services bin as directed).

I ended up with an assembly reference like this:
=Report_Formats.Report_Formats.CustomFormat(Fields !Phone.Value, "Phone")

When I click the preview tab I get an error:
c:\sinotification\report project2\CustomCodeInReport.rdl Error while loading code module: ‘Report_Formats, Version=1.0.1629.14027, Culture=neutral, PublicKeyToken=null’. Details: File or assembly name Report_Formats, or one of its dependencies, was not found.

I don't know if this is because of an error in the class (I don't think it is) or if the code I added to the XML config files is either incorrect (it is exactly as in the book) or in the wrong spot.

Microsoft may have made other changes between the beta (which the book is based on) and my version.

Can anyone help me find what the problem is??



Sandy Murdock MCP

__________________
Sandy Murdock MCP

I have it working but I can't believe that I am doing it the correct way.

I found a reference via microsoft:
http://msdn.microsoft.com/library/de...g_rdl_8mue.asp

which mentioned that the custom dll could be put in EITHER the server directory as noted in the book:
c:\Program...\ReportingServices\ReportServer\bin
or
C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer

When I put the dll in the ReportServer\bin I could not preview the report. I dropped an additional copy into the Report Designer directory and it now works.

Also of note: According to microsoft if you change your class code and recompile you will have to go into each report and update your reference.

I want someone to tell me that I only need to put my class files in one place and maintain them in one place. Anyone?




Sandy Murdock MCP

Yes.
First, you are right. You need the assembly (.dll) file to reside in BOTH places (one for VS designer to work and the other for the report deployed to Reporting Services to work).

And yes, you do NOT need to redeploy the assembly every time you change the report that calls it. You only need to re-deploy the assembly if it changes. When you do change it, be sure to NOT change the Version or you will have to update the reports that use it to refer to the assembly with the new version number.