Problem with AS data source

I've successfully created a data source and reports against an Analysis
Services database.
The AS database is on the same machine as RS (let's call this Server
1).
I tried this against a second AS database (on Server 2), and it works
fine from Visual Studio, but when I deploy it to RS (on Server 1) and
try to run it, I get the error:
"...Cannot create a connection to data source 'DevServer'.
(rsErrorOpeningConnection)
A connection cannot be made. Ensure that the server is running.
Unable to read from the transport connection: An existing connection
was forcibly closed by the remote host."
I'm not doing anything complicated. It's just that the AS database is
on a different machine from the RS server. Shouldn't this work?
Ideas?
TIA,
JimHi Jim.
Could 'devserver' have firewall on for its network connection?
<jhcorey@.yahoo.com> wrote in message
news:1150819548.395205.74950@.r2g2000cwb.googlegroups.com...
> I've successfully created a data source and reports against an Analysis
> Services database.
> The AS database is on the same machine as RS (let's call this Server
> 1).
> I tried this against a second AS database (on Server 2), and it works
> fine from Visual Studio, but when I deploy it to RS (on Server 1) and
> try to run it, I get the error:
> "...Cannot create a connection to data source 'DevServer'.
> (rsErrorOpeningConnection)
> A connection cannot be made. Ensure that the server is running.
> Unable to read from the transport connection: An existing connection
> was forcibly closed by the remote host."
> I'm not doing anything complicated. It's just that the AS database is
> on a different machine from the RS server. Shouldn't this work?
> Ideas?
> TIA,
> Jim
>|||I just tried deploying everything to Server 2, and it works fine.
So my conclusion is that for a report that goes against an AS cube, RS
must be on the same machine as AS. But it would be great if I was
wrong.
Jim
Tim Dot NoSpam wrote:
> Hi Jim.
> Could 'devserver' have firewall on for its network connection?
> <jhcorey@.yahoo.com> wrote in message
> news:1150819548.395205.74950@.r2g2000cwb.googlegroups.com...
> > I've successfully created a data source and reports against an Analysis
> > Services database.
> > The AS database is on the same machine as RS (let's call this Server
> > 1).
> >
> > I tried this against a second AS database (on Server 2), and it works
> > fine from Visual Studio, but when I deploy it to RS (on Server 1) and
> > try to run it, I get the error:
> >
> > "...Cannot create a connection to data source 'DevServer'.
> > (rsErrorOpeningConnection)
> > A connection cannot be made. Ensure that the server is running.
> > Unable to read from the transport connection: An existing connection
> > was forcibly closed by the remote host."
> >
> > I'm not doing anything complicated. It's just that the AS database is
> > on a different machine from the RS server. Shouldn't this work?
> > Ideas?
> >
> > TIA,
> > Jim
> >|||It is great! <g>
I'm not a configuration wiz, but here are some things you could do until you
figure out how to get reporting services to correctly pass the user's
credentials to AS:
1) change the datasource in report manager for the OLAP conection to use a
domain user that has the necessary privileges on AS (preferrably a domain
account that's not an admin in AS).
Ideally, RS will pass the credentials of the user to AS during the
connection.
A good enterprise configuration for a smaller group could be to split sql
server, analysis services and reporting services across 3 boxes, preferrably
64bit.
<jhcorey@.yahoo.com> wrote in message
news:1150824174.761885.143160@.h76g2000cwa.googlegroups.com...
>I just tried deploying everything to Server 2, and it works fine.
> So my conclusion is that for a report that goes against an AS cube, RS
> must be on the same machine as AS. But it would be great if I was
> wrong.
> Jim
> Tim Dot NoSpam wrote:
>> Hi Jim.
>> Could 'devserver' have firewall on for its network connection?
>> <jhcorey@.yahoo.com> wrote in message
>> news:1150819548.395205.74950@.r2g2000cwb.googlegroups.com...
>> > I've successfully created a data source and reports against an Analysis
>> > Services database.
>> > The AS database is on the same machine as RS (let's call this Server
>> > 1).
>> >
>> > I tried this against a second AS database (on Server 2), and it works
>> > fine from Visual Studio, but when I deploy it to RS (on Server 1) and
>> > try to run it, I get the error:
>> >
>> > "...Cannot create a connection to data source 'DevServer'.
>> > (rsErrorOpeningConnection)
>> > A connection cannot be made. Ensure that the server is running.
>> > Unable to read from the transport connection: An existing connection
>> > was forcibly closed by the remote host."
>> >
>> > I'm not doing anything complicated. It's just that the AS database is
>> > on a different machine from the RS server. Shouldn't this work?
>> > Ideas?
>> >
>> > TIA,
>> > Jim
>> >
>

Problem with Analysis Services Provider

Hi,

For some reason I cannot execute reports using the provider "Microsoft SQL Server Analysis Services (AdomdClient)". I can see my cube through the Query Builder and execute the queries with it too, but when I run the query I get an error...

An error has occurred during report processing.
Cannot create a connection to data source 'SalesMartCube'.
A connection cannot be made. Ensure that the server is running.
No connection could be made because the target machine actively refused it

When I change the provider to "Microsoft OLE DB Provider for Analysis Services 9.0" I can execute the report, but I lose the ability to use the MDX query builder with this provider!

Can someone tell me how I can get the analysis services provider to work or how I can get the mdx query builder to work using the old db propvider?

I have no trouble connecting to the Analysis Services server using the sql 2000 "mdx sample application" and I can also connect to it with excel by importing a datasource. But I cannot connect to it from sql management studio 2005, I get a similar error to above. Could it be that sql server 2005 cannot connect to AS2000?

Thanks,

Lachlan

Did you try to add the ConnectTo property to your connection string when connecting to AS 2000:

data source=localhost;initial catalog=SalesMartCube; ConnectTo=8.0

-- Robert

|||

Hi Robert,

I tried your suggestion but I get a different error when I click on the preview pane using "ConnectTo=8.0" in the connection string...

An error has occurred during local report processing.
An error has occurred during report processing.
Cannot create a connection to data source 'SalesMartCube'.
The LCID or Compare String flags have already been set by an existing connection. They cannot be changed.

It seems strange to me that I can see the query results in query builder but get an error on the preview pane.

I've also noticed that some of the query builder features are not available to me such as query parameters, command type and query designer. Is this because I am connecting to AS2000 rather than AS2005?

Thanks for your help.

Lachlan

Problem with an aggregation

Hi,

I am new to the reporting services and I've been working on problem in one of my reports all day long and after 8 hours of frusturation I decided ask for a profesional help.

Ok here is my problem: I have a report that calculates the amount of meetings with our clients. The dataset contains an activity_id field that we assign for each our meetings with our clients. SSRS counts these meetings and shows it in a drilldown enabled report. Everything seems fine on the report except that someof the activities involves few different clients and SSRS is not counting the activities multiple times in region drilldown as there is only one activity id associates in that region even though it contains different companies. And I want those companies to be calculated in too.

From the crude drawing below I wanted to explain my dilemma visually. As it can be seen the total number of meetings we had is actually 40. But as we had 3 activities that involves more than 1 clients it only gives 37 as a count. I would like to know is there a way to make the report count the same activity multiple times if activity_id is associated with more than one clients.

I hope I managed to explain my problem

**********************************************************************************************

Manager Region Market Company Meeting Detail

+Manager 1 (9 meetings)

+Manager 2 (37 meetings)

- West (37 meetings)

-Denver (37 meetings)

+Company 1 (5 meetings)

+Company 2 (2meetings)

+Company 3 (2meetings)

+Company 4 (3meetings)

+Company 5 (0meetings)

+Company 6 (0meetings)

+Company 7 (5meetings)

+Company 8 (1meetings)

+Comapny 9 (19meetings)

+Company 10 (3meetings)

Total (40 meetings)

You would need to use a composite key by grouping on the combination of the activity_id and company_id rather than just the activity_id. I believe strongly in doing as much of the math as possible in the SQL statement, rather than the report. That way you can use your same report and simply show the total that was calculated rather than the calculating the total. For example:

Code Snippet

SELECT

base.Manager,

base.Region,

base.Market,

base.Company,

base.MeetingDetail,

MTot.Total as ManagerTotal,

RTot.Total as RegionTotal,

M2Tot.Total as MarketTotal,

CTot.Total as CompanyTotal

FROM

baseTable base,

(SELECT COUNT(*) AS Total FROM baseTable bt WHERE bt.Manager = base.Manager) MTot,

(SELECT COUNT(*) AS Total FROM baseTable bt WHERE bt.Manager = base.Manager AND bt.Region = base.Region) RTot,

etc.

This is really bad SQL, but I don't know the actual structure that you are working from and I think this conveys the idea.

If this isn't clear, post or send me the table structures and I will help you build a query that calculates your totals.

Larry

|||

Thank you Larry,

I will try to follow up with your suggestion hopefully it will help. if I got stuck I will post the table structure to you. Thank you again for your prompt response.

Regards,

Burak

|||

Hi Larry,

I've been trying to use your suggestion but I couldn't figure it out a way to use it.

My sql code is as follows

Code Snippet

SELECT DISTINCT
TOP 100 PERCENT ACTIVITY_ID, Date, ACTIVITY_TYP_NM, LAST_NM, FIRST_NM, COMPANY_NM, DISPLAY_NM, Region, SUMMARY, MLAE, Market,
STATE, Expr1
FROM dbo.INTV_Sales_Funnel
GROUP BY ACTIVITY_ID, Date, ACTIVITY_TYP_NM, LAST_NM, FIRST_NM, COMPANY_NM, DISPLAY_NM, Region, SUMMARY, MLAE, Market, STATE,
Expr1
ORDER BY ACTIVITY_ID, Date, SUMMARY, COMPANY_NM

MLAE represents the Manager

and Expr1 represents the Count

the thing is when I used the count im getting a value that more than I should get and the reason for this, is in some of our events we invite multiple people from a company or multiple people from multiple companies.But the report should reflect only 1 count of the event if the meeting had either 1 person or more from a single company. I managed to get rid of those extra people on the meetings over the report so activities only listed once. But it seems like I really need to find a way to make that calculation over the report. Is there a way to use Count Distinct on report with 2 values. Right now I am using Activity ID but I guess if add both activity id and company name as you mentioned earlier on your response I might be able to solve this problem.

|||

First, on re-reading your original post, I am not sure that your original solution wasn't correct. If you had 37 meetings and 3 meetings had two customers each then you would show the result of the sum of the meetings that each customer attended was 40 rather than 37 because each of the three meetings with two customers each would be counted twice.

That said, here is a method of generating the query that will return your results. Lets start with what you know that you want and build the query from left to right on your table above. This will not get us the most optimized query, but it should show the method of layering results within a query that can allow you to get complex results with simple nested queries. One advantage to this method is that you can check the results at each stage.

First, let's get a count of all of the meetings for the managers:

Code Snippet

SELECT
DISF.MLAE,
COUNT(DISF.Activity_Id) ManagerTotal
FROM
(SELECT
DISTINCT
MLAE,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE

Then, let's get the count of meetings per region per manager:

Code Snippet

SELECT
DISF.MLAE,
DISF.Region,
COUNT(DISF.Activity_Id) RegionTotal
FROM
(SELECT
DISTINCT
MLAE,
Region,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE,
DISF.Region

Next, let's get the count of meetings per market within a region for each manager:

Code Snippet

SELECT
DISF.MLAE,
DISF.Region,
DISF.Market,
COUNT(DISF.Activity_Id) MarketTotal
FROM
(SELECT
DISTINCT
MLAE,
Region,
Market,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE,
DISF.Region,
DISF.Market

Lastly, let's get the count of meetings per customer within each market and region for each manager:

Code Snippet

SELECT
DISF.MLAE,
DISF.Region,
DISF.Market,
DISF.Company_NM,
COUNT(DISF.Activity_Id) CompanyTotal
FROM
(SELECT
DISTINCT
MLAE,
Region,
Market,
Company_NM,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE,
DISF.Region,
DISF.Market,
DISF.Company_NM

Then, when you want to combine them and return all of the values, join each of the four queries to the main query as follows:

Code Snippet

SELECT
main.Activity_Id,
main.Date,
main.ACTIVITY_TYP_NM,
main.LAST_NM,
main.FIRST_NM,
main.COMPANY_NM,
main.DISPLAY_NM,
main.Region,
main.SUMMARY,
main.MLAE,
main.Market,
main.STATE,
mgr.ManagerTotal,
rgn.RegionTotal,
mkt.MarketTotal,
cmp.CompanyTotal
FROM
INTV_Sales_Funnel main
JOIN
(
SELECT
DISF.MLAE,
COUNT(DISF.Activity_Id) ManagerTotal
FROM
(SELECT
DISTINCT
MLAE,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE
) mgr
ON
main.MLAE = mgr.MLAE
JOIN
(
SELECT
DISF.MLAE,
DISF.Region,
COUNT(DISF.Activity_Id) RegionTotal
FROM
(SELECT
DISTINCT
MLAE,
Region,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE,
DISF.Region
) rgn
ON
main.MLAE = rgn.MLAE
AND
main.Region = rgn.Region
etc.

I hope this helps. Please let me know how it turns out.

Larry

Problem with &rc:toolbar=false parameter

I am having a problem turning the toolbar off in reports. When I add the
&rc:toolbar=false parameter to the URL, the report is displayed with two
vertical scroll bars. The inner scroll bar scrolls the report and the
external scroll bar scrolls down to what appears to be another report
containing the following:
"Reporting Services Error
----
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Cannot redirect after HTTP headers have been sent."
With &rc:toolbar=true or without the toolbar parameter, the report displays
fine with only one scroll bar. In this case the toolbar is shown and the
beginning of the URL changes from "http://web01/ReportServer" to
"http://web01/ReportServer/Pages/ReportViewer.aspx" followed by the
parameters.
Since the URL with ReportViewer.aspx displays the report correctly, I tried
to use it with the &rc:toolbar=true parameter but when the report is
displayed, the URL reverts to the one without ReportViewer.aspx and the two
scroll bars appear.
I am using RS2005 and displaying the report in a Windows application and if
the toolbar is shown, it wraps to two lines and consumes too much of the web
browser, so I would like to be able to turn the toolbar off but can't find a
way without getting the error.
Does anyone know how to turn the toolbar off or of anything in the report
that could be causing this behavior?
Thanks,
TomHi Tom,
Thank you for the post.
I have tested in my side, it works fine for me.
The report rendered in a whole html page.
Does this occured on all the report?
Here is a article about the Device information settings, you may try to
follow it to set up.
Reporting Services Device Information Settings
http://msdn2.microsoft.com/en-us/library/ms155397.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei Lu,
Most of our reports use groups with drill-down and those that do use
drill-down exhibit the problem with the toolbar being hidden. Did the
report you tested use drill-down?
The only option we have for setting toolbar=false is in the URL because when
we use a browser to show the reports, we want the toolbar but when the
report is displayed in the Windows app, we want the toolbar hidden.
Thanks,
Tom
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:PCCj9tHWGHA.4620@.TK2MSFTNGXA01.phx.gbl...
> Hi Tom,
> Thank you for the post.
> I have tested in my side, it works fine for me.
> The report rendered in a whole html page.
> Does this occured on all the report?
> Here is a article about the Device information settings, you may try to
> follow it to set up.
> Reporting Services Device Information Settings
> http://msdn2.microsoft.com/en-us/library/ms155397.aspx
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Tom,
I also tested with drill down report. It works fine.
Would you please try to post your error log here? By default, the error log
files are located at \Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\LogFiles
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

problem while configuring RS using rsconfih utility.

i installed reporting services on the same machine where i insatalled SQl
server. i did some sample reports in visual studio.net 2003. initally when i
try to deploy it,iam getting 'cannot connect to http://localhost/report
server.' one more insteresting thing is when i browse to
http://localhost/reports or reportserver is an stating that ' connot find to
directory /not having permissions.' then i gave some permission set to both
these virtual directory.
and later i try to browse i got a different error --'The report server
cannot open a connection to the report server database. A connection to the
database is required for all requests and processing.
(rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
command its giving an error that 'No Reporting Services instance found on
localhost.'. What to do Next i don't have any choice,can any one susject me
some thing.
----
--
pammiDid your installation succeed? This seems to look like you didn't actually
have a successful installation.
In your SQL Server, do you have a database named reportserver and another
called reportservertempdb?
In your filesystem, do you have files under c:\program files\sql
server\mssql\reporting services?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
>i installed reporting services on the same machine where i insatalled SQl
> server. i did some sample reports in visual studio.net 2003. initally when
> i
> try to deploy it,iam getting 'cannot connect to http://localhost/report
> server.' one more insteresting thing is when i browse to
> http://localhost/reports or reportserver is an stating that ' connot find
> to
> directory /not having permissions.' then i gave some permission set to
> both
> these virtual directory.
> and later i try to browse i got a different error --'The report server
> cannot open a connection to the report server database. A connection to
> the
> database is required for all requests and processing.
> (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> command its giving an error that 'No Reporting Services instance found on
> localhost.'. What to do Next i don't have any choice,can any one susject
> me
> some thing.
> ----
> --
> pammi|||Lukasz, while installation i don't have problems but when i check it now i
don't have those two databases(reportserver and reportservertempdb) and i
have files under c:\program files\sql
> server\mssql\reporting services. Now what to do i have to reinstall it again. And one more thing i forgot to say is my reporting services is an Evaluation Edition which i down loaded from microsoft site.
"Lukasz Pawlowski [MSFT]" wrote:
> Did your installation succeed? This seems to look like you didn't actually
> have a successful installation.
> In your SQL Server, do you have a database named reportserver and another
> called reportservertempdb?
> In your filesystem, do you have files under c:\program files\sql
> server\mssql\reporting services?
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
> >i installed reporting services on the same machine where i insatalled SQl
> > server. i did some sample reports in visual studio.net 2003. initally when
> > i
> > try to deploy it,iam getting 'cannot connect to http://localhost/report
> > server.' one more insteresting thing is when i browse to
> > http://localhost/reports or reportserver is an stating that ' connot find
> > to
> > directory /not having permissions.' then i gave some permission set to
> > both
> > these virtual directory.
> > and later i try to browse i got a different error --'The report server
> > cannot open a connection to the report server database. A connection to
> > the
> > database is required for all requests and processing.
> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> > command its giving an error that 'No Reporting Services instance found on
> > localhost.'. What to do Next i don't have any choice,can any one susject
> > me
> > some thing.
> >
> > ----
> >
> > --
> > pammi
>
>|||If you do not have the databases, then the report server will not work.
You will need to reinstall reporting services. Ensure that after setup, the
reportserver service is running in the service control manager. Also ensure
you can access the report server on the virtual directory you specified
during setup,e.g. http://localhost/reportserver (default).
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
news:5F564F75-5CF5-4EC7-8DEF-2CA873450D3C@.microsoft.com...
> Lukasz, while installation i don't have problems but when i check it now i
> don't have those two databases(reportserver and reportservertempdb) and i
> have files under c:\program files\sql
>> server\mssql\reporting services. Now what to do i have to reinstall it
>> again. And one more thing i forgot to say is my reporting services is an
>> Evaluation Edition which i down loaded from microsoft site.
>
> "Lukasz Pawlowski [MSFT]" wrote:
>> Did your installation succeed? This seems to look like you didn't
>> actually
>> have a successful installation.
>> In your SQL Server, do you have a database named reportserver and another
>> called reportservertempdb?
>> In your filesystem, do you have files under c:\program files\sql
>> server\mssql\reporting services?
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
>> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
>> >i installed reporting services on the same machine where i insatalled
>> >SQl
>> > server. i did some sample reports in visual studio.net 2003. initally
>> > when
>> > i
>> > try to deploy it,iam getting 'cannot connect to http://localhost/report
>> > server.' one more insteresting thing is when i browse to
>> > http://localhost/reports or reportserver is an stating that ' connot
>> > find
>> > to
>> > directory /not having permissions.' then i gave some permission set to
>> > both
>> > these virtual directory.
>> > and later i try to browse i got a different error --'The report server
>> > cannot open a connection to the report server database. A connection to
>> > the
>> > database is required for all requests and processing.
>> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for
>> > user
>> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
>> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
>> > command its giving an error that 'No Reporting Services instance found
>> > on
>> > localhost.'. What to do Next i don't have any choice,can any one
>> > susject
>> > me
>> > some thing.
>> >
>> > ----
>> >
>> > --
>> > pammi
>>|||Thanks Lukasz,
i reistalled it and now its working...
pavan
"Lukasz Pawlowski [MSFT]" wrote:
> If you do not have the databases, then the report server will not work.
> You will need to reinstall reporting services. Ensure that after setup, the
> reportserver service is running in the service control manager. Also ensure
> you can access the report server on the virtual directory you specified
> during setup,e.g. http://localhost/reportserver (default).
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> news:5F564F75-5CF5-4EC7-8DEF-2CA873450D3C@.microsoft.com...
> > Lukasz, while installation i don't have problems but when i check it now i
> > don't have those two databases(reportserver and reportservertempdb) and i
> > have files under c:\program files\sql
> >> server\mssql\reporting services. Now what to do i have to reinstall it
> >> again. And one more thing i forgot to say is my reporting services is an
> >> Evaluation Edition which i down loaded from microsoft site.
> >
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> >> Did your installation succeed? This seems to look like you didn't
> >> actually
> >> have a successful installation.
> >>
> >> In your SQL Server, do you have a database named reportserver and another
> >> called reportservertempdb?
> >>
> >> In your filesystem, do you have files under c:\program files\sql
> >> server\mssql\reporting services?
> >>
> >> -Lukasz
> >>
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >>
> >> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> >> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
> >> >i installed reporting services on the same machine where i insatalled
> >> >SQl
> >> > server. i did some sample reports in visual studio.net 2003. initally
> >> > when
> >> > i
> >> > try to deploy it,iam getting 'cannot connect to http://localhost/report
> >> > server.' one more insteresting thing is when i browse to
> >> > http://localhost/reports or reportserver is an stating that ' connot
> >> > find
> >> > to
> >> > directory /not having permissions.' then i gave some permission set to
> >> > both
> >> > these virtual directory.
> >> > and later i try to browse i got a different error --'The report server
> >> > cannot open a connection to the report server database. A connection to
> >> > the
> >> > database is required for all requests and processing.
> >> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for
> >> > user
> >> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> >> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> >> > command its giving an error that 'No Reporting Services instance found
> >> > on
> >> > localhost.'. What to do Next i don't have any choice,can any one
> >> > susject
> >> > me
> >> > some thing.
> >> >
> >> > ----
> >> >
> >> > --
> >> > pammi
> >>
> >>
> >>
>
>

Problem when viewing reports in browser

Hi,
I have a report that use fixedheader in some of its tablecolumn. The
reports also using drill through.
In report designer, the fixedheader works fine. Also when I'm jump to
another report (the drill through), there is a "back to parent report"
button in the new report shown.
The problem is, when I deploy the report to the report server. When
I'm viewing the report in the browser (ie 6), the fixedheader doesn't
work. Also the "back to parent report" button, gone.
How can I solve this? ThxOn Mar 29, 12:00 pm, "Alphonse" <amphysv...@.gmail.com> wrote:
> Hi,
> I have a report that use fixedheader in some of its tablecolumn. The
> reports also using drill through.
> In report designer, the fixedheader works fine. Also when I'm jump to
> another report (the drill through), there is a "back to parent report"
> button in the new report shown.
> The problem is, when I deploy the report to the report server. When
> I'm viewing the report in the browser (ie 6), the fixedheader doesn't
> work. Also the "back to parent report" button, gone.
> How can I solve this? Thx
Fix the fixedheader bug. Its because I'm merging some cells in the
fixed column. After split all the merging cells, the freeze pane works
fine in the browser. I guess this is a bug, cause it didn't error in
the report designer preview.
Still have problem with the "back to parent report" in the browser.
Any help for this issue, would greatly appreciated.
Thanks

Problem when launchin reportBuilder

One of our Client is using our WebApplication (ASP.NET2). In this application it is possible to lauch reportBuilder to allow reports creation. We never have any problem with this feature except today when we tried this feature on one our client computer.

Normaly when we tried this feature for the first time in a computer we get a window to allow us to install the ReportBuilder Application. So we juste have to click on run and then some plugin is installed and after that reportBuilder is working fine. When we tried to launch ReportBuilder for the time today on this computer we didn't have the choice to install the pluging but only to download it. So i've download it and put it on a folder. The i've tried to run it but the file is not associate with anything so windows ask me which program i want to use to run it. The file is called ReportBuilder.application

This is the first time this thing happened. When i was looking on this computer i've noticed that there doesn't seems to have installed any FrameWork. So i was wondering if this can be problem ? Tomorow i have to go back to find a solution for this problem so i want to know if i need to install the framework to use ReportBuilder on a Client computer?

Report Builder requires .Net Framework v2.

Problem when deploying Reports

Hello, I am working on SQL Server 2005 Reporting Services embedded in the Visual Studio 2005. I ve build reports perefctly, but the problem raised when I tried to deploy this report:

I am deploying these report with a debug configuration , and I have tried with the 2 TargetServerURL:

http://localhost/reportserver$sql2005

http://localhost/reportserver

The Error message is the following:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/reportserver$sql2005.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Configuration Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>

<b> Parser Error Message: </b>Could not load type 'Microsoft.Web.Services.ScriptModule'. (c:\inetpub\wwwroot\web.config line 123)<br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

Line 121: </httpHandlers>
Line 122: <httpModules>
<font color=red>Line 123: <add name="ScriptModule" type="Microsoft.Web.Services.ScriptModule"/>
</font>Line 124: <add name="BridgeModule" type="Microsoft.Web.Services.BridgeModule"/>
Line 125: <add name="WebResourceCompression" type="Microsoft.Web.Services.WebResourceCompressionModule"/></pre></code>

</td>
</tr>
</table>

<br>

<b> Source File: </b> c:\inetpub\wwwroot\web.config<b> Line: </b> 123
<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

</font>

</body>
</html>
<!--
[ConfigurationErrorsException]: Could not load type 'Microsoft.Web.Services.ScriptModule'. (c:\inetpub\wwwroot\web.config line 123) (c:\inetpub\wwwroot\web.config line 123)
at System.Web.Configuration.HttpModuleAction.get_Entry()
at System.Web.Configuration.HttpModulesSection.CreateModules()
at System.Web.HttpApplication.InitModules()
at System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers)
at System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context)
at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
-->
--. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

How Should I proceed to remedy this?

Thanks in advance

make sure report server is running.

please let me know what u r getting when access " http://localhost/reportserver"

|||

Well, when runing the reportServer URL, this error message was displayed

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load type 'Microsoft.Web.Services.ScriptModule'. (c:\inetpub\wwwroot\web.config line 123)

Source Error:

Line 121:</httpHandlers>

Line 122:<httpModules>

Line 123:<add name="ScriptModule" type="Microsoft.Web.Services.ScriptModule"/>

Line 124:<add name="BridgeModule" type="Microsoft.Web.Services.BridgeModule"/>

Line 125:<add name="WebResourceCompression" type="Microsoft.Web.Services.WebResourceCompressionModule"/>

What Can I do to load this module? Thanks

Problem Viewing Reports on Server

Hello, we're having a bit of an issue getting Report Server to display reports. We've published via the web-interface and Visual Studio. After we publish, it gives an error and it looks as if it's trying to find the data source that we used to create the report. We've changed the datasource names to match that of the local machine too. Here's the error...

An error has occurred during report processing.

Cannot create a connection to data source 'LocalDataSourceName'.

Keyword not supported: 'driver'.

Any help would be greatly appreciated. Thank you!

What is the connection string and which data provider are you using? It looks like the data provider can't handle the connection string.|||Problem solved....we were using an invalid connection string. For some reason it was working on one server but not the other. Just tried a different string on both of them and it works great now.

Problem Viewing reports in Report Manager

I have successfully installed the sql server reporting services on a windows
2003 server. I have been able to deploy several reports to the report
server. I have even been able to schedule a report to execute and send out
via email every morning of the week.
Here's the problem. When I try to view a report using the report manager I
get a
The page cannot be found
HTTP 404 - File not found
Internet Explorer
error. I just don't get it. I can perform every other function using the
report manager except view the report online. Which of course is a problem
because I want to send my customers to the site to be able to view and run
reports.
Thanks for any help.
--
Jon Clayton
Regions Financial CorporationSounds like a security issue or a malformed URL. It's very difficult (from
here) to determine how you access report manager differently than the online
version, but could you post a URL that worked, and a URL that failed?
Dwayne|||Thanks for your help.
Here is a link that works
http://Servername/Reports/Pages/Folder.aspx
This link of course brings up the default folders page
Click on a folder and go to the following url, which work
http://servername/Reports/Pages/Folder.aspx?ItemPath=%2fTeamWorkLoad&ViewMode=List
Click on a report in that folder to view the report using the following url
fail
http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport
The failure only occurs within the frame below. The header frame is still
displayed, therefore I am able to:
Click on the properties tab with the failed page displayed is successful
using the following ur
http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport&SelectedTabId=PropertiesTab
I have given full access permissions to the ASPNET account on the local
machine to the two RS folders.
I am convinced that it is a permissions issue. As a matter of fact I had an
instance installed in my test invironment which is Windows 2000 which worked
fine. But ever since the latest security updates that machine is having the
same issue.
Thanks again for your help.
--
Jon Clayton
Regions Financial Corporation
"Dwayne J. Baldwin" wrote:
> Sounds like a security issue or a malformed URL. It's very difficult (from
> here) to determine how you access report manager differently than the online
> version, but could you post a URL that worked, and a URL that failed?
> Dwayne
>
>|||"Jon" wrote:
> Thanks for your help.
> Here is a link that works
> http://Servername/Reports/Pages/Folder.aspx
> This link of course brings up the default folders page
> Click on a folder and go to the following url, which works
> http://servername/Reports/Pages/Folder.aspx?ItemPath=%2fTeamWorkLoad&ViewMode=List
> Click on a report in that folder to view the report using the following url
> fails
> http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport
> The failure only occurs within the frame below. The header frame is still
> displayed, therefore I am able to:
> Click on the properties tab with the failed page displayed is successful
> using the following url
> http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport&SelectedTabId=PropertiesTab
> I have given full access permissions to the ASPNET account on the local
> machine to the two RS folders.
> I am convinced that it is a permissions issue. As a matter of fact I had an
> instance installed in my test invironment which is Windows 2000 which worked
> fine. But ever since the latest security updates that machine is having the
> same issue.
> Thanks again for your help.
> --
> Jon Clayton
> Regions Financial Corporation
>
> "Dwayne J. Baldwin" wrote:
> > Sounds like a security issue or a malformed URL. It's very difficult (from
> > here) to determine how you access report manager differently than the online
> > version, but could you post a URL that worked, and a URL that failed?
> >
> > Dwayne
> >
> >
> >
> > I had the same problem. The RSWebApplication.config file in the ReportServer bin folder has a URL setting which should be the same as your server.|||It appears that the entries in the config files are correct. Thanks for the
tip.
--
Jon Clayton
Regions Financial Corporation
"DLM" wrote:
>
> "Jon" wrote:
> > Thanks for your help.
> >
> > Here is a link that works
> > http://Servername/Reports/Pages/Folder.aspx
> > This link of course brings up the default folders page
> >
> > Click on a folder and go to the following url, which works
> > http://servername/Reports/Pages/Folder.aspx?ItemPath=%2fTeamWorkLoad&ViewMode=List
> >
> > Click on a report in that folder to view the report using the following url
> > fails
> > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport
> > The failure only occurs within the frame below. The header frame is still
> > displayed, therefore I am able to:
> >
> > Click on the properties tab with the failed page displayed is successful
> > using the following url
> > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport&SelectedTabId=PropertiesTab
> >
> > I have given full access permissions to the ASPNET account on the local
> > machine to the two RS folders.
> >
> > I am convinced that it is a permissions issue. As a matter of fact I had an
> > instance installed in my test invironment which is Windows 2000 which worked
> > fine. But ever since the latest security updates that machine is having the
> > same issue.
> >
> > Thanks again for your help.
> >
> > --
> > Jon Clayton
> > Regions Financial Corporation
> >
> >
> > "Dwayne J. Baldwin" wrote:
> >
> > > Sounds like a security issue or a malformed URL. It's very difficult (from
> > > here) to determine how you access report manager differently than the online
> > > version, but could you post a URL that worked, and a URL that failed?
> > >
> > > Dwayne
> > >
> > >
> > >
> > > I had the same problem. The RSWebApplication.config file in the ReportServer bin folder has a URL setting which should be the same as your server.|||Hi Jon,
I have exactly the same problem. Please advise what I need to check/do?
Thanks very much
Khat.
"Jon" wrote:
> It appears that the entries in the config files are correct. Thanks for the
> tip.
> --
> Jon Clayton
> Regions Financial Corporation
>
> "DLM" wrote:
> >
> >
> > "Jon" wrote:
> >
> > > Thanks for your help.
> > >
> > > Here is a link that works
> > > http://Servername/Reports/Pages/Folder.aspx
> > > This link of course brings up the default folders page
> > >
> > > Click on a folder and go to the following url, which works
> > > http://servername/Reports/Pages/Folder.aspx?ItemPath=%2fTeamWorkLoad&ViewMode=List
> > >
> > > Click on a report in that folder to view the report using the following url
> > > fails
> > > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport
> > > The failure only occurs within the frame below. The header frame is still
> > > displayed, therefore I am able to:
> > >
> > > Click on the properties tab with the failed page displayed is successful
> > > using the following url
> > > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport&SelectedTabId=PropertiesTab
> > >
> > > I have given full access permissions to the ASPNET account on the local
> > > machine to the two RS folders.
> > >
> > > I am convinced that it is a permissions issue. As a matter of fact I had an
> > > instance installed in my test invironment which is Windows 2000 which worked
> > > fine. But ever since the latest security updates that machine is having the
> > > same issue.
> > >
> > > Thanks again for your help.
> > >
> > > --
> > > Jon Clayton
> > > Regions Financial Corporation
> > >
> > >
> > > "Dwayne J. Baldwin" wrote:
> > >
> > > > Sounds like a security issue or a malformed URL. It's very difficult (from
> > > > here) to determine how you access report manager differently than the online
> > > > version, but could you post a URL that worked, and a URL that failed?
> > > >
> > > > Dwayne
> > > >
> > > >
> > > >
> > > > I had the same problem. The RSWebApplication.config file in the ReportServer bin folder has a URL setting which should be the same as your server.|||I am also having this same exact problem. I can run everything without issue
on our test server but production server is exhibiting this exact behavior?
I can do everything but view the report. I can even run the report on the
production server through code and through http://server/reportserver.
Navigate to the folder/report and viola. I can enter parameters and run it.
But not in the report manager gui' I get a 404 when I press the view
report button. If I press it a second time I then get an error in the lower
left hand corner of IE. If I open it up it states that on Line 50 permission
denied and url = http://server/reportserver...blah...blah...blah
Kevin
"Khat Liko" wrote:
> Hi Jon,
> I have exactly the same problem. Please advise what I need to check/do?
> Thanks very much
> Khat.
> "Jon" wrote:
> > It appears that the entries in the config files are correct. Thanks for the
> > tip.
> > --
> > Jon Clayton
> > Regions Financial Corporation
> >
> >
> > "DLM" wrote:
> >
> > >
> > >
> > > "Jon" wrote:
> > >
> > > > Thanks for your help.
> > > >
> > > > Here is a link that works
> > > > http://Servername/Reports/Pages/Folder.aspx
> > > > This link of course brings up the default folders page
> > > >
> > > > Click on a folder and go to the following url, which works
> > > > http://servername/Reports/Pages/Folder.aspx?ItemPath=%2fTeamWorkLoad&ViewMode=List
> > > >
> > > > Click on a report in that folder to view the report using the following url
> > > > fails
> > > > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport
> > > > The failure only occurs within the frame below. The header frame is still
> > > > displayed, therefore I am able to:
> > > >
> > > > Click on the properties tab with the failed page displayed is successful
> > > > using the following url
> > > > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport&SelectedTabId=PropertiesTab
> > > >
> > > > I have given full access permissions to the ASPNET account on the local
> > > > machine to the two RS folders.
> > > >
> > > > I am convinced that it is a permissions issue. As a matter of fact I had an
> > > > instance installed in my test invironment which is Windows 2000 which worked
> > > > fine. But ever since the latest security updates that machine is having the
> > > > same issue.
> > > >
> > > > Thanks again for your help.
> > > >
> > > > --
> > > > Jon Clayton
> > > > Regions Financial Corporation
> > > >
> > > >
> > > > "Dwayne J. Baldwin" wrote:
> > > >
> > > > > Sounds like a security issue or a malformed URL. It's very difficult (from
> > > > > here) to determine how you access report manager differently than the online
> > > > > version, but could you post a URL that worked, and a URL that failed?
> > > > >
> > > > > Dwayne
> > > > >
> > > > >
> > > > >
> > > > > I had the same problem. The RSWebApplication.config file in the ReportServer bin folder has a URL setting which should be the same as your server.

Problem viewing reports in Report Builder

Hi.

I get a problem when I want to preview a report in Report Builder. I just launch Report Builder by the url [1] (RS is on a server, and I work on a laptop). Then I choose a model and create a simple report. When I press "Run Report", I get an error message saying: "The permissions granted to user 'mydomain\myusername' are insufficient for performing this operation. (rsAccessDenied)". But my user are assigned to content manager...

If I then save the report to the Report Server, I can access the report through e.g. the Report Manager without any problems.

Why doesn't the preview functionality work for me? Are there some settings I need to set, or is it a bug in Report Builder?

Regards, Tomsi

[1] http://<servername>/reportserver/reportbuilder/reportbuilderlocalintranet.application

Same problem for me. If I add myself to the local admin group it will work fine. Of course that is not a valid solution. What security piece are we missing?

Is there a how to or step by step on the this part of the security for report builder?

Thanks much

Carl

|||Do you have the system permission "Execute Report Definitions"? It is configurable from the Site Settings link in Report Manager.|||

Thanks. Adding myself (NT user or group) to a "System Role Assignement" under "site-wide security" fixed it.

|||

Hello, I am supposed to be the administrator but I cant see system wide security.

Problem viewing reports in Report Builder

Hi.

I get a problem when I want to preview a report in Report Builder. I just launch Report Builder by the url [1] (RS is on a server, and I work on a laptop). Then I choose a model and create a simple report. When I press "Run Report", I get an error message saying: "The permissions granted to user 'mydomain\myusername' are insufficient for performing this operation. (rsAccessDenied)". But my user are assigned to content manager...

If I then save the report to the Report Server, I can access the report through e.g. the Report Manager without any problems.

Why doesn't the preview functionality work for me? Are there some settings I need to set, or is it a bug in Report Builder?

Regards, Tomsi

[1] http://<servername>/reportserver/reportbuilder/reportbuilderlocalintranet.application

Same problem for me. If I add myself to the local admin group it will work fine. Of course that is not a valid solution. What security piece are we missing?

Is there a how to or step by step on the this part of the security for report builder?

Thanks much

Carl

|||Do you have the system permission "Execute Report Definitions"? It is configurable from the Site Settings link in Report Manager.|||

Thanks. Adding myself (NT user or group) to a "System Role Assignement" under "site-wide security" fixed it.

|||

Hello, I am supposed to be the administrator but I cant see system wide security.

Problem viewing reports from report server

Hi,
I am new to Microsoft SQL Server Reporting Services.
I followed the MSDN tutorial and successfully created a basic report.
The preview of the report is fine within Business Intelligence
Studio. I successfully deployed it to http://localhost/ReportServer.
Look:
-- Build started: Project: Report Project1, Configuration:
Production --
Build complete -- 0 errors, 0 warnings
-- Deploy started: Project: Report Project1, Configuration:
Production --
Deploying to http://localhost/ReportServer
Deploying report '/Report Project1/Sales Orders'.
Deploy complete -- 0 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped
========== ========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========
But, when I tried to check it out from the Web browser (either IE or
FireFox), the report is not displayed. Instead I saw the following
error message:
For security reasons DTD is prohibited in this XML document. To enable
DTD processing set the ProhibitDtd property on XmlReaderSettings to
false and pass the settings into XmlReader.Create method.
However, the report is downloadable. If you click on "Export", I can
export it to Excel or PDF.
Question: In which file, do I set the ProhibitDtd property on
XmlReaderSettings to false and pass it to XmlReader.Create method?
Thank you!Were you able to solve your problem ? I am having same issues
"antonyliu2002@.yahoo.com" wrote:
> Hi,
> I am new to Microsoft SQL Server Reporting Services.
> I followed the MSDN tutorial and successfully created a basic report.
> The preview of the report is fine within Business Intelligence
> Studio. I successfully deployed it to http://localhost/ReportServer.
> Look:
> -- Build started: Project: Report Project1, Configuration:
> Production --
> Build complete -- 0 errors, 0 warnings
> -- Deploy started: Project: Report Project1, Configuration:
> Production --
> Deploying to http://localhost/ReportServer
> Deploying report '/Report Project1/Sales Orders'.
> Deploy complete -- 0 errors, 0 warnings
> ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped
> ==========> ========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========> But, when I tried to check it out from the Web browser (either IE or
> FireFox), the report is not displayed. Instead I saw the following
> error message:
> For security reasons DTD is prohibited in this XML document. To enable
> DTD processing set the ProhibitDtd property on XmlReaderSettings to
> false and pass the settings into XmlReader.Create method.
> However, the report is downloadable. If you click on "Export", I can
> export it to Excel or PDF.
> Question: In which file, do I set the ProhibitDtd property on
> XmlReaderSettings to false and pass it to XmlReader.Create method?
> Thank you!
>

Problem viewing Reports from Network

Hi,
We have a network of XP Machines.
When i try to view the reports in the application from the same
machine itself it's coming up properly,but when i try to acess the
reports in the application from another machine it's giving me the
following error,
?The permissions granted to user ?OLDSERVER\Guest' are insufficient
for performing this operation. (rsAccessDenied)
As a solution to the problem of permissions in the help it's mentioned
that we need to create roles in the SQL Server Report Manager for the
users whom we need to give access to the reports.When we are accessing
the reports from the network by default we are accessing the server as
guests who doesn't have much rights.So I have created role (Browser )
on SQL Server Report Manager for the guest user and tried accessing
the server.
Then it's giving the following error
The Error Log description for the error was as follows,
aspnet_wp!library!cd4!10/13/2004-21:48:41:: e
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server.
See the error log for more details. -->
System.InvalidOperationException: Computer name could not be obtained.
at System.Environment.get_MachineName()
at Microsoft.ReportingServices.Diagnostics.RunningJobContext..ctor(String
jobId, String requestPath,
JobActionEnum action, JobTypeEnum type, RunningJobList parentList,
String userName, HttpContext
optionalWebCtx)
at Microsoft.ReportingServices.Diagnostics.RunningJobList.AddJob(String
jobId, String requestPath,
JobActionEnum action, JobTypeEnum type, String userName, HttpContext
optionalCtx)
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase..ctor(String
jobId, String requestPath,
JobActionEnum action, JobTypeEnum jobType, String userName)
at Microsoft.ReportingServices.Library.ProcessReportParametersCancelableStep..ctor(RSService
rs,
CatalogItemContext reportContext, Guid reportID, Guid linkID,
DateTime historyDate, Int32 executionOption,
ReportSnapshot compiledDefinition, ReportSnapshot snapshotData,
String savedParametersXml,
NameValueCollection values, JobTypeEnum jobType, String userName)
at Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext
reportContext, Guid reportID, Guid linkID, DateTime historyDate,
Int32 executionOption, ReportSnapshot
compiledDefinition, ReportSnapshot snapshotData, String
savedParametersXml, NameValueCollection values,
JobTypeEnum jobType)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean
forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.GetReportParameters(String
report, String historyID, Boolean
forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
-- End of inner exception stack trace --
aspnet_wp!webserver!cd4!10/13/2004-21:48:41:: e ERROR:
Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log
for more details. -->
System.InvalidOperationException: Computer name could not be obtained.
Thanks in Advance,
RajeshTake a look at
http://msdn.microsoft.com/library/en-us/rswork/htm/rms_security_v1_10bm.asp
. Try using built-in accounts Everyone or Users instead of Guest.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Rajesh" <rajeshkchandran@.gmail.com> wrote in message
news:cad1e70a.0410201456.280c018f@.posting.google.com...
> Hi,
> We have a network of XP Machines.
> When i try to view the reports in the application from the same
> machine itself it's coming up properly,but when i try to acess the
> reports in the application from another machine it's giving me the
> following error,
> 'The permissions granted to user 'OLDSERVER\Guest' are insufficient
> for performing this operation. (rsAccessDenied)
> As a solution to the problem of permissions in the help it's mentioned
> that we need to create roles in the SQL Server Report Manager for the
> users whom we need to give access to the reports.When we are accessing
> the reports from the network by default we are accessing the server as
> guests who doesn't have much rights.So I have created role (Browser )
> on SQL Server Report Manager for the guest user and tried accessing
> the server.
> Then it's giving the following error
> The Error Log description for the error was as follows,
> aspnet_wp!library!cd4!10/13/2004-21:48:41:: e
> ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server.
> See the error log for more details. -->
> System.InvalidOperationException: Computer name could not be obtained.
> at System.Environment.get_MachineName()
> at
> Microsoft.ReportingServices.Diagnostics.RunningJobContext..ctor(String
> jobId, String requestPath,
> JobActionEnum action, JobTypeEnum type, RunningJobList parentList,
> String userName, HttpContext
> optionalWebCtx)
> at Microsoft.ReportingServices.Diagnostics.RunningJobList.AddJob(String
> jobId, String requestPath,
> JobActionEnum action, JobTypeEnum type, String userName, HttpContext
> optionalCtx)
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase..ctor(String
> jobId, String requestPath,
> JobActionEnum action, JobTypeEnum jobType, String userName)
> at
> Microsoft.ReportingServices.Library.ProcessReportParametersCancelableStep..ctor(RSService
> rs,
> CatalogItemContext reportContext, Guid reportID, Guid linkID,
> DateTime historyDate, Int32 executionOption,
> ReportSnapshot compiledDefinition, ReportSnapshot snapshotData,
> String savedParametersXml,
> NameValueCollection values, JobTypeEnum jobType, String userName)
> at
> Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext
> reportContext, Guid reportID, Guid linkID, DateTime historyDate,
> Int32 executionOption, ReportSnapshot
> compiledDefinition, ReportSnapshot snapshotData, String
> savedParametersXml, NameValueCollection values,
> JobTypeEnum jobType)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean
> forRendering, NameValueCollection values,
> DatasourceCredentialsCollection credentials)
> at
> Microsoft.ReportingServices.Library.RSService.GetReportParameters(String
> report, String historyID, Boolean
> forRendering, NameValueCollection values,
> DatasourceCredentialsCollection credentials)
> -- End of inner exception stack trace --
> aspnet_wp!webserver!cd4!10/13/2004-21:48:41:: e ERROR:
> Reporting Services error
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log
> for more details. -->
> System.InvalidOperationException: Computer name could not be obtained.
>
> Thanks in Advance,
> Rajesh

Problem viewing report with Report Viewer

Hi,

I am using the Report Viewer Control to display the Reports. My query is generated dynamically so that output the query is a datatable. My application gives the user the flexibility to select the tables & the table-fields on which he wants to run the report. So I cannot have a fixed report file as I do not know what will the user select.

I tried adding the result datatable as the datasource for the report dynamically.

protected void RunReport_Click(object sender, EventArgs e){string constg ="server=localhost;Database=techapp;user id=sa;password=admin;";SqlConnection con =new SqlConnection(constg);//query is the query string that is generated at runtimeSqlDataAdapter da =new SqlDataAdapter(query,con);DataSet ds =new DataSet();da.Fill(ds,"ReportDataTable"); con.Close();ViewReport(ds.Tables["ReportDataTable"]);}protected void ViewReport(DataTable dt){ ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportDataSource rd =new ReportDataSource(); rd.Name ="ReportData_Data"; rd.Value = dt; ReportViewer1.LocalReport.DataSources.Add(rd); ReportViewer1.DataBind();}

My problem is that the entire code gets executed properly without any exception but the report is not displayed. I checked the ReportDataSource & it shows the proper value. In all the samples that I went through, I found that they have mentioned a report file. I don't know if this is the cause of the problem, but if it is then In mycase how can I create a report design file if I wouldn't know what to add in that file at design time.

I do not have an expertise in this. can anyone please guide me through the right way & let me know what is it that I'm not doing correct?

I guess its the problem with height of report

Check whether you have set the height of report as 100%. Change that to some fixed size let say 800px.

Let me know if you need any further help

|||

Hi Ashok,

I tried adjusting the height of the report viewer . This is the changed code but it still doesn't show any thing.

 ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.Height = Unit.Pixel(500); ReportDataSource rd =new ReportDataSource(); rd.Name ="ReportData_Data"; rd.Value = ds.Tables["ReportDataTable"]; ReportViewer1.LocalReport.DataSources.Add(rd); ReportViewer1.DataBind();

Could the problem be the absence of a report design file ie an rdlc file. I downloaded a sample code from net where the report file is created dynamically & it seemed to work this way.

Is a report design file by default required for the report viewer control to display the report? What is the complexity involved in creating such design files on your own?? Can you shed some light on these points ?

Thanks

Problem using Visual Studio 2008 Winforms ReportViewer

I have an application built using VS 2008 (3.5 fx). I build a series of
reports (using VS 2005 (sigh)) and am now tryiing to render them using a
Windows form and the ReportViewer control in the VS 2008 app. However I
always get the error message "The source of the report definition has not
been specified" when I execute the line
m_reportViewer.RefreshReport();
When I try to view the very same report in a VS 2005 app it renders without
error. I can also view the report using Report Manager and preview it in the
VS 2005 app I use to build it. Any suggestions?
Thx
Helen
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.comNever mind. I added and removed the ReportViewer control a few times,
switching between Versino 8 & Version 9, and finally it worked :)
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.com

Problem using custom assemblies in SSRS2005

I've created a custom assembly (in VB (VS-2005)) for use in some SSRS2005
reports.
project: ReportsLibrary
Public Class ReportsCodeLibrary
Public Shared Function ReturnXML(MVList as Object, Root As String, Node As
String, Element As String) As String
Dim ReturnString = ""
Dim sParamItem As Object
ReturnString = "<" & Root & ">"
For Each sParamItem In MultiValueList
ReturnString &= "<" & Node & "><" & Element & ">" & sParamItem & "</"
& Element & "></" & Node & ">"
Next
ReturnString &= "</" & Root & ">"
Return (ReturnString)
End Function
Public Shared Function Format(s As String) As String
Format = left(s,4) & "-" & mid(s,5,2) & "-" & mid(s,7,3) & "-" &
right(s,4)
End Function
End Class
Each of these functions work properly if I put them in the Code section. But
since they are being used in multiple reports, I want to have the code in one
place and use that assembly.
The project is compiled in "Release" configuration.
I attach this compiled dll (ReportsLibrary.dll) to the report in the
Report's properties "Reference" section. Since these are Shared functions, I
don't need to define individual classes on that sheet.
When I get this working, I'll copy the dll to the SSRS ReportServer\bin
directory on the SSRS computer.
On the TextBox's (txtTableField2) Value property, I enter the expression
"=ReportsLibrary.ReportsCodeLibrary.Format(Fields!fieldName.Value)"
When I preview the report in Visual Studio, I get these errors:
[rsErrorLoadingCodeModule] Error while loading code module: â'ReportsLibrary,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullâ'. Details: Could not
load file or assembly 'ReportsLibrary, Version=1.0.0.0, Culture=neutral,
PublicKeyToken=null' or one of its dependencies. The system cannot find the
file specified.
[rsCompilerErrorInExpression] The Value expression for the textbox
â'txtTableField2â' contains an error: [BC30451] Name 'ReportsLibrary' is not
declared.
So, what am I missing? What do I need to do to get this assembly to work
with SSRS?
Thanks,
WayneIs the .dll copied to the following folder on your development machine:
"C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies"?
--
Matt
"Wayne" wrote:
> I've created a custom assembly (in VB (VS-2005)) for use in some SSRS2005
> reports.
> project: ReportsLibrary
> Public Class ReportsCodeLibrary
> Public Shared Function ReturnXML(MVList as Object, Root As String, Node As
> String, Element As String) As String
> Dim ReturnString = ""
> Dim sParamItem As Object
> ReturnString = "<" & Root & ">"
> For Each sParamItem In MultiValueList
> ReturnString &= "<" & Node & "><" & Element & ">" & sParamItem & "</"
> & Element & "></" & Node & ">"
> Next
> ReturnString &= "</" & Root & ">"
> Return (ReturnString)
> End Function
> Public Shared Function Format(s As String) As String
> Format = left(s,4) & "-" & mid(s,5,2) & "-" & mid(s,7,3) & "-" &
> right(s,4)
> End Function
> End Class
> Each of these functions work properly if I put them in the Code section. But
> since they are being used in multiple reports, I want to have the code in one
> place and use that assembly.
> The project is compiled in "Release" configuration.
> I attach this compiled dll (ReportsLibrary.dll) to the report in the
> Report's properties "Reference" section. Since these are Shared functions, I
> don't need to define individual classes on that sheet.
> When I get this working, I'll copy the dll to the SSRS ReportServer\bin
> directory on the SSRS computer.
> On the TextBox's (txtTableField2) Value property, I enter the expression
> "=ReportsLibrary.ReportsCodeLibrary.Format(Fields!fieldName.Value)"
> When I preview the report in Visual Studio, I get these errors:
> [rsErrorLoadingCodeModule] Error while loading code module: â'ReportsLibrary,
> Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullâ'. Details: Could not
> load file or assembly 'ReportsLibrary, Version=1.0.0.0, Culture=neutral,
> PublicKeyToken=null' or one of its dependencies. The system cannot find the
> file specified.
> [rsCompilerErrorInExpression] The Value expression for the textbox
> â'txtTableField2â' contains an error: [BC30451] Name 'ReportsLibrary' is not
> declared.
> So, what am I missing? What do I need to do to get this assembly to work
> with SSRS?
> Thanks,
> Wayne|||Matt,
Thanks! this took care of it. If only I had found this documented somewhere...
"Matt" wrote:
> Is the .dll copied to the following folder on your development machine:
> "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies"?
> --
> Matt
>
> "Wayne" wrote:
> > I've created a custom assembly (in VB (VS-2005)) for use in some SSRS2005
> > reports.
> >
> > project: ReportsLibrary
> > Public Class ReportsCodeLibrary
> > Public Shared Function ReturnXML(MVList as Object, Root As String, Node As
> > String, Element As String) As String
> > Dim ReturnString = ""
> > Dim sParamItem As Object
> > ReturnString = "<" & Root & ">"
> > For Each sParamItem In MultiValueList
> > ReturnString &= "<" & Node & "><" & Element & ">" & sParamItem & "</"
> > & Element & "></" & Node & ">"
> > Next
> > ReturnString &= "</" & Root & ">"
> > Return (ReturnString)
> > End Function
> >
> > Public Shared Function Format(s As String) As String
> > Format = left(s,4) & "-" & mid(s,5,2) & "-" & mid(s,7,3) & "-" &
> > right(s,4)
> > End Function
> > End Class
> >
> > Each of these functions work properly if I put them in the Code section. But
> > since they are being used in multiple reports, I want to have the code in one
> > place and use that assembly.
> >
> > The project is compiled in "Release" configuration.
> > I attach this compiled dll (ReportsLibrary.dll) to the report in the
> > Report's properties "Reference" section. Since these are Shared functions, I
> > don't need to define individual classes on that sheet.
> > When I get this working, I'll copy the dll to the SSRS ReportServer\bin
> > directory on the SSRS computer.
> >
> > On the TextBox's (txtTableField2) Value property, I enter the expression
> > "=ReportsLibrary.ReportsCodeLibrary.Format(Fields!fieldName.Value)"
> > When I preview the report in Visual Studio, I get these errors:
> > [rsErrorLoadingCodeModule] Error while loading code module: â'ReportsLibrary,
> > Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullâ'. Details: Could not
> > load file or assembly 'ReportsLibrary, Version=1.0.0.0, Culture=neutral,
> > PublicKeyToken=null' or one of its dependencies. The system cannot find the
> > file specified.
> > [rsCompilerErrorInExpression] The Value expression for the textbox
> > â'txtTableField2â' contains an error: [BC30451] Name 'ReportsLibrary' is not
> > declared.
> >
> > So, what am I missing? What do I need to do to get this assembly to work
> > with SSRS?
> >
> > Thanks,
> > Wayne|||Hi Wayne,
You're right - I had to dig around in samples to find it. Difficult to
search on unless one knows to look for "Custom Report Item" in BOL.
Cheers,
Matt
"Wayne" wrote:
> Matt,
> Thanks! this took care of it. If only I had found this documented somewhere...
> "Matt" wrote:
> > Is the .dll copied to the following folder on your development machine:
> > "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies"?
> > --
> > Matt
> >
> >
> > "Wayne" wrote:
> >
> > > I've created a custom assembly (in VB (VS-2005)) for use in some SSRS2005
> > > reports.
> > >
> > > project: ReportsLibrary
> > > Public Class ReportsCodeLibrary
> > > Public Shared Function ReturnXML(MVList as Object, Root As String, Node As
> > > String, Element As String) As String
> > > Dim ReturnString = ""
> > > Dim sParamItem As Object
> > > ReturnString = "<" & Root & ">"
> > > For Each sParamItem In MultiValueList
> > > ReturnString &= "<" & Node & "><" & Element & ">" & sParamItem & "</"
> > > & Element & "></" & Node & ">"
> > > Next
> > > ReturnString &= "</" & Root & ">"
> > > Return (ReturnString)
> > > End Function
> > >
> > > Public Shared Function Format(s As String) As String
> > > Format = left(s,4) & "-" & mid(s,5,2) & "-" & mid(s,7,3) & "-" &
> > > right(s,4)
> > > End Function
> > > End Class
> > >
> > > Each of these functions work properly if I put them in the Code section. But
> > > since they are being used in multiple reports, I want to have the code in one
> > > place and use that assembly.
> > >
> > > The project is compiled in "Release" configuration.
> > > I attach this compiled dll (ReportsLibrary.dll) to the report in the
> > > Report's properties "Reference" section. Since these are Shared functions, I
> > > don't need to define individual classes on that sheet.
> > > When I get this working, I'll copy the dll to the SSRS ReportServer\bin
> > > directory on the SSRS computer.
> > >
> > > On the TextBox's (txtTableField2) Value property, I enter the expression
> > > "=ReportsLibrary.ReportsCodeLibrary.Format(Fields!fieldName.Value)"
> > > When I preview the report in Visual Studio, I get these errors:
> > > [rsErrorLoadingCodeModule] Error while loading code module: â'ReportsLibrary,
> > > Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullâ'. Details: Could not
> > > load file or assembly 'ReportsLibrary, Version=1.0.0.0, Culture=neutral,
> > > PublicKeyToken=null' or one of its dependencies. The system cannot find the
> > > file specified.
> > > [rsCompilerErrorInExpression] The Value expression for the textbox
> > > â'txtTableField2â' contains an error: [BC30451] Name 'ReportsLibrary' is not
> > > declared.
> > >
> > > So, what am I missing? What do I need to do to get this assembly to work
> > > with SSRS?
> > >
> > > Thanks,
> > > Wayne