Problem with authentication prompting whilst fetching a report over the NET

Hi all,
I'm having a problem with accessing a report.
When I test it on my machine (2000 & reporting services installed on same
machine) there's no problem. As soon as I try to access it vie the internet
(I route through no-ip.org) then a window pops up wanting authentication. I
want to do away with this please.
How do I do this so no prompting occurs?
Regards
John.The authentication for a data source can be different for the dev env than
the production env... Go to the data source in the Prod env, and ensure
that something OTHER than prompt for credentials is set for the data
source...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <a@.b.c> wrote in message
news:%23iJ6eE7XFHA.2768@.tk2msftngp13.phx.gbl...
> Hi all,
> I'm having a problem with accessing a report.
> When I test it on my machine (2000 & reporting services installed on same
> machine) there's no problem. As soon as I try to access it vie the
> internet (I route through no-ip.org) then a window pops up wanting
> authentication. I want to do away with this please.
> How do I do this so no prompting occurs?
> Regards
> John.
>

Problem with assebly

I have problems with referensing assebly to my report. I copy my.dll to
\MSSQL\Reporting Services\ReportManager\bin
and
\MSSQL\Reporting Services\ReportServer\bin.
I have added the assembly to the report using the Referecnce tab poniting to \MSSQL\Reporting Services\ReportServer\bin but i still get error File or assembly name AssTest, or one of its dependencies, was not found.
In assebly i have simple function and it's static, i call method like this =Namespace.Class.Method.
Please, help.
AlešI did mistake in path to dll
Aleš
"AG, NLB d.d." wrote:
> I have problems with referensing assebly to my report. I copy my.dll to
> \MSSQL\Reporting Services\ReportManager\bin
> and
> \MSSQL\Reporting Services\ReportServer\bin.
> I have added the assembly to the report using the Referecnce tab poniting to \MSSQL\Reporting Services\ReportServer\bin but i still get error File or assembly name AssTest, or one of its dependencies, was not found.
> In assebly i have simple function and it's static, i call method like this =Namespace.Class.Method.
> Please, help.
> Aleš
>
>sql

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 access to analysis services: repository structure cannot be created

Hello,

I have a problem with Analysis Services. We use this product because it's needed for NetIQ Analysis Center, our OLAP reporting tool.

When I try to open the Analysis Manager, I can see the server but when I try to access it, the following error message is displayed: "repository structure cannot be created on the target server: the specified object cannot be found. For more information, see the section 'service pack installation' in the service pack readme file."

I checked this service pack readme file, but couldn't find anything relevant to this problem.
The files for both the sample foodmart and the NetiQ Analysis Center databases are still on this server, so I suppose something happened with the configuration information of this server, not with the databases themselves.

Event entries in the system and application log files do not reveal anything, nothing points to a problem with OLAP/Analysis Services.

The connection string to this server seems to be ok as well.

Unregistering and reregistering this server does not resolve the problem: as soon as I try to register, the same error message is displayed.

SQl, sqlsrvagent, MSDTC and Olap services are all running.

Did anyone see this behaviour before? Or does anyone know how to resolve or how to at least troubleshoot this particular problem?

Help will be much appreciated!

Timur

This sounds like a corruption issue with your repository although possibly it's as simple as a permissions problem with the relational database the repostitory is stored in.

First check your access to the relational database (SQL or Jet) that the repository is stored in. If this is okay, you can restore the default msmdrep.mdb by resetting the repository connection strings. (provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Analysis services\Bin\msmdrep.mdb) Then you can migrate this to SQL if you wish. It is strongly recommended that you use the native format and not the Meta Data Services (previously named Microsoft Repository) format and the latest services packs will even enforce this during migration)

sql

Problem while using stored procedures with temporary tables in dataset

I am trying to generate a report using SQL Server Reporting Service. The dataset is passed the results from a stored procedure. The stored proc contains a temporary table. On exceuting of proc, it fetches the result but when I try to save dataset I get following error message

Invalid object name '#AdditionalParams'. (.Net SqlClient Data Provider)

And no colums are returned in the data set created.

Any help on this would be appreciated.

Thanks in advance

If possible, try using a table variable instead, or create a physical table first.

http://www.odetocode.com/Articles/365.aspx

Here are some workarounds for temp tables.

http://www.sql-server-performance.com/rd_temp_tables.asp

If you have to, try using set fmtonly off in stored procedure.

http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

cheers,

Andrew

|||

I exceuted the proc as stored procedure. And latter I added a new field to same dataset, as it didnt had any field because it had thrown error. I refreshed the datset and I got all the dataset fields although initally it showed error and it worked.

But their is essentially problem the way datset are handled in reporting service.

Thanks

Problem while using stored procedures with temporary tables in dataset

I am trying to generate a report using SQL Server Reporting Service. The dataset is passed the results from a stored procedure. The stored proc contains a temporary table. On exceuting of proc, it fetches the result but when I try to save dataset I get following error message

Invalid object name '#AdditionalParams'. (.Net SqlClient Data Provider)

And no colums are returned in the data set created.

Any help on this would be appreciated.

Thanks in advance

If possible, try using a table variable instead, or create a physical table first.

http://www.odetocode.com/Articles/365.aspx

Here are some workarounds for temp tables.

http://www.sql-server-performance.com/rd_temp_tables.asp

If you have to, try using set fmtonly off in stored procedure.

http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

cheers,

Andrew

|||

I exceuted the proc as stored procedure. And latter I added a new field to same dataset, as it didnt had any field because it had thrown error. I refreshed the datset and I got all the dataset fields although initally it showed error and it worked.

But their is essentially problem the way datset are handled in reporting service.

Thanks

Problem while converting pdf document to Word.

Hi,
I have a pdf document which is generated from MS SQL Reporting Services.
I am unable to convert the pdf document(which was generated from MS SQL
Reporting Services) To a WORD document USINg SOme tools which i downloaded
from Internet.
The PDF document i generated using Reporting services,has just some static
text.
any idea?
thanks for your reply,
regards
praveenThis problem comes only with pdfs which are generated using MS SQL reporting
Services.
"praveen79" wrote:
> Hi,
> I have a pdf document which is generated from MS SQL Reporting Services.
> I am unable to convert the pdf document(which was generated from MS SQL
> Reporting Services) To a WORD document USINg SOme tools which i downloaded
> from Internet.
> The PDF document i generated using Reporting services,has just some static
> text.
> any idea?
> thanks for your reply,
> regards
> praveen

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 using reporting service

Dear all,
i have installed reporting service a few days ago, but i encounter the
following problems,
my report server is in another machine(rather than localhost, like
most examples on the web), after teh installation, i have made rdl,
and deploy to the server, everything goes fine until i type
http://xxx.xxx.xxx.xxx/Reports to access the report. i can browse the
directories, but dead link shown once i click on teh report.
strange thing is when i type http://xxx.xxx.xxx.xxx/ReportServer/, i
can see the report generated on teh screen. could anyone suggest ways
to solve it?
another problem is i tried to use render() to generate report in my
web site (that is localhost) using the server (xxx.xxx.xxx.xxx), but
error keep sending to me ( The request failed with HTTP status 401:
Access Denied.
), i have added a web reference already, it wont work even i type
http://xxx.xxx.xxx.xxx/retest2/.... in the full path
thank you for helping in advancecontrol your .config files on your server (specially under the reportmanager
folder)
in the .config file, you have the URL of the ReportServer http virtual
folder.
Make sure this parameter = http://xxx.xxx.xxx.xxx/ReportServer/
"jasonymk" <jasonymk@.sinaman.com> a écrit dans le message de news:
a4075300.0409172006.526eb426@.posting.google.com...
> Dear all,
> i have installed reporting service a few days ago, but i encounter the
> following problems,
> my report server is in another machine(rather than localhost, like
> most examples on the web), after teh installation, i have made rdl,
> and deploy to the server, everything goes fine until i type
> http://xxx.xxx.xxx.xxx/Reports to access the report. i can browse the
> directories, but dead link shown once i click on teh report.
> strange thing is when i type http://xxx.xxx.xxx.xxx/ReportServer/, i
> can see the report generated on teh screen. could anyone suggest ways
> to solve it?
> another problem is i tried to use render() to generate report in my
> web site (that is localhost) using the server (xxx.xxx.xxx.xxx), but
> error keep sending to me ( The request failed with HTTP status 401:
> Access Denied.
> ), i have added a web reference already, it wont work even i type
> http://xxx.xxx.xxx.xxx/retest2/.... in the full path
> thank you for helping in advance|||For the second problem set your WS proxy to DefaultCredentials.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23dmIqeanEHA.1800@.TK2MSFTNGP15.phx.gbl...
> control your .config files on your server (specially under the
reportmanager
> folder)
> in the .config file, you have the URL of the ReportServer http virtual
> folder.
> Make sure this parameter = http://xxx.xxx.xxx.xxx/ReportServer/
>
> "jasonymk" <jasonymk@.sinaman.com> a écrit dans le message de news:
> a4075300.0409172006.526eb426@.posting.google.com...
> > Dear all,
> >
> > i have installed reporting service a few days ago, but i encounter the
> > following problems,
> >
> > my report server is in another machine(rather than localhost, like
> > most examples on the web), after teh installation, i have made rdl,
> > and deploy to the server, everything goes fine until i type
> > http://xxx.xxx.xxx.xxx/Reports to access the report. i can browse the
> > directories, but dead link shown once i click on teh report.
> >
> > strange thing is when i type http://xxx.xxx.xxx.xxx/ReportServer/, i
> > can see the report generated on teh screen. could anyone suggest ways
> > to solve it?
> >
> > another problem is i tried to use render() to generate report in my
> > web site (that is localhost) using the server (xxx.xxx.xxx.xxx), but
> > error keep sending to me ( The request failed with HTTP status 401:
> > Access Denied.
> > ), i have added a web reference already, it wont work even i type
> > http://xxx.xxx.xxx.xxx/retest2/.... in the full path
> >
> > thank you for helping in advance
>|||thank you so much for the advice, i will try that later on.
if you have time ,would you see the wuestion i post entitled " 3(should be
2) different conputers problem)?
thanks so much
"Jéjé" wrote:
> control your .config files on your server (specially under the reportmanager
> folder)
> in the .config file, you have the URL of the ReportServer http virtual
> folder.
> Make sure this parameter = http://xxx.xxx.xxx.xxx/ReportServer/
>
> "jasonymk" <jasonymk@.sinaman.com> a écrit dans le message de news:
> a4075300.0409172006.526eb426@.posting.google.com...
> > Dear all,
> >
> > i have installed reporting service a few days ago, but i encounter the
> > following problems,
> >
> > my report server is in another machine(rather than localhost, like
> > most examples on the web), after teh installation, i have made rdl,
> > and deploy to the server, everything goes fine until i type
> > http://xxx.xxx.xxx.xxx/Reports to access the report. i can browse the
> > directories, but dead link shown once i click on teh report.
> >
> > strange thing is when i type http://xxx.xxx.xxx.xxx/ReportServer/, i
> > can see the report generated on teh screen. could anyone suggest ways
> > to solve it?
> >
> > another problem is i tried to use render() to generate report in my
> > web site (that is localhost) using the server (xxx.xxx.xxx.xxx), but
> > error keep sending to me ( The request failed with HTTP status 401:
> > Access Denied.
> > ), i have added a web reference already, it wont work even i type
> > http://xxx.xxx.xxx.xxx/retest2/.... in the full path
> >
> > thank you for helping in advance
>
>|||Thanks Teo,
i think i have done so by follow:
Dim rs As New reportservice.ReportingService
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
' Render the report as an HTML4.0 fragment using the Web service
Dim results As [Byte]()
results =rs.Render("http://xxx.xxx.xxx.xxx/ReportServer/retest2/testreport",
"HTML4.0", Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
Nothing, Nothing, Nothing)
so...i think i have to check he computer setting before i move on...
please have a look to the topic (3 different computers problem)
thanks in advance.
"Teo Lachev" wrote:
> For the second problem set your WS proxy to DefaultCredentials.
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:%23dmIqeanEHA.1800@.TK2MSFTNGP15.phx.gbl...
> > control your .config files on your server (specially under the
> reportmanager
> > folder)
> > in the .config file, you have the URL of the ReportServer http virtual
> > folder.
> > Make sure this parameter = http://xxx.xxx.xxx.xxx/ReportServer/
> >
> >
> > "jasonymk" <jasonymk@.sinaman.com> a écrit dans le message de news:
> > a4075300.0409172006.526eb426@.posting.google.com...
> > > Dear all,
> > >
> > > i have installed reporting service a few days ago, but i encounter the
> > > following problems,
> > >
> > > my report server is in another machine(rather than localhost, like
> > > most examples on the web), after teh installation, i have made rdl,
> > > and deploy to the server, everything goes fine until i type
> > > http://xxx.xxx.xxx.xxx/Reports to access the report. i can browse the
> > > directories, but dead link shown once i click on teh report.
> > >
> > > strange thing is when i type http://xxx.xxx.xxx.xxx/ReportServer/, i
> > > can see the report generated on teh screen. could anyone suggest ways
> > > to solve it?
> > >
> > > another problem is i tried to use render() to generate report in my
> > > web site (that is localhost) using the server (xxx.xxx.xxx.xxx), but
> > > error keep sending to me ( The request failed with HTTP status 401:
> > > Access Denied.
> > > ), i have added a web reference already, it wont work even i type
> > > http://xxx.xxx.xxx.xxx/retest2/.... in the full path
> > >
> > > thank you for helping in advance
> >
> >
>
>

Problem when passing parameters to Reporting services

Hello,
Am new to reporting services and having problems passing parameters.
I am using ASP.Net with .NetFramework 1.1 and am trying out reporting
services 2005.
I am using an object of the ReportExecutionService along with the render
method.
I have tried a few differnet examples and none have worked. Does anyone have
any working piece of code that i can try?
Thanks in advance
Regards
IshanJust to add to the question...
There are at least two Render methods specified in the documentation.
One is a call with 12 parameters one of which is the Report parameters.
The other Render method comes from the ReportExecution service and takes
just 5 parameters and the Report Parameters are set using a call to a separate
SetReportExecutionParameters.
Which of these methods has anyone used successfully ? Getting very strange
errors regarding Parameters from both of these Render routines.

problem when installing sql reporting services 2005(encrypt problem)

Hi,

I am trying to install sql reporting services 2005....i am getting this error

“Error : SQL Server Setup cannot install files to the compressed or encrypted folder: C:\Program Files\Microsoft SQL Server\. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then run SQL Server Setup again.”…

on the same machine sql server 2000 is also installed

Please help me ..its urgent....

Regards,

Pradeep

You may either have a compress or a EFS encrypted folder. This isn′t allowed in SQL Server 2005. Remove the compressions and / or the encryption and try again.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

problem when installing SQL 2005 Reporting services

Dear all,

i have a problem on installing SQL 2005,when i was installing SQL 2005,i select to install all components (DB services,Reporting Services,...etc) except SQL Notification services.

the whole components were intalled properly except the reportingservices it was failed and it gave me Error # : 1603

Machine : Machine Name ####
Product : Microsoft SQL Server 2005 Reporting Services
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0004_XXX_RS.log
Error Number : 1603

when i run the Reporting Configuration manager to try to get the problem,i got this error message :

"The version of DB is in a format is that is not valid, or it can't be read,the found version is C.0.5.43. the expected version is C.0.8.40". To Continue,update the version of the report server database and verify access rights.(rsInvaludRerpotServerDatabase)"

It looks like you are doing an upgrade to RS 2005. Have you tried clicking the "Upgrade" button on the "Database Setup" page of the RS Config tool after selecting the required RS database?

Thanks,
Sharmila

|||

The problem because of i didn't install SP1 for SQL 2005,SP1 contains Hot fixes for RS,and it works fine from the RS Configuration manager after i installed SP1.

Problem when installing MS SQL Reporting Service

Hi,
I need help.
I am trying to install the Reporting Service.
When the screen was in "System Prerequisites Check", it tell me that
visual Studio.NET 2003 is not installed.
After clicking next in "System Prerequisites Check"
It jump to a page called "Welcome to ...SQL Reporting Service SETUP"
and then it automatically jump to a page called "Installing Reporting
Services"
But I haven't selected anything.
Then wait a few minutes, a general error message appears and and tell
me "... was failed to install Reporting Service" with the "Send Report"
and "Don't send" button.
Could anyone get the solution? Thank you very much.I am facing similar problem while installing Reporting Services.
At the "System Prerequisites Check" all checks are OK but at the
"Welcome to Ms SQL Server 2000 Reporting Services Setup" screen I
waited for 10-15 minutes for the NEXT button that never appeared.
Finally, a general error message appears and telling
me "... was failed to install Reporting Service" with the "Send Report"
and "Don't send" button.
Can someone help?|||I have resolved the problem by doing a windows update, shut down all
the active applications. Then proceed with the installation.
Your installer may be corrupted if this doesn't help.

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 when accessing RS using fully qualified name or IP.

Hi,
I am using Reporting Services 2000 running on Win2k3. I have admin rights
for this machine.
Everything works just great if I am accessing Reporting services in our
intranet using http://server1/reports or http://server1/reportserver
But, When I view reports using fully qualified name e.g.
http://server1.mydomain.com/reports after entering username/password it shows
first page and when I click on any report item I get "The page cannot be
displayed" in the bottom frame.
Weird thing is if I access reports using
http://server1.mydomain.com/reportserver (simple file browse view) instead
of http://server1.mydomain.com/reports everything works fine.
Here is what I have tried after reading several posts.
I edited RSWebApplication.config located at
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\
Old setting:
<ReportServerUrl>http://server1/ReportServer</ReportServerUrl>
New Setting:
<ReportServerUrl>http://server1.mydomain.com/ReportServer</ReportServerUrl>
When I apply the above setting I get the following error on the very first
page.
"The request failed with HTTP status 401: Unauthorized. "
I also edited RSReportServer.config located under \ReportServer folder but
still same error.
"The request failed with HTTP status 401: Unauthorized. "
Any help will be greatly appreciated.
Thx!
--
Nayan Patel (MCSE, MCDBA, MCSD.net)
www.binaryworld.net
A Powerful Knowledge Sharing PlatformHelloooo guys, I found the solution.
After reading MSDN I found that <ReportServerExternalUrl> tag must be added
to use FQDN so you can access RS over internet. Report manager will use this
URL to redirect to the report server.
Modify the RSWebApplication.Config file located under \ReportManager folder
as below
e.g.
<UI>
<ReportServerUrl>http://server1/ReportServer</ReportServerUrl>
<ReportServerExternalUrl>http://server1.mydomain.com/ReportServer</ReportServerExternalUrl>
</UI>
Correction to MSDN statement.
====================MSDN has half way correct information. MSDN states <ReportServerURL> must be
added but it has to be <ReportServerUrl> instead <ReportServerURL> (Note:
XML is case sensitive).
If you enter <ReportServerURL> instead <ReportServerUrl> you will get the
following error.
"The configuration file contains an element that is not valid. The
ReportServerExternalURL element is not a configuration file element."
Nayan Patel (MCSE, MCDBA, MCSD.net)
www.binaryworld.net
A Powerful Knowledge Sharing Platform
"Nayan" wrote:
> Hi,
> I am using Reporting Services 2000 running on Win2k3. I have admin rights
> for this machine.
> Everything works just great if I am accessing Reporting services in our
> intranet using http://server1/reports or http://server1/reportserver
> But, When I view reports using fully qualified name e.g.
> http://server1.mydomain.com/reports after entering username/password it shows
> first page and when I click on any report item I get "The page cannot be
> displayed" in the bottom frame.
> Weird thing is if I access reports using
> http://server1.mydomain.com/reportserver (simple file browse view) instead
> of http://server1.mydomain.com/reports everything works fine.
> Here is what I have tried after reading several posts.
> I edited RSWebApplication.config located at
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\
> Old setting:
> <ReportServerUrl>http://server1/ReportServer</ReportServerUrl>
> New Setting:
> <ReportServerUrl>http://server1.mydomain.com/ReportServer</ReportServerUrl>
> When I apply the above setting I get the following error on the very first
> page.
> "The request failed with HTTP status 401: Unauthorized. "
> I also edited RSReportServer.config located under \ReportServer folder but
> still same error.
> "The request failed with HTTP status 401: Unauthorized. "
> Any help will be greatly appreciated.
> Thx!
> --
> Nayan Patel (MCSE, MCDBA, MCSD.net)
> www.binaryworld.net
> A Powerful Knowledge Sharing Platform
>

Problem w/ Dynamic Query

I'm having problems constructing a dynamic query on the Data tab in SQL Reporting Services. When I try to use one of the reporting parameters it fails with "The expression for the query â'Dataâ' contains an error: [BC30648] String constants must end with a double quote." I want to be able to append the value of the chain the user selected to the end of the query. Anyone have any ideas.
My query is:
="SELECT {{[Product].[All Product]}*{Descendants([Market].[All Market].[Bob Jones])}} on rows,
{{[Time].[All Time].[2003-01-01 00:00:00].[2003-05-16 00:00:00],
[Time].[All Time].[2004-01-01 00:00:00].[2004-05-16 00:00:00],
[Time].[All Time].[2003-01-01 00:00:00].[2003-06-16 00:00:00],
[Time].[All Time].[2004-01-01 00:00:00].[2004-06-16 00:00:00]}
*{[Dollar Volume]}} on columns FROM " & Parameters!Chain.Value
If I get rid of the parameter and just end the query with a hard coded chain it works.Did you try appending a CStr(Parameters!Chain.Value) instead?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karch" <Karch@.discussions.microsoft.com> wrote in message
news:A1A5AB61-FFAC-49C3-A300-290A7C85906C@.microsoft.com...
> I'm having problems constructing a dynamic query on the Data tab in SQL
Reporting Services. When I try to use one of the reporting parameters it
fails with "The expression for the query â'Dataâ' contains an error:
[BC30648] String constants must end with a double quote." I want to be able
to append the value of the chain the user selected to the end of the query.
Anyone have any ideas.
> My query is:
> ="SELECT {{[Product].[All Product]}*{Descendants([Market].[All
Market].[Bob Jones])}} on rows,
> {{[Time].[All Time].[2003-01-01 00:00:00].[2003-05-16 00:00:00],
> [Time].[All Time].[2004-01-01 00:00:00].[2004-05-16 00:00:00],
> [Time].[All Time].[2003-01-01 00:00:00].[2003-06-16 00:00:00],
> [Time].[All Time].[2004-01-01 00:00:00].[2004-06-16 00:00:00]}
> *{[Dollar Volume]}} on columns FROM " & Parameters!Chain.Value
> If I get rid of the parameter and just end the query with a hard coded
chain it works.|||Parameterized MDX queries are not supported by the OleDB provider for OLAP
8.0. Therefore you have to use an expression-based query (in the text-based
generic query designer).
Since you cannot execute expression-based queries directly in the query
designer, you should first design your report based on a MDX query _without_
parameters, detect the fields and design the report.
When you are done, you would convert the MDX query into an expression-based
MDX query (as you tried initially). Before doing that, you might want to add
a textbox somewhere in your report and experiment with the expression till
it evaluates to a valid MDX query and then copy the expression into the
query designer.
You might also want to check out a sample available for download:
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
Additional information on the integration of RS 2000 and AS 2000 is provided
at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karch" <Karch@.discussions.microsoft.com> wrote in message
news:AC5B0D16-5C07-4258-AF6C-EC6925180DE0@.microsoft.com...
> I looked at it again. I think the problem is that parameters are not
supported with the OLE DB provider. The report I'm generating is hitting a
cube.
> Query:
> SELECT {{[Product].[All Product]}*{Descendants([Market].[All
Market].[East - Bob Jones])}} on rows, {{[Time].[All Time].[2003-01-01
00:00:00].[2003-05-18 00:00:00], [Time].[All Time].[2004-01-01
00:00:00].[2004-05-16 00:00:00], [Time].[All Time].[2003-01-01
00:00:00].[2003-06-15 00:00:00], [Time].[All Time].[2004-01-01
00:00:00].[2004-06-13 00:00:00]}*{[Dollar Volume]}} on columns FROM @.Chain
> @.Chain is mapped to "=Parameters!Chain.Value" in the DataSet.
> Error:
> Could not generate a list of fields for the query. Check the query syntax
or click Refresh Fields on the query toolbar. The ICommandWithParameters
interface is not supported by the 'MSOLAP.2' provider. Command parameters
are unsupported with the current provider.
>
> "Ravi Mumulla (Microsoft)" wrote:
> > Did you try appending a CStr(Parameters!Chain.Value) instead?
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > "Karch" <Karch@.discussions.microsoft.com> wrote in message
> > news:A1A5AB61-FFAC-49C3-A300-290A7C85906C@.microsoft.com...
> > > I'm having problems constructing a dynamic query on the Data tab in
SQL
> > Reporting Services. When I try to use one of the reporting parameters
it
> > fails with "The expression for the query â?~Dataâ?T contains an error:
> > [BC30648] String constants must end with a double quote." I want to be
able
> > to append the value of the chain the user selected to the end of the
query.
> > Anyone have any ideas.
> > >
> > > My query is:
> > > ="SELECT {{[Product].[All Product]}*{Descendants([Market].[All
> > Market].[Bob Jones])}} on rows,
> > > {{[Time].[All Time].[2003-01-01 00:00:00].[2003-05-16 00:00:00],
> > > [Time].[All Time].[2004-01-01 00:00:00].[2004-05-16 00:00:00],
> > > [Time].[All Time].[2003-01-01 00:00:00].[2003-06-16 00:00:00],
> > > [Time].[All Time].[2004-01-01 00:00:00].[2004-06-16 00:00:00]}
> > > *{[Dollar Volume]}} on columns FROM " & Parameters!Chain.Value
> > >
> > > If I get rid of the parameter and just end the query with a hard coded
> > chain it works.
> >
> >
> >|||First Prize.
Thanks for the assistance. Sure helped me alot
"Robert Bruckner [MSFT]" wrote:
> Parameterized MDX queries are not supported by the OleDB provider for OLAP
> 8.0. Therefore you have to use an expression-based query (in the text-based
> generic query designer).
> Since you cannot execute expression-based queries directly in the query
> designer, you should first design your report based on a MDX query _without_
> parameters, detect the fields and design the report.
> When you are done, you would convert the MDX query into an expression-based
> MDX query (as you tried initially). Before doing that, you might want to add
> a textbox somewhere in your report and experiment with the expression till
> it evaluates to a valid MDX query and then copy the expression into the
> query designer.
> You might also want to check out a sample available for download:
> http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
> Additional information on the integration of RS 2000 and AS 2000 is provided
> at:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Karch" <Karch@.discussions.microsoft.com> wrote in message
> news:AC5B0D16-5C07-4258-AF6C-EC6925180DE0@.microsoft.com...
> > I looked at it again. I think the problem is that parameters are not
> supported with the OLE DB provider. The report I'm generating is hitting a
> cube.
> >
> > Query:
> > SELECT {{[Product].[All Product]}*{Descendants([Market].[All
> Market].[East - Bob Jones])}} on rows, {{[Time].[All Time].[2003-01-01
> 00:00:00].[2003-05-18 00:00:00], [Time].[All Time].[2004-01-01
> 00:00:00].[2004-05-16 00:00:00], [Time].[All Time].[2003-01-01
> 00:00:00].[2003-06-15 00:00:00], [Time].[All Time].[2004-01-01
> 00:00:00].[2004-06-13 00:00:00]}*{[Dollar Volume]}} on columns FROM @.Chain
> >
> > @.Chain is mapped to "=Parameters!Chain.Value" in the DataSet.
> >
> > Error:
> > Could not generate a list of fields for the query. Check the query syntax
> or click Refresh Fields on the query toolbar. The ICommandWithParameters
> interface is not supported by the 'MSOLAP.2' provider. Command parameters
> are unsupported with the current provider.
> >
> >
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > Did you try appending a CStr(Parameters!Chain.Value) instead?
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "Karch" <Karch@.discussions.microsoft.com> wrote in message
> > > news:A1A5AB61-FFAC-49C3-A300-290A7C85906C@.microsoft.com...
> > > > I'm having problems constructing a dynamic query on the Data tab in
> SQL
> > > Reporting Services. When I try to use one of the reporting parameters
> it
> > > fails with "The expression for the query â?~Dataâ?T contains an error:
> > > [BC30648] String constants must end with a double quote." I want to be
> able
> > > to append the value of the chain the user selected to the end of the
> query.
> > > Anyone have any ideas.
> > > >
> > > > My query is:
> > > > ="SELECT {{[Product].[All Product]}*{Descendants([Market].[All
> > > Market].[Bob Jones])}} on rows,
> > > > {{[Time].[All Time].[2003-01-01 00:00:00].[2003-05-16 00:00:00],
> > > > [Time].[All Time].[2004-01-01 00:00:00].[2004-05-16 00:00:00],
> > > > [Time].[All Time].[2003-01-01 00:00:00].[2003-06-16 00:00:00],
> > > > [Time].[All Time].[2004-01-01 00:00:00].[2004-06-16 00:00:00]}
> > > > *{[Dollar Volume]}} on columns FROM " & Parameters!Chain.Value
> > > >
> > > > If I get rid of the parameter and just end the query with a hard coded
> > > chain it works.
> > >
> > >
> > >
>
>

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 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 using Windows Authentication

Hello,
I have just installed Reporting Services and was able to figure out
pretty much everything, with the exception of using Windows
Authentication.
As I am an administrator on the machine on which Reporting Services is
running, I am able to successfully log in. However, no other accounts
are able to gain access even though these accounts are in the same
domain as the machine. Other people are simply prompted for a
username/password, and are denied access.
At first I thought that this was an issue with the way the
application's users were configured. I added a few accounts to tha
application via the Reporting Service's web interface and assigned
some roles. However, the same problem persists.
When I enable anonymous access to the application via IIS, everyone is
able to log in, so I know that the application is at least
accessible. Unfortunatly, anonymous access is not a viable option.
I readily admit that I am a novice, and I would not be surprised to
find that I have overlooked a simple configuration issue somewhere.
Please help!
Thanks,
tcbThey should not be getting prompted. First, does the machine running RS
using a fixed IP address?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"baker2g" <tcbakes@.gmail.com> wrote in message
news:1187038113.665332.22320@.x40g2000prg.googlegroups.com...
> Hello,
> I have just installed Reporting Services and was able to figure out
> pretty much everything, with the exception of using Windows
> Authentication.
> As I am an administrator on the machine on which Reporting Services is
> running, I am able to successfully log in. However, no other accounts
> are able to gain access even though these accounts are in the same
> domain as the machine. Other people are simply prompted for a
> username/password, and are denied access.
> At first I thought that this was an issue with the way the
> application's users were configured. I added a few accounts to tha
> application via the Reporting Service's web interface and assigned
> some roles. However, the same problem persists.
> When I enable anonymous access to the application via IIS, everyone is
> able to log in, so I know that the application is at least
> accessible. Unfortunatly, anonymous access is not a viable option.
> I readily admit that I am a novice, and I would not be surprised to
> find that I have overlooked a simple configuration issue somewhere.
> Please help!
> Thanks,
> tcb
>|||On Aug 13, 1:57 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> They should not be getting prompted. First, does the machine running RS
> using a fixed IP address?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "baker2g" <tcba...@.gmail.com> wrote in message
> news:1187038113.665332.22320@.x40g2000prg.googlegroups.com...
>
> > Hello,
> > I have just installed Reporting Services and was able to figure out
> > pretty much everything, with the exception of using Windows
> > Authentication.
> > As I am an administrator on the machine on which Reporting Services is
> > running, I am able to successfully log in. However, no other accounts
> > are able to gain access even though these accounts are in the same
> > domain as the machine. Other people are simply prompted for a
> > username/password, and are denied access.
> > At first I thought that this was an issue with the way the
> > application's users were configured. I added a few accounts to tha
> > application via the Reporting Service's web interface and assigned
> > some roles. However, the same problem persists.
> > When I enable anonymous access to the application via IIS, everyone is
> > able to log in, so I know that the application is at least
> > accessible. Unfortunatly, anonymous access is not a viable option.
> > I readily admit that I am a novice, and I would not be surprised to
> > find that I have overlooked a simple configuration issue somewhere.
> > Please help!
> > Thanks,
> > tcb- Hide quoted text -
> - Show quoted text -
Thanks for the response!
I don't think that the machine is using a fixed IP addresss. I have
deployed RS on my local box and have had people test it by using my IP
address (http://<ipaddress>/Reports). Although the IP address is not
static, it does not change frequently and should be fine while I am
playing aroung with RS. People were able to access the app when
anonymous access was turned on, so I know that people can access the
RS app when authentication is removed from the equation.
Thanks,
tcb|||I had a weird issue with a server of mine where it would prompt for username
and password when it should not have. The issue went away once I gave it a
fixed IP address. As far as anonymous working, well when anonymous it
doesn't care who you are so it is not doing the same actions.
If you can give it a fixed IP address and at least see if your being
prompted goes away.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"baker2g" <tcbakes@.gmail.com> wrote in message
news:1187040249.518255.134720@.j4g2000prf.googlegroups.com...
> On Aug 13, 1:57 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> They should not be getting prompted. First, does the machine running RS
>> using a fixed IP address?
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "baker2g" <tcba...@.gmail.com> wrote in message
>> news:1187038113.665332.22320@.x40g2000prg.googlegroups.com...
>>
>> > Hello,
>> > I have just installed Reporting Services and was able to figure out
>> > pretty much everything, with the exception of using Windows
>> > Authentication.
>> > As I am an administrator on the machine on which Reporting Services is
>> > running, I am able to successfully log in. However, no other accounts
>> > are able to gain access even though these accounts are in the same
>> > domain as the machine. Other people are simply prompted for a
>> > username/password, and are denied access.
>> > At first I thought that this was an issue with the way the
>> > application's users were configured. I added a few accounts to tha
>> > application via the Reporting Service's web interface and assigned
>> > some roles. However, the same problem persists.
>> > When I enable anonymous access to the application via IIS, everyone is
>> > able to log in, so I know that the application is at least
>> > accessible. Unfortunatly, anonymous access is not a viable option.
>> > I readily admit that I am a novice, and I would not be surprised to
>> > find that I have overlooked a simple configuration issue somewhere.
>> > Please help!
>> > Thanks,
>> > tcb- Hide quoted text -
>> - Show quoted text -
> Thanks for the response!
> I don't think that the machine is using a fixed IP addresss. I have
> deployed RS on my local box and have had people test it by using my IP
> address (http://<ipaddress>/Reports). Although the IP address is not
> static, it does not change frequently and should be fine while I am
> playing aroung with RS. People were able to access the app when
> anonymous access was turned on, so I know that people can access the
> RS app when authentication is removed from the equation.
> Thanks,
> tcb
>

Problem Using Stored Procedures in Report Datasets

I have a local Reporting Services report that I am modifying to use a stored procedure.

Although I am executing a stored procedure in the dataset query window, I also have to run a SELECT statement to retrieve the fields from a table that will populate the report.

The code that I have in the dataset query window looks like the following:

EXECUTE @.retCode = RunClaimVerification @.parmID, @.parmDate, @.parmRecordID OUTPUT

SELECT *

FROM ClaimsDetail

WHERE ClaimRecordID = @.parmRecordID

When I execute this code, the only results that are returned SEEM TO BE the return code associated with running the stored procedure.

I thought about putting the SELECT code in the stored procedure and returning a table or a cursor from the stored procedure BUT it looks like tables are not supported as Report Parameter data types.

The stored procedure code generates Claim data that is stored in a SQL Table. The fields in this SQL table need to be retrieved by a unique record id to populate the fields in the report.

Does anybody have any suggestions as to how to go about doing this OR any suggestions that would help me resolve this problem?

Reporting Services only allows one result (table or the return value of a stored procedure) to be retrieved per query. This is the reason that only the return code seems to be included in the dataset. Also, out parameters for stored procedures are not supported in Reporting Services.

Try changing the stored procedure to also Select the data from the ClaimsDetail table, and return the resultant table instead of the return code. However, don't set the return value to a parameter--just execute the stored procedure. This should produce a dataset containing the results of the Select statement.

Ian