[UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))] [FileLoadException: Could not load file or assembly 'System.Web.RegularExpressions, Version=2.0.0.0, Culture=neutral, PublicKeyToken°3f5f7f11d50a3a' or one of its dependencies. Access is denied.] System.Web.Configuration.RegexWorker..cctor() +0
Go to the Reporting Services Configuration Manager and …
— This SQL reads in a varchar(10) field called work_hours that could have anything in it. It should be numeric represented as decimal.
— The CASE statement will produce either 0.00, or (if it is numeric) whatever is in the …
=Replace(Round(Fields!Rate.Value,2),”.00″,””)…
When starting Visual Studio 2010, it would hang for about 30 seconds trying to load the toolbox. I found this solution online and it worked for me:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
http://michaelcrump.net/fixing-a-broken-toolbox-in-visual-studio-2010-sp1
I was recently running into a situation where every time I …
This problem occurs when “Prevent saving changes that require table re-creation” option is enabled.
Solution:
Go into Tools -> Options -> Designers-> Uncheck “Prevent saving changes that require table re-creation”.…
Since SSRS does not have a report footer, it can be challening to figure out how to display information one time within the page footer on the last page. Here is one workaround that works well.
At the top of …
Using the Database Diagram, you can create a Primary/Foreign Key relationship between two tables. But if the tables already have data, the relationship will fail to establish. If you are sure you won’t have orphaned data, the resolution is to …
SELECT * INTO dbo.NewTable FROM dbo.OldTable
Create only a subset of columns:
SELECT column5, column8, column11 INTO dbo.NewTable FROM dbo.OldTable…
1) Create an external Assembly DLL (Class Library). You can use Framework 3.5.
a) Name it ‘DataForSSRSReport’.
b) Rename the default class to ‘clsDataForSSRS’. Make sure the class is Public.
c) Use ‘Private Shared’, ‘Public Shared Property’, and ‘Public Shared …
In the ActiveReport-ReportStart section of your parent report, you can assign any object type to the Report object variable, ‘UserData’
UserData is a public object of the DataDynamics.ActiveReports.ActiveReport.
Scenario:
Let’s say you are using a Watermark in your parent report. …
