Reporting Services

Authentication via internet explorer fails when connecting to reporting
services from a hostname other then the NETBIOS name.
for example my servers name is BOB
so if i do http://bob/ReportServer it works fine
I have an A record that points reportingservices.mydomain.com to BOB's ip
address
so if i go to http://reportingservices.mydomain.com/ReportServer I get the
user credentials box. How can I fix this?On Mar 2, 9:06 pm, Nick T <N...@.discussions.microsoft.com> wrote:
> Authentication via internet explorer fails when connecting to reporting
> services from a hostname other then the NETBIOS name.
> for example my servers name is BOB
> so if i dohttp://bob/ReportServerit works fine
> I have an A record that points reportingservices.mydomain.com to BOB's ip
> address
> so if i go tohttp://reportingservices.mydomain.com/ReportServerI get the
> user credentials box. How can I fix this?
It seems like you should check the authentication methods of the
virtual directory pointed to in IIS for http://reportingservices.mydomain.com/ReportServer.
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||The virtual directory is just part of the default web site
"EMartinez" wrote:
> On Mar 2, 9:06 pm, Nick T <N...@.discussions.microsoft.com> wrote:
> > Authentication via internet explorer fails when connecting to reporting
> > services from a hostname other then the NETBIOS name.
> >
> > for example my servers name is BOB
> >
> > so if i dohttp://bob/ReportServerit works fine
> >
> > I have an A record that points reportingservices.mydomain.com to BOB's ip
> > address
> >
> > so if i go tohttp://reportingservices.mydomain.com/ReportServerI get the
> > user credentials box. How can I fix this?
> It seems like you should check the authentication methods of the
> virtual directory pointed to in IIS for http://reportingservices.mydomain.com/ReportServer.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||Hello,
I think this situation depends on security settings in IE.
Try to add http://reportingservices.mydomain.com/ website to your trusted
websites.
If still you 'll be prompted for login and password check security settings
in IE (for trusted sites).
Ensure that you have checked the last option for logging user (logging with
current user name and password).
I hope this will help.
Best regards,
Rados³aw £ebkowski
U¿ytkownik "Nick T" <NickT@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:2821371F-75FC-4BC7-A0E0-B7B01A512874@.microsoft.com...
> Authentication via internet explorer fails when connecting to reporting
> services from a hostname other then the NETBIOS name.
> for example my servers name is BOB
> so if i do http://bob/ReportServer it works fine
> I have an A record that points reportingservices.mydomain.com to BOB's ip
> address
> so if i go to http://reportingservices.mydomain.com/ReportServer I get the
> user credentials box. How can I fix this?

Reporting Service: Render order of operations.

Just curious, but I am looking for some sort of definitive outline on
the steps reporting services goes through to render a report.
Example:
Header/Footer first.
Second starting from the top of the body of the report render the
first object.
If that object's a grid process the grid's header/footer first, then
go to each successive group until the details.
If a new page is pulled up, this happens here.
And so on..
It would help immensely creating reports, and also I have something I
can show to management who have a beef with a report and cannot grasp
why reporting service processes certain things in "illogical order".
Regards,
- jOn Nov 5, 3:38 pm, modi321 <modi...@.gmail.com> wrote:
> Just curious, but I am looking for some sort of definitive outline on
> the steps reporting services goes through to render a report.
> Example:
> Header/Footer first.
> Second starting from the top of the body of the report render the
> first object.
> If that object's a grid process the grid's header/footer first, then
> go to each successive group until the details.
> If a new page is pulled up, this happens here.
> And so on..
> It would help immensely creating reports, and also I have something I
> can show to management who have a beef with a report and cannot grasp
> why reporting service processes certain things in "illogical order".
> Regards,
> - j
Was this unclear or is there no visual work flow of how MS reporting
services renders a report?|||>From my experience, processing renders as
1. Table Header
2. Table Footer
(3. Group 1 Header)
(4. Group 1 Footer)
(5. Group 2 Header)
(6. Group 2 Footer)
...
x. Details
Order of execution appears to be top left-to-right, to bottom. Custom
Functions populated conditionally in the Details rows that store
values into (Static) global variables will render as 0 in the headers
and footers, because the data items are populated last.
Microsoft is extremely non-committal when it comes to order of
rendering.
-- Scott

Reporting Service

I am trying to write a win app that will display the list of reports on a server that a given user id has access to. For example, if there are 150 reports on a server, how to tell which reports loginA has access to. I can get the list of reports, but I am not sure how to get the security information for each report. Anyone have any ideas?

R

Hi Ron,

Take a look at the ListChildren SOAP method. I believe it does exactly what you are looking for.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_2yt2.asp

|||

I am using that, and I am getting the report listing. The trouble is I want to know what login has access to which reports. ListChildren doesn't do this and I am REALLY trying not to directly access the RS database. I am assuming that the Profile related tables have the info I want.

R

Reporting Financial Ratings

I'm running into 'CLS-compliance' problems trying to use characters such as "+" and "-" as reporting fields. For example, Standard and Poors ratings have these characters to indicate a notch between main letter rating categories. I have reports that need to display distributions of these various ratings in column charts. However, the X axis labels refuse to print because of these characters!

Any suggestions? This is an awfully common type of labelling in this business!

Thanks

Try Char(43) instead of "+" and Char(45) instead of "-".