Showing posts with label services. Show all posts
Showing posts with label services. Show all posts

Friday, March 30, 2012

Problems integrating reporting services into a web app

Hello

I have an existing web app on my web server, and reporting services on my app server. I'm trying to integrate the reports into the web app.

The problem is, when the user clicks 'execute report', the app, predictably, falls over, because the aspx page thinks it's on the same server as reporting services, whereas it's not.

Does anybody know how these requests from the aspx page can be redirected to a different server? The way I see it, if I can't get the integration working through url access, I'll have to use the soap api, which will involve dynamically creating drop downs for the report parameters, etc, which is moving away from utilising the advantages that reporting services brings!

Any thoughts would be greatly appreciated.

Thanks in advance
Dominic

Hi Dominic,

this article will help you embed the report in your web application:
http://msdn2.microsoft.com/en-us/library/ms153563.aspx

regards
Helen|||

Thanks for the reply helen. My problem is that in our architecture the client can't access the report server directly. I've decided to go with the reportviewer control instead.

Cheers

Dominic

Problems instancing Reporting Services

I set up Reporting Services as a Web Reference and when I try to instance it, I get a "type expected" error message. Let's say the web reference is named SQLRS. When I do a DIM rs as NEW SQLRS, a blue squiggly appears under SQLRS and it displays the type expected error message.

What am I missing? Anyone know or have a link to an example I could look at? Thanks for any help.Additional information:

When I bring up the Reporting Services as a web reference, I don't get a drop down list of the methods and properties that are listed in the Add a Web Reference dialogue box and from what I've seen in examples online. For instance, there should be a ListChildren method, but I don't see it when intellisense kicks in.

Example: Let's say I name the web service ReportingService. If I try to instance it by going DIM rs as NEW ReportingService, I get the blue squiggly line complaining that "Type expected". If I type ReportingService. intellisense kicks in, but what appears in the drop down box is not what I expect. There are no ListChildren, ListEvents, ListJobs, etc.

What I suspect is that I need to DIM the ReportingService with one of the selections from the intellisense dropdown box, but I have no idea which one as all the examples I've seen online show differently. Has there been changes to this with service pack 2 that I'm not aware of? Any help would be appreciated.|||Ok, I just love answering my own questions.

It turns out that all the examples I've been trying to follow are a bit off. To create an instance of the Reporting Services as a web service, first add the web service as a web reference to your project. (i.e., right click on references in the solution explorer and type in the web address of the reporting services: http://myserver/ReportServer/ReportService.asmx)

Then, to create an instance, use something like:

DIM rs as NEW ReportingService.ReportingService

Now you will have an object called rs that will have the properties and methods of the ReportingService web service such as ListChildren, ListJobs, Render, etc.

Problems installing SSRS on web server

Hi gang -
I've just recently begun playing around with SQL Server Reporting
Services (SSRS), and I was blown away by it. I had no problem
installing it to my development machine (XP Pro, IIS 6, SQL Server 2000
Dev Ed), but I'm having a lot of trouble setting it up in the
production environment.
I am incredibly frustrated by the documentation on this, and from what
I've seen, no one else has had this problem.
When I'm attempting to install to the first WEB SERVER(IIS 5.0), I get
a warning message during the install that I don't have the Visual
Studio IDE installed (which shouldn't be a problem--I mean, hey, it's a
server, right?). Fine.
The next page or so is the list of which components you want to
install--and Tada, NO SERVER COMPONENTS are in the list. The first time
this happened, I shrugged, and went through the rest of the set up
process. I didn't recieve any of the other setup pages (virtual
directories, SQL Server connection info, etc). It ended up installing a
handful of other dlls (everything under the client components branch
was available for install).
Stumped? I am.
Here's the last little bit of info: I'm attempting to install this
software over a terminal connection. The servers are co-located, and I
was hopeing to install this without taking the neccessary road trip. I
doubt this is the problem, but hey, you never know.
If anyone else has experienced this problem and has a resolution,
please, please let me know.
Thanks much,
Mark S. Milley, MCADI have found a post that had a similar problem until they upgrade to
SP4 on the web server. I'm going to see if that corrects the problem.
In addition, there is no Default Web Site on the server, however, my
symptoms so far are different than what others have experienced. I'll
keep you posted...|||Ignore warning about VS, that is only for development tools, not production.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Milley - BinarySwitch" <mark.milley@.binaryswitch.com> wrote in message
news:1126879087.836704.12350@.z14g2000cwz.googlegroups.com...
> Hi gang -
> I've just recently begun playing around with SQL Server Reporting
> Services (SSRS), and I was blown away by it. I had no problem
> installing it to my development machine (XP Pro, IIS 6, SQL Server 2000
> Dev Ed), but I'm having a lot of trouble setting it up in the
> production environment.
> I am incredibly frustrated by the documentation on this, and from what
> I've seen, no one else has had this problem.
>
> When I'm attempting to install to the first WEB SERVER(IIS 5.0), I get
> a warning message during the install that I don't have the Visual
> Studio IDE installed (which shouldn't be a problem--I mean, hey, it's a
> server, right?). Fine.
> The next page or so is the list of which components you want to
> install--and Tada, NO SERVER COMPONENTS are in the list. The first time
> this happened, I shrugged, and went through the rest of the set up
> process. I didn't recieve any of the other setup pages (virtual
> directories, SQL Server connection info, etc). It ended up installing a
> handful of other dlls (everything under the client components branch
> was available for install).
> Stumped? I am.
> Here's the last little bit of info: I'm attempting to install this
> software over a terminal connection. The servers are co-located, and I
> was hopeing to install this without taking the neccessary road trip. I
> doubt this is the problem, but hey, you never know.
> If anyone else has experienced this problem and has a resolution,
> please, please let me know.
> Thanks much,
> Mark S. Milley, MCAD
>

Problems installing SRS

I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6
development box. The local database is SQL Server 2000 sp3.
At the end of the installation I get an error message indicating that
the 'Setup could not initialize the report server' and that I'll have
to manually initialize the Report Server.
After running rsactive I got the message indicating that the "Report
Server Web Service has not generated a public key".
Looking in the log files is less-than-helpful (hundreds of lines
indicating that some -unknown- file is missing):
===============================================================================
aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
a
===============================================================================
When I navigate to the http://localhost/ReportServer I get the
following error message:
An internal error occurred on the report server. (again not very
helpful).
IIS is listening on port 80 (and there are no other apps on the port).
SO... I'm running out of things to try and patience. Is there anyone
out there who can help me get over this problem? I really need to
get this installed ASAP and there doesn't seem to be any documentation
anywhere that explains what is going wrong!!!
Any help appreciated.
GlennAfter much trail-and-error and finally a call to Microsoft I was able to
install the SRS and get everything working. I'm posting this in hopes that my
solution will help someone in a similar situation.
Ultimately the problem was solved by:
1) accessing the machine.config file
2) find the user name in the process model section (by default it's set
to 'machine')
3) change this to 'system' (temporarily)
4) using EnterpriseManager open the Keys table of the ReportServer
database (three are probably 2 keys)
5) delete the NON-ZERO key (don't delete the ZERO key)
6) browse to http:/localhost/ReportServer (should no longer produce any
errors!!!)
7) browse to http:/localhost/Reposrts
Hope this helps...
Glenn
"Glenn" wrote:
> I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6
> development box. The local database is SQL Server 2000 sp3.
> At the end of the installation I get an error message indicating that
> the 'Setup could not initialize the report server' and that I'll have
> to manually initialize the Report Server.
> After running rsactive I got the message indicating that the "Report
> Server Web Service has not generated a public key".
> Looking in the log files is less-than-helpful (hundreds of lines
> indicating that some -unknown- file is missing):
> ===============================================================================> aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> a
> ===============================================================================> When I navigate to the http://localhost/ReportServer I get the
> following error message:
> An internal error occurred on the report server. (again not very
> helpful).
> IIS is listening on port 80 (and there are no other apps on the port).
>
> SO... I'm running out of things to try and patience. Is there anyone
> out there who can help me get over this problem? I really need to
> get this installed ASAP and there doesn't seem to be any documentation
> anywhere that explains what is going wrong!!!
> Any help appreciated.
> Glenn
>

Problems installing SQL Reporting Services

I verified that the prerequisites MDAC, ASP, IIS 5 and MSDTC were all
installed, but I'm getting an error duing the install that says:
"IIS is either not installed or not configured for server component
installation"
Any ideas?
Carlton.
I just solved the same issue. Go to Administrative Tools, IIS Manager and
make sure the Default Web site is not stopped. If it is, then Start it and
then the Reporting Services install will not give you this error.
"Cwhitmore" wrote:

> I verified that the prerequisites MDAC, ASP, IIS 5 and MSDTC were all
> installed, but I'm getting an error duing the install that says:
> "IIS is either not installed or not configured for server component
> installation"
> Any ideas?
> Carlton.
>
|||Sunil,
The default website was running. I have serveral virtual directories that
run fine.
Any other ideas?
Carlton.
"Sunil Gulati" wrote:
[vbcol=seagreen]
> I just solved the same issue. Go to Administrative Tools, IIS Manager and
> make sure the Default Web site is not stopped. If it is, then Start it and
> then the Reporting Services install will not give you this error.
> "Cwhitmore" wrote:

Problems Installing Reporting Services on Win2003

Hello All,
I have been trying to install reporting svcs EE on win2003 server for
the past 4 days. but not successful so far.
This is the set up i have.
win 2003, sql server 2000 EE and reporting svcs EE.
trying to create the RS databases on the local SQL server.
First I tried using the
1. Select NT Authority\SYSTEM account
2. default names for the virtual dirs
3. local sql server instance and a Service Account.
Here it says i need this hot fix QFE 859 but couldnt find it on the MS
site.
Second Attempt
1. Select NT Authority\SYSTEM account
2. default names for the virtual dirs
3. local sql server instance and a SQL login account.
It completes most of the installation but throws up this error saying
cant connect to the databases.
I see the local sql server and see that the RS databases are created
I try to access the http://<server>/Report and ReportManager
I give the user/passwd, its authenticated and in the end I get a
message saying couldnt not connect to the database.
I would like to know if anyone faced similar issues and if there is way
around this.
Thanks
BofoThe NT Authority\SYSTEM account uses the Bultin\Administrator account to
login tin SQL. If this account is missing you would see this error. If the
account it there make sure it has access to the databases. For use, we used a
Domain User account for the install of RS and SQL.
"Win2003InstallIssues" wrote:
> Hello All,
> I have been trying to install reporting svcs EE on win2003 server for
> the past 4 days. but not successful so far.
> This is the set up i have.
> win 2003, sql server 2000 EE and reporting svcs EE.
> trying to create the RS databases on the local SQL server.
> First I tried using the
> 1. Select NT Authority\SYSTEM account
> 2. default names for the virtual dirs
> 3. local sql server instance and a Service Account.
> Here it says i need this hot fix QFE 859 but couldnt find it on the MS
> site.
> Second Attempt
> 1. Select NT Authority\SYSTEM account
> 2. default names for the virtual dirs
> 3. local sql server instance and a SQL login account.
> It completes most of the installation but throws up this error saying
> cant connect to the databases.
> I see the local sql server and see that the RS databases are created
> I try to access the http://<server>/Report and ReportManager
> I give the user/passwd, its authenticated and in the end I get a
> message saying couldnt not connect to the database.
> I would like to know if anyone faced similar issues and if there is way
> around this.
> Thanks
> Bofo
>|||Thanks for the info. That was probably the problem. I used the NT
Authority\NETWORK SERVICE account and used a domain user account for
the ReportServer and seems to do fine.
at the end of the installation a couple of DOS windows pop-up
the first one says
"cannot connect to the database as the name of the server already
exists or a duplicate go to system utilities and change the name....
or something like that.
But the Reports and ReportServer urls seems to do fine.
Is this due to the fact that I have the SQL server and the RS running
from the same physical machine ?
Also would like to know what is the best way to setup the system. Like
having the SQL server on a seperate machine or it doesnt really matter.
Thanks
Bofo|||The RS databases have to be on SQL, whether or not ReportServer and Report
Manager are on the same machine does not matter.That is the good thing about
EE RS. You have flexibility in how you want to deploy your solutions. As an
example, we currently have RS, the RS databases and IIS on one server that
access another SQL Server for the reports. We will be moving to an App Center
load balanced IIS cluster, RS and databases in the middle and then the
external SQL Server for the data. This will give us the flexibility we need.
"Win2003InstallIssues" wrote:
> Thanks for the info. That was probably the problem. I used the NT
> Authority\NETWORK SERVICE account and used a domain user account for
> the ReportServer and seems to do fine.
> at the end of the installation a couple of DOS windows pop-up
> the first one says
> "cannot connect to the database as the name of the server already
> exists or a duplicate go to system utilities and change the name....
> or something like that.
> But the Reports and ReportServer urls seems to do fine.
> Is this due to the fact that I have the SQL server and the RS running
> from the same physical machine ?
> Also would like to know what is the best way to setup the system. Like
> having the SQL server on a seperate machine or it doesnt really matter.
> Thanks
> Bofo
>|||Hi, Thanks very much for the info.
I was able to install it successfully when I had the SQL server running
locally.
But I need to make to work having the SQL server on a different
machine.
Here is my scenario.
1. SQL server 2000 is running on a Win2003 Server which is NOT in my
domain and I want my RS databases on this machine.
2. Reporting services, IIS will run on my machine which is also running
Win2003 Server
My options during installation are
Windows Authenication and
for the reportServer a Service account (default) option
At the end of the installation I get a message saying that Reporting
Services cannot be initalized
I try to access the localhost/Reports
and I get the following error message
=============The report server cannot open a connection to the report server
database. A connection to the database is required for all requests and
processing. (rsReportServerDatabaseUnavailable) Get Online Help Login
failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=============
I would like to know if the problem is due to the fact that the SQL
server is running outside my domain ?
Also I would appreciate what are the best options to choose for the
account types, I read diff docs and each give a different opinion. I am
very new to this type of environment and feeling stupid for not being
able to make this work.
Thanks
Bofo|||Sorry it took so long to get back to you. To answer your questions.
Is there a trust relation between the two domains? This will be need to
ensure that authenication will work.
I would recommend that you setup IIS and RS to run under the account of a
Domain User with local admin on the servers. Then have the user IIS and RS
service is running under be set as trusted for delegation as well as the
servers. If you still get the "Login failed for user '(null)' error then we
need to make sure that the kerberos ticket is being passed. If it is not
being passed then you will have to manually create SPN entries for these
users and servers to ensure that the kerberos ticket is passed and received.
I do not know of any problems with the way you have it designed. Remember,
the more comlex the install the harder it is to troubleshoot.
"Win2003InstallIssues" wrote:
> Hi, Thanks very much for the info.
> I was able to install it successfully when I had the SQL server running
> locally.
> But I need to make to work having the SQL server on a different
> machine.
> Here is my scenario.
> 1. SQL server 2000 is running on a Win2003 Server which is NOT in my
> domain and I want my RS databases on this machine.
> 2. Reporting services, IIS will run on my machine which is also running
> Win2003 Server
> My options during installation are
> Windows Authenication and
> for the reportServer a Service account (default) option
> At the end of the installation I get a message saying that Reporting
> Services cannot be initalized
> I try to access the localhost/Reports
> and I get the following error message
> =============> The report server cannot open a connection to the report server
> database. A connection to the database is required for all requests and
> processing. (rsReportServerDatabaseUnavailable) Get Online Help Login
> failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =============> I would like to know if the problem is due to the fact that the SQL
> server is running outside my domain ?
> Also I would appreciate what are the best options to choose for the
> account types, I read diff docs and each give a different opinion. I am
> very new to this type of environment and feeling stupid for not being
> able to make this work.
> Thanks
> Bofo
>|||Hey !
thanks for the all the info. I got it going. the problem was that i
created the domain after SQL server was installed and also my co-worker
was using Windows Auth Only. So the problem with trusted connection.
Changed the option to Windows and SQL accounts and created a sql acc
with admin permissions and viola !
but i am stuck with SQL query issues now (I have already posted my
problem under another thread)
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/b0fb9b6091537e6f/1ac3d86d514559be
thanks
bofo

Problems installing Reporting Services

Hi Folks,

I want to download Reporting Services for SQL Server Express Edition but I can't find it.

It seems to be in Analysis Services but when I run SQLEXPR_ADV.EXE I don't find any mention of Reporting Services.

I get to the final options choice which offers me 'Database Services' and 'Client Components' but neither of these mentions Reporting Services.

I have installed BI Studio successfully.

I'd be grateful for any and all suggestions.

Thanks a lot.

Barry

You obtain "Reporting Services", you have to download and install SQL Server Express Advanced Services.

See:

SQL Server 2005 Express Edition (Advanced/SSMS)
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
http://msdn2.microsoft.com/en-us/library/ms365247.aspx
http://tinyurl.com/yelwr9

|||

It doesn't seem you read my question very carefully.

|||

hi Barry,

first verify IIS has been properly installed on the hosting computer ()...

uncheck "Hide advanced configuration options" setting..

in the "Feature selection" dialog task wizard, include "Reporting services"

after the "installation whistles" I got
"Reporting Services
The Reporting Services installation options you specified in Setup determine whether further configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed just the program files, you must run the Reporting Services Configuration tool to deploy the report server."

and it has been properly installed...

regards

|||

Hi Andrea,

Thanks for your reply.

Unfortunately, you told me what to do but not how to do it so I couldn't follow your advice.

Barry

|||

hi Barry,

Barry333 wrote:

Hi Andrea,

Thanks for your reply.

Unfortunately, you told me what to do but not how to do it so I couldn't follow your advice.

Barry

where did you find problems?

regarding IIS installation, goto control panel->Add or remove programs->Add or remove Windows components... check IIS..

the rest of the "message" indicates that, after running the SQLEXPR_ADV.EXE, you have to uncheck the "hid advanced configuration options" check box and proceed with the installation wizard... the very next wizard step is "Feature selection", where you have to specify to install the Report Server as well...

regards

|||

Hi Andrea,

I appreciate your concern.

Thanks

Barry

|||

hi Barry,

did you solve your isue?

regards

|||

Yes, by referring to the three books I recently bought on SQL Server 2005 Express.

One of the obscure problems was that SSE defaults to preventing remote access, which I needed.

Barry

|||

Hi Andrea,

I have put together a short step-by-step Tutorial for installing Reporting Services to help other people.

Would you like to contribute ?

If so, you can look at my draft :-

http://www.databaseanswers.org/pi_best_practice_display/manual.asp?manual_id=MS-RPTSVCS

You might like to consider how to add this part of your email to me :-

"the rest of the "message" indicates that, after running the SQLEXPR_ADV.EXE, you have to uncheck the "hid advanced configuration options" check box and proceed with the installation wizard... the very next wizard step is "Feature selection", where you have to specify to install the Report Server as well.

Regards

Barry

|||

hi Barry,

Barry333 wrote:

You might like to consider how to add this part of your email to me :-

"the rest of the "message" indicates that, after running the SQLEXPR_ADV.EXE, you have to uncheck the "hid advanced configuration options" check box and proceed with the installation wizard... the very next wizard step is "Feature selection", where you have to specify to install the Report Server as well.

* After running the SQLEXPR_ADV.EXE installer just double-clicking on it and after the pre-requisites installation (when required), please uncheck the "Hide advanced configuration options" check box to enable the full wizard and wizard steps experience.. The very next wizard step is "Feature selection", where you have to specify to install the Report Server as well.

sounds good? but I'm not native english speaker, so you should perhaps reconsider your invitation

regards

Wednesday, March 28, 2012

Problems Initializing Reporting Serivices

We are trying to install Reporting Services on a server and we are getting
this error.
ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does
not match a supported version.
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(String databaseName, String serverVersion, String& script)
just to be sure, it that mean the version of SQL Server we have will not
allow Reporting services to be installed or is it something else that cause
the error?
We have SQL Server Enterprise 64x.On Dec 13, 9:02 am, Ben <B...@.discussions.microsoft.com> wrote:
> We are trying to install Reporting Services on a server and we are getting
> this error.
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does
> not match a supported version.
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(String databaseName, String serverVersion, String& script)
> just to be sure, it that mean the version of SQL Server we have will not
> allow Reporting services to be installed or is it something else that cause
> the error?
> We have SQL Server Enterprise 64x.
It seems like your SQL Server version is different than your SSRS
version. This link might help. http://207.46.236.188/MSDN/ShowPost.aspx?PostID=2294611&SiteID=1
Regards,
Enrique Martinez
Sr. Software Consultant|||Are you trying to do a fresh install of Reporting Services or are you just
now trying to configure it?
If you are trying to configure it make sure that when you installed SRS
from the SQL Server 2005 media that you re-applied any service packs that
you put on SQL Server 2005 before installing Reporting Services. This can
happen when the current installation is at an SP1 or SP2 level yet the
installed files from SRS are at an RTM level.
If it is a "Fresh" install of SRS see if you can select the radio button
that says "Configure Later" rather than the "Common Configuration" button.
This will allow you to do all of the configuration steps after SRS has
installed. This will allow you to apply any SPs necessary before you try
and configure SRS.
Also, if you are trying to upgrade an instance of SQL Server 2000 SRS you
can always upgrade the database AFTER you have installed 2005 SRS. You
don't have to upgrade the existing instance of SRS all you actually need is
the database. Just make sure you exported the encryption key for the
database from the old SRS 2000 instance before doing that. (You can do this
by using the rskeymgmt tool in the 80\tools\binn folder. Just do a
rskeymgmt -? and look for the key export example)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Problems Initializing Reporting Serivices
>
> We are trying to install Reporting Services on a server and we are
getting
> this error.
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does
> not match a supported version.
> at
>
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgra
deScript(String databaseName, String serverVersion, String& script)
> just to be sure, it that mean the version of SQL Server we have will not
> allow Reporting services to be installed or is it something else that
cause
> the error?
> We have SQL Server Enterprise 64x.
>sql

Monday, March 26, 2012

Problems Exporting To Excel When Using Report Subscription

Hi,
I'm having a problem with Reporting Services report subscriptions.
I have a set of reports that need to be sent via email on a schedule. I need
to send them in Excel format, but the files sent to my email account are
unreadable in Excel. I am using Excel 2003 and can manually export reports
and open them in Excel without any problems, yet when I use a subscription to
email the Excel files they are not valid files. They have the .xls extension,
but Excel can't open them properly, it just opens them as a load of
unintelligible text.
The same thing happens when I set up a subscription to email a report in XML
format, I could export it manually and it worked fine, yet when I run the
subscription to email the XML report to me I get an invalid XML file.
Has anyone else had this problem or does anyone know how to fix it?
If it helps, the report server is stored on a network server, not my local PC.
The server is running Windows Server 2003 Pro, my PC is running Windows XP
Pro and has Office 2003. Office is not installed on the server, but I doubt
that makes any difference, since I can manually export to Excel without any
problems.
Thanks in advance
TabbyWhen you run them "locally" due you mean from VS.NET on your workstation?
If yes... I found that generating reports "locally" can have totally
different results than running them on the report server.
If this is the case...try loading the report via a browser from the report
server.
If this is not the case... try pdf/html or other output formats to narrow
down the problem. I found problems exporting to excel but not other formats
when report objects are overlapping.
Tabby Cool wrote:
>Hi,
>I'm having a problem with Reporting Services report subscriptions.
>I have a set of reports that need to be sent via email on a schedule. I need
>to send them in Excel format, but the files sent to my email account are
>unreadable in Excel. I am using Excel 2003 and can manually export reports
>and open them in Excel without any problems, yet when I use a subscription to
>email the Excel files they are not valid files. They have the .xls extension,
>but Excel can't open them properly, it just opens them as a load of
>unintelligible text.
>The same thing happens when I set up a subscription to email a report in XML
>format, I could export it manually and it worked fine, yet when I run the
>subscription to email the XML report to me I get an invalid XML file.
>Has anyone else had this problem or does anyone know how to fix it?
>If it helps, the report server is stored on a network server, not my local PC.
>The server is running Windows Server 2003 Pro, my PC is running Windows XP
>Pro and has Office 2003. Office is not installed on the server, but I doubt
>that makes any difference, since I can manually export to Excel without any
>problems.
>Thanks in advance
>Tabby
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||No, I am not running htem from Visual Studio, I am running them direct from
the Report Manager.
When you run reports in Visual Studio, can you actually export them? I
thought you could only preview them, there is no option to export a report
from the preview screen.
I have tried exporting them to both XML and Excel, I can do this perfectly
from the Report Manager, yet when I use a subscription to email the reports
to me in either of these formats the files are unusable.
William N wrote:
>When you run them "locally" due you mean from VS.NET on your workstation?
>If yes... I found that generating reports "locally" can have totally
>different results than running them on the report server.
>If this is the case...try loading the report via a browser from the report
>server.
>If this is not the case... try pdf/html or other output formats to narrow
>down the problem. I found problems exporting to excel but not other formats
>when report objects are overlapping.
>>Hi,
>[quoted text clipped - 23 lines]
>>Tabby|||I have tried exporting to PDF, again, this works fine when performed manually,
but the email attachments from the subscription are not valid PDFs and can't
be opened by Adobe Acrobat.
It seems there is something different with the export procedure when using a
subscription as opposed to exporting manually, I don't understand why it
would work perfectly one way and not the other.|||Seems like the report is not getting the the data?
Are you saving the credentials in your data connection?
Tabby Cool wrote:
>I have tried exporting to PDF, again, this works fine when performed manually,
>but the email attachments from the subscription are not valid PDFs and can't
>be opened by Adobe Acrobat.
>It seems there is something different with the export procedure when using a
>subscription as opposed to exporting manually, I don't understand why it
>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||Yes, the credentials are stored in the data source.
William N wrote:
>Seems like the report is not getting the the data?
>Are you saving the credentials in your data connection?
>>I have tried exporting to PDF, again, this works fine when performed manually,
>>but the email attachments from the subscription are not valid PDFs and can't
>[quoted text clipped - 3 lines]
>>subscription as opposed to exporting manually, I don't understand why it
>>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||Not sure what else to suggest.
I always try to simplify as much as possible first. Maybe try creating a
report with just a "Hello" text box and see if that works (no data sets or
anything else).
If it doesn't, then it's probably a server/install issue.
Good luck.
Tabby Cool wrote:
>Yes, the credentials are stored in the data source.
>>Seems like the report is not getting the the data?
>[quoted text clipped - 5 lines]
>>subscription as opposed to exporting manually, I don't understand why it
>>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1

Problems exporting from reporting services 2005 to excel with a lot of rows

Hello,

When I export to excel a report made in Reporting Services 2005, and it has a lot of rows in a table (in the detail section), I have to wait a lot of time, and when it finish the size of the file is bigger than the excel file exported from the old reports in crystal report 6. When I open this exported documents, I have to wait more time until I can see them.

The document have 3 sheets, the first have the document map, the second has a report header, and the last one the page header and the body section (with the table). We thought that it could be the document map because it has hyperlinks to the third sheet, but I have tried to delete this sheet in the excel document and the size is more or less the same.

I tried also exporting to CSV but the results aren't what we need.

What could I do?

Anybody can help me? :/|||

Hi ,

I suggest you to align your report items perfectly to the standards of reporting services

what can you notice when the Excel is opened.if you can see unnecessary columns with zero width.then my expectation is right.

if you can see the dots on report layout tab,when you design the report

,make sure that a report item should not end between these two dots

(size should be the multiple of 0.125 inch)

Follow the same for each Report item in the Report and let me know what did you end up with ?

Thank you,

Raj Deep>A

|||

Hi Raj Deep,

Thanks for your response, but my report items are not between any dots, and the size of every textbox is 0.5. The problem must be because there are too many data in the table, I think, but it wasn′t a matter for crystal reports 8. Any other idea? :)

Thank you,

Pablo

Problems during the installation of Integration Services

Trying to install SQL Server 2005 on my machine,I installed each part (engine, reporting services, integration services etc) seperately.

During the installation of Integration Services I got the following message

failed to install and configure assemblies D:\Microsoft SQL Server 90\90\DTS\Tasks\Microsoft.Sqlserver.MSMQTasks.dll in the COM+ catalog. Error: -2146233087

ErrorMessage: Unknown Error 0x80131501

ErrorDescription: You must have administrative credentials to perform this task. Contact your system administrator for assistance

I am administrator of my machine an i tried to install SQL usign this account.

I selected IGNORE and the installation continued. Will I have any problem with Integration Services in the future because of this error?

What is the source of this problem? How could I solve this problem?

Thank You Very Much

I had the same problem but i didnt find any solution.

Did you? Could you please post the solution when you find it?

Thank you

|||

I, too, am getting the same error under the same circumstances (logged in with admin priviledges). Using the help button on the error notification sent me to a web page to directs the user to confirm that the Distributed Transaction Coordinator service is logged in as "Network Service", which it is, so the help advice was useless.

Does anyone know the real source of this error?

Thanks

|||What OS?|||

I'm running XP Pro and Studio 2005 .NET. I found a different note that suggested uninstalling SQL Server, Studio and, .NET, and then reinstalling in that order. I'd really like to avoid uninstalling Studio if possible, though.

I did go back and uninstall all SQL servers (SQL Express was previously installed), and attempt the SQL 2005 install again and got the same error. I pressed "Ignore" and the complete install proceeded to the end without a problem. However, I suspect that MSMQTask.dll, the file that was causing the error, is going to needed at some point and I'll get failures.

Thanks

|||I'm getting the same problem with XP Pro.

I'm surprised it took 6 months for anybody showing interest in this problem. Usually this forum is awesome for solutions.

- Thanks.

Problems during the installation of Integration Services

Trying to install SQL Server 2005 on my machine,I installed each part (engine, reporting services, integration services etc) seperately.

During the installation of Integration Services I got the following message

failed to install and configure assemblies D:\Microsoft SQL Server 90\90\DTS\Tasks\Microsoft.Sqlserver.MSMQTasks.dll in the COM+ catalog. Error: -2146233087

ErrorMessage: Unknown Error 0x80131501

ErrorDescription: You must have administrative credentials to perform this task. Contact your system administrator for assistance

I am administrator of my machine an i tried to install SQL usign this account.

I selected IGNORE and the installation continued. Will I have any problem with Integration Services in the future because of this error?

What is the source of this problem? How could I solve this problem?

Thank You Very Much

I had the same problem but i didnt find any solution.

Did you? Could you please post the solution when you find it?

Thank you

|||

I, too, am getting the same error under the same circumstances (logged in with admin priviledges). Using the help button on the error notification sent me to a web page to directs the user to confirm that the Distributed Transaction Coordinator service is logged in as "Network Service", which it is, so the help advice was useless.

Does anyone know the real source of this error?

Thanks

|||What OS?|||

I'm running XP Pro and Studio 2005 .NET. I found a different note that suggested uninstalling SQL Server, Studio and, .NET, and then reinstalling in that order. I'd really like to avoid uninstalling Studio if possible, though.

I did go back and uninstall all SQL servers (SQL Express was previously installed), and attempt the SQL 2005 install again and got the same error. I pressed "Ignore" and the complete install proceeded to the end without a problem. However, I suspect that MSMQTask.dll, the file that was causing the error, is going to needed at some point and I'll get failures.

Thanks

|||I'm getting the same problem with XP Pro.

I'm surprised it took 6 months for anybody showing interest in this problem. Usually this forum is awesome for solutions.

- Thanks.

Problems during the deployment of a report

Hello,
I just made a fresh install of Win2003 with VS.NET and SQL server 2000 with
reporting services. When I started to do some test projects to see if
everything was working again and to see what the reporting services where I
ran into some problems:
- first I started a new reporting project and after setting up a test report
I tried to build the project what worked, but when it came to the stage of
deploying it during the build process it came with the error: " The
permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
performing this operation.". After searching the Internet I didn't found a
sollution, so I tried the following:
- I started a new web application (as allways) placed a button and textbox
on it and ran it. It didn't work, it came with the following error "Error:
Project Is Not Configured To Be Debugged". Looking in IIS admin I found out
that there was only a virtual directory but no application made for it
(properties "create" application). After doing this the web app worked.
So it looks like VS.NET 2003 doesn't have enhough rights to work properly
(because the reportingservices are still not working)? How can I fix this?
BTW:
- When I click within VS.NET on the internalt browser tab it display's mine
reports properly, I can browse through multiple pages, save my report to pdf.
- I posted this already to the dotnet.general newsgroup, and they told me to
post the question on this forum.
Thanks,
Charl1. I am getting the same error "The permissions granted to user
'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
performing this operation." I thought it was because we installed a
certifercate and applied SSL.
2. How do I use SSL in Interdev with Report Services?
"Charl" wrote:
> Hello,
> I just made a fresh install of Win2003 with VS.NET and SQL server 2000 with
> reporting services. When I started to do some test projects to see if
> everything was working again and to see what the reporting services where I
> ran into some problems:
> - first I started a new reporting project and after setting up a test report
> I tried to build the project what worked, but when it came to the stage of
> deploying it during the build process it came with the error: " The
> permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> performing this operation.". After searching the Internet I didn't found a
> sollution, so I tried the following:
> - I started a new web application (as allways) placed a button and textbox
> on it and ran it. It didn't work, it came with the following error "Error:
> Project Is Not Configured To Be Debugged". Looking in IIS admin I found out
> that there was only a virtual directory but no application made for it
> (properties "create" application). After doing this the web app worked.
> So it looks like VS.NET 2003 doesn't have enhough rights to work properly
> (because the reportingservices are still not working)? How can I fix this?
> BTW:
> - When I click within VS.NET on the internalt browser tab it display's mine
> reports properly, I can browse through multiple pages, save my report to pdf.
> - I posted this already to the dotnet.general newsgroup, and they told me to
> post the question on this forum.
> Thanks,
> Charl
>|||Hello Charl,
This issue can occur if the virutal folders of IIS for reporting service
allow anonymouse.
Please check the following settings:
Right click Reports /ReportServer in IIS->Properties->Directory Security
Make sure "Intergrated Windows authentication" is checked and "enable
anonymouse access" is unchecked.
For SSL setting, please refer to
Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/sslsetup.asp
Hope this helps.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Problems during the deployment of a report
| thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==| X-WBNR-Posting-Host: 144.141.194.3
| From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
| References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
| Subject: RE: Problems during the deployment of a report
| Date: Wed, 26 Jan 2005 12:13:04 -0800
| Lines: 43
| Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| 1. I am getting the same error "The permissions granted to user
| 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
| performing this operation." I thought it was because we installed a
| certifercate and applied SSL.
|
|
| 2. How do I use SSL in Interdev with Report Services?
|
|
| "Charl" wrote:
|
| > Hello,
| >
| > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
with
| > reporting services. When I started to do some test projects to see if
| > everything was working again and to see what the reporting services
where I
| > ran into some problems:
| >
| > - first I started a new reporting project and after setting up a test
report
| > I tried to build the project what worked, but when it came to the stage
of
| > deploying it during the build process it came with the error: " The
| > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
for
| > performing this operation.". After searching the Internet I didn't
found a
| > sollution, so I tried the following:
| >
| > - I started a new web application (as allways) placed a button and
textbox
| > on it and ran it. It didn't work, it came with the following error
"Error:
| > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
out
| > that there was only a virtual directory but no application made for it
| > (properties "create" application). After doing this the web app worked.
| > So it looks like VS.NET 2003 doesn't have enhough rights to work
properly
| > (because the reportingservices are still not working)? How can I fix
this?
| >
| > BTW:
| > - When I click within VS.NET on the internalt browser tab it display's
mine
| > reports properly, I can browse through multiple pages, save my report
to pdf.
| >
| > - I posted this already to the dotnet.general newsgroup, and they told
me to
| > post the question on this forum.
| >
| > Thanks,
| > Charl
| >
||||Thanks Peter,
This solved mine problem!
So what you are saying is that it isn't possible to use the reportingservice
with anonymouse access enabled? Because that is what I would like to do for
my reports?!?
Thanks,
Charl
"Peter Yang [MSFT]" wrote:
> Hello Charl,
> This issue can occur if the virutal folders of IIS for reporting service
> allow anonymouse.
> Please check the following settings:
> Right click Reports /ReportServer in IIS->Properties->Directory Security
> Make sure "Intergrated Windows authentication" is checked and "enable
> anonymouse access" is unchecked.
> For SSL setting, please refer to
> Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> /sslsetup.asp
> Hope this helps.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Problems during the deployment of a report
> | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> | X-WBNR-Posting-Host: 144.141.194.3
> | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> | Subject: RE: Problems during the deployment of a report
> | Date: Wed, 26 Jan 2005 12:13:04 -0800
> | Lines: 43
> | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | 1. I am getting the same error "The permissions granted to user
> | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> | performing this operation." I thought it was because we installed a
> | certifercate and applied SSL.
> |
> |
> | 2. How do I use SSL in Interdev with Report Services?
> |
> |
> | "Charl" wrote:
> |
> | > Hello,
> | >
> | > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
> with
> | > reporting services. When I started to do some test projects to see if
> | > everything was working again and to see what the reporting services
> where I
> | > ran into some problems:
> | >
> | > - first I started a new reporting project and after setting up a test
> report
> | > I tried to build the project what worked, but when it came to the stage
> of
> | > deploying it during the build process it came with the error: " The
> | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
> for
> | > performing this operation.". After searching the Internet I didn't
> found a
> | > sollution, so I tried the following:
> | >
> | > - I started a new web application (as allways) placed a button and
> textbox
> | > on it and ran it. It didn't work, it came with the following error
> "Error:
> | > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
> out
> | > that there was only a virtual directory but no application made for it
> | > (properties "create" application). After doing this the web app worked.
> | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> properly
> | > (because the reportingservices are still not working)? How can I fix
> this?
> | >
> | > BTW:
> | > - When I click within VS.NET on the internalt browser tab it display's
> mine
> | > reports properly, I can browse through multiple pages, save my report
> to pdf.
> | >
> | > - I posted this already to the dotnet.general newsgroup, and they told
> me to
> | > post the question on this forum.
> | >
> | > Thanks,
> | > Charl
> | >
> |
>|||HI...
We are usining both Annyonymous and Windows Integrations. This seems to
work. Are we doing something wrong?
:)
"Charl" wrote:
> Thanks Peter,
> This solved mine problem!
> So what you are saying is that it isn't possible to use the reportingservice
> with anonymouse access enabled? Because that is what I would like to do for
> my reports?!?
> Thanks,
> Charl
>
> "Peter Yang [MSFT]" wrote:
> > Hello Charl,
> >
> > This issue can occur if the virutal folders of IIS for reporting service
> > allow anonymouse.
> >
> > Please check the following settings:
> >
> > Right click Reports /ReportServer in IIS->Properties->Directory Security
> >
> > Make sure "Intergrated Windows authentication" is checked and "enable
> > anonymouse access" is unchecked.
> >
> > For SSL setting, please refer to
> >
> > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> > http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> > /sslsetup.asp
> >
> > Hope this helps.
> >
> > Thanks & Regards,
> >
> > Peter Yang
> > MCSE2000/2003, MCSA, MCDBA
> > Microsoft Online Partner Support
> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> >
> > =====================================================> >
> > Business-Critical Phone Support (BCPS) provides you with technical phone
> > support at no charge during critical LAN outages or "business down"
> > situations. This benefit is available 24 hours a day, 7 days a week to all
> > Microsoft technology partners in the United States and Canada.
> >
> > This and other support options are available here:
> >
> > BCPS:
> > https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> >
> > Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> >
> > If you are outside the United States, please visit our International
> > Support page:
> > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> >
> > =====================================================> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > --
> > | Thread-Topic: Problems during the deployment of a report
> > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> > | X-WBNR-Posting-Host: 144.141.194.3
> > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> > | Subject: RE: Problems during the deployment of a report
> > | Date: Wed, 26 Jan 2005 12:13:04 -0800
> > | Lines: 43
> > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> > | MIME-Version: 1.0
> > | Content-Type: text/plain;
> > | charset="Utf-8"
> > | Content-Transfer-Encoding: 7bit
> > | X-Newsreader: Microsoft CDO for Windows 2000
> > | Content-Class: urn:content-classes:message
> > | Importance: normal
> > | Priority: normal
> > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> > | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
> > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> > |
> > | 1. I am getting the same error "The permissions granted to user
> > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> > | performing this operation." I thought it was because we installed a
> > | certifercate and applied SSL.
> > |
> > |
> > | 2. How do I use SSL in Interdev with Report Services?
> > |
> > |
> > | "Charl" wrote:
> > |
> > | > Hello,
> > | >
> > | > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
> > with
> > | > reporting services. When I started to do some test projects to see if
> > | > everything was working again and to see what the reporting services
> > where I
> > | > ran into some problems:
> > | >
> > | > - first I started a new reporting project and after setting up a test
> > report
> > | > I tried to build the project what worked, but when it came to the stage
> > of
> > | > deploying it during the build process it came with the error: " The
> > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
> > for
> > | > performing this operation.". After searching the Internet I didn't
> > found a
> > | > sollution, so I tried the following:
> > | >
> > | > - I started a new web application (as allways) placed a button and
> > textbox
> > | > on it and ran it. It didn't work, it came with the following error
> > "Error:
> > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
> > out
> > | > that there was only a virtual directory but no application made for it
> > | > (properties "create" application). After doing this the web app worked.
> > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> > properly
> > | > (because the reportingservices are still not working)? How can I fix
> > this?
> > | >
> > | > BTW:
> > | > - When I click within VS.NET on the internalt browser tab it display's
> > mine
> > | > reports properly, I can browse through multiple pages, save my report
> > to pdf.
> > | >
> > | > - I posted this already to the dotnet.general newsgroup, and they told
> > me to
> > | > post the question on this forum.
> > | >
> > | > Thanks,
> > | > Charl
> > | >
> > |
> >
> >|||Hello Charl,
If you want to anonymouse to be able to run report properly, usually you
shall grant proper permission to ASP.net and USR_machinename accout.
- Chang the anonymous account to use IUSR_machinename
- Add aspnet/IUSR_machinename as a RM account and assigned browse, View
reports and View folder.
Usually you can check "enable anonymous access" in Reports virtual
directory but you shall not check it in ReportServer folder.
If the issue persists, try to add aspnet to the Admins group. Hope this
helps.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Problems during the deployment of a report
| thread-index: AcUEbXeOmZUeArSJTFSbCQ/6IpLr7w==| X-WBNR-Posting-Host: 62.194.205.63
| From: "=?Utf-8?B?Q2hhcmw=?=" <Charl@.noemail.nospam>
| References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
<ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
<5AaE0XCBFHA.2732@.cpmsftngxa10.phx.gbl>
| Subject: RE: Problems during the deployment of a report
| Date: Thu, 27 Jan 2005 04:41:05 -0800
| Lines: 151
| Message-ID: <D24DA289-3C1A-4C11-B6CE-847A313DE4BE@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41027
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks Peter,
|
| This solved mine problem!
| So what you are saying is that it isn't possible to use the
reportingservice
| with anonymouse access enabled? Because that is what I would like to do
for
| my reports?!?
|
| Thanks,
|
| Charl
|
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Charl,
| >
| > This issue can occur if the virutal folders of IIS for reporting
service
| > allow anonymouse.
| >
| > Please check the following settings:
| >
| > Right click Reports /ReportServer in IIS->Properties->Directory Security
| >
| > Make sure "Intergrated Windows authentication" is checked and "enable
| > anonymouse access" is unchecked.
| >
| > For SSL setting, please refer to
| >
| > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
| >
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
| > /sslsetup.asp
| >
| > Hope this helps.
| >
| > Thanks & Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| >
| > =====================================================| >
| > Business-Critical Phone Support (BCPS) provides you with technical
phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| >
| > BCPS:
| >
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
| >
| > Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page:
| > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
| >
| > =====================================================| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > --
| > | Thread-Topic: Problems during the deployment of a report
| > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==| > | X-WBNR-Posting-Host: 144.141.194.3
| > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
| > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
| > | Subject: RE: Problems during the deployment of a report
| > | Date: Wed, 26 Jan 2005 12:13:04 -0800
| > | Lines: 43
| > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40960
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | 1. I am getting the same error "The permissions granted to user
| > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
| > | performing this operation." I thought it was because we installed a
| > | certifercate and applied SSL.
| > |
| > |
| > | 2. How do I use SSL in Interdev with Report Services?
| > |
| > |
| > | "Charl" wrote:
| > |
| > | > Hello,
| > | >
| > | > I just made a fresh install of Win2003 with VS.NET and SQL server
2000
| > with
| > | > reporting services. When I started to do some test projects to see
if
| > | > everything was working again and to see what the reporting services
| > where I
| > | > ran into some problems:
| > | >
| > | > - first I started a new reporting project and after setting up a
test
| > report
| > | > I tried to build the project what worked, but when it came to the
stage
| > of
| > | > deploying it during the build process it came with the error: " The
| > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are
insufficient
| > for
| > | > performing this operation.". After searching the Internet I didn't
| > found a
| > | > sollution, so I tried the following:
| > | >
| > | > - I started a new web application (as allways) placed a button and
| > textbox
| > | > on it and ran it. It didn't work, it came with the following error
| > "Error:
| > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I
found
| > out
| > | > that there was only a virtual directory but no application made for
it
| > | > (properties "create" application). After doing this the web app
worked.
| > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
| > properly
| > | > (because the reportingservices are still not working)? How can I
fix
| > this?
| > | >
| > | > BTW:
| > | > - When I click within VS.NET on the internalt browser tab it
display's
| > mine
| > | > reports properly, I can browse through multiple pages, save my
report
| > to pdf.
| > | >
| > | > - I posted this already to the dotnet.general newsgroup, and they
told
| > me to
| > | > post the question on this forum.
| > | >
| > | > Thanks,
| > | > Charl
| > | >
| > |
| >
| >
||||i've a similiar problem the error message is "The permissions granted to user
'DOMAIN\USER are insufficient for performing this operation. (rsAccessDenied)
"
I've changed premission of the fisical directory "ReportingServices" to
everyone full control
and put the aspnet user in the administrators group but it didn't work.
Is there any documentention on how to set a reporting server to anonyous use?
"Peter Yang [MSFT]" wrote:
> Hello Charl,
> If you want to anonymouse to be able to run report properly, usually you
> shall grant proper permission to ASP.net and USR_machinename accout.
> - Chang the anonymous account to use IUSR_machinename
> - Add aspnet/IUSR_machinename as a RM account and assigned browse, View
> reports and View folder.
> Usually you can check "enable anonymous access" in Reports virtual
> directory but you shall not check it in ReportServer folder.
> If the issue persists, try to add aspnet to the Admins group. Hope this
> helps.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Problems during the deployment of a report
> | thread-index: AcUEbXeOmZUeArSJTFSbCQ/6IpLr7w==> | X-WBNR-Posting-Host: 62.194.205.63
> | From: "=?Utf-8?B?Q2hhcmw=?=" <Charl@.noemail.nospam>
> | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> <5AaE0XCBFHA.2732@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Problems during the deployment of a report
> | Date: Thu, 27 Jan 2005 04:41:05 -0800
> | Lines: 151
> | Message-ID: <D24DA289-3C1A-4C11-B6CE-847A313DE4BE@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41027
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Thanks Peter,
> |
> | This solved mine problem!
> | So what you are saying is that it isn't possible to use the
> reportingservice
> | with anonymouse access enabled? Because that is what I would like to do
> for
> | my reports?!?
> |
> | Thanks,
> |
> | Charl
> |
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Charl,
> | >
> | > This issue can occur if the virutal folders of IIS for reporting
> service
> | > allow anonymouse.
> | >
> | > Please check the following settings:
> | >
> | > Right click Reports /ReportServer in IIS->Properties->Directory Security
> | >
> | > Make sure "Intergrated Windows authentication" is checked and "enable
> | > anonymouse access" is unchecked.
> | >
> | > For SSL setting, please refer to
> | >
> | > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> | >
> http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> | > /sslsetup.asp
> | >
> | > Hope this helps.
> | >
> | > Thanks & Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > When responding to posts, please "Reply to Group" via your newsreader
> so
> | > that others may learn and benefit from your issue.
> | >
> | > =====================================================> | >
> | > Business-Critical Phone Support (BCPS) provides you with technical
> phone
> | > support at no charge during critical LAN outages or "business down"
> | > situations. This benefit is available 24 hours a day, 7 days a week to
> all
> | > Microsoft technology partners in the United States and Canada.
> | >
> | > This and other support options are available here:
> | >
> | > BCPS:
> | >
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> | >
> | > Others:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/
> | >
> | > If you are outside the United States, please visit our International
> | > Support page:
> | > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> | >
> | > =====================================================> | >
> | > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> | >
> | >
> | > --
> | > | Thread-Topic: Problems during the deployment of a report
> | > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> | > | X-WBNR-Posting-Host: 144.141.194.3
> | > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> | > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> | > | Subject: RE: Problems during the deployment of a report
> | > | Date: Wed, 26 Jan 2005 12:13:04 -0800
> | > | Lines: 43
> | > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:40960
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | 1. I am getting the same error "The permissions granted to user
> | > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> | > | performing this operation." I thought it was because we installed a
> | > | certifercate and applied SSL.
> | > |
> | > |
> | > | 2. How do I use SSL in Interdev with Report Services?
> | > |
> | > |
> | > | "Charl" wrote:
> | > |
> | > | > Hello,
> | > | >
> | > | > I just made a fresh install of Win2003 with VS.NET and SQL server
> 2000
> | > with
> | > | > reporting services. When I started to do some test projects to see
> if
> | > | > everything was working again and to see what the reporting services
> | > where I
> | > | > ran into some problems:
> | > | >
> | > | > - first I started a new reporting project and after setting up a
> test
> | > report
> | > | > I tried to build the project what worked, but when it came to the
> stage
> | > of
> | > | > deploying it during the build process it came with the error: " The
> | > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are
> insufficient
> | > for
> | > | > performing this operation.". After searching the Internet I didn't
> | > found a
> | > | > sollution, so I tried the following:
> | > | >
> | > | > - I started a new web application (as allways) placed a button and
> | > textbox
> | > | > on it and ran it. It didn't work, it came with the following error
> | > "Error:
> | > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I
> found
> | > out
> | > | > that there was only a virtual directory but no application made for
> it
> | > | > (properties "create" application). After doing this the web app
> worked.
> | > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> | > properly
> | > | > (because the reportingservices are still not working)? How can I
> fix
> | > this?
> | > | >
> | > | > BTW:
> | > | > - When I click within VS.NET on the internalt browser tab it
> display's
> | > mine
> | > | > reports properly, I can browse through multiple pages, save my
> report
> | > to pdf.
> | > | >
> | > | > - I posted this already to the dotnet.general newsgroup, and they
> told
> | > me to
> | > | > post the question on this forum.
> | > | >
> | > | > Thanks,
> | > | > Charl
> | > | >
> | > |
> | >
> | >
> |
>sql

Problems deploying to a different server

I've been playing with Reporting Services on my computer and got it working fine. I can view the reports on my localhost with no problems. However, when I change the TargetServerURL in the report properties to the server that I want the report to go on (yes, the target server has SQL Reporting Services installed on it), I get the following error message:

Server was unable to process request. > Method ReportingService.SetExecutionOptions can not be reflected. > Unknown error - HRESULT 0x80131047

Anyone have any idea of what's going wrong here? Thanks for any help.

Just to add: I do have rights to the server I'm trying to publish to. This is assuming that SQL Reporting Services is distributing the reports under my username. It could well be that it's trying to use the generic ASPNET user that Visual Studio has a habit of using for its web publishing. Anyone know for sure?Problem solved. Silly mistake on my part. I deployed Framework 2.0 beta to that server and by default it set the folders used by Report Services to use ASP.NET 2.0 which my Visual Studio 2003 didn't like, so I set the folders to use ASP.NET 1.1 and all is good.sql

Friday, March 23, 2012

Problems Creating Report

Hi,

I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report.

What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters.

I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column.

Can anyone offer any suggestions?

Dave

Sounds like a T-SQL issue. Do you have a sample of the query?|||My apologies, I just realised I neglected to mention that the source data was in a cube. What I have in the cube is a product dimension, a time dimension (which goes down to week level), and a measure for sales amount.|||Anybody got any ideas?|||

In MDX I would suggest using ParallelPeriod. The following is an AdventureWorks query showing an example. You just need to replace the expicit time members with parameters:

WITH
MEMBER [Measures].[Selection] as '
Sum(
[Date].[Calendar].[Month].&[2003]&[1]
:
[Date].[Calendar].[Month].&[2003]&[5]
, [Measures].[Sales Amount]
)'
MEMBER [Measures].[SamePeriodLastYear] as '
Sum(
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[1])
:
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[5])
, [Measures].[Sales Amount]
)'

SELECT
{ [Measures].[Selection]
, [Measures].[SamePeriodLastYear]
} ON 0,

NON EMPTY [Product].[Product Categories].Members ON 1

FROM [Adventure Works]

|||Thanks very much, that works a treat.|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Try constructing a MemberUniqueName string and passing that to the StrToMember functiuon

Sum(
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)

|||

Hi Adam,

Again, that works fine in SQL Studio with integer values instead of the parameters. However, when I try it in Reporting Services with my parameters I get the following error:

"The 'ThisYear' calculated member cannot be created because of the following error: Parser: The StartWeek parameter could not be resolved because it was referenced in ann inner subexpression"

My calculated member field is now:

"Sum(
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)"

|||

Some options:

try removing the CStr() call and see if that works
OR

Problems Creating Report

Hi,

I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report.

What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters.

I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column.

Can anyone offer any suggestions?

Dave

Sounds like a T-SQL issue. Do you have a sample of the query?|||My apologies, I just realised I neglected to mention that the source data was in a cube. What I have in the cube is a product dimension, a time dimension (which goes down to week level), and a measure for sales amount.|||Anybody got any ideas?|||

In MDX I would suggest using ParallelPeriod. The following is an AdventureWorks query showing an example. You just need to replace the expicit time members with parameters:

WITH
MEMBER [Measures].[Selection] as '
Sum(
[Date].[Calendar].[Month].&[2003]&[1]
:
[Date].[Calendar].[Month].&[2003]&[5]
, [Measures].[Sales Amount]
)'
MEMBER [Measures].[SamePeriodLastYear] as '
Sum(
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[1])
:
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[5])
, [Measures].[Sales Amount]
)'

SELECT
{ [Measures].[Selection]
, [Measures].[SamePeriodLastYear]
} ON 0,

NON EMPTY [Product].[Product Categories].Members ON 1

FROM [Adventure Works]

|||Thanks very much, that works a treat.|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Ok,

I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.

I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:

ThisYear

Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)

LastYear

Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)

I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!

Dave

|||

Try constructing a MemberUniqueName string and passing that to the StrToMember functiuon

Sum(
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)

|||

Hi Adam,

Again, that works fine in SQL Studio with integer values instead of the parameters. However, when I try it in Reporting Services with my parameters I get the following error:

"The 'ThisYear' calculated member cannot be created because of the following error: Parser: The StartWeek parameter could not be resolved because it was referenced in ann inner subexpression"

My calculated member field is now:

"Sum(
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)"

|||

Some options:

try removing the CStr() call and see if that works
OR