Showing posts with label own. Show all posts
Showing posts with label own. Show all posts

Tuesday, March 27, 2012

Forms Authentication without Report Manager

I am intergrating Reporting Services into my own web application and want to use Forms Authentication. Do I need to do anything different than the Security Extension Sample on MSDN books online? Specifically, since I no longer need to go through Report Manager, how would I login the user and manage the cookie?http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp?ferame=true will help you in this. Actualyl I am researching this myself. I am looking to add/delete user roles programmatically. So far, I am having little luck but, I think I'll pull it together!

Monday, March 12, 2012

Formatted text in report parameter

I want the user to add his/her own title and some text to the report which can be bold, different color etc. Can this be done via a single report parameter and are there any ways to do it?

Not out of the box. If you use SRS 2005, the ReportViewer controls (part of VS 2005) will allow you to show reports in any ASP.NET or Winforms application. Using the controls, you can hide the report parameters page and replace it with your own prompting logic. See www.gotreportviewer.com for more details.

If you use SRS 2000, you can achieve most of this by putting an iframe to the report server in your web page and include rc:Parameters=False to hide the parameters area. You web page would be responsible for parameters prompting and for feeding the values to the report server iframe. For ex: http://server/reportserver/?PathToTheReport&rc:Parameters=false&Param1=value1&Param2=Value2