Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Sazzad — Wed, 21 Dec 2005 05:28:29 GMT

being a long time access reports user, i am missing the "OnFormat, OnPrint etc.." report events which is not available in reporting services.

anyone knows how to overcome this limitation of reporting services ??

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Mohamed Sharaf — Thu, 22 Dec 2005 17:03:30 GMT

Hello Sazzad,
There are plenty of useful events of the ReportViewer control. Please take a look at this article http://msdn2.microsoft.com/en-us/library/ms255387.aspx

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Eran — Tue, 18 Apr 2006 10:33:08 GMT

Great Article !
Thank You :)

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Haitham El-Ghareeb — Tue, 09 May 2006 21:04:29 GMT

Simple as usual, full of data as usual too, so lovely blog contains nice articles with easy implementation, I know I have not been taking too many looks over your blog, but It is really nice. Good Luck with it.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Graham Angell — Thu, 11 May 2006 12:34:26 GMT

After many frustrating hours trying to get a custom assembly to work with ReportViewer I found your blog. Everything now works fine. My sincere thanks!

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

umangi Shah — Wed, 17 May 2006 00:54:48 GMT

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Raja — Wed, 24 May 2006 21:24:09 GMT

Hi Mohammad,

Your article is awesome and solved some of the mysteries I had....But now I have a problem of running the report (I am not using reportviewer control) which uses a custom assembly which in turn uses a web service to get the information required. I was able to get the report working in the preview mode but when I actually run it, It gave the exact error which you were talking in step 2 (Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.). It would be great if you can suggest me a measure to solve this.

Thanks in Advance,
Raja

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Amy — Wed, 24 May 2006 23:05:16 GMT

I have separated assembly and reference it from my report and I get following error.

Error while loading code module: ‘ClassLibrary1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'ClassLibrary1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

Your solution below:

-----------------------------------------
For the people who are trying to move their code in separated assembly and reference it from their report, they would face another problem.

If you are following the steps mentioned in MSDN regarding how to reference custom code (mentioned above). You will end up with this message

Error while loading code module: ‘ClassLibrary1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'ClassLibrary1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

After a lot of trials with this error, I found that I have to do the following.

Select the report file from Solution Explorer, Go to Properties Window and change its BuildAction to Content
Set Copy to output Directory property to Copy always or Copy if newer
In the form designer class (the partial class created by Visual Studio according to naming schema <FormName>.Designer.CS or <FormName>.Designer.VB) replace the line which instruct the ReportViewer to load the report file from resource file with another line that instruct the ReportViewer to load the report from current directory.
So this line
this.reportViewer1.LocalReport.ReportEmbeddedResource = "testLocalReport.Report1.rdlc";

With this line
this.reportViewer1.LocalReport.ReportPath = "Report1.rdlc";

Copy the dll that you are referencing to the Debug or Release directory of your application
Make the line that executes the report in the current appDomain first, then add the lines that trust the referenced assembly and all assemblies referenced by this assembly (see above)

-----------------------------------------

applies to windows application. Does anyone know how to solve it for a web application?

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

jholmes — Tue, 06 Jun 2006 00:49:03 GMT

I have the same problem Raja has. Any suggestions on fixing it? It's driving me crazy, not to mention I can't get my report working.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

David Overton — Mon, 19 Jun 2006 22:20:00 GMT

I got round the file not found error by placing the file in "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE". I still can't seem to reference the code, but this is a step closer.

ttfn

David

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Seato — Thu, 27 Jul 2006 10:44:23 GMT

Bloody Brilliant! Been looking for this info for ages. It was doing my head in until I found this insightful post.

Microsoft really suck with documentation on this Report stuff. Kodos to you for trawling through the code to get it work.

Well done, and THANKS!

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Bob — Wed, 09 Aug 2006 22:59:06 GMT

Anyone find solution for web apps yet?

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Chris — Wed, 16 Aug 2006 07:15:01 GMT

What I would really like to do is refrerence some code in the current assembly instead of a custom assembly. This would avoid all the nasty versioning issues that I think would come with a custom assembly. Is this possible? I am assuming not, since I have never seen it mentioned anywhere and I can't get it to work. But I don't understand why it wouldn't be supported.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Satish — Wed, 16 Aug 2006 15:13:44 GMT

Excellent Article. Thanks a lot.
Microsoft should learn something from this guy.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

diego pego — Thu, 17 Aug 2006 02:43:33 GMT

Really great article. That helped a LOT. I'm thinking if Microsoft intended to made this cryptic... anyway, thanks again!!!

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

brunelli — Thu, 24 Aug 2006 23:22:09 GMT

Thank you Mohamed for the helpful post!

If anybody accesses code from an custom assembly, don't forget to add the AllowPartialyTrustedCallers into the AssemblyInfo. If not, your report will run, but you may get an #Error where you use a method or member of the assembly.

Found here, and very useful anyway....

http://www.c-sharpcorner.com/UploadFile/balajiintel/CustomAssemblyinRS06302005081435AM/CustomAssemblyinRS.aspx?ArticleID=f3904516-e30a-401a-aa01-463636d78f18

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

lsites — Tue, 26 Sep 2006 16:05:48 GMT

How do you get ClickOnce to deploy the rdlc files if you put the reports into a separate assembly

Security problem

Jelle — Wed, 04 Oct 2006 15:29:01 GMT

Hi,

I have a working .exe with a report viewer with a custom dll to look up use a resource file so that I can have multiple languages in my reports. However, if I change this project to a class and use it from another .exe I get the next nasty error(s). Seems some permission problems.. I tried adding [assembly: AllowPartiallyTrustedCallers] to the custom assembly, but without success. Who can help me on this one?

Jelle

Microsoft.Reporting.WinForms.LocalProcessingException: An error occurred during local report processing. ---> Microsoft.Reporting.DefinitionInvalidException: The definition of the report 'Main Report' is invalid. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)

at System.Security.CodeAccessPermission.Demand()

at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

at System.Reflection.Assembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, StackCrawlMark& stackMark)

at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)

at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)

at System.AppDomain.CreateInstanceFrom(String assemblyFile, String typeName)

at System.AppDomain.CreateInstanceFromAndUnwrap(String assemblyName, String typeName)

at Microsoft.ReportingServices.Diagnostics.AssemblyLocationResolver.CreateResolver(AppDomain tempAppDomain)

at Microsoft.ReportingServices.ReportProcessing.ReportCompileTime.ResolveAssemblylocations(StringList codeModules, CompilerParameters options, ErrorContext errorContext, AppDomain compilationTempAppDomain)

at Microsoft.ReportingServices.ReportProcessing.ReportCompileTime.InternalCompile(Report report, AppDomain compilationTempAppDomain, Boolean refusePermissions)

at Microsoft.ReportingServices.ReportProcessing.ReportCompileTime.Compile(Report report, AppDomain compilationTempAppDomain, Boolean refusePermissions)

at Microsoft.ReportingServices.ReportProcessing.ReportPublishing.Phase3(ParameterInfoCollection& parameters, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions)

at Microsoft.ReportingServices.ReportProcessing.ReportPublishing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] definition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& description, String& language, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)

at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CompileReport(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& reportDescription, String& reportLanguage, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)

at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions)

The action that failed was:

Demand

The type of the first permission that failed was:

System.Security.Permissions.FileIOPermission

The first permission that failed was:

<IPermission class="System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Read="C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.Common\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.Common.dll"

PathDiscovery="C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.Common\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.Common.dll"/>

The demand was for:

<IPermission class="System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Read="C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.Common\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.Common.dll"

PathDiscovery="C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.Common\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.Common.dll"/>

The granted set of the failing assembly was:

<PermissionSet class="System.Security.PermissionSet"

version="1">

<IPermission class="System.Security.Permissions.FileDialogPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Access="Open"/>

<IPermission class="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Allowed="ApplicationIsolationByUser"

UserQuota="512000"/>

<IPermission class="System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Flags="Execution"/>

<IPermission class="System.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Window="SafeTopLevelWindows"

Clipboard="OwnClipboard"/>

<IPermission class="System.Security.Permissions.SiteIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Site="tempuri.org"/>

<IPermission class="System.Security.Permissions.StrongNameIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

PublicKeyBlob="0000000000000000"

Name="AdminUnit.application"

AssemblyVersion="1.0.0.19"/>

<IPermission class="System.Security.Permissions.UrlIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Url="http://tempuri.org/AdminUnit.application"/>

<IPermission class="System.Security.Permissions.ZoneIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Zone="Internet"/>

<IPermission class="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

version="1"

Level="SafePrinting"/>

<IPermission class="System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1">

</ConnectAccess>

</IPermission>

</PermissionSet>

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Jelle — Wed, 04 Oct 2006 15:48:02 GMT

it seems that I have my report viewer installed on D: and not in C: so in the C:\windows\assembly where report viewer is looking by default is maybe the problem. How do I move my reportviewer to the GAC of the C?

Solution to fileio permission

Jelle — Wed, 04 Oct 2006 18:05:27 GMT

You have to provide the right path to the report:

this.Viewer.LocalReport.ReportPath = Environment.CurrentDirectory + @"\" + reportToLoad + ".rdlc";

this.Viewer.ProcessingMode = ProcessingMode.Local;

this.Viewer.LocalReport.ExecuteReportInCurrentAppDomain(AppDomain.CurrentDomain.Evidence);

this.Viewer.LocalReport.ReportPath = Environment.CurrentDirectory + @"\" + reportToLoad + ".rdlc";

FileIOPermission filePerm = new FileIOPermission(FileIOPermissionAccess.Read, this.Viewer.LocalReport.ReportPath);

filePerm.Assert();

this.Viewer.LocalReport.AddTrustedCodeModuleInCurrentAppDomain(System.Reflection.Assembly.GetAssembly(typeof(GDS.User.WinLanguage)).FullName);

this.Viewer.LocalReport.DataSources.Clear();

foreach (System.Data.DataTable _dataTable in ReportDataSet.Tables)

{

this.Viewer.LocalReport.DataSources.Add(

new ReportDataSource(ReportDataSet.DataSetName + "_" + _dataTable.TableName, _dataTable));

}

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Davide Senatore — Wed, 25 Oct 2006 01:36:34 GMT

Great article!!! A very good exam of an interesting and very useful tool... Thank you!!!

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Sebastian — Fri, 27 Oct 2006 15:42:10 GMT

Great post!, but what about localization? How can I localize my column headers?

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Pradeep — Mon, 20 Nov 2006 16:06:19 GMT

I have a problem in Printing Report from ReportViewer. If I print the report, when it is in NORMAL LAYOUT...it is not getting printed. But if I print the same by setting PRINT LAYOUT...coming good.

Is there any way to show the report in PRINT LAYOUT by default? OR Is there any way to set the LAYOUT mode programaticaly?

Thank you

Pradeep.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Bruno — Fri, 22 Dec 2006 16:14:54 GMT

This worked fine for me untill I installed the SP1 for Visual Studio. Now I got back the "Error while loading code module: ‘ClassLibrary1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'ClassLibrary1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."-Error. I am still investigating. Any soloution?

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Gancy — Thu, 04 Jan 2007 17:45:01 GMT

Very nice article. But I need to know how to use custom assemblies on web based report rendering. My custom assembly need to access reportserver.exe.config file, which result sin FileIO security exception. I am sure some one must have done this before.

F*cking VS2005 SP1

Sebastian — Wed, 31 Jan 2007 22:22:29 GMT

Hey dude, great article.

For those having the "Error while loading code module:" error in web applications, try installing VS2005 SP1. But after that you win reports projects will have that error according to this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1099668&SiteID=1

Still looking for the solution...

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

M$ — Tue, 13 Feb 2007 19:55:13 GMT

Is it possible to convert rdl to rdlc and render the report at run time ?

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

M$ — Tue, 13 Feb 2007 21:05:44 GMT

Is this the only way to convert RDL to RDLC and could this be done at run-time ?

RDL-to-RDLC Conversion

When converting a .rdl file to .rdlc format, you must manually replace the data source and query information in the report definition with data constructs provided in your application.

Rename the .rdl file to use the .rdlc file extension.

In Visual Studio 2005, open the solution or project that will contain the report.

Create or add the dataset that defines the data you want to use to your projector solution. For more information, see Creating Data Sources for a ReportViewer Report.

On the Project menu, click Add Existing Item and then select the .rdlc file that you created in the first step.

In the project, open the form or Web page that will contain the report.

From the Toolbox, in the Data group, drag a ReportViewer control onto the form or Web page.

In the ReportViewer Tasks smart tags panel, in Choose Reports, select the .rdlc file to use with the control.

In the ReportViewer Tasks smart tags panel, in Choose Data Sources, select the dataset you want to use. The dataset object, binding source object, and table object will appear at the bottom of the workspace. For more information about updating data source references, see Updating and Rebinding Data Source References.

Save all files, and then build or deploy the project to verify that the report contains the data you expect.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Vikas — Mon, 19 Feb 2007 22:16:41 GMT

If you are trying to access a custom assembly code in the reports and if you are getting the following error.

Error while loading code module: ‘ClassLibrary1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'ClassLibrary1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

Then copy the Custom Assembly dll into the following folder.

PROGRAMFILES\Visual Studio 8\Common7\IDE\PublicAssemblies

See the following post for more details.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1099668&SiteID=1

Good Post Mohamed :-)

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Bogdan — Fri, 23 Feb 2007 20:03:14 GMT

Great article!

This report control is a mess and it feels just like no more than an “idea”.

Thanks to this article and all comments I finally managed to run something...

Here are few pointers for those trying to display images from DB on the report.

In my example I used Categories table from Northwind DB

Image control available for the report control needs raw bytes to be passed in Value property.

Note: System.Windows.Forms.PictureBox.Image property uses Image class.

Image.MIMEType=image/bmp

Image.Source=Database

Image.Value=Utils.Utils.GetRawBytes(Fields!Picture.Value)

Where GetRawBytes() is a static method in a referenced assembly Utils

using System;

using System.Drawing;

using System.IO;

using System.Configuration;

namespace Utils

{

public class Utils

{

public static byte[] GetRawBytes(byte[] bytes)

{

// remove OLE header if present

MemoryStream ms = null;

try

{

int offset = 0;

// use offset=78 for Northwind DB

if (ConfigurationManager.AppSettings["ImageOffset"].ToString().Length > 0)

offset = Convert.ToInt32(ConfigurationManager.AppSettings["ImageOffset"]);

if (offset > 0)

{

ms = new MemoryStream(bytes, offset, bytes.Length - offset);

bytes = ms.ToArray();

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

}

finally

{

if (ms != null)

{

ms.Close();

ms = null;

}

return bytes;

}

Print button is not visible when i use rdl files as local reports

Suri — Thu, 05 Apr 2007 10:20:31 GMT

Print button is not visible when i use rdl files as local reports through report viewer.

Print button is not displaying and only two types of export options.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Pete — Tue, 17 Apr 2007 01:53:21 GMT

Hi,

Just sharing a "feature" on winform reportviewer which did cost a day to figure out:

I got "Some parameters or crednetials have not been specified". Strange thing, I did not get them when running through visual studio (either debug or release), but ONLY when run apart from VS. (go figure that one).

After working through tips here on the site, THANKS, (a few I discovered the "hard way" already), I finally figured it and just wanted to share:

First do a localreport refresh, than the viewer itself:

reportViewer1.LocalReport.Refresh();

reportViewer1.RefreshReport();

For some reason I had it the other way around, resulting in that mysterious error, but not within VS environment.

Cheers,

Pieter

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Shane — Tue, 17 Apr 2007 03:24:51 GMT

Thanks for the post. What you can also do is add the copying of the dll to the PublicAssemblies folder to the post build event for the assembly in your code so you don't have to remember to do it after each build. e.g.

copy E:\projects\vsdev\<project>\Common\bin\Debug\Project.Common.dll "C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies"

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

John — Tue, 05 Jun 2007 21:50:11 GMT

How do you format Boolean columns to display a checkbox?

Monika Aleksieva — Mon, 25 Jun 2007 15:59:57 GMT

John,

You cannot display checkboxes. If you want to display boolean columns, you can add an image and specify image path depending on the value of your data. For example 1.gif (true) and 0.gif (false) can look like a box with or without a tick.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Monika Aleksieva — Mon, 25 Jun 2007 16:57:38 GMT

For web apps to work with local reports and custom assemblies that are NOT installed in GAC, you have to run Microsoft Report Viewer Redistributable 2005 SP1. This is available here - http://www.microsoft.com/downloads/details.aspx?FamilyId=35F23B3C-3B3F-4377-9AE1-26321F99FDF0&displaylang=en

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

John — Tue, 26 Jun 2007 23:38:48 GMT

I have a formula for column called %Diff to Goal

=Iif(Fields!ThisYearActual.Value > 0 And Fields!ThisYearGoal.Value > 0,( (Fields!ThisYearActual.Value - Fields!ThisYearGoal.Value) / Fields!ThisYearGoal.Value), 0 )

What I really want is to check for values greater than NULL, but used "> 0" instead.

But I do not see any options in the Edit Expression dialog box to check for Null values.

At the moment, if ThisYearActual is > 0, but ThisYearGoal is Null, the ‘% Diff to Goal’ is displaying an ‘#Error’ message.

Is there a better way to write this formula, and/or check for null values?

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Tom — Wed, 27 Jun 2007 14:39:56 GMT

I have a report that is part of my project (is not in a DLL) so is there a way to access textboxes that I've placed on the report to populate with a value? Or do I need to put my report in a seperate DLL?

I guess the part that is confusing me is when you browse to add a reference.....is this referring to the fact that the report is in a DLL?

Thanks and great blog

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Di — Mon, 02 Jul 2007 09:12:24 GMT

I have a problem with deploying reports from Visual Studio where it is remembering an old user name to try to use for deploying - it does not have sufficient permissions. Do you know how to force it to prompt for a user? For deploying, we only need to supply a URL in the project properties.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Di — Mon, 09 Jul 2007 16:07:39 GMT

Excellent -solved my problem with the error.However, I am trying to use the custom code to create a comma delimited list of values from the row values in a table. I get the list accummulating correctly till the group footer where the list value is then empty. The list is accummulated within my external class using calls on the detail line of the table.

It appears that there is a separate instance being used for the level 1 grouper from the detail line grouper and thus when I call my external class to get the accumulated value, the result is empty.

Any suggestions on how to overcome this would be greatly appreciated.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Anthony Manvell — Wed, 25 Jul 2007 13:51:37 GMT

Excellent, concise article. Very informative will save me hours of investigation. Many thanks.

How do you format Boolean columns to display a checkbox?

VinK — Mon, 13 Aug 2007 14:28:16 GMT

Displaying checkboxes in microsoft reports is very simple and an interesting method can be found right here

http://www.xhydra.com/dotnet/displaying-checkboxes-in-microsoft-reports.html

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

dshah — Tue, 21 Aug 2007 20:14:43 GMT

Thanks for this amazing blog.. i have visited this blog for the first time and I am fan of it now. This article is amazing.

Thank you so much.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Samee Qayum — Thu, 30 Aug 2007 17:18:45 GMT

AS,

I have used your solution but the problem of adding a data source name was not included - had to get from MS support.

I still have the problem:

T"he report references the code module 'System.Windows.Forms', which is not trusted"

Can you help ?

Regards

Samee Qayum

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

alexjoei — Thu, 20 Sep 2007 12:37:55 GMT

Hello, good article, but i have donde all hte steps, and i still have the:

"The report references the code module ‘System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’, which is not a trusted assembly".

I have a report that in the 'Code' has a function that uses system.drawing, i write in my load event the two lines (AddTrustedCodeModuleInCurrentAppDomain, ExecuteReportInCurrentAppDomain)

but it dont solves my problem,

any idea please??

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Cesar — Wed, 26 Sep 2007 16:10:01 GMT

Really thanks for this useful blog!! ^^

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Cesar — Wed, 26 Sep 2007 16:13:18 GMT

And, ah. If you still are running problems with "no permission" message event after adding the AddTrustedCodeModuleInCurrentAppDomain and ExecuteReportInCurrentAppDomain, the error was gone when I inverted the order. So, you need to execute ExecuteReportInCurrentAppDomain first, then AddTrustedCodeModuleInCurrentAppDomain.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Michael C — Thu, 04 Oct 2007 08:53:19 GMT

And that does it!! Thanks Ceasar. I inverted the AddTrustedCodeModuleInCurrentAppDomain and ExecuteReportInCurrentAppDomain and there you have it, my barcode generation code loaded. Now just to get it to format the datastream.

Now I have a solution to replace lovely Crystal Reports.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

jim hudson — Mon, 15 Oct 2007 18:25:49 GMT

mohammed, you are the man. ever think about writing a book ;)

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Ravi — Fri, 19 Oct 2007 15:33:38 GMT

Hi...

I am having a report name "Report1.rdlc"

Now,I want to add a textbox at runtime...How can i??

Thanks in advance

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

mojtaba — Wed, 05 Dec 2007 13:31:56 GMT

Thank For Your Try And Soloution...

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Pooya Davoodi — Wed, 23 Jan 2008 15:17:57 GMT

I found a way to deal with the problem that Raja says above at:

"http://blogs.msdn.com/mosharaf/archive/2005/12/20/LocalReportCustomCode.aspx#606223"

After a lot of checking, at last I found out that if you disable the "ClickOnce Security Settings" from the security section of properties of your project, it works fine. I don't know exactly why, but it works.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Pooya Davoodi — Wed, 23 Jan 2008 15:20:51 GMT

sorry, in the previous comment that I posted, I typed an extra double quotation at the end of the link.

Report Preprocessing: SQL Server Reporting Server Group PageTotals Walkthrough, Part I: the RDL and the Server

TechSpoken — Sun, 02 Mar 2008 21:47:17 GMT

Report Preprocessing: SQL Server Reporting Server Group PageTotals Walkthrough, Part I: the RDL and the Server

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

sunu — Tue, 18 Mar 2008 12:20:00 GMT

i have created a report rdlc and got connection to the database .... the databse has only two columns fname and lname...

the query in the table adapter is:

SELECT fname, lname FROM dbo.sunu where lname=@lastname

i have set a report parameter "lastname" also ..

i have passed the parameter value as "s" through the set parameter method and obtained it in the report also as i can see the parameter printed on my report when it is rendered...

but the data is not filtered based on lname="s"??

any ideas as to what i am doing wrong??

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

sunju — Tue, 18 Mar 2008 14:32:07 GMT

one more thing .. iam not using reportviewer instead i am directly writing the report to a file

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Smith — Wed, 02 Apr 2008 15:28:55 GMT

When i try to use your function toUpperCase i get the following error message:

An error occurred during local report processing. Failed to load expression host assembly. Details: Parameter count mismatch.

I double checked the parameters i`m passing to the method and cannot figure out where is the problem.

Even on the most simple example like =Code.toUpperCase("aaa") i get the same message!

Can you please give me some clue?

how to display subtotal of previous page in the top of next page in rdlc report.

uma — Thu, 24 Apr 2008 11:06:08 GMT

hi how to display subtotal of previous page in the top of next page in rdlc report.

Ex:

page 1

name acc bal

a 6 10

b 7 20

sutotal 30

page 2

subtotal of first page 30

name acc bal

aa 6 10

bb 9 60

sutotal 70

page 3

subtotal of second page 30

can anyone plz.. help me its urgent.

Thanks in advance,

uma

Reference custom code assembly in ReportViewer control

Expecho's .Net corner — Mon, 28 Apr 2008 21:10:08 GMT

Reference custom code assembly in ReportViewer control

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

uma — Mon, 05 May 2008 12:54:29 GMT

hi i am using this custom code to display subtotal of first page in the next page

Public Double P=0

Public String Myfun(Double t)

{

P=t

Return P

}

and i am calling this fun in text box

=Code.Myfun(Sum(Fields!OrderID.Value.ToString))

=IIF(Code.P = 0,"",Code.P)

but its giving these errors

Error 1 There is an error on line 1 of custom code: [BC30183] Keyword is not valid as an identifier. C:\Inetpub\wwwroot\WebSite5\Report.rdlc 1

Error 2 The Value expression for the textbox ‘OrderID_2’ contains an error: [BC30456] 'Myfun' is not a member of 'ReportExprHostImpl.CustomCodeProxy'. C:\Inetpub\wwwroot\WebSite5\Report.rdlc 1

Error 3 The Value expression for the textbox ‘textbox13’ contains an error: [BC30456] 'P' is not a member of 'ReportExprHostImpl.CustomCodeProxy'. C:\Inetpub\wwwroot\WebSite5\Report.rdlc 1

plz.. anyone can help me.

thanks

uma

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

jemacc — Thu, 05 Jun 2008 16:53:29 GMT

I am trying to add code to to my report. I am not very familiar with referencing the assembly. With the following code can you point me in the right direction as to how I would refrence the assembly and classes

Function SetLanguage(ByVal value AS Object) As Object

If value = "EUR"

Return "French"

ElseIf value = "GBP"

Return "French"

Else

Return "French"

End If

End Function

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Chris Forbes — Sat, 02 Aug 2008 00:03:23 GMT

Embedded or local reports: I shall test this in a WinForm application, but I can not get the report engine to see, "find", a private assembly using the ReportViewer control and a local report (.rdlc) in a web application using SQLExpress unless I put the assembly into C:\Windows\Microsoft.Net\framework\v2.0.50727\MyTestAssembly.dll (for example). I have tried all of the above lines of code in my on_load routine and while the permissions problem is solved, finding the library is not, or at least not for web apps.

If the system directory, .../v2.0.50727, is the only way, it won't fly. System admins would have tripple kittens and frankly, I wouldn't blame them.

Also, it would be of very limited use to build libraries of functionality that could be used by Reports in WinForm applications, but not in Web applications.

If there is a way to inform the Report engine from a web app where to look for the dll (it's plumb crazy that it doesn't at least look in current directory), I would love to hear about it. Having said that, great blog! Even the books I can find don't go into this much detail.

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

AAA — Fri, 29 Aug 2008 16:56:58 GMT

Do you know how to refer to the report parameters in the custom code

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Dilip M.D — Mon, 08 Sep 2008 15:09:09 GMT

It worked for me with just first step. Thanks Mohamed.

re: Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Paul M. Allen — Sun, 14 Sep 2008 01:44:31 GMT

Re: your blog - good stuff!

I am just getting into Microsoft Reports, initially doing reports for display in a reportviewer and using local mode rather than a server as part of a billing system I am building in VS2005 - the objective was to find a way to avoid endless hours of typing printdocument code and to take advantage of the

PDF/Excel export feature. The learning curve got pretty steep when I started to do a report that would generate an invoice.

Part of the complexity is due to the fact that the viewer will be used to display multiple reports.

Hopefully the following code (triggered when a selection is made from a listbox) will be helpful in giving others who might be trying to do something similar not necessarily answers but instead insights into the process.

There is a well documented problem when printing with the 2005 viewer. On some

printers - including both my Canon printers - the margins get messed up unless

the margins are set to .5in or more. The easy solution is to just set the margins

to .5in and accept the fact that they're wider than we'd prefer.

I would agree with the observation that Reports and the Reportviewer are works in progress but that seems to be the case with lots of Microsoft stuff - seems like whenever we want to do something that goes beyond basic functionality that things get ugly. I wonder if any of the people who develop things there ever try to put them to use in the real world.

My comments in the code are notes to myself to remind me what I did and why.

switch (listBoxReportList.Text.ToString())

{

//You have to manually set the datasource when doing the subreport as below

//We want to display different reports in the same report viewer.

//The tricky part is that we build the reports in the development environment

//using the PMABillingDataSet but the program actually uses an instance of it called pmaBillingDataSet1.

//After we've built the report, the we need to go into the rdlc file code for the report using the XML editor

//and change the PMABillingDataSet references to pmaBillingDataSet1 to get the thing to work.

//Perhaps the answer is to pass the datasetname as a parameter.

//In the report viewer, we can't use embedded resource value because it would lock in the data source so we need to use

//file path to get the report. In the development environment, the path is \bin\debug\Reports\.

//In the code below, note that the datasource(ReportDataSource - "pmaBillingDataSet1_Customer") values have to match

//to match the values in bindingSourceCustomer.

//Also note that if you do not uses the Reset method as shown below, the viewer holds the reference to the last

//instance used and doesn't do the new report because it's trying to use the old datasource. Yuk!

//Also note that after we've done it all, we have to call RefreshReport to get the report to display.

//Unless the following is done, the reportviewer will not display a report containing subreports

//The standard approach include private void SubreportBasicInfoEventHandler(object sender, SubreportProcessingEventArgs e) to handle the event

//this.reportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SubreportBasicInfoEventHandler);

//it and call it in Form_Load. For the moment, I created the handler here.

//Note that the sequence in which things happen needs to be right.

case "Customer List":

System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;

buttonShowReport.BackColor = System.Drawing.Color.Chocolate;

listBoxReportCustomer.SelectedIndex = 0;

listBoxReportMonth.SelectedIndex = -1;

listBoxReportYear.SelectedIndex = -1;

reportViewer1.LocalReport.DataSources.Clear();

reportViewer1.Reset();

reportViewer1.LocalReport.ReportPath = Application.StartupPath + @"\Reports\ReportCustomerList.rdlc";

ReportDataSource mydatasource = new ReportDataSource("pmaBillingDataSet1_Customer", bindingSourceCustomer);

reportViewer1.LocalReport.DataSources.Add(mydatasource);

reportViewer1.RefreshReport();

System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;

break;

case "Current Invoice":

System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;

buttonShowReport.BackColor = System.Drawing.Color.Chocolate;

listBoxReportCustomer.SelectedIndex = 0;

listBoxReportMonth.SelectedIndex = -1;

listBoxReportYear.SelectedIndex = -1;

reportViewer1.LocalReport.DataSources.Clear();

reportViewer1.Reset();

reportViewer1.LocalReport.ReportPath = Application.StartupPath + @"\Reports\ReportInvoiceContainer.rdlc";

reportViewer1.LocalReport.EnableExternalImages = true;

//the following values are for test purposes only

//if the parameters are left empty, we get errors

CompanyName = "Test Company Name";

CompanyAddress = "1000 Main St.";

InvoiceImage1 = Application.StartupPath + "/images/InvoiceImage1.jpg";

InvoiceImage2 = Application.StartupPath + "/images/InvoiceImage2.jpg";

//This sets the string value for a parameter ("ParamaterName", value). The Parameter "CompanyNameParameter"

//is declared in the report as an empty parameter.

ReportParameter companynamevalue = new ReportParameter("CompanyNameParameter", CompanyName);

reportViewer1.LocalReport.SetParameters(new ReportParameter[] {companynamevalue});

ReportParameter companyaddressvalue = new ReportParameter("CompanyAddressParameter", CompanyAddress);

reportViewer1.LocalReport.SetParameters(new ReportParameter[] {companyaddressvalue});

//This parameter is used in the filter

ReportParameter invoiceidnumber = new ReportParameter("InvoiceIDNumberParameter", textBoxInvoiceNumber.Text.ToString());

reportViewer1.LocalReport.SetParameters(new ReportParameter[] {invoiceidnumber});

ReportParameter imagelogo1 = new ReportParameter("ImagePath1Parameter", InvoiceImage1);

reportViewer1.LocalReport.SetParameters(new ReportParameter[] { imagelogo1 });

ReportParameter imagelogo2 = new ReportParameter("ImagePath2Parameter", InvoiceImage2);

reportViewer1.LocalReport.SetParameters(new ReportParameter[] { imagelogo2 });

ReportDataSource mydatasourceinvoice = new ReportDataSource("pmaBillingDataSet1_InvoiceLineItem2008", bindingSourceInvoiceDetail);

reportViewer1.LocalReport.DataSources.Add(mydatasourceinvoice);

this.reportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SubreportInvoiceEventHandler);

reportViewer1.RefreshReport();

System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;

break;

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

Yasser Ahmed — Tue, 16 Sep 2008 22:46:12 GMT

Thanks for ur great effort >> I am working on web application and I have followed all your steps to add function in code to connect database and add the dll reference but i still get this error :There is an error on line 4 of custom code: [BC30002] Type 'SqlConnection' is not defined.

My function is:

Public Function TestConn(ByVal RevID As String, ByVal QstID As String, ByVal AnswID As String) As String

Dim constr As String = "Data Source=THINKPAD\SQLEXPRESS;Initial Catalog=motorola;Integrated Security=SSPI"

Dim ObjConn2 As SqlConnection = New System.Data.SqlClient.SqlConnection(constr)

ObjConn2.Open()

Dim strSQL As String = "SELECT COUNT(dbo.MotoDetails.AnswerID) AS AnswerCount FROM Dale_Eval INNER JOIN MotoDetails ON Dale_Eval.Rev_ID = MotoDetails.Rev_ID WHERE MotoDetails.QuestID =" + QstID + " AND Dale_Eval.Rev_ID = " + RevID + " AND MotoDetails.AnswerID = " + AnswID + ""

Dim cmd As SqlCommand = New System.Data.SqlClient.SqlCommand(strSQL, ObjConn2)

Dim dr As SqlDataReader

dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)

dr.Read()

Dim TotlaAn As String = dr(0).ToString()

dr.Close()

Return TotlaAn

End Function

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

DarkAraym — Wed, 05 Nov 2008 20:46:31 GMT

Thank you so much!!! I've been trying to do this for ages. For a while I was still getting the permission error, but thanks to Ceasar everything works great. AMAZING!

Detecting Printing in Native Reports

Doug Tumeo — Fri, 07 Nov 2008 17:17:04 GMT

I am creating reports in SSRS 2005 that will be displayed directly from ReportServer, not within an application. In this situation, do you know of a way to hide controls based upon whether the report is rendered on screen or printed. (I want to hide some controls on printed output.)

Thanks in advance,

Doug

Code class doesn't work

toninicasanipasta — Thu, 11 Dec 2008 11:33:25 GMT

Great post, but I'm trying to use Code class after introduce a function in Code tab and it doesn't work:

Code tab:

public function Hello()as string

return "Hello"

end function

Expression:

=Code. <---- And here it doesn't appear my function listed. Someone knows why? I'm gonna be crazy with this...

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

en88 — Tue, 10 Mar 2009 22:07:57 GMT

I still don't get the permission after switch the position of two statements. I'm using VS 2008, is this the reason why it doesn't work for me?

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

ChandraM — Tue, 16 Jun 2009 01:04:01 GMT

Can you please let me know How I can build a dataset using custom code in rdlc report/document ?

re: Adding custom code to Local Reports in Visual Studio.NET 2005 (Problems & Solutions)

ChandraM — Tue, 16 Jun 2009 01:05:38 GMT

I am working on microsoft reports/documents and need help in building a dataset in the report custom code, can somebody help me?