Monday, March 26, 2012
Forms Authentication
After two days of work I can't resolve my problem. I implemented the
Custom Security Sample. The http://myMachineName/Reportserver work
properly when I connected it.
I started getting the following error when I try to connect to Report
Manager:
Access denied
The Report Service is installed in my machine and the Report Server
Database in another server.
Can anybody help me please?
Thanks.Gave,
Did you disable impersonation for the Report Manager Virtual Directory?
Are you logging into Report Manager with the same username defined in
the node
<AdminConfiguration>
<UserName>username</UserName>
</AdminConfiguration>
in the RSReportServer.config file?
Andy Potter
Andy Potter|||Andy,
Thanks for the reply
Yes, in Report Manager Virtual Directory the anonymous access is
checked and I used the same user that are in RSReportServer.config
file.
What other issue can be?
Thanks.
Potter ha escrito:
> Gave,
> Did you disable impersonation for the Report Manager Virtual Directory?
> Are you logging into Report Manager with the same username defined in
> the node
> <AdminConfiguration>
> <UserName>username</UserName>
> </AdminConfiguration>
> in the RSReportServer.config file?
> Andy Potter
>
>
> Andy Potter|||Gave,
Put some breakpoints in your extension and step through the CheckAccess
overloads in the Authorization.cs class. Specifically, look at the
comparison that checks to see if the user logging in matches the
administrator username.
// If the user is the administrator, allow unrestricted access.
if (0 == String.Compare(userName, m_adminUserName, true,
CultureInfo.CurrentCulture))
return true;
Andy Potter|||Andy,
Thanks again. I resolved my problem; I forgot to change <identity
impersonate="true"/> to <identity impersonate="false"/>.
Sorry and Thanks a lot for your time.
Gave.
Potter ha escrito:
> Gave,
> Put some breakpoints in your extension and step through the CheckAccess
> overloads in the Authorization.cs class. Specifically, look at the
> comparison that checks to see if the user logging in matches the
> administrator username.
> // If the user is the administrator, allow unrestricted access.
> if (0 == String.Compare(userName, m_adminUserName, true,
> CultureInfo.CurrentCulture))
> return true;
> Andy Pottersql
Friday, March 23, 2012
Formatting Parameter and Field Dates
I'm new to Reporting Services so bear w/ me,
I'm having troubles with formatting the parameter and field dates. To resolve the Field dates I just formmated them in the query, but I still haven't found a way for the Parameter fields. The date parameters is passed as YYYYMMDD(oracle number data type), and I want to format and display it as MM/DD/YYYY.
Any help would be appreciated,
also would like how to know how this works for the field values as well,
Thanks,
Nick
If you want to change the format of the parameter (assuming that your referring to a date parameter) you can use this one:
=Format(Now(), "MM/dd/yyyy")
Click on the "Tools" then "Report Parameters". Under the Default Values, click on the Non-Queried option then place on the text field the formula above.
Hope this helps..
|||Thanks for the reply. I'm not sure if I did it the best way, but I ended up using
="From Date: " + Parameters!FromDate.Value.substring(4,2) + "/" + Parameters!FromDate.Value.substring(6,2) + "/" + Parameters!FromDate.Value.substring(0, 4).