Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / August 2005

Tip: Looking for answers? Try searching our database.

Using custom assembly in designer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SevDer - 30 Aug 2005 22:13 GMT
Hi,

I am trying to use custom assemblies in the reports.
For a specific report I add the reference properly and used it in the field
calculation.

However when I try to preview it, or build it fails and gives me the
following error message:

Error while loading code module: 'ReportHelper, Version=1.0.2062.19195,
Culture=neutral, PublicKeyToken=null'. Details: File or assembly name
ReportHelper, or one of its dependencies, was not found.
The value expression for the field '=
ReportHelper.EnumRepresent(Fields!MyType.Value)' contains an error:
[BC30451] Name 'ReportHelper' is not declared.

Note: I do not have report manager on my machine but the design tools only,
so I do not have the luxury to configure any config files etc.

Can you please help?

Signature

SevDer
http://www.sevder.com
A new .NET Source For .NET Developers

SevDer - 30 Aug 2005 22:23 GMT
I found my answer a minute later.

So here is the moral of the story:
   "You need to read the help files better, at least finish the paragraph
you've started"

I need to copy the dll to "C:\Program Files\Microsoft SQL
Server\80\Tools\Report Designer"

-------------------------------------------------------------------------------------------------
Now, I have a ***new problem***, once designer uses this dll, it is locked.
How can I release this lock without shutting down the VS.NET.
-------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------

Signature

SevDer
http://www.sevder.com
A new .NET Source For .NET Developers

> Hi,
>
[quoted text clipped - 16 lines]
>
> Can you please help?
Robert Bruckner [MSFT] - 31 Aug 2005 05:30 GMT
If you close the report project/solution, VS.NET may release the lock on the
dll. If it does not, then there is no way around shutting down VS - sorry.

-- Robert
Signature

This posting is provided "AS IS" with no warranties, and confers no rights.


>I found my answer a minute later.
>
[quoted text clipped - 32 lines]
>>
>> Can you please help?
SevDer - 31 Aug 2005 20:44 GMT
It simply does not release it :(
I hope this will be improved with the new version.

Signature

SevDer
http://www.sevder.com
A new .NET Source For .NET Developers

> If you close the report project/solution, VS.NET may release the lock on
> the dll. If it does not, then there is no way around shutting down VS -
[quoted text clipped - 40 lines]
>>>
>>> Can you please help?
SevDer - 31 Aug 2005 20:45 GMT
It simply does not release it :(
I hope this will be improved with the new version.

Signature

SevDer
http://www.sevder.com
A new .NET Source For .NET Developers

> If you close the report project/solution, VS.NET may release the lock on
> the dll. If it does not, then there is no way around shutting down VS -
[quoted text clipped - 40 lines]
>>>
>>> Can you please help?
Donovan Smith [MSFT] - 31 Aug 2005 23:54 GMT
Try this:  Select "(Your project name) Properties" under the Project menu.
Click on Configuration Manager in the upper right corner of the dialog and
uncheck (if checked) Deploy.  Next, select Start under the Debug menu and
you should see your report shown in a separate process.  The secret here is
that if you never click on the Preview tab in VS or bring up the References
tab in the Report Properties dialog, I don't believe your assembly will be
locked.  If you do happen to click on either, you will have to close and
restart VS to free the lock, sorry.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> If you close the report project/solution, VS.NET may release the lock on
> the dll. If it does not, then there is no way around shutting down VS -
[quoted text clipped - 40 lines]
>>>
>>> Can you please help?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.