sql server reporting services: Remove Drill Down on Group -- sql server reporting services

Remove Drill Down on Group

SQL
8/10/2004 4:09:43 PM

sql server reporting services:

Hi,

When first creating my report, I used the wizard to set up drill down on my
first group. I know want to remove that so that all the groups are expanded
by default. How can I change the group to remove the drill down?

Second...
I have the following in my report

Group 1
Group 2-1
Group 2-2
Group 2-3
Footer Group 1

How can I use the sub-totals in Group 2-1, 2-2, 2-3 in a formula in the
footer of Group1? Hope that made sense...

Thanks in advance.

Remove Drill Down on Group

Dave Foderick
8/10/2004 4:34:19 PM

#1: Go to the properties of report band that is being
shown or hidden (most likely the detail band of the
report). Expand the Visibility property and make sure
Hidden is false and clear ToggleItem.

#2: Try using the scope parameter of the formula. For
example, Sum(Fields!field.Value,"Group 2-1")

-Dave Foderick
Net Knowledge

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.