OLAP based reports not rendering

I hope someone with a bit of knowledge about Analysis Services and Reporting
Services can give me some help here, please.
A client has the following setup:
One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services sp
2 and IIS 5.
One Windows 2003 server running Analysis Services sp 3.
--
1 role has been created in AS, with full access to everything. This is an AD
group, and we've tried adding all sorts of AD users to this group, to give
them access to the cube. We haven't tried adding "Everyone" and given it
full access.
--
When developing reports, we can access the OLAP cube with the usual NT login
of the developer. The report report renders perfectly on the dev box.
In Report Manager, reports based on SQL Server queries works perfectly.
Reports based on OLAP will work when run on the server running Reporing
Services, but NO OTHER computer. So when we access the Reporing Services
server with Remote Desktop, the OLAP report will render. From any other
computer, all in the same domain, it won't work.
The error message we get is basically "Cannot create a connection to data
source '<our datasource>'". But the "explanation" varies depending on what
user we try to use in our connection settings. The most common was "Database
'<our database>' could not be found." The other one was "Unknown error
E_(bunch of characters)".
So... any suggestions? I've found posts from other people who seem to have
had the same problem as ours, but no solution. We haven't figured out where
the problem is. Is it the credentials sent from Internet Explorer? Is it the
identity used in the connection string? Is it a new bug in SP 2? Reporting
Services has just been installed, and SP2 was installed immedeately. We
don't know if it would have worked without SP2, and I guess we won't find
out.
All help is really appreciated on this one!
Yours,
Kaisa M. Lindahloh yes please - we are having the same problems and noone seems to be able
to help !!!!
Please can someone help ?
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:OqAZtwYbFHA.3240@.TK2MSFTNGP12.phx.gbl...
>I hope someone with a bit of knowledge about Analysis Services and
>Reporting Services can give me some help here, please.
> A client has the following setup:
> One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services
> sp 2 and IIS 5.
> One Windows 2003 server running Analysis Services sp 3.
> --
> 1 role has been created in AS, with full access to everything. This is an
> AD group, and we've tried adding all sorts of AD users to this group, to
> give them access to the cube. We haven't tried adding "Everyone" and given
> it full access.
> --
> When developing reports, we can access the OLAP cube with the usual NT
> login of the developer. The report report renders perfectly on the dev
> box.
> In Report Manager, reports based on SQL Server queries works perfectly.
> Reports based on OLAP will work when run on the server running Reporing
> Services, but NO OTHER computer. So when we access the Reporing Services
> server with Remote Desktop, the OLAP report will render. From any other
> computer, all in the same domain, it won't work.
> The error message we get is basically "Cannot create a connection to data
> source '<our datasource>'". But the "explanation" varies depending on what
> user we try to use in our connection settings. The most common was
> "Database '<our database>' could not be found." The other one was "Unknown
> error E_(bunch of characters)".
> So... any suggestions? I've found posts from other people who seem to have
> had the same problem as ours, but no solution. We haven't figured out
> where the problem is. Is it the credentials sent from Internet Explorer?
> Is it the identity used in the connection string? Is it a new bug in SP 2?
> Reporting Services has just been installed, and SP2 was installed
> immedeately. We don't know if it would have worked without SP2, and I
> guess we won't find out.
> All help is really appreciated on this one!
> Yours,
> Kaisa M. Lindahl
>|||Provider=MSOLAP.2;Client Cache Size=25;Data
Source=myOLAPServer;SSPI=Kerberos;Initial Catalog=myOLAPDB;Auto Synch
Period=20000
Look into setting up Kerberos/trust betweent he servers and check the
connection string above "Kerberos"
--
Gary Foster
"Kathy" wrote:
> oh yes please - we are having the same problems and noone seems to be able
> to help !!!!
> Please can someone help ?
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:OqAZtwYbFHA.3240@.TK2MSFTNGP12.phx.gbl...
> >I hope someone with a bit of knowledge about Analysis Services and
> >Reporting Services can give me some help here, please.
> >
> > A client has the following setup:
> >
> > One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services
> > sp 2 and IIS 5.
> >
> > One Windows 2003 server running Analysis Services sp 3.
> > --
> > 1 role has been created in AS, with full access to everything. This is an
> > AD group, and we've tried adding all sorts of AD users to this group, to
> > give them access to the cube. We haven't tried adding "Everyone" and given
> > it full access.
> > --
> >
> > When developing reports, we can access the OLAP cube with the usual NT
> > login of the developer. The report report renders perfectly on the dev
> > box.
> > In Report Manager, reports based on SQL Server queries works perfectly.
> > Reports based on OLAP will work when run on the server running Reporing
> > Services, but NO OTHER computer. So when we access the Reporing Services
> > server with Remote Desktop, the OLAP report will render. From any other
> > computer, all in the same domain, it won't work.
> >
> > The error message we get is basically "Cannot create a connection to data
> > source '<our datasource>'". But the "explanation" varies depending on what
> > user we try to use in our connection settings. The most common was
> > "Database '<our database>' could not be found." The other one was "Unknown
> > error E_(bunch of characters)".
> >
> > So... any suggestions? I've found posts from other people who seem to have
> > had the same problem as ours, but no solution. We haven't figured out
> > where the problem is. Is it the credentials sent from Internet Explorer?
> > Is it the identity used in the connection string? Is it a new bug in SP 2?
> > Reporting Services has just been installed, and SP2 was installed
> > immedeately. We don't know if it would have worked without SP2, and I
> > guess we won't find out.
> >
> > All help is really appreciated on this one!
> >
> > Yours,
> >
> > Kaisa M. Lindahl
> >
>
>|||For our reports that use Analysis Services we had to do the following.
First, we ended up was using a single domain account hard-coded in the
data-link properties for the datasource. This account must have at least a
read-only role on the AS box in Analysis Manager. We were not allowed to use
Kerberos delegation as out SA team thought it was a security reisk on AD2k.
We may go this route once they have upgraded to AD2k3 as that release is
supposed to have the ability to provide scope limited Kerberos delegation.
Anyway, from here, it seemed like it would work. Our users are given access
or not based on their domain accounts being in a group ReportingServices on
the Report Server machine. What we found though was this still did not work.
Finally we found that after every deploy, we always have to go to the
web-based report manager, find the datasource that points to AS and check the
box "Use as Windows credentials when connecting to the data source" and then
retype the password and apply. After this our reports worked fine. Be aware
that this check box gets unchecked each time you deploy. I have not found
any other workaround. If you do, please let me know.
Hope this helps.
"garyf@.someone.com" wrote:
> Provider=MSOLAP.2;Client Cache Size=25;Data
> Source=myOLAPServer;SSPI=Kerberos;Initial Catalog=myOLAPDB;Auto Synch
> Period=20000
> Look into setting up Kerberos/trust betweent he servers and check the
> connection string above "Kerberos"
> --
> Gary Foster
>
> "Kathy" wrote:
> > oh yes please - we are having the same problems and noone seems to be able
> > to help !!!!
> > Please can someone help ?
> >
> >
> > "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> > news:OqAZtwYbFHA.3240@.TK2MSFTNGP12.phx.gbl...
> > >I hope someone with a bit of knowledge about Analysis Services and
> > >Reporting Services can give me some help here, please.
> > >
> > > A client has the following setup:
> > >
> > > One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services
> > > sp 2 and IIS 5.
> > >
> > > One Windows 2003 server running Analysis Services sp 3.
> > > --
> > > 1 role has been created in AS, with full access to everything. This is an
> > > AD group, and we've tried adding all sorts of AD users to this group, to
> > > give them access to the cube. We haven't tried adding "Everyone" and given
> > > it full access.
> > > --
> > >
> > > When developing reports, we can access the OLAP cube with the usual NT
> > > login of the developer. The report report renders perfectly on the dev
> > > box.
> > > In Report Manager, reports based on SQL Server queries works perfectly.
> > > Reports based on OLAP will work when run on the server running Reporing
> > > Services, but NO OTHER computer. So when we access the Reporing Services
> > > server with Remote Desktop, the OLAP report will render. From any other
> > > computer, all in the same domain, it won't work.
> > >
> > > The error message we get is basically "Cannot create a connection to data
> > > source '<our datasource>'". But the "explanation" varies depending on what
> > > user we try to use in our connection settings. The most common was
> > > "Database '<our database>' could not be found." The other one was "Unknown
> > > error E_(bunch of characters)".
> > >
> > > So... any suggestions? I've found posts from other people who seem to have
> > > had the same problem as ours, but no solution. We haven't figured out
> > > where the problem is. Is it the credentials sent from Internet Explorer?
> > > Is it the identity used in the connection string? Is it a new bug in SP 2?
> > > Reporting Services has just been installed, and SP2 was installed
> > > immedeately. We don't know if it would have worked without SP2, and I
> > > guess we won't find out.
> > >
> > > All help is really appreciated on this one!
> > >
> > > Yours,
> > >
> > > Kaisa M. Lindahl
> > >
> >
> >
> >sql

Olap and reporting service problem

Hi.
This is an OLAP question.
I have a dimension which is a father-son dimension.
I built the cube in analysis server.
In the analysis browser I can see the dimension fine,
I hant my reporting services report to show that dimension.
The problem is that the report won't show me that dimension in
hierarchy tree (even if I check drill down) but flatten it down.
Does some one know if report service can handle those kind of reports?
Thanks.Hi Nick,
I am having the same problem. Have you managed to get an answer? Would love
to know how to solve this.
Anusha
"nicknack" wrote:
> Hi.
> This is an OLAP question.
> I have a dimension which is a father-son dimension.
> I built the cube in analysis server.
> In the analysis browser I can see the dimension fine,
> I hant my reporting services report to show that dimension.
> The problem is that the report won't show me that dimension in
> hierarchy tree (even if I check drill down) but flatten it down.
> Does some one know if report service can handle those kind of reports?
>
> Thanks.
>|||Hi Anusha,
I did managed to get an answer.
You can't do this!
RS is not really an OLAP tool and it doesn't know how to deal with
parent-child dimension and thats why it flatten down the dimension.
Currently, I saw that there isn't any simple way to solve this.
Sorry...
Anusha =D7=9B=D7=AA=D7=91:
> Hi Nick,
> I am having the same problem. Have you managed to get an answer? Would lo=ve
> to know how to solve this.
> Anusha
> "nicknack" wrote:
> > Hi.
> > This is an OLAP question.
> >
> > I have a dimension which is a father-son dimension.
> > I built the cube in analysis server.
> > In the analysis browser I can see the dimension fine,
> >
> > I hant my reporting services report to show that dimension.
> > The problem is that the report won't show me that dimension in
> > hierarchy tree (even if I check drill down) but flatten it down.
> >
> > Does some one know if report service can handle those kind of reports?
> >
> >
> > Thanks.
> >
> >|||Thanks, At least I can stop pulling my hair out!!!
Anusha
"nicknack" wrote:
> Hi Anusha,
> I did managed to get an answer.
> You can't do this!
> RS is not really an OLAP tool and it doesn't know how to deal with
> parent-child dimension and thats why it flatten down the dimension.
>
> Currently, I saw that there isn't any simple way to solve this.
> Sorry...
> Anusha ×?ת×?:
> > Hi Nick,
> >
> > I am having the same problem. Have you managed to get an answer? Would love
> > to know how to solve this.
> >
> > Anusha
> >
> > "nicknack" wrote:
> >
> > > Hi.
> > > This is an OLAP question.
> > >
> > > I have a dimension which is a father-son dimension.
> > > I built the cube in analysis server.
> > > In the analysis browser I can see the dimension fine,
> > >
> > > I hant my reporting services report to show that dimension.
> > > The problem is that the report won't show me that dimension in
> > > hierarchy tree (even if I check drill down) but flatten it down.
> > >
> > > Does some one know if report service can handle those kind of reports?
> > >
> > >
> > > Thanks.
> > >
> > >
>sql

Ok, Apply buttons not working in Report Manager

This is weird. I have 2 different installs of Reporting Services and both do
nothing when trying to upload a file (rdl, datasource, etc)
Basically, the buttons don't post. This also happens on the apply buttons
in the property pages. Cancel and other buttons work.
I am thinking I need something in my aspnet_client folder that is not there.
I have the 1_1_4322 folder.
Any ideas?Nevermind...This happens if you misconfigure stuff when moving virtual
directories to another site.
"Eric" wrote:
> This is weird. I have 2 different installs of Reporting Services and both do
> nothing when trying to upload a file (rdl, datasource, etc)
> Basically, the buttons don't post. This also happens on the apply buttons
> in the property pages. Cancel and other buttons work.
> I am thinking I need something in my aspnet_client folder that is not there.
> I have the 1_1_4322 folder.
> Any ideas?

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....
What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.
|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?
|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....
What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.
|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?
|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

sql

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....
What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.
|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?
|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....
What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.
|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?
|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

OK button not working...

I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK.

I have installed the app, SP2, and a hotfix that is on the website. Help....
What happens when you try to click the OK button, or is it disabled?|||Thanks. The button presses, but doesn't "click". There aren't any tool tips when I mouse over or hover, and the page doesn't change.|||I have tried to reinstall the Reoporting Services app on the server, but after the install was completed, the functions are the same. I cannot use the web page GUI to do anything. I can deploy reports and data connections via Visual Studio, though. I need the web GUI to work too. HELP!|||This sounds like some sort of network issue. Can you access it while logged in on the server? Does http://localhost/reports work? Do you have any special security set in the browser? Does it work from other machines?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same "Ok button" issue. Was this ever resolved?|||I just solved this problem.

For some reason, my aspnet_client/system_web/1_1_4322 directory was missing. In that directory is WebUIValidation.js, a file required by Reporting Services for validation.

To fix it, I just copied the folder from my local IIS installation and now it works perfectly.|||hmm... it could just be the browser you are using. the first time i used reporting services (without reading the requirements specs - who wants to waste time on that kinda ***? ) i was working on mozilla and most of the functionality got disabled. the safest browser to use with reporting services is ie.
|||osubvr

Did you reinstall .net framework or copy file? Has anyone else had this issue?
|||

I have the same issue. Nothing seems to work:

the file is there

reinstalling .Net doesn't bring any good news either.

I even put the physical name in machine.conf in the root of .Net and still nothing

Please Help!

|||I reinstalled .net framework and now the buttons are working again.....weird|||

I deleted even the aspnet_client directory and then simply used aspnet_regiis -i. No error messages. the aspnet_client directory was copied back to inetpub\wwwroot\ but my SQLReportingServices still not working (web interface) ..always asking for his WebUiValidation.js. I'm exasperated.

I have an SBS Premium...I don't know if this makes any change to a normal Server 2003.

|||Miracle..but it works now. The mysteries of computer science...|||

I only have the D:\InetPub\WWWRoot\aspnet_client\system_web\2_0_50727 folder...it does not include any files...should it? I just installed this on a fresh server...

BTW, the other issue is that reports have "X" for the controls...assume its tied to the same issue...

|||

I've run aspnet_regiss -i (and -c) , I still get the same error. The complication might be that the default website points to d:/websites/wwwroot instead of c:/inetpub.

Is there any way to get it to work?

Regards Bert

Ok button not responding

I installed the developer version of reporting services
and I am having problems getting things entered in the
admin screens. When I go to the "New Data Source"
screen, the OK button does nothing. I have no script
errors on the page, and have other .net applications
running on the web server. I also have problems when
trying to update roles/security. I get an error when
click the ok button telling me that I need to select at
least 1 role even though I have them selected.I ran this command and all my .net pages stopped
responding. I had to uninstall .net and reinstall, and
then uninstall RS and reinstall and I still have the same
problem.
Any suggestions?
Thanks,
Dan J
>--Original Message--
>Dan
>I also encountered this problem.
>Sometimes during the install the IIS registration fails.
If you run the
>following at the command line this resolves the problem.
>C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
\aspnet_regiis.exe -i
>This should fix your problem
>Cheers
>
>"Dan J" wrote:
>> I installed the developer version of reporting
services
>> and I am having problems getting things entered in the
>> admin screens. When I go to the "New Data Source"
>> screen, the OK button does nothing. I have no script
>> errors on the page, and have other .net applications
>> running on the web server. I also have problems when
>> trying to update roles/security. I get an error when
>> click the ok button telling me that I need to select
at
>> least 1 role even though I have them selected.
>>
>.
>|||Dan,
I ran into something like this before. Reporting services installs to your
default website. When things get moved around (like I tried to do), your root
website can be missing the aspnet_client folder (usually found in
c:\inetpub\wwwroot). Just copy this folder over to the root of your website.
That folder contains some java scripts that contain some generic code which
is required for RS to execute the commands in the manager.
- Matt
"Dan J" wrote:
> I ran this command and all my .net pages stopped
> responding. I had to uninstall .net and reinstall, and
> then uninstall RS and reinstall and I still have the same
> problem.
> Any suggestions?
> Thanks,
> Dan J
> >--Original Message--
> >Dan
> >
> >I also encountered this problem.
> >
> >Sometimes during the install the IIS registration fails.
> If you run the
> >following at the command line this resolves the problem.
> >
> >C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
> \aspnet_regiis.exe -i
> >
> >This should fix your problem
> >
> >Cheers
> >
> >
> >"Dan J" wrote:
> >
> >> I installed the developer version of reporting
> services
> >> and I am having problems getting things entered in the
> >> admin screens. When I go to the "New Data Source"
> >> screen, the OK button does nothing. I have no script
> >> errors on the page, and have other .net applications
> >> running on the web server. I also have problems when
> >> trying to update roles/security. I get an error when
> >> click the ok button telling me that I need to select
> at
> >> least 1 role even though I have them selected.
> >>
> >>
> >.
> >
>|||I havent moved any websites on my server. I tried
copying the aspnet_client to the root of both of the RS
virtual directories (out of frustration) but still no
luck. I assume it is an asp problem, just not sure what
it needs. I havent done anything "wierd" with the server
or any of the installs.
Please help!!!
Dan
>--Original Message--
>Dan,
>I ran into something like this before. Reporting
services installs to your
>default website. When things get moved around (like I
tried to do), your root
>website can be missing the aspnet_client folder (usually
found in
>c:\inetpub\wwwroot). Just copy this folder over to the
root of your website.
>That folder contains some java scripts that contain some
generic code which
>is required for RS to execute the commands in the
manager.
>- Matt
>"Dan J" wrote:
>> I ran this command and all my .net pages stopped
>> responding. I had to uninstall .net and reinstall,
and
>> then uninstall RS and reinstall and I still have the
same
>> problem.
>> Any suggestions?
>> Thanks,
>> Dan J
>> >--Original Message--
>> >Dan
>> >
>> >I also encountered this problem.
>> >
>> >Sometimes during the install the IIS registration
fails.
>> If you run the
>> >following at the command line this resolves the
problem.
>> >
>> >C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
>> \aspnet_regiis.exe -i
>> >
>> >This should fix your problem
>> >
>> >Cheers
>> >
>> >
>> >"Dan J" wrote:
>> >
>> >> I installed the developer version of reporting
>> services
>> >> and I am having problems getting things entered in
the
>> >> admin screens. When I go to the "New Data Source"
>> >> screen, the OK button does nothing. I have no
script
>> >> errors on the page, and have other .net
applications
>> >> running on the web server. I also have problems
when
>> >> trying to update roles/security. I get an error
when
>> >> click the ok button telling me that I need to
select
>> at
>> >> least 1 role even though I have them selected.
>> >>
>> >>
>> >.
>> >
>.
>sql

OK button is not working on file upload page

Hi everybody,
I hope than somebody can help me to fix my reporting services server.
I can upload reports on my reportin services server i dont know why but when
i press the OK button nothings happend everything is working bit i need to to
ulpload to new reports but i can't...
maybe if smebody know some diagnostic tool than can help to fix the problem
will be great.
plase, help....
Thanks.This happened to me once. But with the Apply button in the parameters section
of the report manager. This indicates the installation of reporting services
is corrupted and I had to reinstall it on the server.
Maybe that's not the problem for you, but it solved my problem.
"Edman" wrote:
> Hi everybody,
> I hope than somebody can help me to fix my reporting services server.
> I can upload reports on my reportin services server i dont know why but when
> i press the OK button nothings happend everything is working bit i need to to
> ulpload to new reports but i can't...
> maybe if smebody know some diagnostic tool than can help to fix the problem
> will be great.
> plase, help....
> Thanks.

Offsite Printing

Anyone have any suggestions on how I can go about getting Reporting Services
Reports(about 2000 pages) printed by a 3rd party printshop? PDF export etcmy co in the past has output the rpt to a PDF file, put the pdf on a cd, then
taken it to Kinkos to have them print out the file. This has worked will even
when travelling around the country.
hth!
"Davin" wrote:
> Anyone have any suggestions on how I can go about getting Reporting Services
> Reports(about 2000 pages) printed by a 3rd party printshop? PDF export etcsql

Offline Reporting DB...

A customer of ours was considering replication as a means of maintaining
data in a second DB on a second server for reporting use only. We think
replication is overkill since they won't mind if the data is a day or two
old.
I like the idea of simply restoring their most recent full backup on the
reporting server, but I'm not sure if they do a full backup every night.
What are other approaches that folks use to accomplish this sort of thing?
Log shipping doesn't seem right; replication seems like overkill. DTS
possibly? Any thoughts, links, or words will be greatly appreciated!
Thanks in advance for your time,
James Hunter RossWithout details about the database size, your connection bandwidth, etc.,
it's hard to say what is the best way for your needs.
If the customer can tolerate data two days old, you can use snapshot
replication and set the snapshot interval as 48 hours. Yuo can also make use
of log shipping secondary server with restored databases being in read-only
mode. Then users can run reports off the databases from time to time. The
inconvenience with log shipping is to regularly kick users out of the
database so that restore of transaction logs can go on. The third option
will be increase full backup frequency so that there is a full backup every
two days, otherwise you will have to restore from a full backup more than 2
days ago and apply all subsequent transaction logs.
Other things you can consider: will copy database wizard apply? It requires
the database being shut down.
Richard
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OYhK%23KdcFHA.3828@.tk2msftngp13.phx.gbl...
>A customer of ours was considering replication as a means of maintaining
>data in a second DB on a second server for reporting use only. We think
>replication is overkill since they won't mind if the data is a day or two
>old.
> I like the idea of simply restoring their most recent full backup on the
> reporting server, but I'm not sure if they do a full backup every night.
> What are other approaches that folks use to accomplish this sort of thing?
> Log shipping doesn't seem right; replication seems like overkill. DTS
> possibly? Any thoughts, links, or words will be greatly appreciated!
> Thanks in advance for your time,
> James Hunter Ross
>|||Keep it simple, if possible. Backup restore is as simple as it gets, and you get your backups tested
each time.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OYhK%23KdcFHA.3828@.tk2msftngp13.phx.gbl...
>A customer of ours was considering replication as a means of maintaining data in a second DB on a
>second server for reporting use only. We think replication is overkill since they won't mind if
>the data is a day or two old.
> I like the idea of simply restoring their most recent full backup on the reporting server, but I'm
> not sure if they do a full backup every night.
> What are other approaches that folks use to accomplish this sort of thing? Log shipping doesn't
> seem right; replication seems like overkill. DTS possibly? Any thoughts, links, or words will be
> greatly appreciated!
> Thanks in advance for your time,
> James Hunter Ross
>|||We use log shipping for this as our main DB is too large to restore nightly.
Works well.
Mike Kruchten
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OYhK%23KdcFHA.3828@.tk2msftngp13.phx.gbl...
>A customer of ours was considering replication as a means of maintaining
>data in a second DB on a second server for reporting use only. We think
>replication is overkill since they won't mind if the data is a day or two
>old.
> I like the idea of simply restoring their most recent full backup on the
> reporting server, but I'm not sure if they do a full backup every night.
> What are other approaches that folks use to accomplish this sort of thing?
> Log shipping doesn't seem right; replication seems like overkill. DTS
> possibly? Any thoughts, links, or words will be greatly appreciated!
> Thanks in advance for your time,
> James Hunter Ross
>

Offline Reporting DB...

A customer of ours was considering replication as a means of maintaining
data in a second DB on a second server for reporting use only. We think
replication is overkill since they won't mind if the data is a day or two
old.
I like the idea of simply restoring their most recent full backup on the
reporting server, but I'm not sure if they do a full backup every night.
What are other approaches that folks use to accomplish this sort of thing?
Log shipping doesn't seem right; replication seems like overkill. DTS
possibly? Any thoughts, links, or words will be greatly appreciated!
Thanks in advance for your time,
James Hunter Ross
Without details about the database size, your connection bandwidth, etc.,
it's hard to say what is the best way for your needs.
If the customer can tolerate data two days old, you can use snapshot
replication and set the snapshot interval as 48 hours. Yuo can also make use
of log shipping secondary server with restored databases being in read-only
mode. Then users can run reports off the databases from time to time. The
inconvenience with log shipping is to regularly kick users out of the
database so that restore of transaction logs can go on. The third option
will be increase full backup frequency so that there is a full backup every
two days, otherwise you will have to restore from a full backup more than 2
days ago and apply all subsequent transaction logs.
Other things you can consider: will copy database wizard apply? It requires
the database being shut down.
Richard
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OYhK%23KdcFHA.3828@.tk2msftngp13.phx.gbl...
>A customer of ours was considering replication as a means of maintaining
>data in a second DB on a second server for reporting use only. We think
>replication is overkill since they won't mind if the data is a day or two
>old.
> I like the idea of simply restoring their most recent full backup on the
> reporting server, but I'm not sure if they do a full backup every night.
> What are other approaches that folks use to accomplish this sort of thing?
> Log shipping doesn't seem right; replication seems like overkill. DTS
> possibly? Any thoughts, links, or words will be greatly appreciated!
> Thanks in advance for your time,
> James Hunter Ross
>
|||Keep it simple, if possible. Backup restore is as simple as it gets, and you get your backups tested
each time.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OYhK%23KdcFHA.3828@.tk2msftngp13.phx.gbl...
>A customer of ours was considering replication as a means of maintaining data in a second DB on a
>second server for reporting use only. We think replication is overkill since they won't mind if
>the data is a day or two old.
> I like the idea of simply restoring their most recent full backup on the reporting server, but I'm
> not sure if they do a full backup every night.
> What are other approaches that folks use to accomplish this sort of thing? Log shipping doesn't
> seem right; replication seems like overkill. DTS possibly? Any thoughts, links, or words will be
> greatly appreciated!
> Thanks in advance for your time,
> James Hunter Ross
>
|||We use log shipping for this as our main DB is too large to restore nightly.
Works well.
Mike Kruchten
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OYhK%23KdcFHA.3828@.tk2msftngp13.phx.gbl...
>A customer of ours was considering replication as a means of maintaining
>data in a second DB on a second server for reporting use only. We think
>replication is overkill since they won't mind if the data is a day or two
>old.
> I like the idea of simply restoring their most recent full backup on the
> reporting server, but I'm not sure if they do a full backup every night.
> What are other approaches that folks use to accomplish this sort of thing?
> Log shipping doesn't seem right; replication seems like overkill. DTS
> possibly? Any thoughts, links, or words will be greatly appreciated!
> Thanks in advance for your time,
> James Hunter Ross
>

Offline Reporting DB...

A customer of ours was considering replication as a means of maintaining
data in a second DB on a second server for reporting use only. We think
replication is overkill since they won't mind if the data is a day or two
old.
I like the idea of simply restoring their most recent full backup on the
reporting server, but I'm not sure if they do a full backup every night.
What are other approaches that folks use to accomplish this sort of thing?
Log shipping doesn't seem right; replication seems like overkill. DTS
possibly? Any thoughts, links, or words will be greatly appreciated!
Thanks in advance for your time,
James Hunter RossWithout details about the database size, your connection bandwidth, etc.,
it's hard to say what is the best way for your needs.
If the customer can tolerate data two days old, you can use snapshot
replication and set the snapshot interval as 48 hours. Yuo can also make use
of log shipping secondary server with restored databases being in read-only
mode. Then users can run reports off the databases from time to time. The
inconvenience with log shipping is to regularly kick users out of the
database so that restore of transaction logs can go on. The third option
will be increase full backup frequency so that there is a full backup every
two days, otherwise you will have to restore from a full backup more than 2
days ago and apply all subsequent transaction logs.
Other things you can consider: will copy database wizard apply? It requires
the database being shut down.
Richard
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OYhK%23KdcFHA.3828@.tk2msftngp13.phx.gbl...
>A customer of ours was considering replication as a means of maintaining
>data in a second DB on a second server for reporting use only. We think
>replication is overkill since they won't mind if the data is a day or two
>old.
> I like the idea of simply restoring their most recent full backup on the
> reporting server, but I'm not sure if they do a full backup every night.
> What are other approaches that folks use to accomplish this sort of thing?
> Log shipping doesn't seem right; replication seems like overkill. DTS
> possibly? Any thoughts, links, or words will be greatly appreciated!
> Thanks in advance for your time,
> James Hunter Ross
>|||Keep it simple, if possible. Backup restore is as simple as it gets, and you
get your backups tested
each time.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OYhK%23KdcFHA.3828@.tk2msftngp13.phx.gbl...
>A customer of ours was considering replication as a means of maintaining da
ta in a second DB on a
>second server for reporting use only. We think replication is overkill sin
ce they won't mind if
>the data is a day or two old.
> I like the idea of simply restoring their most recent full backup on the r
eporting server, but I'm
> not sure if they do a full backup every night.
> What are other approaches that folks use to accomplish this sort of thing?
Log shipping doesn't
> seem right; replication seems like overkill. DTS possibly? Any thoughts,
links, or words will be
> greatly appreciated!
> Thanks in advance for your time,
> James Hunter Ross
>|||We use log shipping for this as our main DB is too large to restore nightly.
Works well.
Mike Kruchten
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OYhK%23KdcFHA.3828@.tk2msftngp13.phx.gbl...
>A customer of ours was considering replication as a means of maintaining
>data in a second DB on a second server for reporting use only. We think
>replication is overkill since they won't mind if the data is a day or two
>old.
> I like the idea of simply restoring their most recent full backup on the
> reporting server, but I'm not sure if they do a full backup every night.
> What are other approaches that folks use to accomplish this sort of thing?
> Log shipping doesn't seem right; replication seems like overkill. DTS
> possibly? Any thoughts, links, or words will be greatly appreciated!
> Thanks in advance for your time,
> James Hunter Ross
>sql

Office Web Components

Do the interactivity features of OWC client side exist with reporting
services?
Can we replace the work that we do now with OWC and lots of javascript with
RS?I've looked at trying to replicate the pivottable owc in reporting services
but rs just isn't for that, well not without a mega amount of programming.
What part of OWC are you using?
--
Tony Rogerson
SQL Server MVP
http://www.sqlserverfaq.com?mbr=21
(Create your own groups, Forum, FAQ's and a ton more)|||No, RS matrix and chart regions are not meant to replace OWC. As you would
understand it is difficult to implement the same functionality in HTML than
using ActiveX controls. However, you can integrate your OWC components to
run RS reports, e.g. when the lowest level in a dimension hierarchy is
reached.
One more thing. In RS OWC are used only when exporting the report to HTML
OWC format. When this happen, RS exports matrix regions as pivot tables,
charts as chart space objects. However, OWC is not linked to the data
source. Instead, the data is always restricted to the data that the report
query returns.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Mike B" <MikeB@.discussions.microsoft.com> wrote in message
news:D7C0A07C-527C-45AD-9ECE-614BBF123027@.microsoft.com...
> Do the interactivity features of OWC client side exist with reporting
> services?
> Can we replace the work that we do now with OWC and lots of javascript
with
> RS?

Office and Adobe Compatibiiltly

SQL Server Reporting Services can export to Excel and Adobe. Which versions
of these products are supported?for rs 2005
pdf is 1.3
i have tested xls only on Offce 2003 and above
"Dave" wrote:
> SQL Server Reporting Services can export to Excel and Adobe. Which versions
> of these products are supported?|||Actually, the Adobe version supported is 4.x and above. For Excel, it's what
they call the 97-2003 .xls format in Excel 2007 (which works fine in Excel
2007, btw).
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Jimbo" <Jimbo@.discussions.microsoft.com> wrote in message
news:744AC534-34CF-4EC5-8518-95C41E29E617@.microsoft.com...
> for rs 2005
> pdf is 1.3
> i have tested xls only on Offce 2003 and above
>
>
>
> "Dave" wrote:
>> SQL Server Reporting Services can export to Excel and Adobe. Which
>> versions
>> of these products are supported?|||Hi Alain,
Yes, you are right. I just would like to clarify that although PDF 1.3 is
compatible with Adobe Acrobat 4, Reporting Services supports Adobe Acrobat
6 or later.
You can refer to:
Designing for PDF Output
http://msdn2.microsoft.com/en-us/library/ms159713.aspx
Exporting Reports (Reporting Services)
http://msdn2.microsoft.com/en-us/library/ms157153(SQL.100).aspx
Thank you and have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@.microsoft.com.
===========================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================|||Great stuff. Thanks all!
"Charles Wang[MSFT]" wrote:
> Hi Alain,
> Yes, you are right. I just would like to clarify that although PDF 1.3 is
> compatible with Adobe Acrobat 4, Reporting Services supports Adobe Acrobat
> 6 or later.
> You can refer to:
> Designing for PDF Output
> http://msdn2.microsoft.com/en-us/library/ms159713.aspx
> Exporting Reports (Reporting Services)
> http://msdn2.microsoft.com/en-us/library/ms157153(SQL.100).aspx
> Thank you and have a nice day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ===========================================================> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg@.microsoft.com.
> ===========================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ============================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> =========================================================>

Odd report behavior

When I run a reporting services report from report manager the report
executes over and over again. I have to close the browser to stop it. Has
anyone seen this behavior
ThanksCheck report properties, autorefresh and make sure there is not a value for
it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Will Byron" <will.byron@.maxqtech.com> wrote in message
news:eBbrdKb%23EHA.2568@.TK2MSFTNGP11.phx.gbl...
> When I run a reporting services report from report manager the report
> executes over and over again. I have to close the browser to stop it. Has
> anyone seen this behavior
> Thanks
>|||Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23aLcjRb%23EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Check report properties, autorefresh and make sure there is not a value
for
> it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Will Byron" <will.byron@.maxqtech.com> wrote in message
> news:eBbrdKb%23EHA.2568@.TK2MSFTNGP11.phx.gbl...
> > When I run a reporting services report from report manager the report
> > executes over and over again. I have to close the browser to stop it.
Has
> > anyone seen this behavior
> > Thanks
> >
> >
>

Odd query problem

All,
Sql 2000, sp3, Server 2000 sp4
I have 2 servers, a production and a warm standby that I
use for some reporting. The problem I am having is that on
my production server, execution plan is showing a 55% use
for a sort. That same sort is not on the standby server.
The standby completes queries in 10% of the time on
production. They are not identical servers, my production
is a much faster machine. This problem has just started in
the last week. I have done update statistics for all the
tables in the db. I do indexdefrags about once a month, my
db is 350 gbs in size. There is one table that I have not
touched at all yet, there are 1.5 billion rows in this
table. Any other ideas, before I tackle this table.
Interesting note, if I do a select top 100 on production
the ep is similar to the one on my standby. Any reasons?
Thanks in advance all,
Gary AbbottProbably due to other load and use on your production server. You can try
clearing data and procedure cache on the production box (NOTE: This may
cause a severe performance bottleneck if your server is experiencing any
kind of load. Do this during way-off-peak hours only).
To clear data cache: DBCC DROPCLEANBUFFERS
To clear procedure cache: DBCC FREEPROCCACHE
If you are comparing query performance on two different systems, this is the
only way to make sure current cache state doesn't overly influience the
outcomes.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Gary Abbott" <anonymous@.discussions.microsoft.com> wrote in message
news:ed1901c3f0c0$0fe1f700$a501280a@.phx.gbl...
> All,
> Sql 2000, sp3, Server 2000 sp4
> I have 2 servers, a production and a warm standby that I
> use for some reporting. The problem I am having is that on
> my production server, execution plan is showing a 55% use
> for a sort. That same sort is not on the standby server.
> The standby completes queries in 10% of the time on
> production. They are not identical servers, my production
> is a much faster machine. This problem has just started in
> the last week. I have done update statistics for all the
> tables in the db. I do indexdefrags about once a month, my
> db is 350 gbs in size. There is one table that I have not
> touched at all yet, there are 1.5 billion rows in this
> table. Any other ideas, before I tackle this table.
> Interesting note, if I do a select top 100 on production
> the ep is similar to the one on my standby. Any reasons?
> Thanks in advance all,
> Gary Abbott|||you need to provide more info on the query, relevent
indexes in each db, and the execution plan details,
if there is a difference in the execution plan, then
either one has difference indexes or the statistics are
different, what does the execution plan show for estimated
row count in each case?
>--Original Message--
>All,
>Sql 2000, sp3, Server 2000 sp4
>I have 2 servers, a production and a warm standby that I
>use for some reporting. The problem I am having is that
on
>my production server, execution plan is showing a 55% use
>for a sort. That same sort is not on the standby server.
>The standby completes queries in 10% of the time on
>production. They are not identical servers, my production
>is a much faster machine. This problem has just started
in
>the last week. I have done update statistics for all the
>tables in the db. I do indexdefrags about once a month,
my
>db is 350 gbs in size. There is one table that I have not
>touched at all yet, there are 1.5 billion rows in this
>table. Any other ideas, before I tackle this table.
>Interesting note, if I do a select top 100 on production
>the ep is similar to the one on my standby. Any reasons?
>Thanks in advance all,
>Gary Abbott
>.
>

Odd query problem

All,
Sql 2000, sp3, Server 2000 sp4
I have 2 servers, a production and a warm standby that I
use for some reporting. The problem I am having is that on
my production server, execution plan is showing a 55% use
for a sort. That same sort is not on the standby server.
The standby completes queries in 10% of the time on
production. They are not identical servers, my production
is a much faster machine. This problem has just started in
the last week. I have done update statistics for all the
tables in the db. I do indexdefrags about once a month, my
db is 350 gbs in size. There is one table that I have not
touched at all yet, there are 1.5 billion rows in this
table. Any other ideas, before I tackle this table.
Interesting note, if I do a select top 100 on production
the ep is similar to the one on my standby. Any reasons?
Thanks in advance all,
Gary AbbottProbably due to other load and use on your production server. You can try
clearing data and procedure cache on the production box (NOTE: This may
cause a severe performance bottleneck if your server is experiencing any
kind of load. Do this during way-off-peak hours only).
To clear data cache: DBCC DROPCLEANBUFFERS
To clear procedure cache: DBCC FREEPROCCACHE
If you are comparing query performance on two different systems, this is the
only way to make sure current cache state doesn't overly influience the
outcomes.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Gary Abbott" <anonymous@.discussions.microsoft.com> wrote in message
news:ed1901c3f0c0$0fe1f700$a501280a@.phx.gbl...
> All,
> Sql 2000, sp3, Server 2000 sp4
> I have 2 servers, a production and a warm standby that I
> use for some reporting. The problem I am having is that on
> my production server, execution plan is showing a 55% use
> for a sort. That same sort is not on the standby server.
> The standby completes queries in 10% of the time on
> production. They are not identical servers, my production
> is a much faster machine. This problem has just started in
> the last week. I have done update statistics for all the
> tables in the db. I do indexdefrags about once a month, my
> db is 350 gbs in size. There is one table that I have not
> touched at all yet, there are 1.5 billion rows in this
> table. Any other ideas, before I tackle this table.
> Interesting note, if I do a select top 100 on production
> the ep is similar to the one on my standby. Any reasons?
> Thanks in advance all,
> Gary Abbott