Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

report in asp.net

 
   Database Help (Home) -> Programming RSS
Next:  Performance CLR function  
Author Message
Aleks Kleyn

External


Since: Jun 12, 2008
Posts: 4



(Msg. 1) Posted: Thu Jun 12, 2008 3:45 pm
Post subject: report in asp.net
Archived from groups: microsoft>public>ru>sqlserver, others (more info?)

I install on my Vista 64 bit PC Sql Server 64 bit latest release. Using
busines inteligent studio i prepared report. this report works fine in
studio environment. Next step I deployed this report to report server. I
used target server url= http://localhost/reportserver.
1. However when I run IIS I do not see such folder there. when I go to this
url I get error

Description: An error occurred while accessing the resources required to
serve this request. You might not have permission to view the requested
resources.

Error message 401.3: You do not have permission to view this directory or
page using the credentials you supplied (access denied due to Access Control
Lists). Ask the Web server's administrator to give you access to 'C:\Program
Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting
Services\ReportManager\home.aspx
------
How this works,

2. When I go to asp.net there I see control rsweb:ReportViewer.
2a. this control demanded from me to add code
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type =
"Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms,
Version=9.0.0.0, Culture=neutral, PublicKeyToken=....." />
into web.config into httpHandlers.
but i am not sure if this is enough

2b. when I add code <ServerReport ReportPath="..."/> it responds me that
RSClientController' is undefined

2c. then I changed to <LocalReport ReportPath=".."></LocalReport>
Then I got responce
The definition of the report 'Main Report' is invalid.
The report definition is not valid. Details: The report definition has an
invalid target namespace
'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'
which cannot be upgraded.

The question is how I can see this report.

--

Aleks Kleyn
http://www.geocities.com/aleks_kleyn

 >> Stay informed about: report in asp.net 
Back to top
Login to vote
Norman Yuan

External


Since: Jan 11, 2008
Posts: 63



(Msg. 2) Posted: Thu Jun 12, 2008 3:45 pm
Post subject: Re: report in asp.net [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You need a bit more study on what is SQL Server reporting services. When you
install SQL Server2005, you have chance to choose install Reporting Services
or not. If you do, you must have IIS installed before hand.

If you did installed Reporting Services, you could open IIS Manager to
verify it: underneath "Default Web Site", you should see two virtual
directories(applications): Reports and ReportServer (they may suffixed with
"$ServerName", if your SQL Server is a named instance);

If the Reporting Services did get installed, then you should be able to
browse to its Report Manager by this address:
http://localhost[servername]/reports. Of course you need to configure the
reproting services and/or IIS to give access permission: Reporting Services
are just a regular ASP.NET application.

Once you have the proper access to Report services, you can then deploy your
report designed in VS.


"Aleks Kleyn" wrote in message

>I install on my Vista 64 bit PC Sql Server 64 bit latest release. Using
> busines inteligent studio i prepared report. this report works fine in
> studio environment. Next step I deployed this report to report server. I
> used target server url= http://localhost/reportserver.
> 1. However when I run IIS I do not see such folder there. when I go to
> this url I get error
>
> Description: An error occurred while accessing the resources required to
> serve this request. You might not have permission to view the requested
> resources.
>
> Error message 401.3: You do not have permission to view this directory or
> page using the credentials you supplied (access denied due to Access
> Control Lists). Ask the Web server's administrator to give you access to
> 'C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting
> Services\ReportManager\home.aspx
> ------
> How this works,
>
> 2. When I go to asp.net there I see control rsweb:ReportViewer.
> 2a. this control demanded from me to add code
> <add verb="*" path="Reserved.ReportViewerWebControl.axd" type =
> "Microsoft.Reporting.WebForms.HttpHandler,
> Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral,
> PublicKeyToken=....." />
> into web.config into httpHandlers.
> but i am not sure if this is enough
>
> 2b. when I add code <ServerReport ReportPath="..."/> it responds me that
> RSClientController' is undefined
>
> 2c. then I changed to <LocalReport ReportPath=".."></LocalReport>
> Then I got responce
> The definition of the report 'Main Report' is invalid.
> The report definition is not valid. Details: The report definition has an
> invalid target namespace
> 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'
> which cannot be upgraded.
>
> The question is how I can see this report.
>
> --
>
> Aleks Kleyn
> http://www.geocities.com/aleks_kleyn
>

 >> Stay informed about: report in asp.net 
Back to top
Login to vote
Aleks Kleyn

External


Since: Jun 12, 2008
Posts: 4



(Msg. 3) Posted: Thu Jun 12, 2008 7:04 pm
Post subject: Re: report in asp.net [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I do not think you read careful my email before claim that I did not learn
something. However back to subject.

This is not sql 2005, but sql 2008, and may be MS has still there some bugs.
Here possible two options.

MS makes visible report server only to specific user (then for which user)
or they forgot to add this folder to IIS at all.
Then again. If I create this folder I need properly show them to real folder
(assume I know where) and to give proper permitions (this is more harder).
And again. if this folder does not exist at all how it possible that I
deployed succesfully.

--

Aleks Kleyn
http://www.geocities.com/aleks_kleyn

"Norman Yuan" wrote in message

> You need a bit more study on what is SQL Server reporting services. When
> you install SQL Server2005, you have chance to choose install Reporting
> Services or not. If you do, you must have IIS installed before hand.
>
> If you did installed Reporting Services, you could open IIS Manager to
> verify it: underneath "Default Web Site", you should see two virtual
> directories(applications): Reports and ReportServer (they may suffixed
> with "$ServerName", if your SQL Server is a named instance);
>
> If the Reporting Services did get installed, then you should be able to
> browse to its Report Manager by this address:
> http://localhost[servername]/reports. Of course you need to configure the
> reproting services and/or IIS to give access permission: Reporting
> Services are just a regular ASP.NET application.
>
> Once you have the proper access to Report services, you can then deploy
> your report designed in VS.
>
>
> "Aleks Kleyn" wrote in message
>
>>I install on my Vista 64 bit PC Sql Server 64 bit latest release. Using
>> busines inteligent studio i prepared report. this report works fine in
>> studio environment. Next step I deployed this report to report server. I
>> used target server url= http://localhost/reportserver.
>> 1. However when I run IIS I do not see such folder there. when I go to
>> this url I get error
>>
>> Description: An error occurred while accessing the resources required to
>> serve this request. You might not have permission to view the requested
>> resources.
>>
>> Error message 401.3: You do not have permission to view this directory or
>> page using the credentials you supplied (access denied due to Access
>> Control Lists). Ask the Web server's administrator to give you access to
>> 'C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting
>> Services\ReportManager\home.aspx
>> ------
>> How this works,
>>
>> 2. When I go to asp.net there I see control rsweb:ReportViewer.
>> 2a. this control demanded from me to add code
>> <add verb="*" path="Reserved.ReportViewerWebControl.axd" type =
>> "Microsoft.Reporting.WebForms.HttpHandler,
>> Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral,
>> PublicKeyToken=....." />
>> into web.config into httpHandlers.
>> but i am not sure if this is enough
>>
>> 2b. when I add code <ServerReport ReportPath="..."/> it responds me that
>> RSClientController' is undefined
>>
>> 2c. then I changed to <LocalReport ReportPath=".."></LocalReport>
>> Then I got responce
>> The definition of the report 'Main Report' is invalid.
>> The report definition is not valid. Details: The report definition has an
>> invalid target namespace
>> 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'
>> which cannot be upgraded.
>>
>> The question is how I can see this report.
>>
>> --
>>
>> Aleks Kleyn
>> http://www.geocities.com/aleks_kleyn
>>
>
 >> Stay informed about: report in asp.net 
Back to top
Login to vote
Aleks Kleyn

External


Since: Jun 12, 2008
Posts: 4



(Msg. 4) Posted: Fri Jun 13, 2008 8:26 pm
Post subject: Re: report in asp.net [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I still not have answer to this questions. Searching on other forums I found
next responce

t sounds like you are using the VS 2008 report viewer control (which is
still based on the 2005 RDL namespace) in local mode and you try to run a RS
2008 RDL with it.

This is not supported. The VS 2008 report viewer control can only run
2000/2005 RDLs, but not 2007/2008 RDLs.



There are plans to release an updated report viewer control after RS 2008
RTM is released. The updated report viewer control includes the new
processing and rendering engine that ships in RS 2008 and will work with all
versions of RDL (2000, 2005, 2007/2008). However, the exact timing for an
updated report viewer release is not determined at this point.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3234546&SiteID=1

--

Aleks Kleyn
http://www.geocities.com/aleks_kleyn

"Norman Yuan" wrote in message

> You need a bit more study on what is SQL Server reporting services. When
> you install SQL Server2005, you have chance to choose install Reporting
> Services or not. If you do, you must have IIS installed before hand.
>
> If you did installed Reporting Services, you could open IIS Manager to
> verify it: underneath "Default Web Site", you should see two virtual
> directories(applications): Reports and ReportServer (they may suffixed
> with "$ServerName", if your SQL Server is a named instance);
>
> If the Reporting Services did get installed, then you should be able to
> browse to its Report Manager by this address:
> http://localhost[servername]/reports. Of course you need to configure the
> reproting services and/or IIS to give access permission: Reporting
> Services are just a regular ASP.NET application.
>
> Once you have the proper access to Report services, you can then deploy
> your report designed in VS.
>
>
> "Aleks Kleyn" wrote in message
>
>>I install on my Vista 64 bit PC Sql Server 64 bit latest release. Using
>> busines inteligent studio i prepared report. this report works fine in
>> studio environment. Next step I deployed this report to report server. I
>> used target server url= http://localhost/reportserver.
>> 1. However when I run IIS I do not see such folder there. when I go to
>> this url I get error
>>
>> Description: An error occurred while accessing the resources required to
>> serve this request. You might not have permission to view the requested
>> resources.
>>
>> Error message 401.3: You do not have permission to view this directory or
>> page using the credentials you supplied (access denied due to Access
>> Control Lists). Ask the Web server's administrator to give you access to
>> 'C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting
>> Services\ReportManager\home.aspx
>> ------
>> How this works,
>>
>> 2. When I go to asp.net there I see control rsweb:ReportViewer.
>> 2a. this control demanded from me to add code
>> <add verb="*" path="Reserved.ReportViewerWebControl.axd" type =
>> "Microsoft.Reporting.WebForms.HttpHandler,
>> Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral,
>> PublicKeyToken=....." />
>> into web.config into httpHandlers.
>> but i am not sure if this is enough
>>
>> 2b. when I add code <ServerReport ReportPath="..."/> it responds me that
>> RSClientController' is undefined
>>
>> 2c. then I changed to <LocalReport ReportPath=".."></LocalReport>
>> Then I got responce
>> The definition of the report 'Main Report' is invalid.
>> The report definition is not valid. Details: The report definition has an
>> invalid target namespace
>> 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'
>> which cannot be upgraded.
>>
>> The question is how I can see this report.
>>
>> --
>>
>> Aleks Kleyn
>> http://www.geocities.com/aleks_kleyn
>>
>
 >> Stay informed about: report in asp.net 
Back to top
Login to vote
Aleks Kleyn

External


Since: Jun 12, 2008
Posts: 4



(Msg. 5) Posted: Fri Jun 13, 2008 11:39 pm
Post subject: Re: report in asp.net [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

research shows that to define namespace for report we need code

<Report
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">

The year 2008 can be changed to 2005 and this will be namespace for report
2005. Site

http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition

exist, but site

http://schemas.microsoft.com/sqlserver/reporting/208/01/reportdefinition

yet not ready and first link is not good for report 2008.

I can understand this. however this is not clear why browsing of report
should depend on Microsoft web site. tomorow will be power down in Redmond
for a week. As result people will not be able to see reports. For a lot of
applications report is core. the question is not when Microsoft will be
ready to provide report, but how is reliable his product.
 >> Stay informed about: report in asp.net 
Back to top
Login to vote
Jayaram Krishnaswamy

External


Since: Jan 19, 2007
Posts: 2



(Msg. 6) Posted: Sun Aug 24, 2008 2:10 pm
Post subject: RE: report in asp.net [Login to view extended thread Info.]
Archived from groups: microsoft>public>sqlserver>clients, others (more info?)

Reports with extension rdlc can be published to the Local web server(IIS). By
default this port is 80. If a Report Server(2008) is configured on the same
machine (unless it is Windows 2003, I am not sure how it is with Vista) it
has to use a different port. From the messages you show it appears that you
did deploy it to the Report Server and in this case your IIS will not show
it.

To see if your report is deployed or not is to access your Report Server
perferably from the Configuration Manager Tool which in the case of SQL
Server 2008 will have configured it ready to go if you have chosen the native
mode. I have had no problem in deploying my
RDLC files to IIS Web Server
RDL files to the Report Server

I have discussed some of these on my blog,
http://hodentek.blogspot.com


mysorian


"Aleks Kleyn" wrote:

> I install on my Vista 64 bit PC Sql Server 64 bit latest release. Using
> busines inteligent studio i prepared report. this report works fine in
> studio environment. Next step I deployed this report to report server. I
> used target server url= http://localhost/reportserver.
> 1. However when I run IIS I do not see such folder there. when I go to this
> url I get error
>
> Description: An error occurred while accessing the resources required to
> serve this request. You might not have permission to view the requested
> resources.
>
> Error message 401.3: You do not have permission to view this directory or
> page using the credentials you supplied (access denied due to Access Control
> Lists). Ask the Web server's administrator to give you access to 'C:\Program
> Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting
> Services\ReportManager\home.aspx
> ------
> How this works,
>
> 2. When I go to asp.net there I see control rsweb:ReportViewer.
> 2a. this control demanded from me to add code
> <add verb="*" path="Reserved.ReportViewerWebControl.axd" type =
> "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms,
> Version=9.0.0.0, Culture=neutral, PublicKeyToken=....." />
> into web.config into httpHandlers.
> but i am not sure if this is enough
>
> 2b. when I add code <ServerReport ReportPath="..."/> it responds me that
> RSClientController' is undefined
>
> 2c. then I changed to <LocalReport ReportPath=".."></LocalReport>
> Then I got responce
> The definition of the report 'Main Report' is invalid.
> The report definition is not valid. Details: The report definition has an
> invalid target namespace
> 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'
> which cannot be upgraded.
>
> The question is how I can see this report.
>
> --
>
> Aleks Kleyn
> http://www.geocities.com/aleks_kleyn
>
 >> Stay informed about: report in asp.net 
Back to top
Login to vote
Jaimir Guerrero

External


Since: Dec 10, 2008
Posts: 1



(Msg. 7) Posted: Wed Dec 10, 2008 3:18 pm
Post subject: RE: report in asp.net [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Aleks,
1. SQL 2005 use iis, SQL 2008 doesn't. SSRS is a windows service that opens
the port 80.
2. This problem is not about ReportViewer.
3. SSRS2008 need windows authentication for authorization of users to view
the reports and browse the web site.
4. SSRS 2008's web site is locate 'C:\Program Files\Microsoft SQL
Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager.
5. You need create a local security group with your Report“s users and
assign read & execute permission for this folder 'C:\Program Files\Microsoft
SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager.

Jaimir G.

"Aleks Kleyn" wrote:

> I install on my Vista 64 bit PC Sql Server 64 bit latest release. Using
> busines inteligent studio i prepared report. this report works fine in
> studio environment. Next step I deployed this report to report server. I
> used target server url= http://localhost/reportserver.
> 1. However when I run IIS I do not see such folder there. when I go to this
> url I get error
>
> Description: An error occurred while accessing the resources required to
> serve this request. You might not have permission to view the requested
> resources.
>
> Error message 401.3: You do not have permission to view this directory or
> page using the credentials you supplied (access denied due to Access Control
> Lists). Ask the Web server's administrator to give you access to 'C:\Program
> Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting
> Services\ReportManager\home.aspx
> ------
> How this works,
>
> 2. When I go to asp.net there I see control rsweb:ReportViewer.
> 2a. this control demanded from me to add code
> <add verb="*" path="Reserved.ReportViewerWebControl.axd" type =
> "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms,
> Version=9.0.0.0, Culture=neutral, PublicKeyToken=....." />
> into web.config into httpHandlers.
> but i am not sure if this is enough
>
> 2b. when I add code <ServerReport ReportPath="..."/> it responds me that
> RSClientController' is undefined
>
> 2c. then I changed to <LocalReport ReportPath=".."></LocalReport>
> Then I got responce
> The definition of the report 'Main Report' is invalid.
> The report definition is not valid. Details: The report definition has an
> invalid target namespace
> 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'
> which cannot be upgraded.
>
> The question is how I can see this report.
>
> --
>
> Aleks Kleyn
> http://www.geocities.com/aleks_kleyn
>
 >> Stay informed about: report in asp.net 
Back to top
Login to vote
Jennifer Martin

External


Since: Jan 14, 2009
Posts: 1



(Msg. 8) Posted: Wed Jan 14, 2009 2:04 pm
Post subject: RE: report in asp.net [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks Jaimir, for the concise and accurate solution, as I had the same
issue. I think you are the only responder that actually understood the issue.

Jennifer
 >> Stay informed about: report in asp.net 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How to modify a report in Crystal Report 7 - I am a Web developer. I am new to VB 6.0 and Crystal Report. I have joined an organisation where there is an application running(developed in VB6 and crystal report 7). I have to modify one report. In two columns I have to make minor changes i.e put &gt...

Login failed for user 'NT AUTHORITYSYSTEM'. [CLIENT: 192.1.. - It's been suggested that I post here rather than in the windows.server.sbs WIN2003SBS Premium R2 Help! This error is appearing every one minute when SQL Server and SQL Server Agent are running (but not when not): Event Type: Failure Audit Event..

Amortization Report - I'm creating a financial debt program using SQL 2005 as the back-end and Access 2007 (*.accdb) as the front end for a few simple forms and reports. One of the reports they need is an amortization schedule for project debts. Excel has a function to..

monthly report - how to group the data by monthly? thanks...

Help with report/pivot - I am doing a report that shows 1 column per count of transactions for each of 2 different status, + the overall total, and 1 row per product type, of which there are 4. So I need four rows and three columns of counts. The code is not working because it....
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]