Dropdown menu help

I have a report with 4 parameters
2 of them are dropdown menus, one contains groups that populate the other
dropdown box with computer names. The report works great but I would like to
have an ALL function in the computer name dropdown box.
From poking around here I was able to plug a UNION SELECT 'All' AS
ComputerName into the dataset that builds the computername list but I am no
sql wiz by any stretch of the imagination and it seems that is just plugging
in All to the dropdown without any meaning behind it.
Has anyone done this sort of thing before or have any examples they could
share?
Thanks!
Kevinhttp://blogs.msdn.com/chrishays/archive/2004/07/27/199157.aspx
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Kevin Serafin" <kevin.serafinISHEREATecolabDOTcom> wrote in message
news:enxx48jeEHA.2852@.tk2msftngp13.phx.gbl...
> I have a report with 4 parameters
> 2 of them are dropdown menus, one contains groups that populate the other
> dropdown box with computer names. The report works great but I would like
to
> have an ALL function in the computer name dropdown box.
> From poking around here I was able to plug a UNION SELECT 'All' AS
> ComputerName into the dataset that builds the computername list but I am
no
> sql wiz by any stretch of the imagination and it seems that is just
plugging
> in All to the dropdown without any meaning behind it.
> Has anyone done this sort of thing before or have any examples they could
> share?
> Thanks!
> Kevin
>|||Thanks Chris, works great!
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:us4dvpleEHA.140@.TK2MSFTNGP12.phx.gbl...
> http://blogs.msdn.com/chrishays/archive/2004/07/27/199157.aspx
> --
> This post is provided 'AS IS' with no warranties, and confers no rights.
All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No
user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach
of
> children under 3.
> "Kevin Serafin" <kevin.serafinISHEREATecolabDOTcom> wrote in message
> news:enxx48jeEHA.2852@.tk2msftngp13.phx.gbl...
> > I have a report with 4 parameters
> >
> > 2 of them are dropdown menus, one contains groups that populate the
other
> > dropdown box with computer names. The report works great but I would
like
> to
> > have an ALL function in the computer name dropdown box.
> >
> > From poking around here I was able to plug a UNION SELECT 'All' AS
> > ComputerName into the dataset that builds the computername list but I am
> no
> > sql wiz by any stretch of the imagination and it seems that is just
> plugging
> > in All to the dropdown without any meaning behind it.
> >
> > Has anyone done this sort of thing before or have any examples they
could
> > share?
> >
> > Thanks!
> >
> > Kevin
> >
> >
>

drilldown group expanded by default

Hello!!

I have a matrix in a report with groups and subgroups like this :

*group1

*subgroup1.1

item1

item2

etc.

I would like to show the group expanded by default so when I view the report I see:

*group1

subgroup1.1

*group2

subgroup 2.1

Right now I've played with InitialToggleState and visibility->Hidden properties but I don′t know how to do it....help me please

Thanks

You need to set the visibility of the inner group to true. Right click and edit the group in the matrix.|||

I published an article showing the steps for this (at least an example similar enough to be useful, hopefully):

http://www.databasejournal.com/features/mssql/article.php/3527321

This was for MSRS2000, but the logic should be good in SSRS2005.

Good Luck!

Bill

William E. Pearson III
CPA, CMA, CIA, MCSE, MCDBA
Island Technologies Inc.
931 Monroe Drive
Suite 102-321
Atlanta, GA 30308

404.872.5972 Office

wep3@.islandtechnologies.com
wep3@.msas-architect.com

www.msas-architect.com
-- -- --

Publisher Sites:

http://www.databasejournal.com/article.php/1459531

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

http://www.informit.com/authors/bio.asp?a=862acd62-4662-49ae-879d-541c8b4d656f

http://www.2000trainers.com/section.aspx?sectionID=17

Drill down problem, report jumps to top of table!

Hi
I have a report with a table which has two groups. Each group is collapsed
by default when the report loads. When I click on the first group expand
icon (+) the group expands but also the report jumps up the screen so that
the top of my first data row in my table is alligned to the top of the IE
window. This is really annoying and I do not understand why it is happening.
Is this a known bug in RS or has anyone else had this problem and been able
to solve it? It also happens when I expand/collapse the second group.
I think it only started happening after I added a few images to my report. I
have tried removing the images from the report but this does not get rid of
the problem.
Any help/ideas would be greatly appreciated.
Kind Regards
Lewis Holmes
eNateHi
Problem solved!
In Visual Studio I had the page setup so that the body of the report was
larger than the area visible on the screen and so my footer was off the
screen. I have now changed this so that the body of the report is just large
enough for the contents of the body. Now the report does not jump around
when I expand/collapse groups.
Hope this may help anyone else with the same problem.
Regards
Lewis Holmes
eNate
"l.holmes" <enate@.newsgroups.nospam> wrote in message
news:u1ST$9g3FHA.2552@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have a report with a table which has two groups. Each group is collapsed
> by default when the report loads. When I click on the first group expand
> icon (+) the group expands but also the report jumps up the screen so that
> the top of my first data row in my table is alligned to the top of the IE
> window. This is really annoying and I do not understand why it is
> happening. Is this a known bug in RS or has anyone else had this problem
> and been able to solve it? It also happens when I expand/collapse the
> second group.
> I think it only started happening after I added a few images to my report.
> I have tried removing the images from the report but this does not get rid
> of the problem.
> Any help/ideas would be greatly appreciated.
> Kind Regards
> Lewis Holmes
> eNate
>|||Hi Lewis,
It's great to hear you have resolved it and thanks so much for sharing your
experience with us.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.