Showing posts with label assembly. Show all posts
Showing posts with label assembly. Show all posts

Friday, March 9, 2012

publishing report with reference on custom assembly

Hi,
I have a report with reference on ReportLibrary assembly.
In the Code section of the report there is the following code:
Public m_myClass As ReportLibrary.DatabaseInteraction
Protected Overrides Sub OnInit()
m_myClass = ReportLibrary.DatabaseInteraction.GetInstance()
End Sub
When I try to publish this report via Reporting Services API:
warnings = RS.CreateReport(reportName, reportPath, true, definition, null);
I get the following error:
+System.SystemException {"There is an error on line 0 of custom code:
[BC30002] Type 'ReportLibrary.DatabaseInteraction' is not defined. --> There
is an error on line 0 of custom code: [BC30002] Type
'ReportLibrary.DatabaseInteraction' is not defined."}
How I can solve this problem?
Any help would be appreciated.some addition:
my report was deployed from VS before and worked successfully.
this error is happened when I made some changes in the report and tried to
re-publish it.
"Paul Zorin" wrote:
> Hi,
> I have a report with reference on ReportLibrary assembly.
> In the Code section of the report there is the following code:
> Public m_myClass As ReportLibrary.DatabaseInteraction
> Protected Overrides Sub OnInit()
> m_myClass = ReportLibrary.DatabaseInteraction.GetInstance()
> End Sub
> When I try to publish this report via Reporting Services API:
> warnings = RS.CreateReport(reportName, reportPath, true, definition, null);
> I get the following error:
> +System.SystemException {"There is an error on line 0 of custom code:
> [BC30002] Type 'ReportLibrary.DatabaseInteraction' is not defined. --> There
> is an error on line 0 of custom code: [BC30002] Type
> 'ReportLibrary.DatabaseInteraction' is not defined."}
> How I can solve this problem?
> Any help would be appreciated.

Saturday, February 25, 2012

Publish custom assembly with query

My custom assembly works in design mode but when i publish it :

- function without query work well.

- function with query return an error (#Error).

The assembly was copied in C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin

What can i do the use query in my custom assembly.

Thanks for all your answers.

Have you looked at this article.

http://support.microsoft.com/default.aspx?scid=kb;en-us;842419

Problems with custom assemblies are usually related to not granting the correct permissions to the assembly in the config files.