Reporting Services using ASP

Is it possible to use SQL Server Repotring Services without using .net
framework? I want to use it using ASP.Depends on how you want to use it... You can call reports and pass
parameters via URL from ASP...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sumanta" <Sumanta@.discussions.microsoft.com> wrote in message
news:C07F6A9A-9C90-4213-AAB3-68E242E4213C@.microsoft.com...
> Is it possible to use SQL Server Repotring Services without using .net
> framework? I want to use it using ASP.

Reporting Services Report Manager Authentication Issue

Hi,

I have installed Reporting Services 2000 on my pc. And i've used the report viewer control to view the report on a ASP.NET Page. When i view that .ASPX page, i get a windows authentication window before it opens the actual report.

Is there any way to disable this windows authentication dialouge box?

Regards,

PS: in the viewer i give the path of the report as http://localhost/Rerport/ABC.rdlThis forum is on .Net Framework (CLR) integration in SQL Server 2005 that allows you to write routines in CLR languages like c#, VB.NET etc.
I suggest posting your question in SQL Server Reporting Services forum to get a faster response.

Thanks,
-Vineet.

Reporting services problem

Hi, I'm trying to use the reporting services in ASP.NET page.

- I've inserted an ReportViewer object my ASP.NET
- I've a datatable with the info that I want to see in my report

Now I must to create the DataSource object? How can I create a DataSource for this solution?? Somebody can send me an example?

Thanks

Please help me!!!|||Before that you need to create the report.
In fact the ReportViewer is just a container for the report.
In VS you need to do : right click on project / insert new item / Report.
Which version of SRS do you use ?|||

Sorry I didn't see the date of your post !!
I think it's too late to answer ;-)
and I think you were using VS2003...

reporting services Permission question

I posted a report to reporting server, and link the report to asp.net
reportviewer
i link the report to the reportviewer by
Me.ReportViewer1.ServerReport.ReportServerUrl = New
Uri("http://localhost/Reportserver")
Me.ReportViewer1.serverReport.ReportPath = Server.MapPath("Report1.rdl")
however it doesn't have permission to load the report
how can i implicity to pass the user name and passwor to the reportserver
by code?Use networkcredential... look under system.net
Here is the line of code you need:
rs.Credentials = New System.Net.NetworkCredential(RSUserName, RSPassword,
RSDomain)
Where RS is the object to your reporting service web service.
RSUserName, RSPassword, and RSDomain are variables of type string.
Cheers!
=-Chris
"joe" <joe@.discussions.microsoft.com> wrote in message
news:92D8757A-6378-451C-B68B-32E2D8DC538D@.microsoft.com...
>I posted a report to reporting server, and link the report to asp.net
> reportviewer
> i link the report to the reportviewer by
> Me.ReportViewer1.ServerReport.ReportServerUrl = New
> Uri("http://localhost/Reportserver")
> Me.ReportViewer1.serverReport.ReportPath = Server.MapPath("Report1.rdl")
> however it doesn't have permission to load the report
> how can i implicity to pass the user name and passwor to the
> reportserver
> by code?|||any good links or examples, thanks you
"Chris Conner" wrote:
> Use networkcredential... look under system.net
> Here is the line of code you need:
> rs.Credentials = New System.Net.NetworkCredential(RSUserName, RSPassword,
> RSDomain)
> Where RS is the object to your reporting service web service.
> RSUserName, RSPassword, and RSDomain are variables of type string.
> Cheers!
> =-Chris
>
> "joe" <joe@.discussions.microsoft.com> wrote in message
> news:92D8757A-6378-451C-B68B-32E2D8DC538D@.microsoft.com...
> >I posted a report to reporting server, and link the report to asp.net
> > reportviewer
> > i link the report to the reportviewer by
> >
> > Me.ReportViewer1.ServerReport.ReportServerUrl = New
> > Uri("http://localhost/Reportserver")
> > Me.ReportViewer1.serverReport.ReportPath = Server.MapPath("Report1.rdl")
> >
> > however it doesn't have permission to load the report
> > how can i implicity to pass the user name and passwor to the
> > reportserver
> > by code?
>
>

Reporting Services on XP Professional

Is it possible to install reporting services on SQL Server 2000 on XP Professional?

When I try this I get errors: "ASP.NET is not installed or not registered with your Web Server" and "This version of reporting services does not support installing the server components on this operating system"

ASP.NET is installed and registered with IIS. I can publish pages written with Visual Web Developer Express which work fine.

What version of reporting services do I need to be able to install on XP-Pro?

Did you try the latest service pack? And are you running SQL Server Developer Edition?|||

I have now installed SQL Server 2005 Express with advanced services. I can create reports, preview them but cannot view them in Internet Explorer. Is this a limitation of the Express edition?

I get the following error:

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'ProfileMES'. (rsErrorOpeningConnection)

An internal error occurred on the report server. See the error log for more details. (rsInternalError)|||Installing the SQL Server 2000 reporting services require fixed steps, you need the developer edition ignore any questions Windows ask you unless it is relevant to you. Download and install service pack 3 and 3a these are 25 .sql files Windows uses as needed I have used them with all current operating systems, ran into minor problems with Win2k standard server. The next step is very important install the reporting service and you can install it. If it ask for service pack 4 you have to install that too but I installed it a while back. The most important thing is installing the service packs before installing reporting service and don't answer Windows questions. The SQL Server team have cleaned up the Windows questions in 2005 so it is much easier to install. Hope this helps.|||

I found the problem with SQL Server Express: The data source must also be in the same SQL Express you cannot have data coming from any other remote source be it SQL Server, MS Access or whatever.

Still don't no why Reporting services 2000 won't install under XP though. Nothing I try gets rid of the .NET/IIS error. I'll have to see if I can set up a clean machine and do an install from scratch.

Keith

sql

Reporting Services Newbie

Im developing an asp.net 2.0 application which has SQL 2005 at the backend.
I was intending to develop reports using Crystal but I thought I'd first take
a look at Reporting services. I never used before so you'll have to bear
with me.
Im trying to work through a Books Online Tutorial. All is fairly
straightforward, until I come to publish the report. Im getting the
following error
"The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content. Check the documentation for more
information. (rsReportServerDisabled)"
Im not really sure what is going on here and the info Ive found on web has
not helped.
Ive checked my services and "SQL Server Reporting Services (MSSQLSERVER)" is
Started. The Log On account is "Local System Account" - This is unchanged
from installation.
Also, as far as I can tell, the report does not contain any encryped data.
The report is a simple grouped report based on the following SQL
(adventureworks)
SELECT S.OrderDate, S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastName
FROM HumanResources.Employee E INNER JOIN
Person.Contact C ON E.ContactID = C.ContactID INNER JOIN
Sales.SalesOrderHeader S ON E.EmployeeID = S.SalesPersonID
A more general question that I have is whether reporting services is a
replacement for Crystal. Will I be able to generate reports with subreports.
Will I be able to access them from my web app and will I be able to have my
app pdf them and attach them to emails? If so, are there tutorials available
for these uses of reporting services?
All help appreciated> "The report server cannot decrypt the symmetric key used to access sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content. Check the documentation for more
> information. (rsReportServerDisabled)"
OK, Ive managed to resolve this by doing the following suggestion found in
another post:
go to commna prompt
go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
you should find rskeymgmt,rsconfig etc etc
from this location do this --> "rsKeyMgmt -d"
This deletes all the old symmetric keys
Then restart your IIS
then go back to the command prompt and do "rsconfig -e -u (domain\username)
-p (password)"
This will create the encrypted symmetric keys again.
The user name and password to use are the ones the report server is running
under. (maybe your windows account).
I set the SQL Reporting Service to run under my Admin account ie changed it
from System account (Im not sure what account best practice says this
service, or any of the other SQL services, should run under - could someone
advise)
> A more general question that I have is whether reporting services is a
> replacement for Crystal. Will I be able to generate reports with subreports.
> Will I be able to access them from my web app and will I be able to have my
> app pdf them and attach them to emails? If so, are there tutorials available
> for these uses of reporting services?
Having had a bit of a play, I can see that SQL Reporting Services has huge
potential for our organisation. Initially my main task would be to get to
grips with the ASP ReportViewer control and programmatically setting
parameter values for reports. I'd really appreciated some pointers for
decent books, online resources that show 'real' examples of using Reporting
Services within an ASP application|||Terry,
Check out http://www.gotreportviewer.com/. It is the most comprehensive
report viewer control site around. There is also a newsgroup dedicated to the
controls here:
http://forums.microsoft.com/msdn/showforum.aspx?forumid=75&siteid=1
--
Andy Potter
blog: http://sqlreportingservices.spaces.live.com/
"Terry Holland" wrote:
> > "The report server cannot decrypt the symmetric key used to access sensitive
> > or encrypted data in a report server database. You must either restore a
> > backup key or delete all encrypted content. Check the documentation for more
> > information. (rsReportServerDisabled)"
> OK, Ive managed to resolve this by doing the following suggestion found in
> another post:
> go to commna prompt
> go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
> you should find rskeymgmt,rsconfig etc etc
> from this location do this --> "rsKeyMgmt -d"
> This deletes all the old symmetric keys
> Then restart your IIS
> then go back to the command prompt and do "rsconfig -e -u (domain\username)
> -p (password)"
> This will create the encrypted symmetric keys again.
> The user name and password to use are the ones the report server is running
> under. (maybe your windows account).
> I set the SQL Reporting Service to run under my Admin account ie changed it
> from System account (Im not sure what account best practice says this
> service, or any of the other SQL services, should run under - could someone
> advise)
> > A more general question that I have is whether reporting services is a
> > replacement for Crystal. Will I be able to generate reports with subreports.
> > Will I be able to access them from my web app and will I be able to have my
> > app pdf them and attach them to emails? If so, are there tutorials available
> > for these uses of reporting services?
> Having had a bit of a play, I can see that SQL Reporting Services has huge
> potential for our organisation. Initially my main task would be to get to
> grips with the ASP ReportViewer control and programmatically setting
> parameter values for reports. I'd really appreciated some pointers for
> decent books, online resources that show 'real' examples of using Reporting
> Services within an ASP application|||I found the Step by Step book for Reporting Services 2005 gave a good
introduction.
Microsoft SQL Server 2005 Reporting Services Step By Step
ISBN: 0735622507
amazon link:
http://www.amazon.com/Microsoft-Server-2005-Reporting-Services/dp/0735622507/ref=sr_1_5/103-1359644-0587846?ie=UTF8&s=books&qid=1175393092&sr=1-5
"Terry Holland" <MSDNNospam248@.nospam.nospam> wrote in message
news:CBC4ECC2-1023-4449-9838-5577A9C3B17C@.microsoft.com...
>> "The report server cannot decrypt the symmetric key used to access
>> sensitive
>> or encrypted data in a report server database. You must either restore a
>> backup key or delete all encrypted content. Check the documentation for
>> more
>> information. (rsReportServerDisabled)"
> OK, Ive managed to resolve this by doing the following suggestion found in
> another post:
> go to commna prompt
> go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
> you should find rskeymgmt,rsconfig etc etc
> from this location do this --> "rsKeyMgmt -d"
> This deletes all the old symmetric keys
> Then restart your IIS
> then go back to the command prompt and do "rsconfig -e -u
> (domain\username)
> -p (password)"
> This will create the encrypted symmetric keys again.
> The user name and password to use are the ones the report server is
> running
> under. (maybe your windows account).
> I set the SQL Reporting Service to run under my Admin account ie changed
> it
> from System account (Im not sure what account best practice says this
> service, or any of the other SQL services, should run under - could
> someone
> advise)
>> A more general question that I have is whether reporting services is a
>> replacement for Crystal. Will I be able to generate reports with
>> subreports.
>> Will I be able to access them from my web app and will I be able to have
>> my
>> app pdf them and attach them to emails? If so, are there tutorials
>> available
>> for these uses of reporting services?
> Having had a bit of a play, I can see that SQL Reporting Services has huge
> potential for our organisation. Initially my main task would be to get to
> grips with the ASP ReportViewer control and programmatically setting
> parameter values for reports. I'd really appreciated some pointers for
> decent books, online resources that show 'real' examples of using
> Reporting
> Services within an ASP applicationsql

Reporting Services Mode

I need to do an asp.net application that has reports and Forms Authentication
(no windows authentication). I have absolutely NO need for centralized
reports or load balancing.
On my last project I used sql05 reports within asp.net vs05 on a win03/32bit
server and used LOCAL reports.
The good things
Software configuration management was easy because the reports were local.
The bad things
Rendering in Firefox/mozilla - was very very very poor
Report features for browsers other than IE was poor (searching bookmarks)
Exporting large reports >20 meg - crashes IIS
Would the bad things get better if I:
1. Put in links from my asp.net app to the reporting services web site
or
2. Use the asp.net reportviewer but link to reports on the reporting
services server.
As I see it
Doing 1 or 2 would involve some new security; I would like to use my
applications FormAuthentication, which is not against Windows accounts.
Doing 1 or 2 would complicate my software configuration management.
Doing 1 or 2 would complicate my development and deployment infrastructure.
Doing 1 would degrade the look and feel of my application.
Would doing all the extra work involved with 1 or 2, reduce crashing or
improve rendering in Firefox? I don't understand what the real-physical
differences are between running local or on Report Server, other than
distributing the load. I also don't understand why you lose some export
modes when running local reports, but suspect it has to do with licensing.
Your suggestions are appreciated.
thanks,
p.s. I am upgrading the OS to win03 64bit to reduce IIS crashing during
export.Hello Chunk,
The report viewer control Browser Compatiblity with firefox will be
improved in the Visual Studio .Net 2005 SP1.
If you have any specific issue with Firefox, you could send your feedback
to the product team:
http://connect.microsoft.com/
As for the export type, this is by design. Also, you could send your
feedback to the product team if you have any suggestion.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Is there any difference in rendering between local reports and reports
servered off of the Report Server?|||Hello Chunk,
The main difference between the local processing mode and remote processing
mode is that in local processing mode, your application will retrieve and
render the report while in remote mode, report server will retrieve and
render the report.
You could refer this article for more detailed information:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm
l/integratrsapp.asp
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.|||This question came up because one of our developers went through a really bad
time with the Report Viewer control and Firefox. She believes the
ReportViewer Control is evil and we should just give links to the reports
hosted on the Report Server so we don't have to use the Report Viewer.
If we did this some of our asp.net apps would loose their look and feel
because the reports would no longer be embedded. Personally, I don't think
it would render any different. The article you referenced didn't really get
that technical on the rendering of embedded reports.
"Wei Lu [MSFT]" wrote:
> Hello Chunk,
> The main difference between the local processing mode and remote processing
> mode is that in local processing mode, your application will retrieve and
> render the report while in remote mode, report server will retrieve and
> render the report.
> You could refer this article for more detailed information:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm
> l/integratrsapp.asp
>
> 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.
>|||Before going to using links you better test. I think firefox has problems
with reports period, regardless of how you do it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chuck P" <Chuck@.newsgroup.nospam> wrote in message
news:7454D820-CBDD-4BED-A8E7-6BC0DADE2E69@.microsoft.com...
> This question came up because one of our developers went through a really
> bad
> time with the Report Viewer control and Firefox. She believes the
> ReportViewer Control is evil and we should just give links to the reports
> hosted on the Report Server so we don't have to use the Report Viewer.
> If we did this some of our asp.net apps would loose their look and feel
> because the reports would no longer be embedded. Personally, I don't
> think
> it would render any different. The article you referenced didn't really
> get
> that technical on the rendering of embedded reports.
>
>
> "Wei Lu [MSFT]" wrote:
>> Hello Chunk,
>> The main difference between the local processing mode and remote
>> processing
>> mode is that in local processing mode, your application will retrieve and
>> render the report while in remote mode, report server will retrieve and
>> render the report.
>> You could refer this article for more detailed information:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm
>> l/integratrsapp.asp
>>
>> 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.
>>|||That was my guess. I would imagine the rendering dll would be the same on
the Report Server or locally. However, it can't be identical because you get
less output options if you render locally.|||Hello Chunk,
If you could provide some detailed information about what error or what
behavior that you could not get the report render correctly in the FireFox,
I will be appreciated.
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.|||Most of them are described in MSDN community forums.
Search on ReportViewer and FireFox
http://forums.microsoft.com/MSDN/Search/Search.aspx?words=firefox&searchKey=&lcid=1033&searchscope=forumscope&siteid=1&ForumID=75&ForumGroupID=-1&GoButton=+Go+
The HyperLinkTarget failure is bad:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=333437&SiteID=1
If you have links in the report, without a target=_self, if you place a
href in the report the link will open in the iframe of the report viewer.
This only true for pages after the inital page page 1 the viewer behaves
properly.
Shrinking tables (use a hidden textbox) is widely discussed
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=248271&SiteID=1
There is a good article on the code project on how to place the viewer for
better rendering.
http://www.codeproject.com/sqlrs/ReportViewer2005.asp
ToolBar Display Issue:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354888&SiteID=1
Would be great to get a KB article that would document all the issues/work
arounds in one place!|||Hello Chuck,
Thanks for the feedback. Since the compatibility of FireFox for reporting
service will be improved in the Visual Studio .Net 2005 SP1, the product
team will provide some KB article together with SP1 release.
You could download the beta version and try to test do those issue resolved.
Here is the download url for Visual Studio 2005 Service Pack 1 Beta
http://www.microsoft.com/downloads/details.aspx?familyid=8D702463-674B-4978-
9E22-C989130F6553&displaylang=en
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.

Reporting Services Install Error

I am tyring to install SQL 2000 Reporting services on a 2003 Server. I have
installed IIS, asp.net, VS .net 2003, etc. I installed service packs 3, and
4. I have not noticed the upgrade re: the versions. When I attempt to
install Reporting Services, I keep getting the error the the server requires
sp3a. I was able to install this on my laptop with minimal problems but I
cannot get it installed on my desktop. Please help.I found a solution. I had to install a new instance of the Desktop Engine.
Also, I had to install this from the command line as running the setup.exe
in GUI would not work. The following commands did the job:
setup SAPWD="AStrongSAPwd"
setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"
I was able to setup Reporting Services following the installation of Service
Pack 3a.
"Che J" <crazybug212@.hotmail.com> wrote in message
news:OaF5JevRGHA.1204@.TK2MSFTNGP12.phx.gbl...
>I am tyring to install SQL 2000 Reporting services on a 2003 Server. I have
> installed IIS, asp.net, VS .net 2003, etc. I installed service packs 3,
> and
> 4. I have not noticed the upgrade re: the versions. When I attempt to
> install Reporting Services, I keep getting the error the the server
> requires
> sp3a. I was able to install this on my laptop with minimal problems but I
> cannot get it installed on my desktop. Please help.
>

Reporting Services initial application design question

I am new to Reporting Services, and I would like to serve up SQL 2005 Reporting Services reports via an ASP.NET web app (possibly using Report Viewer controls in Server mode).The web app will be running on an IIS server outside the firewall.

I would prefer to have the Reporting Services server be inaccessible outside the firewall, but it seems that the client browsers need direct URL access to the Reporting Services server.I guess this means either locating the Reporting Services server outside the firewall, or opening a hole in the firewall for access to the Reporting Services server.

Is there a Microsoft best-practice methodology/white-paper that addresses this scenario (especially as regards security concerns)?

Alternately, would it be possible, and would the same report presentation functionality be available (reports with expanding/collapsing sections, choice of export formats, etc), by calling the Reporting Services web service directly from the ASP.NET app, and manually populating the Response object?

Thanks.Any help would be appreciated.

Here is a posting that may help your scenario.

http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx

cheers,

Andrew

|||

Thanks for your response. I had found that link previously, but I've since found another idea that sounds promising:

Extending SQL Server Reporting Services with SQL CLR Table-Valued FunctionsExtending SQL Server Reporting Services with SQL CLR Table-Valued Functions http://msdn2.microsoft.com/en-us/library/bb293147.aspx

Reporting services In ASP.NET

Hi All!

I'm starter of Reporting services in asp.net. please let me know some Address to learn it. Thanks

Hi duynnh,

Theres a series of videos on SQL Serverhere on asp.net. Numbers 10 and 11 cover reporting.

After that check out theReporting Services section on msdn.

I hope that helps.

|||

Hi,

Check these links

http://www.ondotnet.com/pub/a/dotnet/2004/11/29/sqlreporting.html

http://aspnet.4guysfromrolla.com/articles/031605-1.aspx

http://www.123aspx.com/Directory.aspx?dir=349

http://www.c-sharpcorner.com/UploadFile/chauhan_sonu57/SQLReportingServices03032006002905AM/SQLReportingServices.aspx

http://codebetter.com/blogs/peter.van.ooijen/archive/2005/11/15/Using-SQL-reporting-services-in-an-asp.net-application-with-some-notes-on-report-parameters.aspx

http://www.dotnetheaven.com/UploadFile/ursbgiri/106012007065515AM/1.aspx

Hope these links may be helpful..

|||

Hi All!

Thanks for your support. Can you give me some example about: ASP.NET 2.0(C#), Report viewer, Reporting Services. Please help me. Thanks

|||

You can check this site it will be great help

http://www.gotreportviewer.com/

|||

You can try these...

http://www.c-sharpcorner.com/UploadFile/chauhan_sonu57/SQLReportingServices03032006002905AM/SQLReportingServices.aspx?ArticleID=1c048538-0c38-40dd-804e-2604e7dd5fa0

http://support.microsoft.com/kb/875447

|||

Try to look at these:

About ReportViewer Control in ASP.NET 2.0 (C#)

http://www.codeproject.com/aspnet/ReportViewer.asp

http://msdn2.microsoft.com/en-us/library/ms251712(VS.80).aspx

http://www.gotreportviewer.com/

Video Tutorial

http://www.ddj.com/database/199701924

hope it helps!

Reporting services hangs

Hi,

someone doing some reports for me using Reporting Services is getting some problems.

This

is what he stated the problem as: "There is a ASP.NET service which

eats up all of the memory until the report system crashes"

By

removing as many of the views as possible and using tables directly,

the report successfully ran (in a bit over two minutes, processing

300,000 records), however, when doubling the amount of data to be

included, the report wouldn't run again.

Has anybody come across a similar problem and have any advice?

Thanks,

Frank

Rather than sending 600,000 rows across the network, I'd suggest filtering/aggregating on the database side and using Reporting Services mainly to format/display. Take advantage of the strenghts of each product.

Otherwise, I'd suggest increasing the amoung of memory available on the machine, and if necessary upgrading to 64-bit which supports much larger amounts of RAM.

Thanks, Donovan.

|||Thanks, I believe the developer has tried to do as much processing on the server, but I will pass on your suggestion.

Upgrading RAM has already been suggested, but the system is for some financially strapped countries so it may not be possible.

Thanks again.|||Hi Donovan,

the developer has redesigned the reports as you suggested and instead of sending 600,000 records to Reporting Services he is now sending 6,300 and the report works!

Thanks a bunch!

Reporting Services error after installing sql server 2005 sp2

Please help!

I have an asp.net 2.0 web app that integrates with reporting services. Since installing sql server 2005 sp2 I get the following error when trying to access reports:

An error has occurred during report processing. (rsProcessingAborted)

This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)

I've checked the directory security for the report server website in IIS and integrated windows authentication is checked.

I can't understand what has caused the problem, before sp2 the reports were working fine.

Thanks in advance for any help,

Andy

We have had the exact same issue in all of our environments - Dev, Staging and Production. Our only work around was to enable sql authentication and setup new datasources using a sql authenticated user. We'd certainly prefer to maintain only windows authentication on our sql servers but can not do so until this issue is resolved.
|||

I used this workaround as well. Also I receive the following error in the Sql server 2005 Surface Area Configuration tool when selecting the 'Windows Integrated Security' node under 'Reporting Services':

The request failed with HTTP status 403: Forbidden. (SQLSAC)

The check box to enable Windows integrated security is greyed out. Do you receive any such error?

Reporting Services Configuration

How to get SQL Reporting Services installed? I read a white paper about
having IIS and ASP.net installed, but assuming I did that, where can I see
the Reporting Services feature?
--
TSIf you are talking about installing the IIS Reporting Server ( instead of the
dev environment), then you will see nothing new anywhere...
However, using IIS go to http://yourservername/reports
and you will see the stuff!
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"TS" wrote:
> How to get SQL Reporting Services installed? I read a white paper about
> having IIS and ASP.net installed, but assuming I did that, where can I see
> the Reporting Services feature?
> --
> TS