Report not rending via web service

I'm somewhat new to reporting services and have used a web service call to
render my reports in my asp.net applications in the past. All the reports
thus far have been Excel, and I've used the same method for calling these
reports from some sample code I found online. This has worked great up till
now.
I have a report I want to render in PDF. I've plugged in the correct values
in my code and the browser will try and download the PDF but returns a "File
is damaged and could not be displayed". I tried rending in Excel and I get
"This file is not in a recognizable format". I've compared my code to past
projects and everything looks good. The only difference with this report is
I used a list control with textboxes instead of a table which I've used on
all past reports. If anyone has a suggestion on what causes these error
message, please reply. Thanks.I figured it out. There was a <httpModules> tag in my web.config that was
causing this problem. I built another project to call my report with a
"clean" web.config and it works fine.
"jweesies" wrote:
> I'm somewhat new to reporting services and have used a web service call to
> render my reports in my asp.net applications in the past. All the reports
> thus far have been Excel, and I've used the same method for calling these
> reports from some sample code I found online. This has worked great up till
> now.
> I have a report I want to render in PDF. I've plugged in the correct values
> in my code and the browser will try and download the PDF but returns a "File
> is damaged and could not be displayed". I tried rending in Excel and I get
> "This file is not in a recognizable format". I've compared my code to past
> projects and everything looks good. The only difference with this report is
> I used a list control with textboxes instead of a table which I've used on
> all past reports. If anyone has a suggestion on what causes these error
> message, please reply. Thanks.

Report not refreshed

I have created an asp.net application in which i have a textbox and botton.T

he textbox value is passed as parameter to a report and the corresponding report is generated on button click.The problem is that once i add a report to any application the same report is displayed each time i.e. the report is not updating whenever there is a change in the database values.

Iam refreshing the datasource in the original report and change is reflected there in original report but in the dotnet application always the old report is maintained......

Can anybody help me out......

I had the same problem reportviewer1.reset nd I sovled it by added a line code before refreshing the report:

reportviewer1.reset

|||

I had the same problem and I sovled it by added a line of code before refreshing the report:

reportviewer1.reset

|||

Thanx Frankmeng for your suggestion but it is not working....

It is giving me build error.

Error 1 'Microsoft.Reporting.WebForms.ReportViewer' does not contain a definition for 'Reset'
Can u help me with this?

I would also like to know whether we can set the paging property of the report so that only desired number of records are displayed in a page and the user doesn't have to scroll up and down.

Thanx.

|||

Arun:

It is sovled by added a line of code in the Button click event.

reportviewer1.localreport.refresh()

|||Thanks a lot Arun its working...

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 loses all data !

Hi,
I have a reportviewer object on an asp.net page.
On this page (not in the reportviewer object) is also a button which pops up
a new window with a pdf document when clicked.
The report loads fine with all the info I want, when I refresh the page or
the report itself the information is still ok.
But as soon as I press the button for the pdf document, the document opens
fine, but it pops-up UNDER the other page, AND the reportviewer object LOSES
ALL DATA and displays this dreaded message : "To render a report, enter the
serverUrl and ReportPath."Eric,
I don't know a lot about ASP web pages, but I've got a notion that I thought
I'd share. As far as the PDF showing up under the webpage, it sounds like
the code for the PDF button doesn't have the Focus properties set properly.
You or your developer should check out that button code and make sure that
when clicked, it switches the focus from the current webpage to the new PDF
page.
As far as losing the data from the ASP page... I would say that is a code
issue with the button functionality too, rather than a Reporting Services
issue, but again, I don't know ASP, so I can't tell you exactly what the
problem is.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Eric" wrote:
> Hi,
> I have a reportviewer object on an asp.net page.
> On this page (not in the reportviewer object) is also a button which pops up
> a new window with a pdf document when clicked.
> The report loads fine with all the info I want, when I refresh the page or
> the report itself the information is still ok.
> But as soon as I press the button for the pdf document, the document opens
> fine, but it pops-up UNDER the other page, AND the reportviewer object LOSES
> ALL DATA and displays this dreaded message : "To render a report, enter the
> serverUrl and ReportPath."|||Yeah I dont know much about ASP pages either, that is the problem :p
I tried using window.focus on my java script to put focus on the pdf page
when it opens, but that code is ignored. In the ASP newsgroup they suggest I
use window.modalDialog but that window cannot be reduced.
As for the report reloading with empty parameters, I temporarily countered
the problem by reloading the report after the button is clicked. But that is
a lame correction since the report reloads with default data and doesnt keep
its current state.
In a nutshell, im still at square one.
"Catadmin" wrote:
> Eric,
> I don't know a lot about ASP web pages, but I've got a notion that I thought
> I'd share. As far as the PDF showing up under the webpage, it sounds like
> the code for the PDF button doesn't have the Focus properties set properly.
> You or your developer should check out that button code and make sure that
> when clicked, it switches the focus from the current webpage to the new PDF
> page.
> As far as losing the data from the ASP page... I would say that is a code
> issue with the button functionality too, rather than a Reporting Services
> issue, but again, I don't know ASP, so I can't tell you exactly what the
> problem is.
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "Eric" wrote:
> > Hi,
> >
> > I have a reportviewer object on an asp.net page.
> > On this page (not in the reportviewer object) is also a button which pops up
> > a new window with a pdf document when clicked.
> >
> > The report loads fine with all the info I want, when I refresh the page or
> > the report itself the information is still ok.
> >
> > But as soon as I press the button for the pdf document, the document opens
> > fine, but it pops-up UNDER the other page, AND the reportviewer object LOSES
> > ALL DATA and displays this dreaded message : "To render a report, enter the
> > serverUrl and ReportPath."

'Report is being generated' Image

Hi,
I'm just wondering about the possibility of changing the 'Report being generated' image. I have my reports embedded in an asp.net application and I'd like to match this image to logo of the application.
ThanksThis image is compiled into one of the RS assemblies as a resource, and it
is accessed with the following line of HTML in the actual page it shows up
in:
<img alt="Report is being generated"
src="?rs:Command=Get&rc:GetImage=8.00.743.00spinning_wheel.gif" />
You're not going to be able to change it, but you can pull the report from
the RS Web Service and then you have a complete customization of how the
report is rendered. The caveat, of course, is that you're going to have to
recreate all of the functionality that URL access affords you (namely
parameter handling).
Jay Nathan
http://www.mariner-usa.com
"Nell" <Nell@.discussions.microsoft.com> wrote in message
news:6E375F26-DC82-4A40-8EE9-CFA8E9FA0A8B@.microsoft.com...
> Hi,
> I'm just wondering about the possibility of changing the 'Report being
generated' image. I have my reports embedded in an asp.net application and
I'd like to match this image to logo of the application.
> Thanks

Report from ASP.NET datagrid

I'd like to populate a datagrid in my asp.net project and run a report
from the grid. Does anyone have any suggestions on how to do this?
Thanks in advance.You could go the link route and use URL access to access the report or you
could create a viewer page with the report viewer on it and pass the
necessary parameters to it on the query string. How extensible do you need
it to be? Will usability be affected if another page is displayed? What
are security requirements?
"gallan" <gregallan@.tvl.com> wrote in message
news:1147822435.406853.303450@.j55g2000cwa.googlegroups.com...
> I'd like to populate a datagrid in my asp.net project and run a report
> from the grid. Does anyone have any suggestions on how to do this?
> Thanks in advance.
>