ClubSite template + sql server 2005 not cooperating...

I've managed to get the clubsite template from asp.net up and running, sorda (http://www.flysniper.com), I get a system error which I believe is related to the fact that my DB isn't working correctly.

I'm trying to configure it to work with ms sql server 2005 which is running on the same machine as the website.

I've followed the instructions of Scott Gu (http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx)

while trying to run aspnet_regsql.exe I get the following error

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -S XXXXXXXXXX
-U YYYYYYYY -P ZZZZZZZZZ -A all -d flysniper

Start adding the following features:
Membership
Profile
RoleManager
Personalization
SqlWebEventProvider

.................
An error has occurred. Details of the exception:
An error has occurred while establishing a connection to the server. When conne
cting to SQL Server 2005, this failure may be caused by the fact that under the
default settings SQL Server does not allow remote connections. (provider: Named
Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Unable to connect to SQL Server database.

I have tried several different things (shooting in the dark) to resolve this issue, including:

verifing that port 445 is avaliable on the firewall per these directions:http://support.microsoft.com/default.aspx?scid=kb;en-us;839269

configured SQL server 2005 to allow remote connections following these directions:http://support.microsoft.com/kb/914277

with no change in results.

Anything else I should look into?

Thanks in advance,

Mike

I get that message when I forget to start sql server before trying to connect to the website.

|||

LockH - thanks for your response, I have confirmed that the SQL Service is up and running.

UPDATE: I have managed to get the aspnet_regsql.exe to run and the tables are created.

I have tried to set the connection string up correctly: <addname="ClubSiteDB"connectionString="Data Source=StormTrooper\FlySniper;Initial Catalog=FlySniperDev;Persist Security Info=True;User ID=XXXXXXXXXXXXX;Password=YYYYYYYYYYYY;"providerName="System.Data.SqlClient"/>

I think its just a switch somewhere that I'm missing.

I have set up a developer website for testing purposes, please usehttp://dev.flysniper.com/flysniperClubSite to see the actual error.

TIA,

Mike

|||

Did you create the tables in the database on the server, or did you copy the database files from your dev machine?

If you copied the database files onto that machine, did you go into database admin and attach the database files to that server?

|||

The tables were created directly on the server. It's my personal machine so I have direct access to it.

Thanks for you time,

Mike

CLR and SQL 2005 Compact Edition

I believe that there is a also a new SQL database for the PDA. Am I right? Is it also possible to use (CF) .Net code inside this edition?

Yes. It's called SQL Server 2005 Mobile Edition. This works on Windows Mobile devices (PocketPC and SmartPhone). You need to install .NETCF 2.0 (compact framework) on the device for using SQL Mobile.

You can develop mobile applications using Visual Studio for Devices.

SQL Mobile is part of SQL Server 2005 or Visual Studio 2005.

You can get more information here:

The SQL Mobile page on MSDN : http://msdn.microsoft.com/mobility/sqlmobile/default.aspx

SQL Mobile page from SQL Server home: http://www.microsoft.com/sql/editions/sqlmobile/default.mspx

News groups: microsoft.public.sqlserver.ce. and

Msdn forums: You will find SQL Mobile under SQL Server: http://forums.microsoft.com/msdn/default.aspx?forumgroupid=19&siteid=1

|||But can you also create UDF en UDT with .Net like the desktop editions?|||SQL Mobile does not support UDT or UDF. Also the CLR is not inside SQL Mobile database. The programming model is different.

Simply stated:
SQL Mobile components is a bunch of dlls that are linked in your device application project. So the database routines are embedded in your application code.

You declare some variables, structures
Application logic - pre data processing
query, modify, delete data from SQL Mobile
Application logic - post data processing

Clearing parameter input

Hi everyone,

I have a question that I believe should be simple to answer yet I cannot find the answer anywhere. I am trying to make it possible for my report to clear the input box whenever the report is run or when anything in a dropdown list is selected. The reason why I want this is because my report has a dropdown list that inputs date ranges for "quick" report info. The other option is to manually type in the begin and end date. If anyone could help me out with this I would be very grateful.

Thanks,

Roy

Visual Studio 2005 makes this quite simple. However, you may be able to accomplish this using custom code in BIS, but I'm not sure how.|||

Thanks for the reply but I still don't userstand how it can be done in Visual Studio 2005. What does BIS stand for?

Thanks,

Roy

|||

Business Intelligence Studio.

Have you developed a front-end for your reports and used dropdownlists in a windows or web application?

Or are you just using a multivalue parameter in business intelligence studio?

|||

Ah ok thanks. There will be no front-end for the reports because the end-user will access the Reports Server using a link from our company intranet site. Permissions will be given based on department, etc. I am not using a mutlivalue parameter. The report gives financial information (sales, etc) based on the date range. The first dropdown gives you predetermined ranges (yesterday, month to day, etc) and also a "Custom" option. The "Custom" option gives the user the ability to fill in the other two boxes with their desired date range. The problem that lies here is sometimes the end user will select a predetermined range like yesterday. So the dropdown stays on "yesterday". Then they might decide they need to put in a custom date range. They forget to change the dropdown to Custom first. Now when they click "View Report" the end result will be yesterday's information which leads to misinformation because of operator error. I want to prevent this. A couple of ways this can be done is:

1) when any of the predetermined options are selected, the two other fill-in boxes are greyed out. (cant find out how to do this)

2) when clicking a predetermined option, the two fill-in boxes are cleared so there is no confusion (not the best method but can't do no 1 so will stick with this one)

Thanks again,

Roy

|||

Anyone have any ideas? Any help would be appreciated.

Thanks!

|||

>>Anyone have any ideas

Um, yes, I do.

If you don't want to develop your own parameter-handling interface, and if the parameters have bearing on one another, the prompts should say so. They need to reflect what your code is doing (presumably ignoring the dates unless "Custom").

So, for example, instead of FromDate and ToDate you can say

FromDate for Custom Range:

ToDate for Custom Range:

... or even more explicit:

FromDate (used for Custom Range only):

ToDate (used for Custom Range only):

... and for your drop down you might also change the prompts in the dropdown.

Yesterday

Month To Date

Custom Range From Date Input

... kind of a pain the way the default interface will arrange your params, and not fool proof, but you are giving the user the information they need to understand what will happen when they make choices.

>L<

Clearing parameter input

Hi everyone,

I have a question that I believe should be simple to answer yet I cannot find the answer anywhere. I am trying to make it possible for my report to clear the input box whenever the report is run or when anything in a dropdown list is selected. The reason why I want this is because my report has a dropdown list that inputs date ranges for "quick" report info. The other option is to manually type in the begin and end date. If anyone could help me out with this I would be very grateful.

Thanks,

Roy

Visual Studio 2005 makes this quite simple. However, you may be able to accomplish this using custom code in BIS, but I'm not sure how.|||

Thanks for the reply but I still don't userstand how it can be done in Visual Studio 2005. What does BIS stand for?

Thanks,

Roy

|||

Business Intelligence Studio.

Have you developed a front-end for your reports and used dropdownlists in a windows or web application?

Or are you just using a multivalue parameter in business intelligence studio?

|||

Ah ok thanks. There will be no front-end for the reports because the end-user will access the Reports Server using a link from our company intranet site. Permissions will be given based on department, etc. I am not using a mutlivalue parameter. The report gives financial information (sales, etc) based on the date range. The first dropdown gives you predetermined ranges (yesterday, month to day, etc) and also a "Custom" option. The "Custom" option gives the user the ability to fill in the other two boxes with their desired date range. The problem that lies here is sometimes the end user will select a predetermined range like yesterday. So the dropdown stays on "yesterday". Then they might decide they need to put in a custom date range. They forget to change the dropdown to Custom first. Now when they click "View Report" the end result will be yesterday's information which leads to misinformation because of operator error. I want to prevent this. A couple of ways this can be done is:

1) when any of the predetermined options are selected, the two other fill-in boxes are greyed out. (cant find out how to do this)

2) when clicking a predetermined option, the two fill-in boxes are cleared so there is no confusion (not the best method but can't do no 1 so will stick with this one)

Thanks again,

Roy

|||

Anyone have any ideas? Any help would be appreciated.

Thanks!

|||

>>Anyone have any ideas

Um, yes, I do.

If you don't want to develop your own parameter-handling interface, and if the parameters have bearing on one another, the prompts should say so. They need to reflect what your code is doing (presumably ignoring the dates unless "Custom").

So, for example, instead of FromDate and ToDate you can say

FromDate for Custom Range:

ToDate for Custom Range:

... or even more explicit:

FromDate (used for Custom Range only):

ToDate (used for Custom Range only):

... and for your drop down you might also change the prompts in the dropdown.

Yesterday

Month To Date

Custom Range From Date Input

... kind of a pain the way the default interface will arrange your params, and not fool proof, but you are giving the user the information they need to understand what will happen when they make choices.

>L<

Clearing parameter input

Hi everyone,

I have a question that I believe should be simple to answer yet I cannot find the answer anywhere. I am trying to make it possible for my report to clear the input box whenever the report is run or when anything in a dropdown list is selected. The reason why I want this is because my report has a dropdown list that inputs date ranges for "quick" report info. The other option is to manually type in the begin and end date. If anyone could help me out with this I would be very grateful.

Thanks,

Roy

Visual Studio 2005 makes this quite simple. However, you may be able to accomplish this using custom code in BIS, but I'm not sure how.|||

Thanks for the reply but I still don't userstand how it can be done in Visual Studio 2005. What does BIS stand for?

Thanks,

Roy

|||

Business Intelligence Studio.

Have you developed a front-end for your reports and used dropdownlists in a windows or web application?

Or are you just using a multivalue parameter in business intelligence studio?

|||

Ah ok thanks. There will be no front-end for the reports because the end-user will access the Reports Server using a link from our company intranet site. Permissions will be given based on department, etc. I am not using a mutlivalue parameter. The report gives financial information (sales, etc) based on the date range. The first dropdown gives you predetermined ranges (yesterday, month to day, etc) and also a "Custom" option. The "Custom" option gives the user the ability to fill in the other two boxes with their desired date range. The problem that lies here is sometimes the end user will select a predetermined range like yesterday. So the dropdown stays on "yesterday". Then they might decide they need to put in a custom date range. They forget to change the dropdown to Custom first. Now when they click "View Report" the end result will be yesterday's information which leads to misinformation because of operator error. I want to prevent this. A couple of ways this can be done is:

1) when any of the predetermined options are selected, the two other fill-in boxes are greyed out. (cant find out how to do this)

2) when clicking a predetermined option, the two fill-in boxes are cleared so there is no confusion (not the best method but can't do no 1 so will stick with this one)

Thanks again,

Roy

|||

Anyone have any ideas? Any help would be appreciated.

Thanks!

|||

>>Anyone have any ideas

Um, yes, I do.

If you don't want to develop your own parameter-handling interface, and if the parameters have bearing on one another, the prompts should say so. They need to reflect what your code is doing (presumably ignoring the dates unless "Custom").

So, for example, instead of FromDate and ToDate you can say

FromDate for Custom Range:

ToDate for Custom Range:

... or even more explicit:

FromDate (used for Custom Range only):

ToDate (used for Custom Range only):

... and for your drop down you might also change the prompts in the dropdown.

Yesterday

Month To Date

Custom Range From Date Input

... kind of a pain the way the default interface will arrange your params, and not fool proof, but you are giving the user the information they need to understand what will happen when they make choices.

>L<

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