Need Help !- [Apply] & [OK] buttons wont work in Report Manager

After installing RS, none of the [OK] or {apply] buttons work to make any
security or config changes.
When i click on them nothing at all happens.Do you have anonymous access enabled for the website. Report Manager does
not allow any administrative type functionality as anonymous.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
> After installing RS, none of the [OK] or {apply] buttons work to make any
> security or config changes.
> When i click on them nothing at all happens.
>
>|||No Anonymous allowed.
As a last troubleshooting step i did a default install of IIS, enabled
ASP.Net, Installed RS. Installed RS SP
I am running RS 2000, on Windows 2003
I need to make this work, anu other ideas ?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uUDCIr84FHA.3416@.TK2MSFTNGP15.phx.gbl...
> Do you have anonymous access enabled for the website. Report Manager does
> not allow any administrative type functionality as anonymous.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
> news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
>> After installing RS, none of the [OK] or {apply] buttons work to make any
>> security or config changes.
>> When i click on them nothing at all happens.
>>
>|||By default the only user that has these rights have to be part of the
administors group on the server (the local group). You can have other
local/domain groups with a role to do this but you need to do it. Have you
tried from the server logged in as administrator (or as someone in the
administrators group?)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:OA4GFv84FHA.2616@.TK2MSFTNGP12.phx.gbl...
> No Anonymous allowed.
> As a last troubleshooting step i did a default install of IIS, enabled
> ASP.Net, Installed RS. Installed RS SP
> I am running RS 2000, on Windows 2003
> I need to make this work, anu other ideas ?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uUDCIr84FHA.3416@.TK2MSFTNGP15.phx.gbl...
>> Do you have anonymous access enabled for the website. Report Manager does
>> not allow any administrative type functionality as anonymous.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
>> news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
>> After installing RS, none of the [OK] or {apply] buttons work to make
>> any security or config changes.
>> When i click on them nothing at all happens.
>>
>>
>|||I had the same problem and here's what I did to fix it. Apparently, my
IIS was configured so that the ASP_NET's webuivalidation.js wasn't able
to load. This somehow prevented any of the buttons on the ReportServer
to work.
And I fixed it based on the same advice given to you by Bruce here. I
think what he means you should TURN ON Anonymous access.
Give this a try...see if you can point your browser to:
http://your-root/aspnet_client/system_web/1_1_4322/WebUIValidation.js
and see if you can see it. (assuming you're using the same version
ASP.NET I am).
I fixed it by going into my IIS settings -> Directory Security -> and
checking the box "Anonymous Access."
David J. Cartwright wrote:
> No Anonymous allowed.
> As a last troubleshooting step i did a default install of IIS, enabled
> ASP.Net, Installed RS. Installed RS SP
> I am running RS 2000, on Windows 2003
> I need to make this work, anu other ideas ?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uUDCIr84FHA.3416@.TK2MSFTNGP15.phx.gbl...
>>Do you have anonymous access enabled for the website. Report Manager does
>>not allow any administrative type functionality as anonymous.
>>
>>--
>>Bruce Loehle-Conger
>>MVP SQL Server Reporting Services
>>"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
>>news:eaBXkQ84FHA.1864@.TK2MSFTNGP12.phx.gbl...
>>After installing RS, none of the [OK] or {apply] buttons work to make any
>>security or config changes.
>>When i click on them nothing at all happens.
>>
>>
>

Need an example for CROSS APPLY!

Does anybody knows, how this cross apply works'
I need a simple example, because I have no idea what it's for!
(I can't found any good example in the net!?!?)
thanks in advance...This is not a great example as the query would be better done with a join,
but it should help you understand the syntax:
USE AdventureWorks
GO
CREATE FUNCTION GetLineItemsForOrder(@.SalesOrderID INT)
RETURNS TABLE
AS
RETURN
(
SELECT SalesOrderDetailID
FROM Sales.SalesOrderDetail
WHERE SalesOrderID = @.SalesOrderID
)
GO
SELECT
SH.SalesOrderID,
LI.SalesOrderDetailID
FROM Sales.SalesOrderHeader SH
CROSS APPLY GetLineItemsForOrder(SH.SalesOrderID) LI
WHERE TotalDue > 20000
GO
DROP FUNCTION GetLineItemsForOrder
GO
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"nullstring" <johannes.veit@.datapec.de> wrote in message
news:1127133941.948110.85450@.g44g2000cwa.googlegroups.com...
> Does anybody knows, how this cross apply works'
> I need a simple example, because I have no idea what it's for!
> (I can't found any good example in the net!?!?)
>
> thanks in advance...
>

Need an example for CROSS APPLY!

Does anybody knows, how this cross apply works?
I need a simple example, because I have no idea what it's for!
(I can't found any good example in the net!?!?)
thanks in advance...
This is not a great example as the query would be better done with a join,
but it should help you understand the syntax:
USE AdventureWorks
GO
CREATE FUNCTION GetLineItemsForOrder(@.SalesOrderID INT)
RETURNS TABLE
AS
RETURN
(
SELECT SalesOrderDetailID
FROM Sales.SalesOrderDetail
WHERE SalesOrderID = @.SalesOrderID
)
GO
SELECT
SH.SalesOrderID,
LI.SalesOrderDetailID
FROM Sales.SalesOrderHeader SH
CROSS APPLY GetLineItemsForOrder(SH.SalesOrderID) LI
WHERE TotalDue > 20000
GO
DROP FUNCTION GetLineItemsForOrder
GO
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"nullstring" <johannes.veit@.datapec.de> wrote in message
news:1127133941.948110.85450@.g44g2000cwa.googlegro ups.com...
> Does anybody knows, how this cross apply works?
> I need a simple example, because I have no idea what it's for!
> (I can't found any good example in the net!?!?)
>
> thanks in advance...
>

Need a query

Table1(id,Name),Table2(myid,address)
if i apply query (Select * from Table1,Table2 where Table1.ID=Table2.myid) then if i have data table1(1,imran),table2(0,xyz) then result not show but i required result if equal or not equalYour query is using an implicit INNER JOIN. Try using an OUTER JOIN instead:

SELECT
 T1.ID,
 T1.Name,
 T2.myid,
 T1.address
FROM
 Table1 T1
LEFT OUTER JOIN
 Table2 T2 ON T1.ID = T2.myid

This will select ALL records from Table1 whether or not there is a match in Table2.

Terri

Navigation is not working correctly when I apply security on RS.

The site is working, all of the reports run, but all of the navigation drops
the https navigation to http links which will not render the application.
Does anyone know where I missed the https to configure as a secure
application?This is everything in my navigation
Home | My Subscriptions | Site Settings | Help
and if I go to the subfolders the home link for the subfolders does it too..
Any help will be nice!!
"Matthew" wrote:
> The site is working, all of the reports run, but all of the navigation drops
> the https navigation to http links which will not render the application.
> Does anyone know where I missed the https to configure as a secure
> application?
>