formula question

I have this crystal formula

How can this be converted to a reporting services Expression

if {ITEMCODE} in ["A","B"]

then "TypeA"

else if

{ITEMCODE} in ["C","D"]

then "TypeB"

else

"TypeC"

Use this:

=iif((Fields!ITEMCODE.Value = "A" OR Fields!ITEMCODE.Value = "B") ,"TypeA",IIF((Fields!ITEMCODE.Value = "C" OR Fields!ITEMCODE.Value = "D"),"TypeB","TypeC"))

Hope this will work.

Regards,

Manoj Verma

|||

Hi Manoj

Is this the only way.

one of my formulas may have to have upto 100 or's?

Thanks for your help

|||

I don't think you may have any other option or if it is there then i'm not able to figure out.

Sorry....

Regards

Manoj Verma

|||

Thanks for your help Manoj

I will have to group them another way using another table!

Formula Problem

I get the following error in Report Manager when running a report. The
report runs perfect in visual studio when I preview it.
Reporting Services Error
_____
* An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
* The sort expression for the grouping 'table1_Group1' uses a numeric
aggregate function on data that is not numeric. Numeric aggregate
functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate
numeric data. (rsProcessingError) Get Online Help
_____
Microsoft Reporting Services
I pass two parameters, qty and sortdate. As the formulas show below,
when they select qty and ascending, it uses sum(fields). When I pick
date, it does not use sum.
This will sort by the value in the sortby parameter. Used for sortdate
field in data.
=iif(Parameters!Direction.Value="Descending" AND
Parameters!SortBy.Value<>"quantity",Fields(Parameters!SortBy.Value).Value,0)
When I need to sort by the sum of the qty since it is grouped, I do
this...
=iif(Parameters!Direction.Value="Descending" AND
Parameters!SortBy.Value="quantity",sum(Fields(Parameters!SortBy.Value).Value),0)
As I said above, this works perfect in visual studio when I preview it.
Any Ideas?What is the datatype of Fields!quantity.Value? Most likely it is not a
System.Int32 at runtime.
You may want to try this (assuming you want to sum up integers):
=iif(Parameters!Direction.Value="Descending" AND
Parameters!SortBy.Value="quantity",
sum(CInt(Fields(Parameters!SortBy.Value).Value)), 0)
Or use this if you want to actually sum double:
=iif(Parameters!Direction.Value="Descending" AND
Parameters!SortBy.Value="quantity",
sum(CDbl(Fields(Parameters!SortBy.Value).Value)), 0.0)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Geddes" <john_g@.alamode.com> wrote in message
news:eTl79Cj4EHA.3504@.TK2MSFTNGP12.phx.gbl...
> I get the following error in Report Manager when running a report. The
> report runs perfect in visual studio when I preview it.
> Reporting Services Error
> _____
>
> * An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> * The sort expression for the grouping 'table1_Group1' uses a numeric
> aggregate function on data that is not numeric. Numeric aggregate
> functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate
> numeric data. (rsProcessingError) Get Online Help
> _____
> Microsoft Reporting Services
>
> I pass two parameters, qty and sortdate. As the formulas show below,
> when they select qty and ascending, it uses sum(fields). When I pick
> date, it does not use sum.
> This will sort by the value in the sortby parameter. Used for sortdate
> field in data.
> =iif(Parameters!Direction.Value="Descending" AND
>
Parameters!SortBy.Value<>"quantity",Fields(Parameters!SortBy.Value).Value,0)
> When I need to sort by the sum of the qty since it is grouped, I do
> this...
> =iif(Parameters!Direction.Value="Descending" AND
>
Parameters!SortBy.Value="quantity",sum(Fields(Parameters!SortBy.Value).Value
),0)
>
> As I said above, this works perfect in visual studio when I preview it.
> Any Ideas?
>

Formula in Excel Sheet

Hello,

I have one simple Report in SQL Reporting Services.

there are only Three Columns GroupName, Description, Amount.

In this report there is Grouping on GroupName Field.

In Group Footer in want Group Total. i'm writting here like =Sum(Fields!Amount.Value)

Now, while preview of this report I'm exporting the same to Excel File.

While opening that Excel file in Group Footer there is no Formula which i written in .rdl file.

If any one can help me out on this Formula field it will be great.

Thank You.

Unfortunately the Excel export doesn't support this.

Formulas are only translated to Excel formulas when they use references to report items instead of fields. For example, instead of "=Fields!Amount.Value" you would use "=ReportItems!AmountTextBox.Value". You can use these to get add two values together on the same row, for instance.

However, you can only use aggregate functions such as SUM on report items when the expression is in the page header or footer. So you won't be able to use, say "=SUM(ReportItems!AmountTextBox.Value" in the table footer.

We are aware that this severely limits the utility of formulas in Excel, and are considering ways to improve it. We do not have a timeframe for this at this time.

Forms security deploy problem and email-subscription

Hi,

I have changed my Reporting services from Windows Security to Forms Security. When I deploy reports on the local SQL server, a windows pops up. This windows requires my username and password for the report server. After I input them, everything works fine.

However, When I deploy reports to the above server from the different SQL server located on a different computer, the windows always pops up, although I type the same username and same password. Any ideas?

Thanks a lot.Is this a Windows dialog box from IE? If so, have you enabled anonymous access to the ReportServer and Reports virtual directories in the IIS management console?This is one of the pre-requisites for making forms authentication work.

Thanks
Tudor|||Hi,

Yes, I have already changed them on the computer where my reporting server is located. In fact, I have succeeded in implementing Forms security locally. Like what I described in my question post, after my inputing username and password, local deploying is fine. But when I deploy from another computer, after my inputer the same username and password, the poped-up windows is still there.

Moreover, I also encountered another problem. When email-subscription works under windows security, but it doesn't work under forms security. The error is "Object reference not set to an instance of an object."

Any ideas about them?

Thanks a lot.|||Urgent. any ideas?|||

Check whether the error comes from the (modified) sample code. For instance the sample implementation of GetUserInfo checks for the existence of the HttpContext and returns null if it's not present.
If you have changed that, it would be possible that it could fail when running the report as part of a subscription.

Thanks
Tudor

|||How do you enable anonymous access to the ReportServer? I have an application that references the URL of the report. It is also prompting for credentials. I would really not like to pass the login and password through. Currently we are using one standard user name and password.

Thanks in advance!|||You enable anonymous in the IIS settings. Note, security will effectively be disabled at this point.|||I received a differnent error while using the Forms Extension with SQL REporting Services 2005 when trying to use email subscriptions. The error I received is "

The Forms extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users."

Any ideas

Thanks

|||

Hi ,

I have configured SMTP server and i have done email subscription to particular customer called "tbs".The report generates daily at 9:00pm and report will be sent to customer's email.But,if the report doesnot contain any Records,the report should not be delivered to Customer.

Could you be able to guide me and suggest me .

Thanks,

Jayaram

Forms security deploy problem and email-subscription

Hi,

I have changed my Reporting services from Windows Security to Forms Security. When I deploy reports on the local SQL server, a windows pops up. This windows requires my username and password for the report server. After I input them, everything works fine.

However, When I deploy reports to the above server from the different SQL server located on a different computer, the windows always pops up, although I type the same username and same password. Any ideas?

Thanks a lot.Is this a Windows dialog box from IE? If so, have you enabled anonymous access to the ReportServer and Reports virtual directories in the IIS management console?This is one of the pre-requisites for making forms authentication work.

Thanks
Tudor|||Hi,

Yes, I have already changed them on the computer where my reporting server is located. In fact, I have succeeded in implementing Forms security locally. Like what I described in my question post, after my inputing username and password, local deploying is fine. But when I deploy from another computer, after my inputer the same username and password, the poped-up windows is still there.

Moreover, I also encountered another problem. When email-subscription works under windows security, but it doesn't work under forms security. The error is "Object reference not set to an instance of an object."

Any ideas about them?

Thanks a lot.|||Urgent. any ideas?|||

Check whether the error comes from the (modified) sample code. For instance the sample implementation of GetUserInfo checks for the existence of the HttpContext and returns null if it's not present.
If you have changed that, it would be possible that it could fail when running the report as part of a subscription.

Thanks
Tudor

|||How do you enable anonymous access to the ReportServer? I have an application that references the URL of the report. It is also prompting for credentials. I would really not like to pass the login and password through. Currently we are using one standard user name and password.

Thanks in advance!|||You enable anonymous in the IIS settings. Note, security will effectively be disabled at this point.|||I received a differnent error while using the Forms Extension with SQL REporting Services 2005 when trying to use email subscriptions. The error I received is "

The Forms extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users."

Any ideas

Thanks

|||

Hi ,

I have configured SMTP server and i have done email subscription to particular customer called "tbs".The report generates daily at 9:00pm and report will be sent to customer's email.But,if the report doesnot contain any Records,the report should not be delivered to Customer.

Could you be able to guide me and suggest me .

Thanks,

Jayaram

sql

Forms security deploy problem

Hi,

I have changed my Reporting services from Windows Security to Forms Security. When I deploy reports on the local SQL server, a windows pops up. This windows requires my username and password for the report server. After I input them, everything works fine.

However, When I deploy reports to the above server from the different SQL server located on a different computer, the windows always pops up, although I type the same username and same password. Any ideas?

Thanks a lot.Is this a Windows dialog box from IE? If so, have you enabled anonymous access to the ReportServer and Reports virtual directories in the IIS management console?This is one of the pre-requisites for making forms authentication work.

Thanks
Tudor|||Hi,

Yes, I have already changed them on the computer where my reporting server is located. In fact, I have succeeded in implementing Forms security locally. Like what I described in my question post, after my inputing username and password, local deploying is fine. But when I deploy from another computer, after my inputer the same username and password, the poped-up windows is still there.

Moreover, I also encountered another problem. When email-subscription works under windows security, but it doesn't work under forms security. The error is "Object reference not set to an instance of an object."

Any ideas about them?

Thanks a lot.|||Urgent. any ideas?|||

Check whether the error comes from the (modified) sample code. For instance the sample implementation of GetUserInfo checks for the existence of the HttpContext and returns null if it's not present.
If you have changed that, it would be possible that it could fail when running the report as part of a subscription.

Thanks
Tudor

|||How do you enable anonymous access to the ReportServer? I have an application that references the URL of the report. It is also prompting for credentials. I would really not like to pass the login and password through. Currently we are using one standard user name and password.

Thanks in advance!|||You enable anonymous in the IIS settings. Note, security will effectively be disabled at this point.|||I received a differnent error while using the Forms Extension with SQL REporting Services 2005 when trying to use email subscriptions. The error I received is "

The Forms extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users."

Any ideas

Thanks

|||

Hi ,

I have configured SMTP server and i have done email subscription to particular customer called "tbs".The report generates daily at 9:00pm and report will be sent to customer's email.But,if the report doesnot contain any Records,the report should not be delivered to Customer.

Could you be able to guide me and suggest me .

Thanks,

Jayaram

forms in reporting services

is there a way to put forms in reporting services? If so, how would this be doneWrong forum. Moving to SSRS forum.|||I deleted it from the ssrs forum. Thanks

forms in reporting services

Is there a way to insert forms in reporting services. If so, how would this be done>?

Reporting Services is not a data entry application so you should probably look at a custom web/windows app or Infopath.

cheers,

Andrew

|||

Andrew,

I know that you can't create forms in reporting services, but you can import a form in to the system. Do you know how that would be done.

|||

Hi there,

Not sure what you mean. Could you provide an example of what you are trying to do?

thanks,

Andrew

|||

Andrew,

when creating a data entry form in reporting services. just like you can upload an .rdl file or an excel file, can you upload a entry form in which data can be entered into a backend sql server database.

|||

Are you using Sharepoint or Report Manager?

You will probably have to write a custom web app or web part to enter data into a sql database, or use the sql web data administrator tool.

There is no facility for creating a data entry form in reporting services.

regards,

Andrew

Forms authentication...

Hello,

I know that basically SQL Reporting Services uses windows authentication. Does anyone know a way to change this behavior so that I can use forms authentication.

Thanks for any help.check this article :Harden MS Reporting Services Using Custom Extensions
and this one too :Using Forms Authentication in Reporting Services|||Just as a side note, you can only use forms authentication if you have an enterprise sql server licence.

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!

forms authentication samples

I cant find the forms authentication samples for srs 2005
C:\Program Files\Microsoft SQL Server\90\Samples\Reporting
Services\Extension Samples\FormsAuthentication SampleNevermind, there was an msi file somewhere
"Marvin" wrote:
> I cant find the forms authentication samples for srs 2005
> C:\Program Files\Microsoft SQL Server\90\Samples\Reporting
> Services\Extension Samples\FormsAuthentication Sample
>

Forms Authentication Resulting in Blank Screen after a few minutes.

Hi – I hope someone can help,

I have developed a custom authentication extension to Reporting Services 2005, using Visual Studio 2005 C#.

In local integration tests the extension behaved as expected, honouring the role based security of our main system. Following the deployment steps laid out from numerous sources all worked perfectly. We were optimistic.

I've since deployed to a 'live' user acceptance staging server, using the same procedures used in Integration and it's behaving incorrectly.

Initially the log in page is displayed as expected, at this point SQL dumps occur in the RS Log directory, the same as is seen here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1750128&SiteID=1

Hopefully there'll be a resolution to that soon. As described in that topic, the main page of Report Manager appears.

After this it all goes wrong.

Sometimes we can browse to a folder and run a report. But after running the report, trying to run something else, or browse back to the containing folder we are presented with the error page with the message:

The permissions granted to user '' are insufficient for performing this operation.

Clicking on the home link brings up the top title and nothing else and you have no option but to close the site and re-login.

Sometimes you get the above message before you can even run a report. The error logs have the message listed at the end of this post.

Other times you log in to the website and the folders don't even appear, just the top title bar.

I have since added some verbose logging in each of the implemented methods in the extension DLL. The permission checking method return true and all the various data in each method appears as expected.

I have checked, checked again and re-checked all the configuration files, they match the local Integration files, barring the machine specific keys etc, they weren't just overwritten.

The location of the log directory where my internal logs are written is read from the configuration files via the SetConfiguration methods, if that wasn't set correctly then there wouldn't be any logs at all, so the configuration is being read correctly by the extension.

One other think that I've noticed is that the back door user that is configured in the config files works perfectly, but I can't see how this can make any sort of a difference as it returns the same result in the extension DLL as a 'normal' user does at the same point in the code.

Can someone please help me, and my poor scalp, it's losing hair at a rate of knots.

Set up:

Windows Server 2005

SQL Server 2005 Service Pack 2 (Developer)

IIS 6

Error message in the log files:

w3wp!library!1!27/06/2007-10:04:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: HTTP status code --> 500

-Details--

Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.

at System.Threading.Thread.AbortInternal()

at System.Threading.Thread.Abort(Object stateInfo)

at System.Web.HttpResponse.End()

at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)

at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()

at System.Threading.Thread.Abort(Object stateInfo)

at System.Web.HttpResponse.End()

at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)

at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Additionally, once I get the error message above, and nothing is displayed apart from the headline bar, If I browse to the ReportServer web-service, in the same session, it works perfectly.

This is terribly frustrating.
|||*bump*

Any Ideas?
|||*re bump*

Forms Authentication Resulting in Blank Screen after a few minutes.

Hi – I hope someone can help,

I have developed a custom authentication extension to Reporting Services 2005, using Visual Studio 2005 C#.

In local integration tests the extension behaved as expected, honouring the role based security of our main system. Following the deployment steps laid out from numerous sources all worked perfectly. We were optimistic.

I've since deployed to a 'live' user acceptance staging server, using the same procedures used in Integration and it's behaving incorrectly.

Initially the log in page is displayed as expected, at this point SQL dumps occur in the RS Log directory, the same as is seen here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1750128&SiteID=1

Hopefully there'll be a resolution to that soon. As described in that topic, the main page of Report Manager appears.

After this it all goes wrong.

Sometimes we can browse to a folder and run a report. But after running the report, trying to run something else, or browse back to the containing folder we are presented with the error page with the message:

The permissions granted to user '' are insufficient for performing this operation.

Clicking on the home link brings up the top title and nothing else and you have no option but to close the site and re-login.

Sometimes you get the above message before you can even run a report. The error logs have the message listed at the end of this post.

Other times you log in to the website and the folders don't even appear, just the top title bar.

I have since added some verbose logging in each of the implemented methods in the extension DLL. The permission checking method return true and all the various data in each method appears as expected.

I have checked, checked again and re-checked all the configuration files, they match the local Integration files, barring the machine specific keys etc, they weren't just overwritten.

The location of the log directory where my internal logs are written is read from the configuration files via the SetConfiguration methods, if that wasn't set correctly then there wouldn't be any logs at all, so the configuration is being read correctly by the extension.

One other think that I've noticed is that the back door user that is configured in the config files works perfectly, but I can't see how this can make any sort of a difference as it returns the same result in the extension DLL as a 'normal' user does at the same point in the code.

Can someone please help me, and my poor scalp, it's losing hair at a rate of knots.

Set up:

Windows Server 2005

SQL Server 2005 Service Pack 2 (Developer)

IIS 6

Error message in the log files:

w3wp!library!1!27/06/2007-10:04:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: HTTP status code --> 500

-Details--

Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.

at System.Threading.Thread.AbortInternal()

at System.Threading.Thread.Abort(Object stateInfo)

at System.Web.HttpResponse.End()

at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)

at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()

at System.Threading.Thread.Abort(Object stateInfo)

at System.Web.HttpResponse.End()

at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)

at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Additionally, once I get the error message above, and nothing is displayed apart from the headline bar, If I browse to the ReportServer web-service, in the same session, it works perfectly.

This is terribly frustrating.
|||*bump*

Any Ideas?
|||*re bump*

Forms authentication problems

Hi,
I'm implementing a custom security extension for Reporting Services,
based on the forms authentication sample, and am having a couple of
problems with authentication.
Here's some background on my set-up.
- We intend to expose reports to our customers over the internet.
Since we already have a main web application with a logon form and
authentication framework, we are sharing the authentication cookies
with that application (which lives on a different server), according
to the MSDN article 'Forms Authentication Across Applications'.
- I have implemented an authentication extension which uses this
framework to authenticate users, and it works. (I can call LogonUser
and get a cookie back if my credentials are valid, among other things.)
- Rather than having a separate logon form for Reporting Services, we
want to redirect users to/from our main logon form on the other server.
First problem: Report Manager isn't redirecting to the logon page that I
specified in the RSWebApplication.config file. Instead it is trying to
call the web service when not authenticated, and failing. (It gets
redirected to the logon page, and doesn't know what to do with it.)
The UFAIRS article doesn't say how RM works out whether the user has
an authentication cookie for the web service which needs forwarding.
Presumably it looks for one in the request, and redirects to the logon
page if the cookie isn't there. But how does it know what the cookie's
called? How does it even know that the web service is using forms
authentication (without first trying it)?
I don't know how what I'm doing is any different to the sample, which
does work. The only thing I've changed (in the Report Manager
configuration) is the loginUrl element within CustomAuthenticationUI,
but RM isn't even trying to redirect the client.
I'm also getting what I think is the same problem using Report Designer
in Visual Studio. When the sample was installed, Report Designer would
pop up a box asking for username and password whenever it tried to use
the web service, but now it just gives me an error message stating "a
connection could not be made to the report server". Again, I'm not sure
how it's trying to determine what it has to do to authenticate itself.
Second problem: redirection from the web service works, but it isn't
respecting the useFullyQualifiedRedirectUrl setting in web.config
(attribute of the httpRuntime element), which I've set to 'true'. The
URL it generates and puts in the query string is relative to the local
server root. Since my logon page is on a different server, I need it to
include the full URL.
Sorry for the long post, and thanks for reading if you got this far.
Please let me know any ideas you might have. I can post details from my
configuration files on request, and please ask if there's something I
haven't made clear. Thanks.
StephenThe name of the authentication cookie is configured in web.config under the
<forms> tag.
Perhaps you can make a call SOAP to LogonUser from your application before
the user gets to report manager. Then send the cookie to the client. Further
access to report server should be authenticated. For report manager to work
in this configuration you need to set the AllowPassthroughCookies - see the
SP1 readme for the exact name.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Kell" <skell@.opaltelecom.co.uk> wrote in message
news:pan.2004.08.04.15.24.00.797000@.opaltelecom.co.uk...
> Hi,
> I'm implementing a custom security extension for Reporting Services,
> based on the forms authentication sample, and am having a couple of
> problems with authentication.
> Here's some background on my set-up.
> - We intend to expose reports to our customers over the internet.
> Since we already have a main web application with a logon form and
> authentication framework, we are sharing the authentication cookies
> with that application (which lives on a different server), according
> to the MSDN article 'Forms Authentication Across Applications'.
> - I have implemented an authentication extension which uses this
> framework to authenticate users, and it works. (I can call LogonUser
> and get a cookie back if my credentials are valid, among other things.)
> - Rather than having a separate logon form for Reporting Services, we
> want to redirect users to/from our main logon form on the other server.
> First problem: Report Manager isn't redirecting to the logon page that I
> specified in the RSWebApplication.config file. Instead it is trying to
> call the web service when not authenticated, and failing. (It gets
> redirected to the logon page, and doesn't know what to do with it.)
> The UFAIRS article doesn't say how RM works out whether the user has
> an authentication cookie for the web service which needs forwarding.
> Presumably it looks for one in the request, and redirects to the logon
> page if the cookie isn't there. But how does it know what the cookie's
> called? How does it even know that the web service is using forms
> authentication (without first trying it)?
> I don't know how what I'm doing is any different to the sample, which
> does work. The only thing I've changed (in the Report Manager
> configuration) is the loginUrl element within CustomAuthenticationUI,
> but RM isn't even trying to redirect the client.
> I'm also getting what I think is the same problem using Report Designer
> in Visual Studio. When the sample was installed, Report Designer would
> pop up a box asking for username and password whenever it tried to use
> the web service, but now it just gives me an error message stating "a
> connection could not be made to the report server". Again, I'm not sure
> how it's trying to determine what it has to do to authenticate itself.
> Second problem: redirection from the web service works, but it isn't
> respecting the useFullyQualifiedRedirectUrl setting in web.config
> (attribute of the httpRuntime element), which I've set to 'true'. The
> URL it generates and puts in the query string is relative to the local
> server root. Since my logon page is on a different server, I need it to
> include the full URL.
> Sorry for the long post, and thanks for reading if you got this far.
> Please let me know any ideas you might have. I can post details from my
> configuration files on request, and please ask if there's something I
> haven't made clear. Thanks.
> Stephen
>|||Firstly, thanks for the reply.
> The name of the authentication cookie is configured in web.config under the
> <forms> tag.
Maybe I misunderstood, but I thought that this was only for the web
service (i.e. in ReportServer/web.config). Report Manager is using Windows
authentication itself, and doesn't have a <forms> element in its
web.config. Let me know if this is not correct.
> Perhaps you can make a call SOAP to LogonUser from your application before
> the user gets to report manager. Then send the cookie to the client. Further
> access to report server should be authenticated. For report manager to work
> in this configuration you need to set the AllowPassthroughCookies - see the
> SP1 readme for the exact name.
Thanks -- I set the PassThroughCookies configuration as required and now I
can access Report Manager. It's still not redirecting in the case of an
unauthenticated request, which would be nice to have working, but not
essential as I can log on using our form first, which generates a valid
cookie. Unfortunately though, I still get the error I described with
Report Designer, and don't have any possibility of working around that
similarly. Please let me know if you have any ideas.
Stephen|||Report manager reads the name of the authentication cookie which is sent by
the report server as an HTTP header.
Unfortunately I don't know of any solution that would allow report designer
to work in this case. As a workaround you could write your own application
that would publish reports using SOAP calls. In the SOAP client, you can
manage your custom cookies as you wish.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Kell" <skell@.opaltelecom.co.uk> wrote in message
news:pan.2004.08.05.14.48.01.766000@.opaltelecom.co.uk...
> Firstly, thanks for the reply.
> > The name of the authentication cookie is configured in web.config under
the
> > <forms> tag.
> Maybe I misunderstood, but I thought that this was only for the web
> service (i.e. in ReportServer/web.config). Report Manager is using Windows
> authentication itself, and doesn't have a <forms> element in its
> web.config. Let me know if this is not correct.
> > Perhaps you can make a call SOAP to LogonUser from your application
before
> > the user gets to report manager. Then send the cookie to the client.
Further
> > access to report server should be authenticated. For report manager to
work
> > in this configuration you need to set the AllowPassthroughCookies - see
the
> > SP1 readme for the exact name.
> Thanks -- I set the PassThroughCookies configuration as required and now I
> can access Report Manager. It's still not redirecting in the case of an
> unauthenticated request, which would be nice to have working, but not
> essential as I can log on using our form first, which generates a valid
> cookie. Unfortunately though, I still get the error I described with
> Report Designer, and don't have any possibility of working around that
> similarly. Please let me know if you have any ideas.
> Stephen
>|||Thanks. I will look into implementing a separate application to deploy
reports.
I am still a bit puzzled about how what I'm doing is substantially
different to the sample -- there's nothing special about my cookies, and
valid cookies can be generated by the RS web service as well as by our own
login page (or at least that's the idea). I'll try to investigate whether
the HTTP requests issued by RM/RD (or the responses they get) are any
different when using the sample, compared to my current installation. (Not
managed to do so yet as I don't currently have a machine with the sample
installed.)
Going back to another issue I mentioned in my first post, I don't suppose
there's any clues about why the web service doesn't generate
fully-qualified redirect URLs? I thought this was all handled by ASP.NET's
underlying FormsAuthentication implementation, but it seems like RS has
altered the normal behaviour, unless I've misunderstood something. Any
suggestions appreciated.
Stephen|||Yes, the redirect in Report manager is done only into the report manager
directory.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Kell" <skell@.opaltelecom.co.uk> wrote in message
news:pan.2004.08.06.15.52.29.703000@.opaltelecom.co.uk...
> Thanks. I will look into implementing a separate application to deploy
> reports.
> I am still a bit puzzled about how what I'm doing is substantially
> different to the sample -- there's nothing special about my cookies, and
> valid cookies can be generated by the RS web service as well as by our own
> login page (or at least that's the idea). I'll try to investigate whether
> the HTTP requests issued by RM/RD (or the responses they get) are any
> different when using the sample, compared to my current installation. (Not
> managed to do so yet as I don't currently have a machine with the sample
> installed.)
> Going back to another issue I mentioned in my first post, I don't suppose
> there's any clues about why the web service doesn't generate
> fully-qualified redirect URLs? I thought this was all handled by ASP.NET's
> underlying FormsAuthentication implementation, but it seems like RS has
> altered the normal behaviour, unless I've misunderstood something. Any
> suggestions appreciated.
> Stephen
>|||(I don't know if anyone's still reading this thread, but if so, I finally
worked out the solution and thought I'd share it.)
Thanks -- it did turn out to be something to do with the redirect
destination being outside of the application's virtual directory, but not
quite what you said. (I won't claim that my explanation matches the
intended logic behind the Reporting Services code, only that it allowed me
to understand and solve the problem I was having.)
In fact, both the RS web service and Report Manager are quite happy to
redirect outside of their virtual directory. The problem is in how their
clients interpret this.
Both Report Manager and Report Designer need some way of determining
whether to call LogonUser. If the web service redirects them to a location
inside its virtual directory, they assume this is a logon page, and do
their ask-for-credentials thing. (For Report Manager it's redirecting to
the page specified in the CustomAuthenticationUI configuration element,
while for Report Designer it's popping up that dialog asking for
credentials.) Once they have the credentials, they call LogonUser to get
their cookie.
If the web service redirects them elsewhere, they don't do any of this,
and instead fall over, in the end generating generic error messages
claiming that the report server isn't working.
I got around this by configuring the web service to redirect to a simple
aspx page (called Logon.aspx, though the name doesn't matter) in its own
virtual directory. In the Page_Load event I test whether a the User-Agent
header was received. This is a bit of magic intended to determine whether
the client is interactive (i.e. a web browser) and therefore capable of
logging in using a form, or not (e.g. a web service client like Report
Designer or Report Manager).
In the case of an interactive client, the page redirects to the (external)
login page. (The URL of the login page is read from a label in the aspx
page, so you don't need to recompile in order to change it.) You must make
sure that you also include the ReturnUrl query string parameter in your
redirect destination URL, *and* that you translate it to a fully-qualified
URL (since RS doesn't seem to do this).
For non-interactive clients, it just serves a blank page (or actually,
since I was feeling helpful, a short message about why the client wasn't
redirected, followed by the aforementioned label showing the login page
URL).
Report Manager and Report Designer now work fine. You can specify the
external login page for RM just like any other.
Sorry for the long-winded explanation -- I hope it proves useful for
someone.
Stephen

Forms Authentication Problem

Hi All,
I have been trying to get Forms Authentication to work for reporting
services. I followed the article at MS's Library to a tee but I keep getting
a http 404 error when I attempt to pull up report manager. I would assume
that its referring to the login page can't be found but I checked the urls
in my config files and they point to the right places. How about in the
security extensions is there an url in there that needs to be updated that I
didn't discover? Any ideas to why I would get this error?
Thanks,
JJOk I fixed the problem mentioned above now I have the following error:
"Unable to communicate with report server. Please verify that the report
server is operational."
What could be causing this problem?
Thanks,
JJ
"JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
news:ebO2z%23rEFHA.2540@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I have been trying to get Forms Authentication to work for reporting
> services. I followed the article at MS's Library to a tee but I keep
getting
> a http 404 error when I attempt to pull up report manager. I would assume
> that its referring to the login page can't be found but I checked the urls
> in my config files and they point to the right places. How about in the
> security extensions is there an url in there that needs to be updated that
I
> didn't discover? Any ideas to why I would get this error?
> Thanks,
> JJ
>|||What version of RS are you running, Standard or Enterprise? Forms
Authentication works only under the Enterprise version.
"JJ" wrote:
> Ok I fixed the problem mentioned above now I have the following error:
> "Unable to communicate with report server. Please verify that the report
> server is operational."
> What could be causing this problem?
> Thanks,
> JJ
> "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
> news:ebO2z%23rEFHA.2540@.TK2MSFTNGP09.phx.gbl...
> > Hi All,
> >
> > I have been trying to get Forms Authentication to work for reporting
> > services. I followed the article at MS's Library to a tee but I keep
> getting
> > a http 404 error when I attempt to pull up report manager. I would assume
> > that its referring to the login page can't be found but I checked the urls
> > in my config files and they point to the right places. How about in the
> > security extensions is there an url in there that needs to be updated that
> I
> > didn't discover? Any ideas to why I would get this error?
> >
> > Thanks,
> >
> > JJ
> >
> >
>
>|||Hi Herb,
I am using the Enterprise Version of Reporting Services. When I go to
http://servername/ReportServer/ and hit enter I get
Server Error in /ReportServer App, Parser error message: Could not load
type Login.
Source Error:
Line 1: <% Page etc...
I have triple checked this login page and have found nothing wrong with it.
When I go to http://servername/Reports and hit enter I get Error : unable to
communicate with report server. Please verify that the report server is
operational.
I have gone through the document 3 times - "Using Forms Authenication with
Reporting Services" and made sure that every
config file is setup properly. I am having one hell of a time trying to get
Reporting services to work properly. It should not be this difficult to
implement / use and Im a programmer that uses Forms Authenication in other
web apps.
Please help.
Thanks,
JJ
"Herb" <Herb@.discussions.microsoft.com> wrote in message
news:B28BE8EB-1DDC-4F3A-8557-2E27556DC447@.microsoft.com...
> What version of RS are you running, Standard or Enterprise? Forms
> Authentication works only under the Enterprise version.
>
> "JJ" wrote:
> > Ok I fixed the problem mentioned above now I have the following error:
> >
> > "Unable to communicate with report server. Please verify that the report
> > server is operational."
> >
> > What could be causing this problem?
> >
> > Thanks,
> >
> > JJ
> >
> > "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
> > news:ebO2z%23rEFHA.2540@.TK2MSFTNGP09.phx.gbl...
> > > Hi All,
> > >
> > > I have been trying to get Forms Authentication to work for reporting
> > > services. I followed the article at MS's Library to a tee but I keep
> > getting
> > > a http 404 error when I attempt to pull up report manager. I would
assume
> > > that its referring to the login page can't be found but I checked the
urls
> > > in my config files and they point to the right places. How about in
the
> > > security extensions is there an url in there that needs to be updated
that
> > I
> > > didn't discover? Any ideas to why I would get this error?
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > >
> >
> >
> >|||Can you post the full error w/ the logon page you mention below? That
sounds like a common asp.net error. Check the following:
On your apx page you have the Page directive -
<%@. Page language="c#" Codebehind="YourPage.aspx.cs" AutoEventWireup="false"
Inherits="YourAppNameSpace.YourPage" %>
Make sure the class name mentioned in the Inherits matches the classname in
your code behind file.
--
Adrian M.
MCP
"JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
news:uiudWGtEFHA.3304@.tk2msftngp13.phx.gbl...
> Hi Herb,
> I am using the Enterprise Version of Reporting Services. When I go to
> http://servername/ReportServer/ and hit enter I get
> Server Error in /ReportServer App, Parser error message: Could not load
> type Login.
> Source Error:
> Line 1: <% Page etc...
> I have triple checked this login page and have found nothing wrong with
> it.
> When I go to http://servername/Reports and hit enter I get Error : unable
> to
> communicate with report server. Please verify that the report server is
> operational.
> I have gone through the document 3 times - "Using Forms Authenication with
> Reporting Services" and made sure that every
> config file is setup properly. I am having one hell of a time trying to
> get
> Reporting services to work properly. It should not be this difficult to
> implement / use and Im a programmer that uses Forms Authenication in other
> web apps.
> Please help.
> Thanks,
> JJ
>
>
> "Herb" <Herb@.discussions.microsoft.com> wrote in message
> news:B28BE8EB-1DDC-4F3A-8557-2E27556DC447@.microsoft.com...
>> What version of RS are you running, Standard or Enterprise? Forms
>> Authentication works only under the Enterprise version.
>>
>> "JJ" wrote:
>> > Ok I fixed the problem mentioned above now I have the following error:
>> >
>> > "Unable to communicate with report server. Please verify that the
>> > report
>> > server is operational."
>> >
>> > What could be causing this problem?
>> >
>> > Thanks,
>> >
>> > JJ
>> >
>> > "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
>> > news:ebO2z%23rEFHA.2540@.TK2MSFTNGP09.phx.gbl...
>> > > Hi All,
>> > >
>> > > I have been trying to get Forms Authentication to work for
>> > > reporting
>> > > services. I followed the article at MS's Library to a tee but I keep
>> > getting
>> > > a http 404 error when I attempt to pull up report manager. I would
> assume
>> > > that its referring to the login page can't be found but I checked the
> urls
>> > > in my config files and they point to the right places. How about in
> the
>> > > security extensions is there an url in there that needs to be updated
> that
>> > I
>> > > didn't discover? Any ideas to why I would get this error?
>> > >
>> > > Thanks,
>> > >
>> > > JJ
>> > >
>> > >
>> >
>> >
>> >
>|||That's the thing Adrian, it does match the code behind file. My inherits
clause matchs namespace and classname. Now here's an interesting thing. When
I first implemented forms authentication. I was asked to login by IIS and
couldn't. So now I am figuring I am locked out of IIS for the moment. How do
I unlock the annonymous user account?
Thanks,
JJ
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:ez0GoetEFHA.3648@.TK2MSFTNGP10.phx.gbl...
> Can you post the full error w/ the logon page you mention below? That
> sounds like a common asp.net error. Check the following:
> On your apx page you have the Page directive -
> <%@. Page language="c#" Codebehind="YourPage.aspx.cs"
AutoEventWireup="false"
> Inherits="YourAppNameSpace.YourPage" %>
> Make sure the class name mentioned in the Inherits matches the classname
in
> your code behind file.
> --
> Adrian M.
> MCP
> "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
> news:uiudWGtEFHA.3304@.tk2msftngp13.phx.gbl...
> > Hi Herb,
> >
> > I am using the Enterprise Version of Reporting Services. When I go to
> > http://servername/ReportServer/ and hit enter I get
> > Server Error in /ReportServer App, Parser error message: Could not load
> > type Login.
> > Source Error:
> >
> > Line 1: <% Page etc...
> >
> > I have triple checked this login page and have found nothing wrong with
> > it.
> >
> > When I go to http://servername/Reports and hit enter I get Error :
unable
> > to
> > communicate with report server. Please verify that the report server is
> > operational.
> >
> > I have gone through the document 3 times - "Using Forms Authenication
with
> > Reporting Services" and made sure that every
> > config file is setup properly. I am having one hell of a time trying to
> > get
> > Reporting services to work properly. It should not be this difficult to
> > implement / use and Im a programmer that uses Forms Authenication in
other
> > web apps.
> >
> > Please help.
> >
> > Thanks,
> >
> > JJ
> >
> >
> >
> >
> >
> > "Herb" <Herb@.discussions.microsoft.com> wrote in message
> > news:B28BE8EB-1DDC-4F3A-8557-2E27556DC447@.microsoft.com...
> >> What version of RS are you running, Standard or Enterprise? Forms
> >> Authentication works only under the Enterprise version.
> >>
> >>
> >> "JJ" wrote:
> >>
> >> > Ok I fixed the problem mentioned above now I have the following
error:
> >> >
> >> > "Unable to communicate with report server. Please verify that the
> >> > report
> >> > server is operational."
> >> >
> >> > What could be causing this problem?
> >> >
> >> > Thanks,
> >> >
> >> > JJ
> >> >
> >> > "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
> >> > news:ebO2z%23rEFHA.2540@.TK2MSFTNGP09.phx.gbl...
> >> > > Hi All,
> >> > >
> >> > > I have been trying to get Forms Authentication to work for
> >> > > reporting
> >> > > services. I followed the article at MS's Library to a tee but I
keep
> >> > getting
> >> > > a http 404 error when I attempt to pull up report manager. I would
> > assume
> >> > > that its referring to the login page can't be found but I checked
the
> > urls
> >> > > in my config files and they point to the right places. How about in
> > the
> >> > > security extensions is there an url in there that needs to be
updated
> > that
> >> > I
> >> > > didn't discover? Any ideas to why I would get this error?
> >> > >
> >> > > Thanks,
> >> > >
> >> > > JJ
> >> > >
> >> > >
> >> >
> >> >
> >> >
> >
> >
>|||Did you are locked out of IIS? I'm not sure what that means. Can you
http://localhost? Is your IUSR_<MachineName> user account disabled?
Did you copy your logon.aspx page to C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer and your custom security
extension assembly to the C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\bin folder?
--
Adrian M.
MCP
"JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
news:%23KTOeltEFHA.624@.TK2MSFTNGP15.phx.gbl...
> That's the thing Adrian, it does match the code behind file. My inherits
> clause matchs namespace and classname. Now here's an interesting thing.
> When
> I first implemented forms authentication. I was asked to login by IIS and
> couldn't. So now I am figuring I am locked out of IIS for the moment. How
> do
> I unlock the annonymous user account?
> Thanks,
> JJ
> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> news:ez0GoetEFHA.3648@.TK2MSFTNGP10.phx.gbl...
>> Can you post the full error w/ the logon page you mention below? That
>> sounds like a common asp.net error. Check the following:
>> On your apx page you have the Page directive -
>> <%@. Page language="c#" Codebehind="YourPage.aspx.cs"
> AutoEventWireup="false"
>> Inherits="YourAppNameSpace.YourPage" %>
>> Make sure the class name mentioned in the Inherits matches the classname
> in
>> your code behind file.
>> --
>> Adrian M.
>> MCP
>> "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
>> news:uiudWGtEFHA.3304@.tk2msftngp13.phx.gbl...
>> > Hi Herb,
>> >
>> > I am using the Enterprise Version of Reporting Services. When I go to
>> > http://servername/ReportServer/ and hit enter I get
>> > Server Error in /ReportServer App, Parser error message: Could not
>> > load
>> > type Login.
>> > Source Error:
>> >
>> > Line 1: <% Page etc...
>> >
>> > I have triple checked this login page and have found nothing wrong with
>> > it.
>> >
>> > When I go to http://servername/Reports and hit enter I get Error :
> unable
>> > to
>> > communicate with report server. Please verify that the report server
>> > is
>> > operational.
>> >
>> > I have gone through the document 3 times - "Using Forms Authenication
> with
>> > Reporting Services" and made sure that every
>> > config file is setup properly. I am having one hell of a time trying to
>> > get
>> > Reporting services to work properly. It should not be this difficult to
>> > implement / use and Im a programmer that uses Forms Authenication in
> other
>> > web apps.
>> >
>> > Please help.
>> >
>> > Thanks,
>> >
>> > JJ
>> >
>> >
>> >
>> >
>> >
>> > "Herb" <Herb@.discussions.microsoft.com> wrote in message
>> > news:B28BE8EB-1DDC-4F3A-8557-2E27556DC447@.microsoft.com...
>> >> What version of RS are you running, Standard or Enterprise? Forms
>> >> Authentication works only under the Enterprise version.
>> >>
>> >>
>> >> "JJ" wrote:
>> >>
>> >> > Ok I fixed the problem mentioned above now I have the following
> error:
>> >> >
>> >> > "Unable to communicate with report server. Please verify that the
>> >> > report
>> >> > server is operational."
>> >> >
>> >> > What could be causing this problem?
>> >> >
>> >> > Thanks,
>> >> >
>> >> > JJ
>> >> >
>> >> > "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
>> >> > news:ebO2z%23rEFHA.2540@.TK2MSFTNGP09.phx.gbl...
>> >> > > Hi All,
>> >> > >
>> >> > > I have been trying to get Forms Authentication to work for
>> >> > > reporting
>> >> > > services. I followed the article at MS's Library to a tee but I
> keep
>> >> > getting
>> >> > > a http 404 error when I attempt to pull up report manager. I would
>> > assume
>> >> > > that its referring to the login page can't be found but I checked
> the
>> > urls
>> >> > > in my config files and they point to the right places. How about
>> >> > > in
>> > the
>> >> > > security extensions is there an url in there that needs to be
> updated
>> > that
>> >> > I
>> >> > > didn't discover? Any ideas to why I would get this error?
>> >> > >
>> >> > > Thanks,
>> >> > >
>> >> > > JJ
>> >> > >
>> >> > >
>> >> >
>> >> >
>> >> >
>> >
>> >
>>
>|||Try this and it will fix it..hopefully
======<%@. Page language="c#" Codebehind="YourPage.aspx.cs"
AutoEventWireup="false"
Inherits="YourAppNameSpace.YourPage, YourNamespace" %>
Cheers
shubie
"JJ" wrote:
> That's the thing Adrian, it does match the code behind file. My inherits
> clause matchs namespace and classname. Now here's an interesting thing. When
> I first implemented forms authentication. I was asked to login by IIS and
> couldn't. So now I am figuring I am locked out of IIS for the moment. How do
> I unlock the annonymous user account?
> Thanks,
> JJ
> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> news:ez0GoetEFHA.3648@.TK2MSFTNGP10.phx.gbl...
> > Can you post the full error w/ the logon page you mention below? That
> > sounds like a common asp.net error. Check the following:
> >
> > On your apx page you have the Page directive -
> > <%@. Page language="c#" Codebehind="YourPage.aspx.cs"
> AutoEventWireup="false"
> > Inherits="YourAppNameSpace.YourPage" %>
> >
> > Make sure the class name mentioned in the Inherits matches the classname
> in
> > your code behind file.
> > --
> > Adrian M.
> > MCP
> >
> > "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
> > news:uiudWGtEFHA.3304@.tk2msftngp13.phx.gbl...
> > > Hi Herb,
> > >
> > > I am using the Enterprise Version of Reporting Services. When I go to
> > > http://servername/ReportServer/ and hit enter I get
> > > Server Error in /ReportServer App, Parser error message: Could not load
> > > type Login.
> > > Source Error:
> > >
> > > Line 1: <% Page etc...
> > >
> > > I have triple checked this login page and have found nothing wrong with
> > > it.
> > >
> > > When I go to http://servername/Reports and hit enter I get Error :
> unable
> > > to
> > > communicate with report server. Please verify that the report server is
> > > operational.
> > >
> > > I have gone through the document 3 times - "Using Forms Authenication
> with
> > > Reporting Services" and made sure that every
> > > config file is setup properly. I am having one hell of a time trying to
> > > get
> > > Reporting services to work properly. It should not be this difficult to
> > > implement / use and Im a programmer that uses Forms Authenication in
> other
> > > web apps.
> > >
> > > Please help.
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > >
> > >
> > >
> > >
> > > "Herb" <Herb@.discussions.microsoft.com> wrote in message
> > > news:B28BE8EB-1DDC-4F3A-8557-2E27556DC447@.microsoft.com...
> > >> What version of RS are you running, Standard or Enterprise? Forms
> > >> Authentication works only under the Enterprise version.
> > >>
> > >>
> > >> "JJ" wrote:
> > >>
> > >> > Ok I fixed the problem mentioned above now I have the following
> error:
> > >> >
> > >> > "Unable to communicate with report server. Please verify that the
> > >> > report
> > >> > server is operational."
> > >> >
> > >> > What could be causing this problem?
> > >> >
> > >> > Thanks,
> > >> >
> > >> > JJ
> > >> >
> > >> > "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
> > >> > news:ebO2z%23rEFHA.2540@.TK2MSFTNGP09.phx.gbl...
> > >> > > Hi All,
> > >> > >
> > >> > > I have been trying to get Forms Authentication to work for
> > >> > > reporting
> > >> > > services. I followed the article at MS's Library to a tee but I
> keep
> > >> > getting
> > >> > > a http 404 error when I attempt to pull up report manager. I would
> > > assume
> > >> > > that its referring to the login page can't be found but I checked
> the
> > > urls
> > >> > > in my config files and they point to the right places. How about in
> > > the
> > >> > > security extensions is there an url in there that needs to be
> updated
> > > that
> > >> > I
> > >> > > didn't discover? Any ideas to why I would get this error?
> > >> > >
> > >> > > Thanks,
> > >> > >
> > >> > > JJ
> > >> > >
> > >> > >
> > >> >
> > >> >
> > >> >
> > >
> > >
> >
> >
>
>

Forms Authentication in Reporting Services

Hi! I need Forms Authentication in Reporting Services. I read this article: http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3

I download and install Forms Authentication Sample installer on my computer. When I have tried to add reference in my priject - dll : Microsoft.ReportingServices.Interfaces.dll , VS2003 write me following mistake

" A reference to С:\....\Microsoft.ReportingServices.Interfaces.dll" could not be added. This is not valid assembly or COM component. .."

On my PC install: SQL 2005 , VS2003

Help me!! :)

If you want to develop SQL 2005 reports, you have to install VS2005, if you want to develop SQL2000 reports, you have install the Reporting components of SQL2000 (Report Server not mandatory).

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks! I install VS2005. add reference and configuring RS as it is written in MSDN.

Write next url: http://reportserver/reports and get next page "You are not authrized this page view". Though IIS configured on anonymous authorization. ?

Forms Authentication in Reporting Services

Hi! I need Forms Authentication in Reporting Services. I read this article: http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3

I download and install Forms Authentication Sample installer on my computer. When I have tried to add reference in my priject - dll : Microsoft.ReportingServices.Interfaces.dll , VS2003 write me following mistake

" A reference to С:\....\Microsoft.ReportingServices.Interfaces.dll" could not be added. This is not valid assembly or COM component. .."

On my PC install: SQL 2005 , VS2003

Help me!! :)

If you want to develop SQL 2005 reports, you have to install VS2005, if you want to develop SQL2000 reports, you have install the Reporting components of SQL2000 (Report Server not mandatory).

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks! I install VS2005. add reference and configuring RS as it is written in MSDN.

Write next url: http://reportserver/reports and get next page "You are not authrized this page view". Though IIS configured on anonymous authorization. ?

sql

Forms Authentication for reporting

Hello
I have a web application that uses forms authentication.
Ideally I would like to be able to make some reports from my Reporting Services server available BUT I would also like to be able to pass authentication data through as I would like the reports available to be dictated by who the user is and the roles that they have within the application.
So for example if I have user A and user B then there are some reports that only user A will want to be able to see and some that only user B will want to see

There are also some reports that will vary the data according to who the user is e.g. user A will want to see their data only and User B will want to see their data only but on the same report
Is this possible? If anyone has any suggestions on where I can look to find out how to do this I would be grateful
thanks
steveI'd suggest doing the authentication before ever getting over to the reporting services server. Let the application control which reports each person can see based on their authorization in the application. Hopefully you will already have this information available, and if not it should not be hard to add.
And... even though it is more work now I'd also consider streaming the reporting services data back from the reporting services server to your application. Your server builds all of the correct parms including user specific required information, passes the request to the reporting services server, it processes the report data and comes back with a report, the report is streamed back to your application which displays it in a web browser or makes it available for download.|||

Thanks Patrick

The authorization information is available as you suggest.
I'm not sure I'm absolutely clear on what you mean bystreaming the reporting services data back. Do you mean some sort of HTTP handler or web service call? Ideally I would like something fairly simple that maintained much of the functionality of Reporting Services - particularly the ability to subscribe and to have different output formats

steve

|||What I am talking about is sending the data to the reporting server torun the report and getting the data back, but not actually using thereporting server to display the report. You'd lose some of thefunctionality of RS, but gain as much flexibility as you can code in.
I know reporting services can restrict report view by userids anddomains,but that is all configured on the reporting services side atthe report and the report folder level. The way that comes to mindfirst doing what you are talking about (passing credentials at reportrun time) is to have the report at a high level look at what is beingpassed and conditionally hide the page.
One thing I don't understand - how will somebody ever haveauthorization to see a report is even available if they are notauthorized to view it? Shouldn't you not even make the option availableto them? Display a report list for the current user, but that list is asubset of ALL of the reports available. They only see what they cantruly get to. I don't have your original post in front of me so I don'tknow if you have some restriction that prevents that. But that routeseems to be the best long term solution for anyone that is planning onusing reporting services and wants authentication.
FYI... in VS2005 there is a control you can put in your applicationthat looks/feels just like the reporting services website. So it willbe easier to stream reports back while keeping alot of thefunctionality.
|||Thanks patrick

steve|||My pleasure. I can't believe I was actually able to help somebody.
Report back with what you finally do and how it worked. I am interestedin seeing your solution and the code that goes along with it.
|||OK, no problems but don't hold your breath it may take a while
steve

Forms Authentication Example not safe for multi-threaded applications

I thought this might be useful for other Reporting Services users.
This relates both the Forms Authentication Example from Microsoft, and
the problem it was giving me loading the Authorization Extension:
http://groups.google.com/groups?selm=f284ebe.0409271146.279ecf4c%40posting.google.com&output=gplain
After contacting Microsoft, and getting their help with this problem,
it was determined that the solution was to use SyncLock on the
InitializeMaps method of the AuthorizationExtension class in the
example. That is, in VB:
Private Shared Sub InitializeMaps()
SyncLock GetType(AuthorizationExtension)
<Code as it appears in example>
End SyncLock
End Sub
This resolved our problem. I hope others find this useful.
- TerryWhat is the equivalent code for C#. I found the InitializeMaps() method in
the Authorization.cs file, but it is not clear how you would apply the
synclock option. Also I found no reference to syncLock in the C# help file.
"Terry Romance" wrote:
> I thought this might be useful for other Reporting Services users.
> This relates both the Forms Authentication Example from Microsoft, and
> the problem it was giving me loading the Authorization Extension:
> http://groups.google.com/groups?selm=f284ebe.0409271146.279ecf4c%40posting.google.com&output=gplain
> After contacting Microsoft, and getting their help with this problem,
> it was determined that the solution was to use SyncLock on the
> InitializeMaps method of the AuthorizationExtension class in the
> example. That is, in VB:
> Private Shared Sub InitializeMaps()
> SyncLock GetType(AuthorizationExtension)
> <Code as it appears in example>
> End SyncLock
> End Sub
> This resolved our problem. I hope others find this useful.
> - Terry
>|||JB,
I know it's been a while and you've probably puzzled this out yourself by
now, but the equivalent C# structure is
lock (typeof(AuthorizationExtension)) {
<...method body here...>
}
FWIW,
-Marc
"jbmeeh" wrote:
> What is the equivalent code for C#. I found the InitializeMaps() method in
> the Authorization.cs file, but it is not clear how you would apply the
> synclock option. Also I found no reference to syncLock in the C# help file.sql

Forms Authentication and Unattended Report Execution

I have implemented forms authentication security extension as described in the MSDN whitepaper "Using Forms Authentication in Reporting Services" and it works fine. However, I ran into problems trying to create scheduled execution snapshot for a report when it fails with unable to authenticate. How do I configure RS to authenticate for unattended execution with forms authentication?

Thanks,Please disregard this one. Stopping and restarting the ReportServerService resolved the issue.