Report Parameter Defaults not being used in deployed reports

When I set the default properties under Report Parameters in some
reports, it works perfectly, in other reports, the parameters specified
in Visual Studio under Report Parameters seem to have no effect when
the report is deployed to the ReportServer. The toolbar for the
parameters displays, and that is OK, but the default values don't
appear in the toolbar like they do in the other reports, and the report
doesn't run until the parameters are selected with the dropdowns. What
is causing the parameters to behave differently from one report to the
other?I have found that although you may change 'defaults' in the Report Designer,
they sometimes do not seem to take when I 'deploy' the modified report. I
don't understand why, bu my solution thus far has been to delete the report
off the report server and then redeploy it. The new/modified default values
appear.
"Kelly Gross" wrote:
> When I set the default properties under Report Parameters in some
> reports, it works perfectly, in other reports, the parameters specified
> in Visual Studio under Report Parameters seem to have no effect when
> the report is deployed to the ReportServer. The toolbar for the
> parameters displays, and that is OK, but the default values don't
> appear in the toolbar like they do in the other reports, and the report
> doesn't run until the parameters are selected with the dropdowns. What
> is causing the parameters to behave differently from one report to the
> other?
>|||Make sure your default value is your available value, otherwise it is
not working.
Kelly Gross wrote:
> When I set the default properties under Report Parameters in some
> reports, it works perfectly, in other reports, the parameters
specified
> in Visual Studio under Report Parameters seem to have no effect when
> the report is deployed to the ReportServer. The toolbar for the
> parameters displays, and that is OK, but the default values don't
> appear in the toolbar like they do in the other reports, and the
report
> doesn't run until the parameters are selected with the dropdowns.
What
> is causing the parameters to behave differently from one report to
the
> other?

Report parameter - > Select All Option is not coming

Hi,
I have created a report parameter with multi-value option.
In preview mode i can see "Select All option" but once deployed i can
not see that option over web. any idea?
Regards,
SriOn May 11, 9:34 am, Sriman <Sri...@.discussions.microsoft.com> wrote:
> Hi,
> I have created a report parameter with multi-value option.
> In preview mode i can see "Select All option" but once deployed i can
> not see that option over web. any idea?
> Regards,
> Sri
Without knowing more details, it sounds like you have SQL Server 2005
SP1 installed on the production box. If so, you will want to install
SP2. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

report model and it's datasource

hi everyone,

I created a report model and deployed it. When I open the rpt builder on web I get the following error.

'The selected data source does not have and content available'

Seemed like it would be a easy issue, but I cannot retrieve any data in the rpt model. The datasource I'm using does work for rpts not associated with the rpt model. Any suggestions? It seems like I've missed a step. Thanks, Lisa

If there is no primary key defined, you can build the model, but no contents. Do you have primary key defined?sql

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.

Report Manager Issue

I have created a parameter in a report, then deployed it Report Manager - this is the issue -

People with only one budget department brought a Reporting Services problem to the forefront - drop-down list boxes seem to be made large enough for x-1 of the items in the list. If there's only one item in the list, the listbox is so small that you can't see the item in the list. Does anyone know how to change the format of some of the stock controls in RS?

This is a known issue that was recently fixed in a QFE. The QFE is not a public QFE so you will need to contact Customer Service to get it. You can refer to KB 919556.

Report Manager does not show Deployed Reports or Site Settings

Can anyone tell me why when I go to Report Manager aside from the Home,
Subscriptions and Help links the rest of the Report Manager is blank. It's
missing the 'Site Settings' link and I also deployed the Sample reports
shipped with Reporting Services but the 'SampleReports' folder does not show
in Report Manager.
I had a very hard time configuring Reporting Services. I had to use the
config tools to create a new key for the RSReportServer.config. I also had to
modify the security option from 'windows' to 'SQL' in order to be able to
access the Report Manager at all.
I know the SampleReports have deployed because if I go to...
http://localhost/ReportServer/SampleReports
...it gives me links to the reports as below...
localhost/ReportServer - /
----
Tuesday, September 20, 2005 2:05 PM <dir> SampleReports
----
Microsoft SQL Server Reporting Services Version 8.00.1038.00
...from which I can then run the reports ...
localhost/ReportServer - /SampleReports
----
[To Parent Directory]
Tuesday, September 20, 2005 2:05 PM <ds> AdventureWorks
Tuesday, September 20, 2005 2:06 PM 17318 Company Sales
Tuesday, September 20, 2005 2:07 PM 44227 Employee Sales Summary
Tuesday, September 20, 2005 2:07 PM 25135 Foodmart Sales
Tuesday, September 20, 2005 2:07 PM 188866 Product Catalog
Tuesday, September 20, 2005 2:07 PM 52167 Product Line Sales
Tuesday, September 20, 2005 2:07 PM 63727 Sales Order Detail
Tuesday, September 20, 2005 2:07 PM 27343 Territory Sales Drilldown
----
Microsoft SQL Server Reporting Services Version 8.00.1038.00
.... and the reports run OK from here.
But why is the Report Manager page not showing the SampleReports folder or
the Site Settings link?I am having the same problem - Site Settings does not appear on the
Report Manager page. Have you been able to resolve the problem?
Brad
Joe wrote:
> Can anyone tell me why when I go to Report Manager aside from the Home,
> Subscriptions and Help links the rest of the Report Manager is blank. It's
> missing the 'Site Settings' link and I also deployed the Sample reports
> shipped with Reporting Services but the 'SampleReports' folder does not show
> in Report Manager.
> I had a very hard time configuring Reporting Services. I had to use the
> config tools to create a new key for the RSReportServer.config. I also had to
> modify the security option from 'windows' to 'SQL' in order to be able to
> access the Report Manager at all.
> I know the SampleReports have deployed because if I go to...
> http://localhost/ReportServer/SampleReports
> ...it gives me links to the reports as below...
> localhost/ReportServer - /
> ----
> Tuesday, September 20, 2005 2:05 PM <dir> SampleReports
> ----
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> ...from which I can then run the reports ...
> localhost/ReportServer - /SampleReports
> ----
> [To Parent Directory]
> Tuesday, September 20, 2005 2:05 PM <ds> AdventureWorks
> Tuesday, September 20, 2005 2:06 PM 17318 Company Sales
> Tuesday, September 20, 2005 2:07 PM 44227 Employee Sales Summary
> Tuesday, September 20, 2005 2:07 PM 25135 Foodmart Sales
> Tuesday, September 20, 2005 2:07 PM 188866 Product Catalog
> Tuesday, September 20, 2005 2:07 PM 52167 Product Line Sales
> Tuesday, September 20, 2005 2:07 PM 63727 Sales Order Detail
> Tuesday, September 20, 2005 2:07 PM 27343 Territory Sales Drilldown
>
> ----
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> .... and the reports run OK from here.
> But why is the Report Manager page not showing the SampleReports folder or
> the Site Settings link?|||I am having the same problem - Site Settings does not appear on the
Report Manager page. Have you been able to resolve the problem?
Brad
Joe wrote:
> Can anyone tell me why when I go to Report Manager aside from the Home,
> Subscriptions and Help links the rest of the Report Manager is blank. It's
> missing the 'Site Settings' link and I also deployed the Sample reports
> shipped with Reporting Services but the 'SampleReports' folder does not show
> in Report Manager.
> I had a very hard time configuring Reporting Services. I had to use the
> config tools to create a new key for the RSReportServer.config. I also had to
> modify the security option from 'windows' to 'SQL' in order to be able to
> access the Report Manager at all.
> I know the SampleReports have deployed because if I go to...
> http://localhost/ReportServer/SampleReports
> ...it gives me links to the reports as below...
> localhost/ReportServer - /
> ----
> Tuesday, September 20, 2005 2:05 PM <dir> SampleReports
> ----
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> ...from which I can then run the reports ...
> localhost/ReportServer - /SampleReports
> ----
> [To Parent Directory]
> Tuesday, September 20, 2005 2:05 PM <ds> AdventureWorks
> Tuesday, September 20, 2005 2:06 PM 17318 Company Sales
> Tuesday, September 20, 2005 2:07 PM 44227 Employee Sales Summary
> Tuesday, September 20, 2005 2:07 PM 25135 Foodmart Sales
> Tuesday, September 20, 2005 2:07 PM 188866 Product Catalog
> Tuesday, September 20, 2005 2:07 PM 52167 Product Line Sales
> Tuesday, September 20, 2005 2:07 PM 63727 Sales Order Detail
> Tuesday, September 20, 2005 2:07 PM 27343 Territory Sales Drilldown
>
> ----
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> .... and the reports run OK from here.
> But why is the Report Manager page not showing the SampleReports folder or
> the Site Settings link?|||I am having the same problem - Site Settings does not appear on the
Report Manager page. Have you been able to resolve the problem?
Brad
Joe wrote:
> Can anyone tell me why when I go to Report Manager aside from the Home,
> Subscriptions and Help links the rest of the Report Manager is blank. It's
> missing the 'Site Settings' link and I also deployed the Sample reports
> shipped with Reporting Services but the 'SampleReports' folder does not show
> in Report Manager.
> I had a very hard time configuring Reporting Services. I had to use the
> config tools to create a new key for the RSReportServer.config. I also had to
> modify the security option from 'windows' to 'SQL' in order to be able to
> access the Report Manager at all.
> I know the SampleReports have deployed because if I go to...
> http://localhost/ReportServer/SampleReports
> ...it gives me links to the reports as below...
> localhost/ReportServer - /
> ----
> Tuesday, September 20, 2005 2:05 PM <dir> SampleReports
> ----
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> ...from which I can then run the reports ...
> localhost/ReportServer - /SampleReports
> ----
> [To Parent Directory]
> Tuesday, September 20, 2005 2:05 PM <ds> AdventureWorks
> Tuesday, September 20, 2005 2:06 PM 17318 Company Sales
> Tuesday, September 20, 2005 2:07 PM 44227 Employee Sales Summary
> Tuesday, September 20, 2005 2:07 PM 25135 Foodmart Sales
> Tuesday, September 20, 2005 2:07 PM 188866 Product Catalog
> Tuesday, September 20, 2005 2:07 PM 52167 Product Line Sales
> Tuesday, September 20, 2005 2:07 PM 63727 Sales Order Detail
> Tuesday, September 20, 2005 2:07 PM 27343 Territory Sales Drilldown
>
> ----
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> .... and the reports run OK from here.
> But why is the Report Manager page not showing the SampleReports folder or
> the Site Settings link?|||This is most likely because you have turned anonymous access in IIS on for
the sites. When you do this no-one is considered administrator. Turn
anonymous access off and it should appear.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bsharp" <bsharp@.myway.com> wrote in message
news:1129737566.404621.241640@.g43g2000cwa.googlegroups.com...
>I am having the same problem - Site Settings does not appear on the
> Report Manager page. Have you been able to resolve the problem?
> Brad
> Joe wrote:
>> Can anyone tell me why when I go to Report Manager aside from the Home,
>> Subscriptions and Help links the rest of the Report Manager is blank.
>> It's
>> missing the 'Site Settings' link and I also deployed the Sample reports
>> shipped with Reporting Services but the 'SampleReports' folder does not
>> show
>> in Report Manager.
>> I had a very hard time configuring Reporting Services. I had to use the
>> config tools to create a new key for the RSReportServer.config. I also
>> had to
>> modify the security option from 'windows' to 'SQL' in order to be able to
>> access the Report Manager at all.
>> I know the SampleReports have deployed because if I go to...
>> http://localhost/ReportServer/SampleReports
>> ...it gives me links to the reports as below...
>> localhost/ReportServer - /
>> ----
>> Tuesday, September 20, 2005 2:05 PM <dir> SampleReports
>> ----
>> Microsoft SQL Server Reporting Services Version 8.00.1038.00
>> ...from which I can then run the reports ...
>> localhost/ReportServer - /SampleReports
>> ----
>> [To Parent Directory]
>> Tuesday, September 20, 2005 2:05 PM <ds> AdventureWorks
>> Tuesday, September 20, 2005 2:06 PM 17318 Company Sales
>> Tuesday, September 20, 2005 2:07 PM 44227 Employee Sales
>> Summary
>> Tuesday, September 20, 2005 2:07 PM 25135 Foodmart Sales
>> Tuesday, September 20, 2005 2:07 PM 188866 Product Catalog
>> Tuesday, September 20, 2005 2:07 PM 52167 Product Line Sales
>> Tuesday, September 20, 2005 2:07 PM 63727 Sales Order Detail
>> Tuesday, September 20, 2005 2:07 PM 27343 Territory Sales
>> Drilldown
>>
>> ----
>> Microsoft SQL Server Reporting Services Version 8.00.1038.00
>> .... and the reports run OK from here.
>> But why is the Report Manager page not showing the SampleReports folder
>> or
>> the Site Settings link?
>

report manager datasources

RS is installed on a 64 bit system. I am pulling my data from Foxpro. I can
get it fine in the report designer, but when deployed to the Report Manager
it wont work....Any ideas or workarounds?Is the datasource shared? If so - are the details correct?
If the data source is custom, does the user running the report have
permission?
"Ben" wrote:
> RS is installed on a 64 bit system. I am pulling my data from Foxpro. I can
> get it fine in the report designer, but when deployed to the Report Manager
> it wont work....Any ideas or workarounds?

Report Manager configuration

We deployed Reporting Services recently to a customer with a latest release and build. When they type in http://<server>/ReportServer, this just comes up with a screen like a navigation sreen showing folders and links to reports. What needs to be done to get the Report Manager screen showing?

It has been a while since I actually installed Reporting Services. When they go into configuration, all of the green checks are there (except for Web Service Identity, which is Red).

Thanks for any information.

Solved it...the user was not using the Virtual Directory. Sorry for the "newbie" post.

Report Loading Error

I have developed a report and deployed it successfully. After I input all the parameters, the report cannot be displayed and shows the error as follows:

???? (rsProcessingAborted) ??
??? 'tempDB' ?? (rsErrorOpeningConnection) ??
Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection.

The report can be loaded a few times before and cannot be loaded now.

I have checked that the DB security setting of authentication is set to "SQL Server and Windows" already.

Any idea to solve this problem?

msfriend wrote:

I have developed a report and deployed it successfully. After I input all the parameters, the report cannot be displayed and shows the error as follows: ???? (rsProcessingAborted) ?? ??? 'tempDB' ?? (rsErrorOpeningConnection) ?? Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection. The report can be loaded a few times before and cannot be loaded now. I have checked that the DB security setting of authentication is set to "SQL Server and Windows" already. Any idea to solve this problem?

Should be authentication problem. Did you find any solution?

Report is not showing

hai friends
i deployed my report and in preview using vs.net i can see the report.
but once i deployed
the report is being generated screen is comming but it is not showing
report.i waited and waited still that report is being generated screen only
i am using evaluation copy is this the limitation of trial ver.we cannot see
the deployed report.
also how can i know how many days left in my evaluation version.I too have the same problem.
Though it works fine with an SQL db. The problem only occurs when using an
Oracle DB. I am using the 8i client. It works fine on my dev machine in
Visual Studio. It hangs when the report is run from a Report Services.
Its quite possible that both issues are related ?
"vishak" wrote:
> hai friends
> i deployed my report and in preview using vs.net i can see the report.
> but once i deployed
> the report is being generated screen is comming but it is not showing
> report.i waited and waited still that report is being generated screen only
> i am using evaluation copy is this the limitation of trial ver.we cannot see
> the deployed report.
> also how can i know how many days left in my evaluation version.|||Oracle is pretty unique and complicated. From the designer if you are using
the graphical query designer then OLEDB is used. If you use the generic
designer then a dotnet managed provider is used. I thought the managed
provider requires 9i or greater but I am not sure of that. When deployed it
uses the managed provider. I am guessing that this is where you problem is
coming from. To test the theory out, switch to generic query mode (the
button is to the right of the ...) and try executing from there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kamlesh Parmar" <KamleshParmar@.discussions.microsoft.com> wrote in message
news:0A3C89B2-BC98-4307-9CEB-201E8E6C7AA1@.microsoft.com...
> I too have the same problem.
> Though it works fine with an SQL db. The problem only occurs when using an
> Oracle DB. I am using the 8i client. It works fine on my dev machine in
> Visual Studio. It hangs when the report is run from a Report Services.
> Its quite possible that both issues are related ?
> "vishak" wrote:
> > hai friends
> > i deployed my report and in preview using vs.net i can see the report.
> > but once i deployed
> > the report is being generated screen is comming but it is not showing
> > report.i waited and waited still that report is being generated screen
only
> >
> > i am using evaluation copy is this the limitation of trial ver.we cannot
see
> > the deployed report.
> >
> > also how can i know how many days left in my evaluation version.

Report hangs on "Report is being generated" screen

I am having issues trying to use a deployed report on our live server.
The report works fine in the development environment - yet when posted to
the live server it seems to work fine but hangs on the "Report is being
generated" screen.
We are still in an evaluation stage of Reporting Services and such are using
the trial version, this is installed on Windows 2003 Server. The report was
developed using Visual Studio 2003 and will be instantiated by an ASP.Net
application. The report is being fired using a
Response.redirect("/ReportServer?%2fReport+Project1%2fReportName&session=" +
Session.SessionID.ToString() + "&rs%3aCommand=Render");
Any suggestions would be greatly appreciated.
Regards
StevenA few questions for you.
- Are you going against the same database when you deploy or a different
one. I.e. could it be a difference is the size of the data you are reporting
against.
- Does this happen when you run the report from Report Manager? If so then
we can disregard the fact it is coming from your app. If it works fine from
the report manager then that tells us a lot too.
- Is your asp.net application on the same server and is it in the same
domain?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"StvPl" <StvPl@.discussions.microsoft.com> wrote in message
news:6290C7CB-C600-41F6-ACE4-ED20D8AD7E45@.microsoft.com...
> I am having issues trying to use a deployed report on our live server.
> The report works fine in the development environment - yet when posted to
> the live server it seems to work fine but hangs on the "Report is being
> generated" screen.
> We are still in an evaluation stage of Reporting Services and such are
using
> the trial version, this is installed on Windows 2003 Server. The report
was
> developed using Visual Studio 2003 and will be instantiated by an ASP.Net
> application. The report is being fired using a
> Response.redirect("/ReportServer?%2fReport+Project1%2fReportName&session="
+
> Session.SessionID.ToString() + "&rs%3aCommand=Render");
> Any suggestions would be greatly appreciated.
> Regards
> Steven
>|||Thanks for your response Bruce.
I've answered your questions below...
> - Are you going against the same database when you deploy or a different
> one. I.e. could it be a difference is the size of the data you are reporting
> against.
It is against the same database and the subset of data retrieved is very
small - perhaps 50 rows.
> - Does this happen when you run the report from Report Manager? If so then
> we can disregard the fact it is coming from your app. If it works fine from
> the report manager then that tells us a lot too.
Works fine from Report Manager.
> - Is your asp.net application on the same server and is it in the same
> domain?
yes.
Thanks for your help
Steven
"Bruce L-C [MVP]" wrote:
> A few questions for you.
> - Are you going against the same database when you deploy or a different
> one. I.e. could it be a difference is the size of the data you are reporting
> against.
> - Does this happen when you run the report from Report Manager? If so then
> we can disregard the fact it is coming from your app. If it works fine from
> the report manager then that tells us a lot too.
> - Is your asp.net application on the same server and is it in the same
> domain?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "StvPl" <StvPl@.discussions.microsoft.com> wrote in message
> news:6290C7CB-C600-41F6-ACE4-ED20D8AD7E45@.microsoft.com...
> > I am having issues trying to use a deployed report on our live server.
> >
> > The report works fine in the development environment - yet when posted to
> > the live server it seems to work fine but hangs on the "Report is being
> > generated" screen.
> >
> > We are still in an evaluation stage of Reporting Services and such are
> using
> > the trial version, this is installed on Windows 2003 Server. The report
> was
> > developed using Visual Studio 2003 and will be instantiated by an ASP.Net
> > application. The report is being fired using a
> > Response.redirect("/ReportServer?%2fReport+Project1%2fReportName&session="
> +
> > Session.SessionID.ToString() + "&rs%3aCommand=Render");
> >
> > Any suggestions would be greatly appreciated.
> >
> > Regards
> > Steven
> >
> >
>
>|||This may be a dumb question, but are you sure that the login you are using
has read permission from the database?
I had a similar symptom when I was testing a deployment. I was using
different login info and forgot to provide access to the database. The
Reporting Services page would come up and I could select a report to run,
but the report would just hang at the generating report stage. Dumb, I know!
Ken
"StvPl" <StvPl@.discussions.microsoft.com> wrote in message
news:6290C7CB-C600-41F6-ACE4-ED20D8AD7E45@.microsoft.com...
> I am having issues trying to use a deployed report on our live server.
> The report works fine in the development environment - yet when posted to
> the live server it seems to work fine but hangs on the "Report is being
> generated" screen.
> We are still in an evaluation stage of Reporting Services and such are
using
> the trial version, this is installed on Windows 2003 Server. The report
was
> developed using Visual Studio 2003 and will be instantiated by an ASP.Net
> application. The report is being fired using a
> Response.redirect("/ReportServer?%2fReport+Project1%2fReportName&session="
+
> Session.SessionID.ToString() + "&rs%3aCommand=Render");
> Any suggestions would be greatly appreciated.
> Regards
> Steven
>|||Thanks for the suggestion Ken.
I've checked the database access and the account specified in the
credentials of the shared data component of the report has full access.
Regards
Steven
"Ken" wrote:
> This may be a dumb question, but are you sure that the login you are using
> has read permission from the database?
> I had a similar symptom when I was testing a deployment. I was using
> different login info and forgot to provide access to the database. The
> Reporting Services page would come up and I could select a report to run,
> but the report would just hang at the generating report stage. Dumb, I know!
> Ken
> "StvPl" <StvPl@.discussions.microsoft.com> wrote in message
> news:6290C7CB-C600-41F6-ACE4-ED20D8AD7E45@.microsoft.com...
> > I am having issues trying to use a deployed report on our live server.
> >
> > The report works fine in the development environment - yet when posted to
> > the live server it seems to work fine but hangs on the "Report is being
> > generated" screen.
> >
> > We are still in an evaluation stage of Reporting Services and such are
> using
> > the trial version, this is installed on Windows 2003 Server. The report
> was
> > developed using Visual Studio 2003 and will be instantiated by an ASP.Net
> > application. The report is being fired using a
> > Response.redirect("/ReportServer?%2fReport+Project1%2fReportName&session="
> +
> > Session.SessionID.ToString() + "&rs%3aCommand=Render");
> >
> > Any suggestions would be greatly appreciated.
> >
> > Regards
> > Steven
> >
> >
>
>