Report Formatting: running

Showing posts with label running. Show all posts

Friday, March 30, 2012

report parameter with mdx

Hi,
I am running analysis services with SQL Server 2000. There I created a
cube which I am handling with reporting services. So far, no problem.
But now I also added some report parameter, which I would like to use
to define the dataset. But every time when I try to include a parameter
into the mdx-query I get an error-message, that named parameter are not
supported by OLE DB. I try to call a parameter by @.param_name
Is it possible to include reportparameter in mdx-queries?
If yes, how?
Thanksyes it is, show me your mdx query and i'll tell you how to do it.
Greg
"mickmack" <access.20.mickmack@.spamgourmet.com> wrote in message
news:1134637862.017069.135030@.o13g2000cwo.googlegroups.com...
> Hi,
> I am running analysis services with SQL Server 2000. There I created a
> cube which I am handling with reporting services. So far, no problem.
> But now I also added some report parameter, which I would like to use
> to define the dataset. But every time when I try to include a parameter
> into the mdx-query I get an error-message, that named parameter are not
> supported by OLE DB. I try to call a parameter by @.param_name
> Is it possible to include reportparameter in mdx-queries?
> If yes, how?
> Thanks
>|||Hi Greg,
thanks for your response.
Thats my current query:
WITH
MEMBER [Measures].[percentage] AS '[Measures].[Analysis_Count] /
([Measures].[Analysis_Count], [analysis].[Alle Analysis])',
FORMAT_STRING = 'Percent'
SELECT
{[Measures].[Analysis_Count], [Measures].[percentage]} ON AXIS(0),
{client.members} ON AXIS(1),
{area.members} ON AXIS(2),
{date_month.members} ON AXIS(3),
{analysis.members} ON AXIS(4)
FROM ISDBIv2
something like that I would like to add:
... WHERE ([client].[@.paramname])
Thanks|||Hi Greg,
thanks for your response.
Thats my current query:
WITH
MEMBER [Measures].[percentage] AS '[Measures].[Analysis_Count] /
([Measures].[Analysis_Count], [analysis].[Alle Analysis])',
FORMAT_STRING = 'Percent'
SELECT
{[Measures].[Analysis_Count], [Measures].[percentage]} ON AXIS(0),
{client.members} ON AXIS(1),
{area.members} ON AXIS(2),
{date_month.members} ON AXIS(3),
{analysis.members} ON AXIS(4)
FROM ISDBIv2
something like that I would like to add:
... WHERE ([client].[@.paramname])
Thanks|||ok, no problem. i assume client is a dimension so,
you do this
1. run the query without the parameter in so you get the fields
2. create a second dataset which just gets out the clients
select {[Measures].[Analysis_count]} on AXIS(0),
{[client].Members} on AXIS(1)
from FROM ISDBIv2
3. set up the parameter as you would normally, i.e. click Report -> Report
Parameters etc etc, give it a name 'paramname' and get it to get the clients
from that dataset
4. change the main query to
= "WITH " &
"MEMBER [Measures].[percentage]" & "AS " &
"'[Measures].[Analysis_Count] / ([Measures].[Analysis_Count],
[analysis].[Alle Analysis])', " &
"FORMAT_STRING = 'Percent' " &
"SELECT " &
"{[Measures].[Analysis_Count], [Measures].[percentage]} ON AXIS(0), "&
" {client.members} ON AXIS(1), " &
"{area.members} ON AXIS(2), " &
"{date_month.members} ON AXIS(3), " &
"{analysis.members} ON AXIS(4) " &
"FROM ISDBIv2 " &
"where ([client].[ " & Parameters!paramname.Value & "])"
that should do it, very long winded explanation, but thought i'd cover all
bases just incase. You will notice that you cannot run the query anymore
this is because of the = sign, but do a preview and it should work. Any
problems let me know, cos i've come accross quite a few random ones.
good luck Greg
"mickmack" <access.20.mickmack@.spamgourmet.com> wrote in message
news:1134651740.902628.68600@.o13g2000cwo.googlegroups.com...
> Hi Greg,
> thanks for your response.
> Thats my current query:
> WITH
> MEMBER [Measures].[percentage] AS '[Measures].[Analysis_Count] /
> ([Measures].[Analysis_Count], [analysis].[Alle Analysis])',
> FORMAT_STRING = 'Percent'
> SELECT
> {[Measures].[Analysis_Count], [Measures].[percentage]} ON AXIS(0),
> {client.members} ON AXIS(1),
> {area.members} ON AXIS(2),
> {date_month.members} ON AXIS(3),
> {analysis.members} ON AXIS(4)
> FROM ISDBIv2
> something like that I would like to add:
> ... WHERE ([client].[@.paramname])
> Thanks
>|||Hi Greg,
thanks. that is the solution I were looking for. The first three steps
I had allready done. But the way to build the query by concatenating
the substrings was very useful.
But I got one big problem. Every time I try to do the preview I got an
error message:
"... double dimensions about (independent) axis - during calculating an
axis" (translated to english)
When I delete the " {client.members} ON AXIS(1), " &" - part the
preview is running. Unfortunatly I need this dimension in my matrix.
Do you have some ideas?
thanks|||I guess, I found the orginal english error message. It is:
"... duplicate dimensions accross independent axis..."|||sorry my fault, should've actually read the script.
Take the where clause out completely and put this in
"{[client].[ " & Parameters!paramname.Value & "]} ON AXIS(1), " &
instead of
" {client.members} ON AXIS(1), " &
The problem is that the original script was referring to the same dimension
twice. Sorry bout that,should work fine now. Let me know how it goes.
Greg
"mickmack" <access.20.mickmack@.spamgourmet.com> wrote in message
news:1134725728.305647.143860@.z14g2000cwz.googlegroups.com...
> Hi Greg,
> thanks. that is the solution I were looking for. The first three steps
> I had allready done. But the way to build the query by concatenating
> the substrings was very useful.
> But I got one big problem. Every time I try to do the preview I got an
> error message:
> "... double dimensions about (independent) axis - during calculating an
> axis" (translated to english)
> When I delete the " {client.members} ON AXIS(1), " &" - part the
> preview is running. Unfortunatly I need this dimension in my matrix.
> Do you have some ideas?
> thanks
>|||Yes, indeed it is working pretty fine now :-) But one last question.
What do I have do to filter data where "date_month.members" are older
than "startdate" and younger than "enddate". I know that is normal mdx.
but i havent done this before.
thanks|||From what you've said i assume you have parameters 'startdate' and
'enddate'. So you can do this by applying a filter to the main dataset.
click the '...' button next to the dataset title and click the filters tab.
In the expressions put date field in the expressions box should look
something like Fields!datename.value then put >= in operator box and put the
startdate parameter in the value box, you'll find it by clicking on the
expression option on the drop down from value. Then repeat for the end date
but put <= in the operator box.
That should do it. I can't off the top of my head think how to do it mdx
without referring to the date_month.members twice and we know that will
cause problems.
cheers
Greg
"mickmack" <access.20.mickmack@.spamgourmet.com> wrote in message
news:1134728307.957458.193420@.g44g2000cwa.googlegroups.com...
> Yes, indeed it is working pretty fine now :-) But one last question.
> What do I have do to filter data where "date_month.members" are older
> than "startdate" and younger than "enddate". I know that is normal mdx.
> but i havent done this before.
> thanks
>|||Hi Greg,
maybe you are interested in a solution with mdx. It is possible to
declare a MEMBER-Field defining a startdate and enddate.
SET [filter] AS '[date].[2005].[12].[1] : [date].[2005].[12].[19] '
Unfortunatly this method creates some other problems. First the named
dates "2005/12/01" and "2005/12/19" have to exist in your database.
Besides, if your time dimension contains weeks instead of month this
way is not possible, unless you are programming a function which is
calculating a week number of a date. So this way is not the best one.
I tried to solve my problem by using filters. But that creates some
problems too. First of all, my dimension is a time-dimension. So I dont
know how to call the entire date, because the dimension is divided in
day, month, year. In addition I set the type of my parameter (startdate
and enddate) to DateTime. But everytime I when I am calling the
preview, I get the errormessage, that the type of the parameter is not
correct. Switching the type to string, the filter does not work
correctly.
Do you have some ideas?
Thanks|||sorry could you just clarify how your dates are stored in your database? Is
it three different columns, one for day, month and year?
If that is the case you could concatenate them into a string of one date in
reporting services, or you could add a new column to your database with the
full date in...
Sorry if i've misinterpretted the issue here.
Greg
"mickmack" <access.20.mickmack@.spamgourmet.com> wrote in message
news:1134977793.241846.273900@.g44g2000cwa.googlegroups.com...
> Hi Greg,
> maybe you are interested in a solution with mdx. It is possible to
> declare a MEMBER-Field defining a startdate and enddate.
> SET [filter] AS '[date].[2005].[12].[1] : [date].[2005].[12].[19] '
> Unfortunatly this method creates some other problems. First the named
> dates "2005/12/01" and "2005/12/19" have to exist in your database.
> Besides, if your time dimension contains weeks instead of month this
> way is not possible, unless you are programming a function which is
> calculating a week number of a date. So this way is not the best one.
> I tried to solve my problem by using filters. But that creates some
> problems too. First of all, my dimension is a time-dimension. So I dont
> know how to call the entire date, because the dimension is divided in
> day, month, year. In addition I set the type of my parameter (startdate
> and enddate) to DateTime. But everytime I when I am calling the
> preview, I get the errormessage, that the type of the parameter is not
> correct. Switching the type to string, the filter does not work
> correctly.
> Do you have some ideas?
> Thanks
>

Wednesday, March 28, 2012

Report Parameter Dataset Running Twice?

Hi,
I have a DDL Report Parameter tied to a Dataset.
When I go to view the Report in RS the Dataset is run to populate the
Parameter, but it also seems to run the Dataset when I hit the View Report
button.
I don't have the Dataset tied to anything except the Report Parameter.
Is there a way to stop the 2nd run?
thank you
tOn May 22, 11:59 am, DigHazuse <DigHaz...@.discussions.microsoft.com>
wrote:
> Hi,
> I have a DDL Report Parameter tied to a Dataset.
> When I go to view the Report in RS the Dataset is run to populate the
> Parameter, but it also seems to run the Dataset when I hit the View Report
> button.
> I don't have the Dataset tied to anything except the Report Parameter.
> Is there a way to stop the 2nd run?
> thank you
> t
It should only be running to populate the report parameter. It sounds
like you possibly have the autorefresh set for the report (go to the:
Report drop-down tab -> Report Properties... -> General tab ->
autorefresh and see if it is selected). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you for responding Enrique ... unfortunately that box is not checked.
Any other ideas?
thank you
t
"EMartinez" wrote:
> On May 22, 11:59 am, DigHazuse <DigHaz...@.discussions.microsoft.com>
> wrote:
> > Hi,
> > I have a DDL Report Parameter tied to a Dataset.
> >
> > When I go to view the Report in RS the Dataset is run to populate the
> > Parameter, but it also seems to run the Dataset when I hit the View Report
> > button.
> >
> > I don't have the Dataset tied to anything except the Report Parameter.
> >
> > Is there a way to stop the 2nd run?
> >
> > thank you
> > t
>
> It should only be running to populate the report parameter. It sounds
> like you possibly have the autorefresh set for the report (go to the:
> Report drop-down tab -> Report Properties... -> General tab ->
> autorefresh and see if it is selected). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>sql

Monday, March 26, 2012

report not running

hi all

i am working on SQL Reporting 2005.

after clicking on report name in report manager or report server the report is not generated .

The internet explorer shows that "opening page ......." in task bar but actually report is not generated .

However same report runs in preview of SQL server BI development studio.

also the same report runs when deployed in some other machine.

plz help me.

Do you get an error of some sort in IE? Check the log file and event log. Anything identifies the error? Start with your report server.|||

i don't get any kind of error message.

In the task bar IE shows message "opening page..." and also shows the progress bar for loading page but i can only see the page without anythinh on it. Also the progress bar doesn't disappear. i think its sort of infinite loop where IE is trying several times to load that page.

plz help me.

Wednesday, March 21, 2012

Report Model Deployment : The model ID of the submitted model must match that of the

Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:

Error 1 The model ID of the submitted model must match that of the
current model. C:\Source\********.smdl 0 0
Tongue Tied

When I change the name of the smdl, it works fine. (Properties of the .smdl file)

Any ideas?

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

|||

Yes, thanks.

The scenario arises when you try to deploy a model in a NEW report project which has the same name as a model designed in a previous report project.

Jean-Pierre

|||

Lev Semenets - MSFT wrote:
For existing models Deploy actually means Update
However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

How can i remove a model from the server.?

Thanks !!|||

Programmatically - by calling SOAP API method DeleteItem()

|||

Hi,

no need to do SOAP.

Just go to the reporting web site, go to the models folder and delete the report.

Re-deploy and it's updated version is back in the folder.

Report Model Deployment : The model ID of the submitted model must match that of the

Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:

Error 1 The model ID of the submitted model must match that of the
current model. C:\Source\********.smdl 0 0
Tongue Tied

When I change the name of the smdl, it works fine. (Properties of the .smdl file)

Any ideas?

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

|||

Yes, thanks.

The scenario arises when you try to deploy a model in a NEW report project which has the same name as a model designed in a previous report project.

Jean-Pierre

|||

Lev Semenets - MSFT wrote:
For existing models Deploy actually means Update
However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

How can i remove a model from the server.?

Thanks !!
|||

Programmatically - by calling SOAP API method DeleteItem()

|||

Hi,

no need to do SOAP.

Just go to the reporting web site, go to the models folder and delete the report.

Re-deploy and it's updated version is back in the folder.

Report Model Deployment : The model ID of the submitted model must match that of the

Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:

Error 1 The model ID of the submitted model must match that of the
current model. C:\Source\********.smdl 0 0
Tongue Tied

When I change the name of the smdl, it works fine. (Properties of the .smdl file)

Any ideas?

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

|||

Yes, thanks.

The scenario arises when you try to deploy a model in a NEW report project which has the same name as a model designed in a previous report project.

Jean-Pierre

|||

Lev Semenets - MSFT wrote:
For existing models Deploy actually means Update
However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

How can i remove a model from the server.?

Thanks !!|||

Programmatically - by calling SOAP API method DeleteItem()

|||

Hi,

no need to do SOAP.

Just go to the reporting web site, go to the models folder and delete the report.

Re-deploy and it's updated version is back in the folder.

Report Model Deployment : The model ID of the submitted model must match that of the

Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:

Error 1 The model ID of the submitted model must match that of the
current model. C:\Source\********.smdl 0 0
Tongue Tied

When I change the name of the smdl, it works fine. (Properties of the .smdl file)

Any ideas?

For existing models Deploy actually means Update

However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

|||

Yes, thanks.

The scenario arises when you try to deploy a model in a NEW report project which has the same name as a model designed in a previous report project.

Jean-Pierre

|||

Lev Semenets - MSFT wrote:
For existing models Deploy actually means Update
However if Model ID is different, this cannot be considered as Update - the model may be completely different. In this case user must remove model from server before re-deploying it.

How can i remove a model from the server.?

Thanks !!|||

Programmatically - by calling SOAP API method DeleteItem()

|||

Hi,

no need to do SOAP.

Just go to the reporting web site, go to the models folder and delete the report.

Re-deploy and it's updated version is back in the folder.

Tuesday, March 20, 2012

Report manager very slow on first access

I'm learning Reporting Services 2000, and running it on a Win2k3 server. I
am the only person using the server and the network, so there are no issues
about many people trying to access anything.
While learning to build an ASP.NET application I ran across something
strange. The first time a report is run it takes a long time for the report
to render (regardless of whether I am accessing it through my web application
or through the Report Manger). After that the report would refresh fine
unless not accessed for a while.
After a bunch of google searches etc. I discovered I could elimnate (or
extend) the Idle Timeout for the DefaultAppPool and it would refresh without
a timeout problem. However, that does not solve the initial request which
still takes a while.
Can the w3wp.exe file be told to run when the server is booted up? Is there
some better way to handle this?
I read a post somewhere that suggested scheduling a dumby report to run at a
particular time so as to keep the Report server running. Are there not more
elegant ways to kick-start the Report Server and keep it running so that a
user won't experience the long delay if they are the first user of the day?
Thanks in advance.Nope, you pretty much have all the issues down. Scheduling a report to run
isn't too bad a solution (added to modifying the idle timeout). I have a
report that I look at daily anyway so I run that report and email it to
myself.
Another possibility, you can have a report autorefresh. I did that for
awhile. I just left this report up on my desktop.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"kvr901" <kvr901@.discussions.microsoft.com> wrote in message
news:A59F2811-2CF0-4B6A-B34D-5A51839FC3C4@.microsoft.com...
> I'm learning Reporting Services 2000, and running it on a Win2k3 server.
> I
> am the only person using the server and the network, so there are no
> issues
> about many people trying to access anything.
> While learning to build an ASP.NET application I ran across something
> strange. The first time a report is run it takes a long time for the
> report
> to render (regardless of whether I am accessing it through my web
> application
> or through the Report Manger). After that the report would refresh fine
> unless not accessed for a while.
> After a bunch of google searches etc. I discovered I could elimnate (or
> extend) the Idle Timeout for the DefaultAppPool and it would refresh
> without
> a timeout problem. However, that does not solve the initial request which
> still takes a while.
> Can the w3wp.exe file be told to run when the server is booted up? Is
> there
> some better way to handle this?
> I read a post somewhere that suggested scheduling a dumby report to run at
> a
> particular time so as to keep the Report server running. Are there not
> more
> elegant ways to kick-start the Report Server and keep it running so that a
> user won't experience the long delay if they are the first user of the
> day?
> Thanks in advance.|||Thanks for the quick reply. A few related questions:
1. As far as I have been able to determine there is no way to create a
dummy report that does not access some data, correct? (If I have to have a
dummy report I would prefer it just have some text like "hello, this is the
dummy rs booting report" or something that does not require it to gather data.
2. Is it better to leave the 20 minute Timeout, and just have the dummy
report generate itself every 5 or 10 minutes? I have read that the Timeout
has something to do with cleaning out garbage if the w3wp file gets corrupted
somehow.
3. Is this (what I consider a problem with Reporting Services 2000) still a
problem in Reporting Services 2005?
"Bruce L-C [MVP]" wrote:
> Nope, you pretty much have all the issues down. Scheduling a report to run
> isn't too bad a solution (added to modifying the idle timeout). I have a
> report that I look at daily anyway so I run that report and email it to
> myself.
> Another possibility, you can have a report autorefresh. I did that for
> awhile. I just left this report up on my desktop.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "kvr901" <kvr901@.discussions.microsoft.com> wrote in message
> news:A59F2811-2CF0-4B6A-B34D-5A51839FC3C4@.microsoft.com...
> > I'm learning Reporting Services 2000, and running it on a Win2k3 server.
> > I
> > am the only person using the server and the network, so there are no
> > issues
> > about many people trying to access anything.
> >
> > While learning to build an ASP.NET application I ran across something
> > strange. The first time a report is run it takes a long time for the
> > report
> > to render (regardless of whether I am accessing it through my web
> > application
> > or through the Report Manger). After that the report would refresh fine
> > unless not accessed for a while.
> >
> > After a bunch of google searches etc. I discovered I could elimnate (or
> > extend) the Idle Timeout for the DefaultAppPool and it would refresh
> > without
> > a timeout problem. However, that does not solve the initial request which
> > still takes a while.
> >
> > Can the w3wp.exe file be told to run when the server is booted up? Is
> > there
> > some better way to handle this?
> >
> > I read a post somewhere that suggested scheduling a dumby report to run at
> > a
> > particular time so as to keep the Report server running. Are there not
> > more
> > elegant ways to kick-start the Report Server and keep it running so that a
> > user won't experience the long delay if they are the first user of the
> > day?
> >
> > Thanks in advance.
>
>|||Answers in-line.
"kvr901" <kvr901@.discussions.microsoft.com> wrote in message
news:C28887CF-657E-48D1-9996-70DCB03D589D@.microsoft.com...
> Thanks for the quick reply. A few related questions:
> 1. As far as I have been able to determine there is no way to create a
> dummy report that does not access some data, correct? (If I have to have
> a
> dummy report I would prefer it just have some text like "hello, this is
> the
> dummy rs booting report" or something that does not require it to gather
> data.
You can definitely do this. Just create a report without the wizard. Add a
textbox to the screen and put some text in it.
> 2. Is it better to leave the 20 minute Timeout, and just have the dummy
> report generate itself every 5 or 10 minutes? I have read that the
> Timeout
> has something to do with cleaning out garbage if the w3wp file gets
> corrupted
> somehow.
I have left the timeout to the default because before I knew the reason I
had come up with a workaround (the autorefresh of the report). I don't know
if there is housekeeping occuring or not.
> 3. Is this (what I consider a problem with Reporting Services 2000) still
> a
> problem in Reporting Services 2005?
There has been no change. This is not a RS 2005 issue. RS 2005 is just an
asp.net application (1.1 framework application in RS 2000 and 2.0 framework
in RS 2005). This is an IIS asp.net issue. A change would have to come about
with a new version of IIS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
>
>
> "Bruce L-C [MVP]" wrote:
>> Nope, you pretty much have all the issues down. Scheduling a report to
>> run
>> isn't too bad a solution (added to modifying the idle timeout). I have a
>> report that I look at daily anyway so I run that report and email it to
>> myself.
>> Another possibility, you can have a report autorefresh. I did that for
>> awhile. I just left this report up on my desktop.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "kvr901" <kvr901@.discussions.microsoft.com> wrote in message
>> news:A59F2811-2CF0-4B6A-B34D-5A51839FC3C4@.microsoft.com...
>> > I'm learning Reporting Services 2000, and running it on a Win2k3
>> > server.
>> > I
>> > am the only person using the server and the network, so there are no
>> > issues
>> > about many people trying to access anything.
>> >
>> > While learning to build an ASP.NET application I ran across something
>> > strange. The first time a report is run it takes a long time for the
>> > report
>> > to render (regardless of whether I am accessing it through my web
>> > application
>> > or through the Report Manger). After that the report would refresh
>> > fine
>> > unless not accessed for a while.
>> >
>> > After a bunch of google searches etc. I discovered I could elimnate (or
>> > extend) the Idle Timeout for the DefaultAppPool and it would refresh
>> > without
>> > a timeout problem. However, that does not solve the initial request
>> > which
>> > still takes a while.
>> >
>> > Can the w3wp.exe file be told to run when the server is booted up? Is
>> > there
>> > some better way to handle this?
>> >
>> > I read a post somewhere that suggested scheduling a dumby report to run
>> > at
>> > a
>> > particular time so as to keep the Report server running. Are there not
>> > more
>> > elegant ways to kick-start the Report Server and keep it running so
>> > that a
>> > user won't experience the long delay if they are the first user of the
>> > day?
>> >
>> > Thanks in advance.
>>|||Thanks, that worked great! I created a dummy report with one textbox and no
data connection, set it to overwrite itself to a directory every 10 minutes,
and now the Report Server works fine.
One related question that perhaps I should post elsewhere....
So far I have created a number of reports using VS2003 to make rdl files.
They work fine.
Using VS2005, how do I create an rdl file for SQL Reporting Services 2000?
When I am using VS2005 it tries to make an rdlc file.
For now I want to stick with Reporting Services 2000 until I have faster
machines with more memory etc. Do I need to continue to use VS2003 to create
and deploy the reports, or can I use VS2005 to create the reports?
Thanks again.|||Oooops... I wrote back too soon. It still doesn't work properly. After the
DefaultAppPool timeout is reached the w3wp file disappears from the
taskmanager and the Reporting Services manager takes a while to load up.
I tried setting the report refresh to every minute, and set the
DefaultAppPool timeout to 2 minutes. Sure enough, after two minutes the w3wp
ends.
I was hoping that the automatic refreshing of the report would override the
timeout setting.
Is the only way to fix this by making the timeout much longer, or maybe once
a day, or something like that?
"kvr901" wrote:
> Thanks, that worked great! I created a dummy report with one textbox and no
> data connection, set it to overwrite itself to a directory every 10 minutes,
> and now the Report Server works fine.|||RS 2005 only creates reports for RS 2000. RS 2005 can use a SQL Server 2000
database for its object cache/metadata. You still need a 2005 licence.
VS 2005 does not come with THE designer for RS 2005. It comes with A
designer that will create RDLC files for use with the new report viewer
control. If you have played with it you will see there is no preview, you
have to put the control on a form/web page and view that.
RS 2005 comes on the SQL Server 2005 CD, the report designer comes with its
own version of VS 2005 so if you are not creating custom assemblies or
extensions then you do not need to purchase or install VS 2005. If there, it
will integrate with it.
I find the designer with RS 2005 much better. Even if you want to use the
new controls in local mode (no server required) it is best to use the RS
2005 report designer and then when ready to integrate with the controls you
just rename it from rdl to rdlc.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"kvr901" <kvr901@.discussions.microsoft.com> wrote in message
news:AABD016F-8937-45EE-A15E-BCECAE95EA1D@.microsoft.com...
> Thanks, that worked great! I created a dummy report with one textbox and
> no
> data connection, set it to overwrite itself to a directory every 10
> minutes,
> and now the Report Server works fine.
> One related question that perhaps I should post elsewhere....
> So far I have created a number of reports using VS2003 to make rdl files.
> They work fine.
> Using VS2005, how do I create an rdl file for SQL Reporting Services 2000?
> When I am using VS2005 it tries to make an rdlc file.
> For now I want to stick with Reporting Services 2000 until I have faster
> machines with more memory etc. Do I need to continue to use VS2003 to
> create
> and deploy the reports, or can I use VS2005 to create the reports?
> Thanks again.
>

Report Manager Unavailable

Installed SRS 2k on a Windows 2003 sp2 machine.
SQL 2k installed, running, Report Server databased got created.
No errors during installation but two odd issues came up.
First, we can access the reportserver page via http://localhost/reportserver
but Report Manager via http://localhost/reports errors with a 404
(with report manager color scheme). It does append the /pages/
folder.aspx to the typed address.
Event viewer does show an Report Manager Event 114 which appears to
equate to "Report Manager cannot connect to the ReportServer service"
checked and the SRS service is running.
Not sure what else to look for.
Second and maybe related: http://localhost/reportserver works but
http://servername/reportserver is not recognized - it goes to an under
construction page. The RSWebApplication.config file has
<ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
I can ping localhost, servername and IP address with success.
Have uninstalled SRS, removed databases and reinstalled same issues.
Any ideas? Thanks for your help.Just in case it helps somebody down the road...
Problem was another website on the server using port 80. Change web
site report manager was using to a different port via IIS and it
worked.
http://webservername:99/reports

Report Manager returning a 500 error

Hi,
So here's what happened. I had successfully deployed an ASP.Net
application, had it running and using SQL 2K5 reporting services just fine.
I rolled out an update to the application, and included an UpdatePanel in a
few of the pages (nothing related to the reports, page-wise).
First snag I ran into was that the Report server (and manager) could not
load the System.web.extensions dll, that was deployed with my project. Both
report services virtual directories are sub-directories to my application on
Win 2K3, so it was inheriting that part of the web.config. I put a <remove>
section in both reporting services web.configs to remove the HttpModule
section named 'ScriptModule', added in to use ASP.NET Ajax v 1.0.
After doing that, the report server virtual directory comes up, so I can
basically browse the server, see the models, and even run the reports that
already exist etc, but can't use the ReportManager web app. The report
manager says that the report server could not be contacted, and to make sure
it is on. In the logs, it shows that a 500-server error was received, and
obviously ends there.
Any advice anyone has on what the problem might be, I'd appreciate it.
Thanks for the help,
PeteHello Pete,
I understand that you have an application to install the reporting services
and you could not get the report manager work.
According to the error state that the report manager could not find the
report server, you may check the following things:
1. RSWebApplication.config file under the C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportManager folder. You may check the
following element:
<UI>
<ReportServerUrl>http://yourservername/your application virtual dic
name/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
2. rsreportserver.config file under the C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer
<UrlRoot>http://yourservername/your application virtual dic
name/reportserver</UrlRoot>
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for the quick response. I tried what you suggested below and it
still didn't fix the problem. Here's a bit more information about the setup.
The DB, Report Server, and IIS for the application all run on the same box,
which is running Windows Server 2K3. I have it setup that the Website is
called <appname> and then it has two virtual directories underneath that
website for ReportServer and ReportManager. Since it is an intranet
application, you access it by going to http://machinename, which defaults to
the one website on it. If you go to http://machinename/ReportManager, you
can access the GUI to manage reports, models, etc. (at least before it was
broken). Going to http://machinename/ReportServer gives you the website
browsing aspect of it, but not the GUI you'd expect.
In the config files you had me check for ReportManager, the <ReportServUrl>
field was empty, but the ReportServer virtual directory field was filled in,
with the proper name of the virtual directory. The <UrlRoot> you mentioned
was already filled in and point to the same URL mentioned above for the
ReportServer itself.
On another note, as I had only been using the ASP.NET AJAX extensions in one
location, I removed that UpdatePanel, and all ajax related items in my
application-specific web.config file, and the Report Manager worked again
immediately. So, I'm thinking there is some direct connection to the two
that I can't find out that is causing it to crash.
Again, any help would be very much appreciated. I don't really think just
avoiding the ASP.NET Ajax extensions is a viable option in the long term.
Thanks,
Pete|||Hello Pete,
I would like to know if you put the whole url for the report server in the
<ReportServUrl> and remove the virtual directory value,
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Yes, I put the full path of the reportServer URl into that location, and
removed the reference to the ReportServerVirtual directory. That
unfortunately did not fix the problem. Any other suggestions would be
appreciated.
Thanks,
Pete
"Wei Lu [MSFT]" wrote:
> Hello Pete,
> I would like to know if you put the whole url for the report server in the
> <ReportServUrl> and remove the virtual directory value,
>
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Pete,
Could you please let me get the report server error log?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Unfortunately I can't get you the client's server log - it is on a
restricted internal machine, and they don't allow internet access from it or
connection of external drives.
In order to provide for a temporary fix, I went ahead and un-did my ASP.NET
Ajax changes in the web.config file and it started working again. It is far
from an ideal solution, but I didn't have time to work through it any more.
If you have any other solutions I'd like to hear them, as I'd like to improve
the UI of our application using ajax at some point in the future.
Thanks,
Pete
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Pete,
If you have time to get the reportserver error log, you may send it to me.
By default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Otherwise, I may lack of information to troubleshoot the error.
Hope it helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Monday, March 12, 2012

Report Manager not responding

Hi,

I'm hoping to get some help here. I've spend countless hours trying to get Reporting Services running without success.

When I run the Report Manager it does not respond. Coming up with Opening page http://localhost/reports/Pages/Folder.aspx. . . The progress bar ticks along but the page never actually loads. The Configuration tool shows green icons everywhere. No errors in the Event viewer.

I am running Windows XP Professional with SP2. I have uninstalled and re-installed IIS, ASP.NET and SQL2005 numerous times. Varying the order, all without success. What else is involved ?

I have loaded Service Pack 1 and the latest hotfixes. What else can I try ?

Thanks in advance,
Claude

Hi,

are you running IE7 Beta 3 ? Then have a look here: http://www.sqlserver2005.de/sqlserver2005/MyBlog/tabid/56/EntryID/10/Default.aspx

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks Jens. I'm using IE 6.

|||Are you able to browse the report server directly (http://servername/reportserver)?|||

Thanks Brain, gives the same non-response.

|||

Some further clues . . .

When I tried connecting to the Report Server with the Management Studio, the following messages appear:

The underlying connection was closed: An unexpected error occurred on a send. (System.Web.Services)

Authentication failed because the remote party has closed the transport stream. (System)

Any ideas ?

|||

Hi,

there should be a more detailed log in the directory of Reporting Services, perhaps you could try to investigate that and send the relevant portion to the forum, thanks.

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I have a similar problem as Claude. I have two instances of SQL Server (2000 and 2005) installed locally. I am using the Developer version of 2005 running under XP Pro. I dont have administrator rights on my machine.

For some reason I just cannot connect to Report Manager, directly from the browser or from Management Studio. It just hangs and eventually tells you that 'cannot find server'. I tried evrything that Claude has done but no luck.

Any ideas please ?

Thanks

|||Are the services started ? What are the logs telling you ? (event log and log in the log directory)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks Jens.

This is the content of the ReportServerWebApp Logfile:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>New Zealand Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerWebApp__08_18_2006_18_32_46.log</Path>
<SystemName>ACKCSABATIER01</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
aspnet_wp!ui!1!18/08/2006-18:33:20:: e ERROR: The underlying connection was closed: An unexpected error occurred on a send.
aspnet_wp!ui!1!18/08/2006-18:33:21:: e ERROR: HTTP status code --> 500
-Details--
System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. > System.IO.IOException: Authentication failed because the remote party has closed the transport stream.

at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)

at System.Net.TlsStream.CallProcessAuthentication(Object state)

at System.Threading.ExecutionContext.runTryCode(Object userData)

at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)

at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result)

at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.ConnectStream.WriteHeaders(Boolean async)

End of inner exception stack trace

at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)

at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetWebResponse(WebRequest request)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
aspnet_wp!ui!1!18/08/2006-18:33:22:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

|||

Did you get any resolution on this? I can deploy reports from Visual Studio, but I cant manage them. I am having a terrible time trying to get the Server Mangement Studio to connect to Reporting Services. I get the same errors in my logs:System.Net.WebException:

The underlying connection was closed: An unexpected error occurred on a send. > System.IO.IOException: Authentication failed because the remote party has closed the transport stream.