Make RS the default website in RS 2005

When installing RS 2000 I did not have to do anything to have RS be the
default website for the server. For instance, I could put in http://myserver
and it would re-direct to http://myserver/Reports/Pages/Folder.aspx
I have gone into IIS Manager attempting to set the default appropriately but
I always end up with security violations and report manager does not come
up.
What are the steps I need to take to have RS 2005 to act the same way as RS
2000 as far as being the default website.
Thanks,
BruceBruce,
For the moment I am trying to keep my RS2005 RTM install as vanilla as
possible, so I haven't tried this.
Go to the RS Configuration tool.
Select the Report Manager Virtual Directory option in the left pane.
Click New.
Delete Reports from the Virtual Directory.
Click OK.
Click Apply.
I think that is likely to do what you want. As I say, I haven't tried
it.
Andrew Watt
MVP - InfoPath
On Mon, 31 Oct 2005 14:15:44 -0600, "Bruce L-C [MVP]"
<brucelc@.newsgroup.nospam> wrote:
>When installing RS 2000 I did not have to do anything to have RS be the
>default website for the server. For instance, I could put in http://myserver
>and it would re-direct to http://myserver/Reports/Pages/Folder.aspx
>I have gone into IIS Manager attempting to set the default appropriately but
>I always end up with security violations and report manager does not come
>up.
>What are the steps I need to take to have RS 2005 to act the same way as RS
>2000 as far as being the default website.
>Thanks,
>Bruce|||Nope. Nice try though. I tried this and first, you couldn't have it blank,
so I put / and then I could click OK and it failed and left it as it was.
Besides, what I want is the same way it works in 2000. If you go to just the
servername it redirects to reports. So you can either specify the full path
or just the server name. I think it will turn out to be a straight IIS
configuration issue.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:opjfm1d25ve92cef6322fc7jrbtcm0qfh2@.4ax.com...
> Bruce,
> For the moment I am trying to keep my RS2005 RTM install as vanilla as
> possible, so I haven't tried this.
> Go to the RS Configuration tool.
> Select the Report Manager Virtual Directory option in the left pane.
> Click New.
> Delete Reports from the Virtual Directory.
> Click OK.
> Click Apply.
> I think that is likely to do what you want. As I say, I haven't tried
> it.
> Andrew Watt
> MVP - InfoPath
> On Mon, 31 Oct 2005 14:15:44 -0600, "Bruce L-C [MVP]"
> <brucelc@.newsgroup.nospam> wrote:
>>When installing RS 2000 I did not have to do anything to have RS be the
>>default website for the server. For instance, I could put in
>>http://myserver
>>and it would re-direct to http://myserver/Reports/Pages/Folder.aspx
>>I have gone into IIS Manager attempting to set the default appropriately
>>but
>>I always end up with security violations and report manager does not come
>>up.
>>What are the steps I need to take to have RS 2005 to act the same way as
>>RS
>>2000 as far as being the default website.
>>Thanks,
>>Bruce
>|||If you have deleted your "default" website from IIS then you'll have to
modify the IIS meta database to make another website the "default". Works
the same way in 2000 and I was hoping they would do away with this CRAZY
requirement. As long as the web has the default IP address of the box....
Here are the steps sent to me from Microsoft Support (it's a recap of what
they had me do):
1. Backed up you IIS Metabase.
2. Downloaded the MetaEdit utility.
232068 HOW TO: Download, Install, and Remove the IIS MetaEdit 2.2 Utility
<http://support.microsoft.com/?id=232068>
3. Shutdown IIS and all its related services via â'iisreset /stopâ'.
4. Shutdown all MMC IIS related tools so nothing be accessing the metabase.
5. Verified that IIS was shutdown by browsing to a few of the sites it served.
6. Started MetaEdit. Expanded the outline control on the left side to locate
the
W3SVC entry and then located current default web site ID.
8. Changed it back to a 1.
9. Changed the AppRoot values on the right hand side for each of the VDIRS
under
the default web site.
10. Exited MetaEdit and restarted IIS.
In addition you can refer to the following article:
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
"Bruce L-C [MVP]" wrote:
> Nope. Nice try though. I tried this and first, you couldn't have it blank,
> so I put / and then I could click OK and it failed and left it as it was.
> Besides, what I want is the same way it works in 2000. If you go to just the
> servername it redirects to reports. So you can either specify the full path
> or just the server name. I think it will turn out to be a straight IIS
> configuration issue.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
> news:opjfm1d25ve92cef6322fc7jrbtcm0qfh2@.4ax.com...
> > Bruce,
> >
> > For the moment I am trying to keep my RS2005 RTM install as vanilla as
> > possible, so I haven't tried this.
> >
> > Go to the RS Configuration tool.
> >
> > Select the Report Manager Virtual Directory option in the left pane.
> >
> > Click New.
> >
> > Delete Reports from the Virtual Directory.
> >
> > Click OK.
> >
> > Click Apply.
> >
> > I think that is likely to do what you want. As I say, I haven't tried
> > it.
> >
> > Andrew Watt
> > MVP - InfoPath
> >
> > On Mon, 31 Oct 2005 14:15:44 -0600, "Bruce L-C [MVP]"
> > <brucelc@.newsgroup.nospam> wrote:
> >
> >>When installing RS 2000 I did not have to do anything to have RS be the
> >>default website for the server. For instance, I could put in
> >>http://myserver
> >>and it would re-direct to http://myserver/Reports/Pages/Folder.aspx
> >>
> >>I have gone into IIS Manager attempting to set the default appropriately
> >>but
> >>I always end up with security violations and report manager does not come
> >>up.
> >>
> >>What are the steps I need to take to have RS 2005 to act the same way as
> >>RS
> >>2000 as far as being the default website.
> >>
> >>Thanks,
> >>
> >>Bruce
> >
>
>

make manual snapshots without default parameters set - how?

It seems like it is only possible to make a snapshot if I set default
values to all parameters. What I want to do is:
- The user generates a report manually after entering some parameters
- The user can decide to save this report as a snapshot by pressing on
the "New Snapshot" button
Is it right that there seems to be no way of doing this? (I'm talking
about the standard Web UI, no self-programmed web service or anything)
Thanks for any help
UrsHi,
check the linked report feature.
Elisabeth
"Urs Eichmann" wrote:
> It seems like it is only possible to make a snapshot if I set default
> values to all parameters. What I want to do is:
> - The user generates a report manually after entering some parameters
> - The user can decide to save this report as a snapshot by pressing on
> the "New Snapshot" button
> Is it right that there seems to be no way of doing this? (I'm talking
> about the standard Web UI, no self-programmed web service or anything)
> Thanks for any help
> Urs
>
>|||That's what I already do, but if I don't set all the parameters to a
default value in the linked report, I cannot make a snapshot.
Urs
Elisabeth wrote:
> Hi,
> check the linked report feature.
> Elisabeth
> "Urs Eichmann" wrote:
>
>>It seems like it is only possible to make a snapshot if I set default
>>values to all parameters. What I want to do is:
>>- The user generates a report manually after entering some parameters
>>- The user can decide to save this report as a snapshot by pressing on
>>the "New Snapshot" button
>>Is it right that there seems to be no way of doing this? (I'm talking
>>about the standard Web UI, no self-programmed web service or anything)
>>Thanks for any help
>>Urs
>>

Make it easier to add a data viewer

Hi,
I use data viewers ALOT and I always always use the same one, the default one which I'm sure is the same as everyone else uses.

Its a bit annoying to have to trek through 3 different screens to add one though. Please could you just add an item onto the right-click contect menu on a data flow path that simply adds in the default data viewer. This can be in addition to the "Data Viewers..." option which is there already.

Would anyone else like this?

-JamieJamie, please create a DCR. Thanks.|||OK, done. 631767545

make Count(*) return zero

hey guys

is there a way to make the count(*) return zero . because the default behavoir is that it will skip this value if there is no records
so a simple query like this

select userid,count(*) as count from users where userid in (select val from sometable)
group by userid

if userid 1 has no records . it wont be returned in the query
instead i want it to show zero
so
userid count
1 0
2 3
3 1
4 0

thanks in advance
hi

you can try this

select userid,count(*) as [count] from testDB where
userid in (select userid from testdb1)
group by userid
union
select userid,0 as [count] from testDB where
userid not in (select userid from testdb1)
group by userid

|||

How about this query..

Select

Val

,Count(UserId)

from

someTable A

Left Outer Join users B On A.val=B.userid

Group By

Val

|||you can also try this one..

Code Snippet

select *
into #users
from (
select 1 as userid union all
select 2 as userid union all
select 3 as userid
) users

select *
into #sometable
from (
select 1 as val
) sometable

select a.userid
, case when count(a.userid) = 1 and sum(b.sumcheck) = 0 then 0 else count(a.userid) end as count
from #users a left outer join
(
select userid
, isnull(val,0) as sumcheck
from #users left outer join
#sometable on #users.userid = #sometable.val
) b on a.userid = b.userid
group by
a.userid

drop table #users
drop table #sometable

|||

RamezR,

Those rows like [userid] = 1, are being excluded from the result set because of the filter in the "where" clause. The is a keyword in the "group by" clause (ALL), that let you see those rows excluded by the filter in the "where" clause.

select userid,count(*) as count

from users

where userid in (select val from sometable)

group by userid ALL

go

AMB

|||when i try to run the query i get Incorrect syntax near the keyword 'ALL'.

i was not aware of this "ALL" keyword but when i looked up the msdn i found that its kinda irrelvant in that case.

so far i found that the best result is achieved using the left outer join

Regards

|||deleted my previous post.. i think what hunchback meant was..

select userid,count(*) as count

from users

where userid in (select val from sometable)

group by all userid|||

rh4m1113,

Thanks for jumping in. That is exactly what I meant, but did not test it.

AMB

|||hunchback,

actually i was also confused and thought only SQL 2005 had the GROUP BY ALL clause .. good thing i tested it.. i have actually learned from this one.. cool post hunchback..

rhamille|||

rh4m1ll3,

Glad you learned something from the post. The "left join" idea is a good one, but you have to be sure that the rows in the right side table has no duplicated rows by the columns used in the join, or you select distinct values from that table previous the join, if not you will get wrong result.

AMB

|||hunchback,

true, so far on some production codes that i have used a similar approach none of them had a requirement of having duplicate records, i'd prole' be taking note of your approach just in case a similar requirement comes. it's much more cleaner and straight forward as well as maximizes the the group by clauses's potential

rhamille|||

Hi hunchback & rh4m1ll3,

Let me understand your solution, (i accept the feature GROUP BY ALL in sql server ).

But I am really confused to accept GROUP BY ALL for this requirement.

See the bellow example, are you sure GROUP BY ALL will work for this requirement?

Code Snippet

Create Table #sometable (

[val] int

);

Insert Into #sometable Values('2');

Insert Into #sometable Values('2');

Insert Into #sometable Values('2');

Insert Into #sometable Values('3');

Insert Into #sometable Values('3');

Insert Into #sometable Values('5');

Insert Into #sometable Values('5');

Create Table #users (

[UserId] int

);

Insert Into #users Values('1');

Insert Into #users Values('2');

Insert Into #users Values('3');

Insert Into #users Values('4');

Insert Into #users Values('5');

Insert Into #users Values('6');

Select

UserId

,Count(Val) Counts

from

#users B

Left Outer Join #sometable A On A.val=B.userid

Group By

UserId

/*

UserId Counts

-- --

1 0

2 3

3 2

4 0

5 2

6 0

*/

Select

UserId

,Count(*) Counts

from

#users B

Where

UserId in (Select val From #sometable)

Group By ALL

UserId

/*

UserId Counts

-- --

1 0

2 1

3 1

4 0

5 1

6 0

*/

|||mani,

good and interesting point .. i have just recently realized that you might have misplaced the Val and UserId on your previous(first) post.. good approach for such requirement

rhamille|||

Manivannan.D.Sekaran,

Look at the original post and execute the stament using the sample data in your post

Select

UserId

,Count(*) Counts

from

#users

where

UserId in (select [val] from #sometable)

Group By

UserId

Result:

UserId Counts
2 1
3 1
5 1

If we want to include also the rows not matching the criteria in the "where" clause, but this time using "left join", then you need to be sure that we join to unique values from #sometable:

Select

u.UserId

,Count(s.[val]) Counts

from

#users as u

left join

(select distinct [val] from #sometable) as s

on u.UserId = s.[val]

Group By

u.UserId

Result

UserId Counts
1 0
2 1
3 1
4 0
5 1
6 0

As you can see, the result from the statement using "left join" and the statement using "GROUP BY ALL", yield same result for the rows returned by the original statement.

AMB

|||Please do NOT use GROUP BY ALL. It is a non-standard extension and will be deprecated in the future. It is marked for deprecation in SQL Serve 2005. So if you use it in your code now you may have to change it in the next version of SQL Server or the version after that.

Make (Select All) as default value in parameter

Dear Anyone,
Does anyone know how to Make (Select All) as default value in parameter selection on a multi-select parameter?

thanks,
Joseph

If the valid values list of the multi value parameter is dataset based, you could set the default value of the parameter to the same dataset field value.

-- Robert

|||

We have the hotfix for the (Select All) option applied (after applying SP1).

However, when the users change another parameter filter which cascades to change to the multivalued parameter filter, the (Select All) option is not reapplied. In other words, if new entries show up in the multivalued parameters list, they are not checked by default, so some records will be missed.

What is the best way to force a (Select All) again after the user filters on another dependent parameter filter?

Make (Select All) as default value in parameter

Dear Anyone,
Does anyone know how to Make (Select All) as default value in parameter selection on a multi-select parameter?

thanks,
Joseph

If the valid values list of the multi value parameter is dataset based, you could set the default value of the parameter to the same dataset field value.

-- Robert

|||

We have the hotfix for the (Select All) option applied (after applying SP1).

However, when the users change another parameter filter which cascades to change to the multivalued parameter filter, the (Select All) option is not reapplied. In other words, if new entries show up in the multivalued parameters list, they are not checked by default, so some records will be missed.

What is the best way to force a (Select All) again after the user filters on another dependent parameter filter?

Make (Select All) as default value in parameter

Dear Anyone,
Does anyone know how to Make (Select All) as default value in parameter selection on a multi-select parameter?

thanks,
Joseph

If the valid values list of the multi value parameter is dataset based, you could set the default value of the parameter to the same dataset field value.

-- Robert

|||

We have the hotfix for the (Select All) option applied (after applying SP1).

However, when the users change another parameter filter which cascades to change to the multivalued parameter filter, the (Select All) option is not reapplied. In other words, if new entries show up in the multivalued parameters list, they are not checked by default, so some records will be missed.

What is the best way to force a (Select All) again after the user filters on another dependent parameter filter?