Cluster Active-Active - Parallelism

Cluster active-active enviroment.
Memory: How can I determine how much memory I need to set ? If I leave
dynamically and one node falls down I receive message error about allocate
memory.
CPU: Processor - Parallelism - Use all available processors. There are 2
processors on each server. In this case I can set this option ON ? If the one
node falls down SQLserver will try to use 2 or 4 processors ?
thanks in advance
set max server memory on both servers so that fail over of either server does
not result in total memory greater than total server memory on each box.
Also with cpu if you have configured to use all available cpus then all
available cpus will be utilized. ie. sql will use only the number of
processors on the server.
HTH
"Shima" wrote:

> Cluster active-active enviroment.
> Memory: How can I determine how much memory I need to set ? If I leave
> dynamically and one node falls down I receive message error about allocate
> memory.
> CPU: Processor - Parallelism - Use all available processors. There are 2
> processors on each server. In this case I can set this option ON ? If the one
> node falls down SQLserver will try to use 2 or 4 processors ?
> thanks in advance
>
|||It is useful that resurces used by instances, does not be greater than one
node...
I
"Olu Adedeji" wrote:
[vbcol=seagreen]
> set max server memory on both servers so that fail over of either server does
> not result in total memory greater than total server memory on each box.
> Also with cpu if you have configured to use all available cpus then all
> available cpus will be utilized. ie. sql will use only the number of
> processors on the server.
>
> HTH
>
> "Shima" wrote:

Cluster Active-Active - Parallelism

Cluster active-active enviroment.
Memory: How can I determine how much memory I need to set ? If I leave
dynamically and one node falls down I receive message error about allocate
memory.
CPU: Processor - Parallelism - Use all available processors. There are 2
processors on each server. In this case I can set this option ON ? If the on
e
node falls down SQLserver will try to use 2 or 4 processors ?
thanks in advanceset max server memory on both servers so that fail over of either server doe
s
not result in total memory greater than total server memory on each box.
Also with cpu if you have configured to use all available cpus then all
available cpus will be utilized. ie. sql will use only the number of
processors on the server.
HTH
"Shima" wrote:

> Cluster active-active enviroment.
> Memory: How can I determine how much memory I need to set ? If I leave
> dynamically and one node falls down I receive message error about allocate
> memory.
> CPU: Processor - Parallelism - Use all available processors. There are 2
> processors on each server. In this case I can set this option ON ? If the
one
> node falls down SQLserver will try to use 2 or 4 processors ?
> thanks in advance
>|||It is useful that resurces used by instances, does not be greater than one
node...
I
"Olu Adedeji" wrote:
[vbcol=seagreen]
> set max server memory on both servers so that fail over of either server d
oes
> not result in total memory greater than total server memory on each box.
> Also with cpu if you have configured to use all available cpus then all
> available cpus will be utilized. ie. sql will use only the number of
> processors on the server.
>
> HTH
>
> "Shima" wrote:
>sqlsql

Clue - Who dun it? The Data Adapter, DataSet, SqlSelect etc...

Ok, I know my connection string and config file are good. Once the rest of the code is added I receive this error:

"SQL Server does not exist or access denied. "

I'm using the 1.1 framework and my hosting company provides MSSql 2005.

Thanks for your time,

Charlie

Here's the code in my cond behind file.

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

namespace blog

{

/// <summary>

/// Summary description for WebForm1.

/// </summary>

public class WebForm1 : System.Web.UI.Page

{

protected System.Data.SqlClient.SqlConnection sqlConnect;

protected System.Web.UI.WebControls.DataList dList;

protected System.Data.SqlClient.SqlDataAdapter DA;

protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;

protected System.Web.UI.WebControls.LinkButton linkAdmin;

protected System.Web.UI.WebControls.Image header;

protected blog.DS ds1;

private void Page_Load(object sender, System.EventArgs e)

{

DA.Fill(ds1, "blogEntry");

dList.DataBind();

}

#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: This call is required by the ASP.NET Web Form Designer.

//

InitializeComponent();

base.OnInit(e);

}

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.sqlConnect = new System.Data.SqlClient.SqlConnection();

this.DA = new System.Data.SqlClient.SqlDataAdapter();

this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();

this.ds1 = new blog.DS();

((System.ComponentModel.ISupportInitialize)(this.ds1)).BeginInit();

this.linkAdmin.Click += new System.EventHandler(this.linkAdmin_Click);

//

// sqlConnection String

//////////////////webserver////////////////

this.sqlConnection1.ConnectionString = "Server=xxx.xxx.xxx.x;Database=myDataBase;User ID=myID;Password=myPass";

//////////////////local///////////////////

//this.sqlConnect.ConnectionString = "workstation id=HAL;packet size=4096;integrated security=SSPI;data source=HAL;pers" +

//"ist security info=False;initial catalog=blog";

//

// DA

//

this.DA.SelectCommand = this.sqlSelectCommand1;

this.DA.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {

new System.Data.Common.DataTableMapping("Table", "blogEntry", new System.Data.Common.DataColumnMapping[] {

new System.Data.Common.DataColumnMapping("bodyID", "bodyID"),

new System.Data.Common.DataColumnMapping("linkID", "linkID")})});

//

// sqlSelectCommand1

//

this.sqlSelectCommand1.CommandText = "SELECT id, wxID, dateID, titleID, bodyID, linkID FROM blogEntry ORDER BY id DESC";

this.sqlSelectCommand1.Connection = this.sqlConnect;

//

// ds1

//

this.ds1.DataSetName = "DS";

this.ds1.Locale = new System.Globalization.CultureInfo("en-US");

this.Load += new System.EventHandler(this.Page_Load);

((System.ComponentModel.ISupportInitialize)(this.ds1)).EndInit();

}

#endregion

private void linkAdmin_Click(object sender, System.EventArgs e)

{

Server.Transfer("logOn.aspx",true);

}

}

}

fatthippo:

Ok, I know my connection string and config file are good. Once the rest of the code is added I receive this error:

"SQL Server does not exist or access denied. "

If you are receiving that error, it generally means that your connection string is NOT good. Check out this KB article:Potential causes of the "SQL Server does not exist or access denied" error message.

|||

That string was pasted in from another page on the same host. It works fine there. Why should I not assume that it's good?

|||

Hello,

Something I just noticed in the stack trace.

 
 blog.WebForm1.Page_Load(Object sender, EventArgs e)in c:\inetpub\wwwroot\blog\index.aspx.cs:31
 

 this is still referencing my local machine. How can I change this?

|||

Hi,

From your code, I can see your connection string is:

Server=xxx.xxx.xxx.x;Database=myDataBase;User ID=myID;Password=myPass

Please check if your server address is correct. Is the SQL server you're connecting to a default instance or a named instance. If a named instance, please try to use Server=xxx.xxx.xxx.xxx\InstanceName

also, please check the login name and password. You can try to create a .udl file for testing. Here are the steps:

1. Create a Text file.
2. Rename it to .udl
3. Double click on the file, and test in the Data Link Properties window.

HTH.

|||

I believe I found the issue. This being my first attempt to host a .net web app on a ISP, it didn't occur to me that modifying the connection string in the provided online text editor wouldn't be sufficient. Simply put, I needed to recompile my app.

Thank-you all for your support.

Fatthippo

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
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>