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.