Clearing LOG Files: assembly

Showing posts with label assembly. Show all posts

Sunday, March 11, 2012

CLR Trigger Error: Could not find Type xxxx in Assembly

I've got the following code (C# code) but when I execute the Create Trigger
statement I get the error
"Could not find Type 'InheritanceTriggers' in assembly 'CLRTriggers'
I believe I'm satisfying all the rules: the class is public, the method is
public, and the method is static.
Anythoughts?
Create Trigger EnforceInheritanceTrigger on [Person]
For INSERT as External Name CLRTriggers.InheritanceTriggers.EnforceBaseObjec
t
GO
CLRTriggers.dll code below
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Microsoft.SqlServer.Server;
namespace My.SQLServer
{
public class InheritanceTriggers
{
[SqlTrigger(Name = @."EnforceInheritanceTrigger", Target =
"[dbo].[Person]", Event = "FOR INSERT")]
public static void EnforceBaseObject()
{
SqlTriggerContext context = SqlContext.TriggerContext;
String SQLForInserted = "SELECT * FROM INSERTED;";
string ATableName = "dbo.Person";
if (context.TriggerAction == TriggerAction.Insert)
{
using (SqlConnection connection
= new SqlConnection(@."context connection=true"))
{
connection.Open();
SqlCommand command = new SqlCommand(SQLForInserted,
connection);
SqlDataReader reader = command.ExecuteReader();
while(reader.Read())
{
System.Guid id = (System.Guid)reader[0];
string s = <sql statement is here>;
SqlCommand command1 = new SqlCommand(s, connection);
SqlPipe pipe = SqlContext.Pipe;
pipe.Send(s);
}
reader.Close();
}
}
}
}
}
> Create Trigger EnforceInheritanceTrigger on [Person]
> For INSERT as External Name
> CLRTriggers.InheritanceTriggers.EnforceBaseObject
You need to include your namespace:
Create Trigger EnforceInheritanceTrigger on [Person]
For INSERT as External Name
CLRTriggers.[My.SQLServer.InheritanceTriggers].EnforceBaseObject
Steven|||Unfortunately, that still didn't help:
Could not find Type 'My.SQLServer.InheritanceTriggers' in assembly
'CLRTriggers'.
but thanks for the suggestion...at least it gave me something new to try. :
)
"Steven Hemingray [MSFT]" wrote:

>
> You need to include your namespace:
> Create Trigger EnforceInheritanceTrigger on [Person]
> For INSERT as External Name
> CLRTriggers.[My.SQLServer.InheritanceTriggers].EnforceBaseObject
> Steven
>
>|||I beg your pardon! I got my namespaces mixed up and you are absolutely
correct! Thank you Steve H! (I'll bet you were saying to yourself, "this
guy's nuts", I know that's the problem) :)
"Steven Hemingray [MSFT]" wrote:

>
> You need to include your namespace:
> Create Trigger EnforceInheritanceTrigger on [Person]
> For INSERT as External Name
> CLRTriggers.[My.SQLServer.InheritanceTriggers].EnforceBaseObject
> Steven
>
>

Thursday, March 8, 2012

CLR integration - Could not find Type '?' in assembly '?'.

Hi,

I'm new to Integration services and .Net programming but am trying to
create a dll that I can access from Sql server 2005.

The dll read's an xml file and carries out some processing. I've run
the code as an console app and it works fine.

I have created the assembly in sqlserver thus:

create assembly PinCodeLoader from
'C:\PinCodeLoader\PinCodeLoader\PinCodeLoader\bin\Debug\PinCodeLoader.dll'
with permission_set = external_access

But when I try to reference the assembly from a stored proc

create procedure dbo.interface_processPinCodefile(@.filename
nvarchar(1024))
as EXTERNAL name PinCodeLoader.PinCodeloader.Main

I get the following error:

Msg 6505, Level 16, State 1, Procedure interface_processPinCodefile,
Line 3
Could not find Type 'PinCodeloader' in assembly 'PinCodeLoader'.

I understand the context of the syntax should be
assembly_name.class_name.method_name. The first lines of the code in
the DLL are as follows

namespace PinCodeLoader
{
class PinCodeLoader
{
static void Main(string[] args)
{

Therefore assembly = PinCodeLoader, class_name = PinCodeLoader and
method_name = Main. Which should equal
EXTERNAL name PinCodeLoader.PinCodeloader.Main, I thought.

Has anybody come across this or can they offer any assistance?

Many thanks,

Paul

Hi, try to compile the .vb file with this command line:

csc.exe /t:library PinCodeLoader.bv (Put the correct name of the .vb file)

If this work look at the properties of the project and search for 'root namespace' (or something similar), and delete it, then try again compiling the entire solution from de IDE...

Good luck

Alejandro F.

|||

You need to include the namespace as well:

create procedure dbo.interface_processPinCodefile(@.filename
nvarchar(1024))
as EXTERNAL name PinCodeLoader.[PinCodeLoader.PinCodeloader].Main

However, you still won't be able to create your proc because SQL can't map nvarchar(1024) to the string array args.

|||

Thanks for your replies guys. I didn't actually try that method but found a way around it.

In my c# program I removed the reference to a namespace, as I was told it's not really necessary and changed the code as follows.

public class PinCodeLoad

{

public static void Main(string filename,string datasource,Int32 timeout, string companyname)

{

So instead of using the args parameter I'm implictly defining them. Plus I preceded my class and method with public

I kept the stored proc as before.

I hope that helps anybody else.

Paul

Wednesday, March 7, 2012

CLR Assembly redeploy problem.

Error1Cannot drop the function 'TranslationStringLike', because it
does not exist or you do not have permission.
Cannot drop the function 'TranslateEngString', because it does not
exist or you do not have permission.
Cannot drop the function 'TranslateEngStringReverse', because it does
not exist or you do not have permission.
DROP ASSEMBLY failed because 'FirmBankCLR' is referenced by object
'TranslationStringLike'.FirmBankCLR

That is the assembly is dependent by other objects, it can't be
dropped until it is not dependent by other objects. How can I resolve
this problem using Visual Studio 2005 or something else?Amber (guxiaobo1982@.gmail.com) writes:

Quote:

Originally Posted by

I have created a C# library containing CLR stored procedures and user-
define functions using Visual Studio 2005, and I have used Visual
Studio to deploy the assembly to a SQL Server 2005 instance
successfully, of course these sps and udfs are used by other T-SQL sps
and udfs. Now the assembly has a new version, and I want to use it to
replace the original one, but when I use Visual Studio 2005 to deploy
the new assembly, the following error occurs:
>
Error 1 Cannot drop the function 'TranslationStringLike', because
it does not exist or you do not have permission. Cannot drop the
function 'TranslateEngString', because it does not exist or you do not
have permission. Cannot drop the function 'TranslateEngStringReverse',
because it does not exist or you do not have permission. DROP ASSEMBLY
failed because 'FirmBankCLR' is referenced by object
'TranslationStringLike'. FirmBankCLR
>
That is the assembly is dependent by other objects, it can't be
dropped until it is not dependent by other objects. How can I resolve
this problem using Visual Studio 2005 or something else?

As long as the interface of the assembly does not change, you can just
do ALTER ASSEMBLY. Either specify directly, which is simple if the DLL
is accessible from SQL Server. Or specify the DLL as a hexstring directly
in the ALTER ASSEMBLY statement.

If the interface has changed, you will need to drop all functions
created from it, as well as dependent assemblies.

I learnt just the other day that ALTER ASSEMBLY is not in the repetoir
of Visual Studio. I don't use Visual Studio to work with assemblies
but stick to the command line. And all impression I get is that
using Visual Studio just makes things harder.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||

Quote:

Originally Posted by

It seems Microsoft hasn't done the job well, but if we have a lot of
objects in the assembly, the manual process of dropping and creating
them is horrible.|||Amber (guxiaobo1982@.gmail.com) writes:

Quote:

Originally Posted by

Quote:

Originally Posted by

>I learnt just the other day that ALTER ASSEMBLY is not in the repetoir
>of Visual Studio. I don't use Visual Studio to work with assemblies
>but stick to the command line. And all impression I get is that
>using Visual Studio just makes things harder.

>
It seems Microsoft hasn't done the job well, but if we have a lot of
objects in the assembly, the manual process of dropping and creating
them is horrible.

Yes, it's horrible if you have to do it each time you change the
implementation of some single method, and it's amazing that VS cannot
handle this situation.

If you change the interface, it's still a lot of work of course of dropping
and recreating objects. But it is or more less inevitable.

I don't know what's in your assemblies, but I woudl suggest that if you
have a suite of functions and procedures that are independent of each other,
that it's best to have a separate assembly for each function/procedure. Of
course, if they use a lot of common code, you still need to put that common
code in a single assembly in which case you are back to the same situation.

Sunday, February 12, 2012

ClickOnce Please Help

When having someone run my click once app that is using SQL CE they are getting this message.

The application requires that assembly System.Data.SqlServerCE Version 9.0.242.0 be installed in the global assembly cache (GAC) first

Can someone please let me know what I need to add to prerequisites?

Update on my issue. I have downloaded the development toolkit for CE and have set CE as a prerequisit. I ran click once and then published the application and downloaded it on a machine that does not have click once. The application installed and started. I went to do something that I know uses CE and I get this message Unable to load DLL sqlceme30.DLL.

|||Maybe you should have a look at this: http://msdn2.microsoft.com/en-us/library/bb219481.aspx

Friday, February 10, 2012

Clearing Assembly cache

I have several reports that worked pre-sp1. Now I receive Reporting errors
such as Data is Null, etc. I believe it may have to do with the cached
copies of the old assemblies based on the searching I have done throughout
this newsgroup. I even re-installed Report Services and didn't apply the
patch and the reports worked fine again. I require the hidden parameter
functionality of SP1.
Can someone please explain to me how to clear old assemblies?
ShawnTo clear your private assembly cache, delete the folder C:\Documents and
Settings\<username>\Local Settings\Application Data\assembly .
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> I have several reports that worked pre-sp1. Now I receive Reporting
errors
> such as Data is Null, etc. I believe it may have to do with the cached
> copies of the old assemblies based on the searching I have done throughout
> this newsgroup. I even re-installed Report Services and didn't apply the
> patch and the reports worked fine again. I require the hidden parameter
> functionality of SP1.
> Can someone please explain to me how to clear old assemblies?
> Shawn
>|||I located my Application Data folder but I do not have an "assembly" folder.
I even have all of the hidden folders showing and I don't have it?
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> To clear your private assembly cache, delete the folder C:\Documents and
> Settings\<username>\Local Settings\Application Data\assembly .
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > I have several reports that worked pre-sp1. Now I receive Reporting
> errors
> > such as Data is Null, etc. I believe it may have to do with the cached
> > copies of the old assemblies based on the searching I have done
throughout
> > this newsgroup. I even re-installed Report Services and didn't apply
the
> > patch and the reports worked fine again. I require the hidden parameter
> > functionality of SP1.
> >
> > Can someone please explain to me how to clear old assemblies?
> >
> > Shawn
> >
> >
>|||Then you don't have a private assembly cache. The problems must be due to
another reason. Could you please details about the specific problem you are
having?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> I located my Application Data folder but I do not have an "assembly"
folder.
> I even have all of the hidden folders showing and I don't have it?
>
> "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > To clear your private assembly cache, delete the folder C:\Documents and
> > Settings\<username>\Local Settings\Application Data\assembly .
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > I have several reports that worked pre-sp1. Now I receive Reporting
> > errors
> > > such as Data is Null, etc. I believe it may have to do with the
cached
> > > copies of the old assemblies based on the searching I have done
> throughout
> > > this newsgroup. I even re-installed Report Services and didn't apply
> the
> > > patch and the reports worked fine again. I require the hidden
parameter
> > > functionality of SP1.
> > >
> > > Can someone please explain to me how to clear old assemblies?
> > >
> > > Shawn
> > >
> > >
> >
> >
>|||First of all, thanks Albert for helping me with this issue.
I had the trial version of Report Services installed on my development
machine. I have account information with email addresses stored in SQL
Server 2000 SP3. I created a very basic report that consisted of a table
that displayed the account names and email addresses. Everything worked
fine in the design environment, Report Manager, and deployed it to my
asp.net application.
Due to some hidden parameter issues, I had to install RS SP1. The report
that required the fix worked great, however my Account Email does not work
anymore in the Report Manager or in my application. It does work in the
design environment though. Really strange. I have several reports with the
same issue.
I uninstalled Report Services completely and reinstalled without SP1 and
everything worked fine again. As soon as I installed SP1 the same issue
occurred. Please see the following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Data is Null. This method or property cannot be called on Null
values.
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> Then you don't have a private assembly cache. The problems must be due to
> another reason. Could you please details about the specific problem you
are
> having?
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > I located my Application Data folder but I do not have an "assembly"
> folder.
> > I even have all of the hidden folders showing and I don't have it?
> >
> >
> > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > To clear your private assembly cache, delete the folder C:\Documents
and
> > > Settings\<username>\Local Settings\Application Data\assembly .
> > >
> > > --
> > > Albert Yen
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > I have several reports that worked pre-sp1. Now I receive Reporting
> > > errors
> > > > such as Data is Null, etc. I believe it may have to do with the
> cached
> > > > copies of the old assemblies based on the searching I have done
> > throughout
> > > > this newsgroup. I even re-installed Report Services and didn't
apply
> > the
> > > > patch and the reports worked fine again. I require the hidden
> parameter
> > > > functionality of SP1.
> > > >
> > > > Can someone please explain to me how to clear old assemblies?
> > > >
> > > > Shawn
> > > >
> > > >
> > >
> > >
> >
> >
>|||Albert? Help! : )
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> First of all, thanks Albert for helping me with this issue.
> I had the trial version of Report Services installed on my development
> machine. I have account information with email addresses stored in SQL
> Server 2000 SP3. I created a very basic report that consisted of a table
> that displayed the account names and email addresses. Everything worked
> fine in the design environment, Report Manager, and deployed it to my
> asp.net application.
> Due to some hidden parameter issues, I had to install RS SP1. The report
> that required the fix worked great, however my Account Email does not work
> anymore in the Report Manager or in my application. It does work in the
> design environment though. Really strange. I have several reports with
the
> same issue.
> I uninstalled Report Services completely and reinstalled without SP1 and
> everything worked fine again. As soon as I installed SP1 the same issue
> occurred. Please see the following error:
>
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Data is Null. This method or property cannot be called on Null
> values.
>
> "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > Then you don't have a private assembly cache. The problems must be due
to
> > another reason. Could you please details about the specific problem you
> are
> > having?
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > I located my Application Data folder but I do not have an "assembly"
> > folder.
> > > I even have all of the hidden folders showing and I don't have it?
> > >
> > >
> > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > To clear your private assembly cache, delete the folder C:\Documents
> and
> > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > >
> > > > --
> > > > Albert Yen
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > I have several reports that worked pre-sp1. Now I receive
Reporting
> > > > errors
> > > > > such as Data is Null, etc. I believe it may have to do with the
> > cached
> > > > > copies of the old assemblies based on the searching I have done
> > > throughout
> > > > > this newsgroup. I even re-installed Report Services and didn't
> apply
> > > the
> > > > > patch and the reports worked fine again. I require the hidden
> > parameter
> > > > > functionality of SP1.
> > > > >
> > > > > Can someone please explain to me how to clear old assemblies?
> > > > >
> > > > > Shawn
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Did you republish your reports after installing SP1? Can you post your RDL,
or better, repro the issue against the sample databases?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Albert? Help! : )
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > First of all, thanks Albert for helping me with this issue.
> >
> > I had the trial version of Report Services installed on my development
> > machine. I have account information with email addresses stored in SQL
> > Server 2000 SP3. I created a very basic report that consisted of a
table
> > that displayed the account names and email addresses. Everything worked
> > fine in the design environment, Report Manager, and deployed it to my
> > asp.net application.
> >
> > Due to some hidden parameter issues, I had to install RS SP1. The
report
> > that required the fix worked great, however my Account Email does not
work
> > anymore in the Report Manager or in my application. It does work in the
> > design environment though. Really strange. I have several reports with
> the
> > same issue.
> >
> > I uninstalled Report Services completely and reinstalled without SP1 and
> > everything worked fine again. As soon as I installed SP1 the same issue
> > occurred. Please see the following error:
> >
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Get Online Help
> > a.. Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > a.. Data is Null. This method or property cannot be called on Null
> > values.
> >
> >
> >
> > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > Then you don't have a private assembly cache. The problems must be
due
> to
> > > another reason. Could you please details about the specific problem
you
> > are
> > > having?
> > >
> > > --
> > > Albert Yen
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > I located my Application Data folder but I do not have an "assembly"
> > > folder.
> > > > I even have all of the hidden folders showing and I don't have it?
> > > >
> > > >
> > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > To clear your private assembly cache, delete the folder
C:\Documents
> > and
> > > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > > >
> > > > > --
> > > > > Albert Yen
> > > > > SQL Server Reporting Services
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > >
> > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > I have several reports that worked pre-sp1. Now I receive
> Reporting
> > > > > errors
> > > > > > such as Data is Null, etc. I believe it may have to do with the
> > > cached
> > > > > > copies of the old assemblies based on the searching I have done
> > > > throughout
> > > > > > this newsgroup. I even re-installed Report Services and didn't
> > apply
> > > > the
> > > > > > patch and the reports worked fine again. I require the hidden
> > > parameter
> > > > > > functionality of SP1.
> > > > > >
> > > > > > Can someone please explain to me how to clear old assemblies?
> > > > > >
> > > > > > Shawn
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||I had originally designed my reports in the pre-SP1 Report services. I
reinstalled Report Services from scratch, (after a complete uninstall), then
immediately installed SP1. Once it was finished I uploaded the old reports
via the Report Manager. Please note the following RDL...
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<rd:GridSpacing>0.1in</rd:GridSpacing>
<RightMargin>0.5in</RightMargin>
<Author>Shawn Trevellick</Author>
<Body>
<ReportItems>
<Textbox Name="Title">
<Style>
<FontFamily>Verdana</FontFamily>
<FontSize>22pt</FontSize>
<TextAlign>Center</TextAlign>
<Color>DarkSlateBlue</Color>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>2</ZIndex>
<Top>0.75in</Top>
<Height>0.5in</Height>
<CanGrow>true</CanGrow>
<Value>= Globals!ReportName</Value>
</Textbox>
<Image Name="imgLogo">
<ZIndex>1</ZIndex>
<MIMEType>= Fields!LargeImageContentType.Value</MIMEType>
<Height>0.3in</Height>
<Source>Database</Source>
<Style />
<Value>=First(Fields!LargeImageData.Value, "LogoData")</Value>
<Sizing>AutoSize</Sizing>
</Image>
<Table Name="table1">
<Height>0.95in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.3in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox14">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>15</ZIndex>
<CanGrow>true</CanGrow>
<Value>Account Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>14</ZIndex>
<CanGrow>true</CanGrow>
<Value>Company Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>13</ZIndex>
<CanGrow>true</CanGrow>
<Value>Contact Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<BorderColor>
<Bottom>DarkSlateBlue</Bottom>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>None</Top>
</BorderStyle>
<VerticalAlign>Middle</VerticalAlign>
<Color>Firebrick</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>12</ZIndex>
<CanGrow>true</CanGrow>
<Value>Email Address</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.2in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox5</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox6</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Email">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextDecoration>Underline</TextDecoration>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>Email</rd:DefaultName>
<Action>
<Hyperlink>="mailto:" +
Fields!Email.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!Email.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
<Sorting>
<SortBy>
<SortExpression>=Fields!AccountName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
</Details>
<DataSetName>AccountEmailData</DataSetName>
<Top>1.5in</Top>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.2in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="AccountName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>11</ZIndex>
<rd:DefaultName>AccountName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!AccountName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CompanyName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>10</ZIndex>
<rd:DefaultName>CompanyName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!CompanyName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="FullName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>9</ZIndex>
<rd:DefaultName>FullName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!FullName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>8</ZIndex>
<rd:DefaultName>textbox11</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group1">
<Label>=Fields!AccountName.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!AccountName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>7</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>6</ZIndex>
<rd:DefaultName>textbox9</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox10</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox13</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<TableColumns>
<TableColumn>
<Width>2.1in</Width>
</TableColumn>
<TableColumn>
<Width>2.3in</Width>
</TableColumn>
<TableColumn>
<Width>2in</Width>
</TableColumn>
<TableColumn>
<Width>3.6in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2.5in</Height>
</Body>
<TopMargin>0.5in</TopMargin>
<DataSources>
<DataSource Name="MyDatasource">
<rd:DataSourceID>dd7d0594-fe10-4986-af0c-2b371fb647c3</rd:DataSourceID>
<DataSourceReference>MyDatasource</DataSourceReference>
</DataSource>
</DataSources>
<Code />
<Width>10in</Width>
<DataSets>
<DataSet Name="LogoData">
<Fields>
<Field Name="LargeImageData">
<DataField>LargeImageData</DataField>
<rd:TypeName>System.Byte[]</rd:TypeName>
</Field>
<Field Name="LargeImageContentType">
<DataField>LargeImageContentType</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>MyDatasource</DataSourceName>
<CommandText>SELECT LargeImageData, LargeImageContentType
FROM sft_Logo
WHERE (OrganizationKey = 0)</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="AccountEmailData">
<Fields>
<Field Name="AccountName">
<DataField>AccountName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CompanyName">
<DataField>CompanyName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="FullName">
<DataField>FullName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Email">
<DataField>Email</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>MyDatasource</DataSourceName>
<CommandText>SELECT bus_Account.AccountName,
bus_Account.CompanyName, bus_Account.LastName + N', ' +
bus_Account.FirstName AS FullName,
bus_Account_Email.Email
FROM bus_Account INNER JOIN
bus_Account_Email ON bus_Account.AccountID =bus_Account_Email.AccountID</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>0.5in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<PageHeight>8.5in</PageHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<Description>This report details the email addresses for the accounts in
the system.</Description>
<PageWidth>11in</PageWidth>
<rd:ReportID>0965746d-9b59-46d8-b847-6f031c160d74</rd:ReportID>
<PageFooter>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<FontStyle>Italic</FontStyle>
<TextAlign>Right</TextAlign>
<Color>DarkSlateBlue</Color>
</Style>
<ZIndex>3</ZIndex>
<Top>0.10438in</Top>
<Height>0.2in</Height>
<Width>3in</Width>
<Value>="Page " & Globals!PageNumber & " of " &
Globals!TotalPages</Value>
<Left>6.95in</Left>
</Textbox>
<Textbox Name="FooterCompany">
<Style>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<FontStyle>Italic</FontStyle>
<TextAlign>Left</TextAlign>
<Color>DarkSlateBlue</Color>
</Style>
<ZIndex>2</ZIndex>
<Top>0.10438in</Top>
<Height>0.2in</Height>
<Width>3in</Width>
<Value>="Administrative Report: " & Globals!ReportName</Value>
<Left>0.05in</Left>
</Textbox>
<Textbox Name="FooterDate">
<Style>
<PaddingLeft>0in</PaddingLeft>
<Format>D</Format>
<BackgroundColor>White</BackgroundColor>
<BorderColor>
<Default>#000000</Default>
</BorderColor>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<FontStyle>Italic</FontStyle>
<TextAlign>Center</TextAlign>
<Color>DarkSlateBlue</Color>
<PaddingBottom>0in</PaddingBottom>
<PaddingTop>0in</PaddingTop>
<PaddingRight>0in</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<Top>0.10438in</Top>
<Height>0.2in</Height>
<Width>3.9in</Width>
<Value>="Reporting Date: " & Globals.ExecutionTime</Value>
<Left>3.05in</Left>
</Textbox>
<Line Name="line1">
<Top>0.05396in</Top>
<Height>0in</Height>
<Style>
<BorderColor>
<Default>Firebrick</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Line>
</ReportItems>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style />
<Height>0.4in</Height>
</PageFooter>
<BottomMargin>0.5in</BottomMargin>
<Language>en-US</Language>
</Report>
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:%2383rd72aEHA.3692@.TK2MSFTNGP09.phx.gbl...
> Did you republish your reports after installing SP1? Can you post your
RDL,
> or better, repro the issue against the sample databases?
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > Albert? Help! : )
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > > First of all, thanks Albert for helping me with this issue.
> > >
> > > I had the trial version of Report Services installed on my development
> > > machine. I have account information with email addresses stored in
SQL
> > > Server 2000 SP3. I created a very basic report that consisted of a
> table
> > > that displayed the account names and email addresses. Everything
worked
> > > fine in the design environment, Report Manager, and deployed it to my
> > > asp.net application.
> > >
> > > Due to some hidden parameter issues, I had to install RS SP1. The
> report
> > > that required the fix worked great, however my Account Email does not
> work
> > > anymore in the Report Manager or in my application. It does work in
the
> > > design environment though. Really strange. I have several reports
with
> > the
> > > same issue.
> > >
> > > I uninstalled Report Services completely and reinstalled without SP1
and
> > > everything worked fine again. As soon as I installed SP1 the same
issue
> > > occurred. Please see the following error:
> > >
> > >
> > > Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown. (rrRenderingError) Get Online Help
> > > a.. Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown.
> > > a.. Data is Null. This method or property cannot be called on Null
> > > values.
> > >
> > >
> > >
> > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > > Then you don't have a private assembly cache. The problems must be
> due
> > to
> > > > another reason. Could you please details about the specific problem
> you
> > > are
> > > > having?
> > > >
> > > > --
> > > > Albert Yen
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > > I located my Application Data folder but I do not have an
"assembly"
> > > > folder.
> > > > > I even have all of the hidden folders showing and I don't have it?
> > > > >
> > > > >
> > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
message
> > > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > > To clear your private assembly cache, delete the folder
> C:\Documents
> > > and
> > > > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > > > >
> > > > > > --
> > > > > > Albert Yen
> > > > > > SQL Server Reporting Services
> > > > > >
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > > > rights.
> > > > > >
> > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
message
> > > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > > I have several reports that worked pre-sp1. Now I receive
> > Reporting
> > > > > > errors
> > > > > > > such as Data is Null, etc. I believe it may have to do with
the
> > > > cached
> > > > > > > copies of the old assemblies based on the searching I have
done
> > > > > throughout
> > > > > > > this newsgroup. I even re-installed Report Services and
didn't
> > > apply
> > > > > the
> > > > > > > patch and the reports worked fine again. I require the hidden
> > > > parameter
> > > > > > > functionality of SP1.
> > > > > > >
> > > > > > > Can someone please explain to me how to clear old assemblies?
> > > > > > >
> > > > > > > Shawn
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||The problem is probably caused by the expression for the MIMEType of
imgLogo. This expression should be enclosed in the First() aggregate as it
is outside the scope of any dataregion, e.g.
=First(Fields!LargeImageContentType.Value, "LogoData")
Also make sure that the value returned from the expression is a supported
MIME type and does not have leading or trailing blanks.
The message you received is due to a problem on our part. We found that you
get this exception whenever the MIMEType expression cannot be evaluated or
is a not valid MIME type. We'll look at fixing this in a future release.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
news:#SADNL3aEHA.3820@.tk2msftngp13.phx.gbl...
> I had originally designed my reports in the pre-SP1 Report services. I
> reinstalled Report Services from scratch, (after a complete uninstall),
then
> immediately installed SP1. Once it was finished I uploaded the old
reports
> via the Report Manager. Please note the following RDL...
>
> "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> news:%2383rd72aEHA.3692@.TK2MSFTNGP09.phx.gbl...
> > Did you republish your reports after installing SP1? Can you post your
> RDL,
> > or better, repro the issue against the sample databases?
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > > Albert? Help! : )
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > > > First of all, thanks Albert for helping me with this issue.
> > > >
> > > > I had the trial version of Report Services installed on my
development
> > > > machine. I have account information with email addresses stored in
> SQL
> > > > Server 2000 SP3. I created a very basic report that consisted of a
> > table
> > > > that displayed the account names and email addresses. Everything
> worked
> > > > fine in the design environment, Report Manager, and deployed it to
my
> > > > asp.net application.
> > > >
> > > > Due to some hidden parameter issues, I had to install RS SP1. The
> > report
> > > > that required the fix worked great, however my Account Email does
not
> > work
> > > > anymore in the Report Manager or in my application. It does work in
> the
> > > > design environment though. Really strange. I have several reports
> with
> > > the
> > > > same issue.
> > > >
> > > > I uninstalled Report Services completely and reinstalled without SP1
> and
> > > > everything worked fine again. As soon as I installed SP1 the same
> issue
> > > > occurred. Please see the following error:
> > > >
> > > >
> > > > Exception of type
> > > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was
> > > > thrown. (rrRenderingError) Get Online Help
> > > > a.. Exception of type
> > > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was
> > > > thrown.
> > > > a.. Data is Null. This method or property cannot be called on
Null
> > > > values.
> > > >
> > > >
> > > >
> > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > > > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > > > Then you don't have a private assembly cache. The problems must
be
> > due
> > > to
> > > > > another reason. Could you please details about the specific
problem
> > you
> > > > are
> > > > > having?
> > > > >
> > > > > --
> > > > > Albert Yen
> > > > > SQL Server Reporting Services
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > >
> > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > > > I located my Application Data folder but I do not have an
> "assembly"
> > > > > folder.
> > > > > > I even have all of the hidden folders showing and I don't have
it?
> > > > > >
> > > > > >
> > > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
> message
> > > > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > > > To clear your private assembly cache, delete the folder
> > C:\Documents
> > > > and
> > > > > > > Settings\<username>\Local Settings\Application Data\assembly .
> > > > > > >
> > > > > > > --
> > > > > > > Albert Yen
> > > > > > > SQL Server Reporting Services
> > > > > > >
> > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > > > rights.
> > > > > > >
> > > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
> message
> > > > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > > > I have several reports that worked pre-sp1. Now I receive
> > > Reporting
> > > > > > > errors
> > > > > > > > such as Data is Null, etc. I believe it may have to do with
> the
> > > > > cached
> > > > > > > > copies of the old assemblies based on the searching I have
> done
> > > > > > throughout
> > > > > > > > this newsgroup. I even re-installed Report Services and
> didn't
> > > > apply
> > > > > > the
> > > > > > > > patch and the reports worked fine again. I require the
hidden
> > > > > parameter
> > > > > > > > functionality of SP1.
> > > > > > > >
> > > > > > > > Can someone please explain to me how to clear old
assemblies?
> > > > > > > >
> > > > > > > > Shawn
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||YAY!!!! Thank you!! That was driving me nuts! I made the changes and it
worked again.
I really appreciate you helping me Albert
"Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
news:eiQW5B5aEHA.3352@.TK2MSFTNGP10.phx.gbl...
> The problem is probably caused by the expression for the MIMEType of
> imgLogo. This expression should be enclosed in the First() aggregate as
it
> is outside the scope of any dataregion, e.g.
> =First(Fields!LargeImageContentType.Value, "LogoData")
> Also make sure that the value returned from the expression is a supported
> MIME type and does not have leading or trailing blanks.
> The message you received is due to a problem on our part. We found that
you
> get this exception whenever the MIMEType expression cannot be evaluated or
> is a not valid MIME type. We'll look at fixing this in a future release.
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> news:#SADNL3aEHA.3820@.tk2msftngp13.phx.gbl...
> > I had originally designed my reports in the pre-SP1 Report services. I
> > reinstalled Report Services from scratch, (after a complete uninstall),
> then
> > immediately installed SP1. Once it was finished I uploaded the old
> reports
> > via the Report Manager. Please note the following RDL...
> >
> > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in message
> > news:%2383rd72aEHA.3692@.TK2MSFTNGP09.phx.gbl...
> > > Did you republish your reports after installing SP1? Can you post
your
> > RDL,
> > > or better, repro the issue against the sample databases?
> > >
> > > --
> > > Albert Yen
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > news:ukZMn#1aEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > > > Albert? Help! : )
> > > >
> > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in message
> > > > news:%23$7xk2qaEHA.2216@.TK2MSFTNGP10.phx.gbl...
> > > > > First of all, thanks Albert for helping me with this issue.
> > > > >
> > > > > I had the trial version of Report Services installed on my
> development
> > > > > machine. I have account information with email addresses stored
in
> > SQL
> > > > > Server 2000 SP3. I created a very basic report that consisted of
a
> > > table
> > > > > that displayed the account names and email addresses. Everything
> > worked
> > > > > fine in the design environment, Report Manager, and deployed it to
> my
> > > > > asp.net application.
> > > > >
> > > > > Due to some hidden parameter issues, I had to install RS SP1. The
> > > report
> > > > > that required the fix worked great, however my Account Email does
> not
> > > work
> > > > > anymore in the Report Manager or in my application. It does work
in
> > the
> > > > > design environment though. Really strange. I have several
reports
> > with
> > > > the
> > > > > same issue.
> > > > >
> > > > > I uninstalled Report Services completely and reinstalled without
SP1
> > and
> > > > > everything worked fine again. As soon as I installed SP1 the same
> > issue
> > > > > occurred. Please see the following error:
> > > > >
> > > > >
> > > > > Exception of type
> > > > >
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> > was
> > > > > thrown. (rrRenderingError) Get Online Help
> > > > > a.. Exception of type
> > > > >
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> > was
> > > > > thrown.
> > > > > a.. Data is Null. This method or property cannot be called on
> Null
> > > > > values.
> > > > >
> > > > >
> > > > >
> > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
message
> > > > > news:%23P2v4iqaEHA.524@.TK2MSFTNGP09.phx.gbl...
> > > > > > Then you don't have a private assembly cache. The problems must
> be
> > > due
> > > > to
> > > > > > another reason. Could you please details about the specific
> problem
> > > you
> > > > > are
> > > > > > having?
> > > > > >
> > > > > > --
> > > > > > Albert Yen
> > > > > > SQL Server Reporting Services
> > > > > >
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > > > rights.
> > > > > >
> > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
message
> > > > > > news:OfDeEBnaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> > > > > > > I located my Application Data folder but I do not have an
> > "assembly"
> > > > > > folder.
> > > > > > > I even have all of the hidden folders showing and I don't have
> it?
> > > > > > >
> > > > > > >
> > > > > > > "Albert Yen [MSFT]" <alberty@.online.microsoft.com> wrote in
> > message
> > > > > > > news:OKLp4DfaEHA.3016@.tk2msftngp13.phx.gbl...
> > > > > > > > To clear your private assembly cache, delete the folder
> > > C:\Documents
> > > > > and
> > > > > > > > Settings\<username>\Local Settings\Application Data\assembly
.
> > > > > > > >
> > > > > > > > --
> > > > > > > > Albert Yen
> > > > > > > > SQL Server Reporting Services
> > > > > > > >
> > > > > > > > This posting is provided "AS IS" with no warranties, and
> confers
> > > no
> > > > > > > rights.
> > > > > > > >
> > > > > > > > "Shawn Trevellick" <shawntrevellick@.hotmail.com> wrote in
> > message
> > > > > > > > news:#eGmdhRaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> > > > > > > > > I have several reports that worked pre-sp1. Now I receive
> > > > Reporting
> > > > > > > > errors
> > > > > > > > > such as Data is Null, etc. I believe it may have to do
with
> > the
> > > > > > cached
> > > > > > > > > copies of the old assemblies based on the searching I have
> > done
> > > > > > > throughout
> > > > > > > > > this newsgroup. I even re-installed Report Services and
> > didn't
> > > > > apply
> > > > > > > the
> > > > > > > > > patch and the reports worked fine again. I require the
> hidden
> > > > > > parameter
> > > > > > > > > functionality of SP1.
> > > > > > > > >
> > > > > > > > > Can someone please explain to me how to clear old
> assemblies?
> > > > > > > > >
> > > > > > > > > Shawn
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Sunday, March 11, 2012

CLR Trigger Error: Could not find Type xxxx in Assembly

Thursday, March 8, 2012

CLR integration - Could not find Type '?' in assembly '?'.

Wednesday, March 7, 2012

CLR Assembly redeploy problem.

Sunday, February 12, 2012

ClickOnce Please Help

Friday, February 10, 2012

Clearing Assembly cache

Clearing LOG Files

Blog Archive

About Me