Actions not appearing in Cube browser

Hello,

I'm reading AS 2005 step by step and have set up two url actions but none of them appear in the context menu when i click on the rows.

I've also tried setting up an URL action which points to http://google.com and I Would presume it would appear when i right clicked on a cell in the cube but nothing appears.

side note: I created a drillthrough action and that works.

please help

Hi,

try to have a look here:

http://www.databasejournal.com/features/mssql/article.php/10894_3647056_1

Francesco

|||Hi,
read it already. didn't help me with anything.

Accessing URL

Hi!

I have two assets: a URL that points to an XML file, and a stored procedure that can accept this file as a text variable and store it in a SQL 2005 table.

create procedure [dbo].[insertObjects]

@.availabilityXml text

as

DECLARE @.xmlHndAdd INT

EXEC sp_xml_prepareDocument @.xmlHndAdd OUTPUT, @.availabilityXml

TRUNCATE TABLE Objects

INSERTObjects

SELECT *

FROM OPENXML(@.xmlHndAdd, '//NewDataSet/Table1', 2)
WITH Objects

Now, I need to find a solution to combine the URL with the proc.Does anyone have any suggestions on how I can pass my URL as a text variable to the procedure?SSIS, vb-script, etc. are welcome!

Thank you!

I believe these are your choices:

a) Store the data into a table through the URL and read it, this approach is mentioned here ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/dff99404-a002-48ee-910e-f37f013d946d.htm (Bulk Importing and Exporting XML Documents) in the SQL Server BOL.

b) Use OPENXML for loading data into a variable. This approach is given here: http://www.perfectxml.com/articles/xml/importxmlsql.asp#openxml

Hope this helps.

Thanks

Waseem

|||Thanks for the reply! I used the a approach, and it's working!|||Which approach did you use?|||OPENXML (b)

Accessing URL

Hi!

I have two assets: a URL that points to an XML file, and a stored procedure that can accept this file as a text variable and store it in a SQL 2005 table.

create procedure [dbo].[insertObjects]

@.availabilityXml text

as

DECLARE @.xmlHndAdd INT

EXEC sp_xml_prepareDocument @.xmlHndAdd OUTPUT, @.availabilityXml

TRUNCATE TABLE Objects

INSERTObjects

SELECT *

FROM OPENXML(@.xmlHndAdd, '//NewDataSet/Table1', 2)
WITH Objects

Now, I need to find a solution to combine the URL with the proc.Does anyone have any suggestions on how I can pass my URL as a text variable to the procedure?SSIS, vb-script, etc. are welcome!

Thank you!

I believe these are your choices:

a) Store the data into a table through the URL and read it, this approach is mentioned here ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/dff99404-a002-48ee-910e-f37f013d946d.htm (Bulk Importing and Exporting XML Documents) in the SQL Server BOL.

b) Use OPENXML for loading data into a variable. This approach is given here: http://www.perfectxml.com/articles/xml/importxmlsql.asp#openxml

Hope this helps.

Thanks

Waseem

|||Thanks for the reply! I used the a approach, and it's working!|||Which approach did you use?|||OPENXML (b)

Accessing URL

Hi!

I have two assets: a URL that points to an XML file, and a stored procedure that can accept this file as a text variable and store it in a SQL 2005 table.

create procedure [dbo].[insertObjects]

@.availabilityXml text

as

DECLARE @.xmlHndAdd INT

EXEC sp_xml_prepareDocument @.xmlHndAdd OUTPUT, @.availabilityXml

TRUNCATE TABLE Objects

INSERTObjects

SELECT *

FROM OPENXML(@.xmlHndAdd, '//NewDataSet/Table1', 2)
WITH Objects

Now, I need to find a solution to combine the URL with the proc.Does anyone have any suggestions on how I can pass my URL as a text variable to the procedure?SSIS, vb-script, etc. are welcome!

Thank you!

I believe these are your choices:

a) Store the data into a table through the URL and read it, this approach is mentioned here ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/dff99404-a002-48ee-910e-f37f013d946d.htm (Bulk Importing and Exporting XML Documents) in the SQL Server BOL.

b) Use OPENXML for loading data into a variable. This approach is given here: http://www.perfectxml.com/articles/xml/importxmlsql.asp#openxml

Hope this helps.

Thanks

Waseem

|||Thanks for the reply! I used the a approach, and it's working!|||Which approach did you use?|||OPENXML (b)

Accessing Reports via URL

I have configured my report server. I can connect to it via Management
Studio and via http://localhost/reports however when I try to connect via
http://servername/reports I get a Windows style password box. What user is
it expecting? Regards, Chris.Ignore me it seems to be working now
"Fresno Bob" <nospam@.nospam.com> wrote in message
news:u7VfBfz7HHA.2476@.TK2MSFTNGP05.phx.gbl...
>I have configured my report server. I can connect to it via Management
>Studio and via http://localhost/reports however when I try to connect via
>http://servername/reports I get a Windows style password box. What user is
>it expecting? Regards, Chris.
>

Accessing reports through URL

Hello, All !!

I'm now getting problems with access reports through URL.
The situation is:
I'm posting the form to the frame, action attribute's URL includes
querystring.
Also I have some inputs in the form.
I'm using method=post.

Problem is that Report Server ignores parameters from query of the action.

I think it should work with them but it doesn't.

If anyone knows what's the matter here, please !

Thank you,
Alexander Yaremchuk

What version of the SQL RS are you using. The latest SQL 2005 CTP drop had this bug, which has been fixed since then.
Thanks
Tudor

accessing reports securely through ASP

Hej
I'm new to Reporting Services. I'm using RS 2005, ASP 2.0 and VS 2003.
I've created the reports and have been using a URL link in my ASP site to
ReportServer/Pages/ReportViewer.aspx?%2fFOLDER%2fREPORT for viewing the
reports. When the reports are accessed outside the server, the browser
requires username and password. This isn't desired.
Whats the best way to handle this? If I switch to VS 2005 does the
ReportViewer control handle this? Is it possible/safe to change the user
rights for ReportViewer.aspx? Its important not to allow users access to the
Report Manager, but can the rights to viewing individual reports be handled
through there?
I appreciate any advise on the matter.On Mar 14, 2:27 pm, jknurek <jknu...@.discussions.microsoft.com> wrote:
> Hej
> I'm new to Reporting Services. I'm using RS 2005, ASP 2.0 and VS 2003.
> I've created the reports and have been using a URL link in my ASP site to
> ReportServer/Pages/ReportViewer.aspx?%2fFOLDER%2fREPORT for viewing the
> reports. When the reports are accessed outside the server, the browser
> requires username and password. This isn't desired.
> Whats the best way to handle this? If I switch to VS 2005 does the
> ReportViewer control handle this? Is it possible/safe to change the user
> rights for ReportViewer.aspx? Its important not to allow users access to the
> Report Manager, but can the rights to viewing individual reports be handled
> through there?
> I appreciate any advise on the matter.
I believe that there is a way to control (minimally) access to reports
in the Report Manager interface (check the top right-hand side of the
main page). Also you can control user access through the application
(as far as, not showing the user a link to the Report Server, etc).
Sometimes the login is required when the user accesses the Report
Server from Mozilla or Firefox (whereas, w/Internet WExplorer, it may
not happen). Also, you can check the Directory Security for the
Reports and Report Server Virtual Directories in IIS to check for
Windows Authentication, anonymous access, etc (via right-clicking My
Computer, select 'Manage' and go to Services and Applications ->
Internet Information Services -> Web Sites -> Default Web and right-
clicking the Reports or ReportServer Virtual Directory and selecting
Properties and the 'Directory Security' tab). Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Accessing report through URL not getting prompted for parameters

I'm accessing my report through a URL:
http://reportserver/ReportServer?/Folder/ReportName&rs:Command=Render&rs:Format=CSV&rc:Parameters=true

I am getting an error: This report requires a default or user-defined
value for the report parameter 'beg_dt'. To run or subscribe to this
report, you must provide a parameter value.
(rsReportParameterValueNotSet) Get Online Help

I do not want to pass the report parameters (to and from dates) through
the URL. I want the dates to be entered by the user running the
report. If I enter default parameters in Report Manager I am not prompted
for the dates.

This will depend on what render format you want to specify in the URL. For rs:format=CSV, you will either need to have default parameters or specify in the URL. You cannot specify parameters to that format post render.

If you are using rs:format=HTML4.0 in the report viewer(report manager or report server), you do not have to specify the parameters. You should be prompted if the parameters are set to prompt with no default values. If you have default values, the report will execute.

Accessing report server

hi!!
i have a pb when i submit the reprtserver URL http://myserver/reportserver
msg from the browser : The permissions granted to user 'SRVBMAPACCE1\IUSR_SRVBMAPACCE1' are insufficient for performing this operation. (rsAccessDenied)
what should i do ?Explicitly add the user in report manager and give them Browser role.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tino" <Tino@.discussions.microsoft.com> wrote in message
news:1AB86E67-D836-4F02-BFEC-4FF6E90EDB72@.microsoft.com...
> hi!!
> i have a pb when i submit the reprtserver URL http://myserver/reportserver
> msg from the browser : The permissions granted to user
'SRVBMAPACCE1\IUSR_SRVBMAPACCE1' are insufficient for performing this
operation. (rsAccessDenied)
> what should i do ?|||Add IUSR to the Reporting Services folder on the file system. Make
sure to replicate the permissions to the items underneath that folder
too.
"Tino" <Tino@.discussions.microsoft.com> wrote in message news:<1AB86E67-D836-4F02-BFEC-4FF6E90EDB72@.microsoft.com>...
> hi!!
> i have a pb when i submit the reprtserver URL http://myserver/reportserver
> msg from the browser : The permissions granted to user 'SRVBMAPACCE1\IUSR_SRVBMAPACCE1' are insufficient for performing this operation. (rsAccessDenied)
> what should i do ?

Accessing report builder from client machine?

Accessing report builder from client machine in which there is no sql server with the url http://<server name>>/reports. The report builder tab is not getting displayed.

when accessing from http://<server name>/reportserver/reportbuilder/reportbuilder.application it gets connected to the report model but when we are running the report it say the user doesnt have sufficient permissions or database can not be processed.

The permission is given to the user on the data source. For admin permission the report is running fine.

Do anybody know the procedure to run adhoc reports from client machine?

Urgent!!

Not being able to see the Report Button means that the user doesn't have the necessary rights to run Report Builder. The user must have rights to the Execute Report Definitions system task and the Report Builder user role tasks.|||

well, I can see the report builder button from client machine. But When I click on it, I go the following Error.

"Can not retrieve Application. Authentication Error."

I am sure that I have full rights to run report builder. any help will be appreciated.

Thank you

Accessing report builder from client machine?

Accessing report builder from client machine in which there is no sql server with the url http://<server name>>/reports. The report builder tab is not getting displayed.

when accessing from http://<server name>/reportserver/reportbuilder/reportbuilder.application it gets connected to the report model but when we are running the report it say the user doesnt have sufficient permissions or database can not be processed.

The permission is given to the user on the data source. For admin permission the report is running fine.

Do anybody know the procedure to run adhoc reports from client machine?

Urgent!!

Not being able to see the Report Button means that the user doesn't have the necessary rights to run Report Builder. The user must have rights to the Execute Report Definitions system task and the Report Builder user role tasks.|||

well, I can see the report builder button from client machine. But When I click on it, I go the following Error.

"Can not retrieve Application. Authentication Error."

I am sure that I have full rights to run report builder. any help will be appreciated.

Thank you

Accessing One''s ReportServer Homepage from Other''s Machines

Hi,

My Reportserver Homepage is http://d620xp/Reports

Requirement is that Users should be able to view all the reports from this URL( from their Desktops)

What are the steps I need to do, to get this ?

Thanks in Advance,

Sundar

What happens when you enter http://d620xp/Reports in other machine's web browsers?

|||

Grant Privileges to the required users. After this when use opens this URL they should be able to see all the deployed reports...|||

Hi,

When Users type the ReportServer URL, they are seeing the Homepage but all the folders ( Datasources, Models and reports) are missing.

Is thr a way to enable Users to see all the Reports ?

Thanks,

Sundar

|||

Hi,

Thanks for your Reply.

How do I grant priviledges to Users ?

Should I do it through ReportManager Homepage or through IIS Site settings ?

Regards,

Sundar

|||You have to grant the correct permissions to the users. Right now, it appears that it is set to the most restrictive permissions.

|||

Sundar1234 wrote:

Hi,

Thanks for your Reply.

How do I grant priviledges to Users ?

Should I do it through ReportManager Homepage or through IIS Site settings ?

Regards,

Sundar

Through reportmanager. Click properties and add the proper role assignments.

|||

Greg,

Under Properties->Security, I have the following:

BUILTIN\Administrators

> Browser, Content Manager, My Reports, Publisher, Report Builder

D620xp\Guest Browser, Everyone

How do I proceed from here ?

Any help is appreciated !

Thanks,

Sundar

|||

Sundar1234 wrote:

Greg,

Under Properties->Security, I have the following:

BUILTIN\Administrators

> Browser, Content Manager, My Reports, Publisher, Report Builder

D620xp\Guest Browser, Everyone

How do I proceed from here ?

Any help is appreciated !

Thanks,

Sundar

Although I've never needed to do this, I would think that you would want D620xp\Guest to have access to My Reports, Report Builder, Browser, Everyone.

Possibly even Content Manager and Publisher if you trust them with that.

Right now your rights for the Guest account are too restrictive.