3G ram for SQL server: returned

Showing posts with label returned. Show all posts

Thursday, March 22, 2012

A Chart for Each Client

I'm trying to create a chart for each client.
In a DataSet, they are returned in a sorted order like this:
ClientName Month Sales
-- -- --
Client 1 1 500
Client 1 2 100
...
Client 1 10 900
Client 2 1 100
Client 2 2 200
...
Client 2 10 800
I'd like to have two charts, Client 1 and Client 2 showing their own
trend.
However, so far I get only ONE chart, either a sum, or the first client
group if it's not sum.
I don't think it will take one query per client.
Thanks.I think I got it by browsing some QA here, simply by putting it in a
group's header or footer in a table.|||Yes, that is correct. If you place a chart in a table detail section, every
chart will just get one detail data row (i.e. essentially just one
datapoint) and this is not what you want. Placing the chart however in the
group's header or footer will generate a chart from all the detail rows that
are contained in the current group.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<hifchan@.yahoo.com> wrote in message
news:1108483860.264648.286130@.c13g2000cwb.googlegroups.com...
>I think I got it by browsing some QA here, simply by putting it in a
> group's header or footer in a table.
>sql

Monday, February 13, 2012

403 error: The remote server returned an error: (403) Forbidden.

When I try to view the report, I got the error "The remote server returned an error: (403) Forbidden. ". And in the event log , I got the detaiil excception:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2007-7-16
Time: 11:28:29
User: N/A
Computer: WEIGUANG
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2007-7-16 11:28:29
Event time (UTC): 2007-7-16 3:28:29
Event ID: 3c4daa414c89430786c106f3c9085b56
Event sequence: 10
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-2-128290300818412520
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: WEIGUANG
Process information:
Process ID: 4152
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.
Request information:
Request URL: http://localhost/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address: 127.0.0.1
User: ASIAPACIFIC\liweig
Is authenticated: True
Authentication Type: NTLM
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I'm using reporting service 2005, does anybody know the reason?

Many thanks.

Kevin

we encounter the same problem. did you already resolved it? can you give us a hint?

thx in advance,
rainer
|||

IIS permissions.

403?

You're not even touching the Report Server.

You need to get your IIS admin to allow your group/users permission to see the RS folders

|||well i am getting the following entry in the eventlog:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 24.07.2007
Time: 12:37:38
User: N/A
Computer: HERAS75
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 24.07.2007 12:37:38
Event time (UTC): 24.07.2007 10:37:38
Event ID: f6730dc158f640c7924c590d73226477
Event sequence: 112
Event occurrence: 5
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/root/AdminReports-1-128297459440092913
Trust level: RosettaMgr
Application Virtual Path: /AdminReports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: HERAS75

Process information:
Process ID: 5052
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.

Request information:
Request URL: http://heras75/AdminReports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /AdminReports/Reserved.ReportViewerWebControl.axd
User host address: 10.101.7.26
User: HER\admin_arnken
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 7
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

if am opening a report page it starts rendering the page but then throws the following error and no data is shown:

The remote server returned an error: (403) Forbidden.|||Admin tools -> IIS
directory security
edit
select 'integrated windows authentication'
ok

right click 'permissions'
from here you can see which groups/users have access

it is better to administer with groups as that way, when someone bothers you to see a report, you can tell them to go and see the helpdesk/whoever manages AD groups instead, and get them to add them to the group

403 error: The remote server returned an error: (403) Forbidden.

When I try to view the report, I got the error "The remote server returned an error: (403) Forbidden. ". And in the event log , I got the detaiil excception:

Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I'm using reporting service 2005, does anybody know the reason?

Many thanks.

Kevin

we encounter the same problem. did you already resolved it? can you give us a hint?

thx in advance,
rainer
|||

IIS permissions.

403?

You're not even touching the Report Server.

You need to get your IIS admin to allow your group/users permission to see the RS folders

|||well i am getting the following entry in the eventlog:

if am opening a report page it starts rendering the page but then throws the following error and no data is shown:

The remote server returned an error: (403) Forbidden.|||Admin tools -> IIS
directory security
edit
select 'integrated windows authentication'
ok

right click 'permissions'
from here you can see which groups/users have access

Thursday, March 22, 2012

A Chart for Each Client

Monday, February 13, 2012

403 error: The remote server returned an error: (403) Forbidden.

403 error: The remote server returned an error: (403) Forbidden.

3G ram for SQL server

Blog Archive

About Me