|
|
You're in the
sql server reporting services
group:Using a parameter to control if detail shows initially with drill
sql server reporting services:
I have been trying to figure out how to have a 'Show Detail?' parameter to control the inital look of a report that has the toggle drill downs. I can't get the expression to work for turning the toggle on from Collapsed to Expanded. Also if I change the InitialToggleState to "Expanded' on my ToggleItem, it displays the "-" but doesn't have any affect on the Detail whose visibility is tied to it. Has anyone figured out how to make this work. It seems like it is designed to work, but I can't get either to fly. Also can you have 2 toggle items on a report, like 1st group level State expand to show Counties and then expand that to show cities? THANKS!!! for the help, Bob --
What you have to do is put the toggle item on (at least) the first higher
group level Fe. year country city value you make 3 row-groups: year, country, city you make year the parent group of country and country the parent group of city the togle item of city is the "country-textbox", the toggle item of country is the "year-textbox". You could also use a toggle item outside the matrix (fe title field or a seperate textbox). Hope this helps [quoted text, click to view] "Bob Hansen" wrote:
> Hi SRS-ers, > > I have been trying to figure out how to have a 'Show Detail?' parameter to > control the inital look of a report that has the toggle drill downs. > > I can't get the expression to work for turning the toggle on from Collapsed > to Expanded. Also if I change the InitialToggleState to "Expanded' on my > ToggleItem, > it displays the "-" but doesn't have any affect on the Detail whose > visibility is tied to it. Has anyone figured out how to make this work. It > seems like it is designed to work, but I can't get either to fly. > > Also can you have 2 toggle items on a report, like 1st group level State > expand to show Counties and then expand that to show cities? > > THANKS!!! for the help, > > Bob > --
I'm having the same problem
I have Company, Division, Department, Employee as groups Company is the parent of Division Division is the parent of Department Department is the parent of Employee Employee toggleitem is set to Department (textbox) Department toggleitem is set to Division (textbox) Division toggleitem is set to Company (textbox) Each group and the textbox for toggle fields have the following expression for initialtogglestate =IIF(Parameters!Company.Value="All",False,True) When entering a single Company all that happens is the toggle icon starts of as '-' instead of '+' with no expansion. Can someone point me to documentation on how this should be set up or explain what I have wrong? Thanks [quoted text, click to view] "Antoon" wrote:
> What you have to do is put the toggle item on (at least) the first higher > group level > Fe. > year country city value > you make 3 row-groups: year, country, city > you make year the parent group of country and country the parent group of city > the togle item of city is the "country-textbox", the toggle item of country > is the "year-textbox". > You could also use a toggle item outside the matrix (fe title field or a > seperate textbox). > > Hope this helps > > > > > "Bob Hansen" wrote: > > > Hi SRS-ers, > > > > I have been trying to figure out how to have a 'Show Detail?' parameter to > > control the inital look of a report that has the toggle drill downs. > > > > I can't get the expression to work for turning the toggle on from Collapsed > > to Expanded. Also if I change the InitialToggleState to "Expanded' on my > > ToggleItem, > > it displays the "-" but doesn't have any affect on the Detail whose > > visibility is tied to it. Has anyone figured out how to make this work. It > > seems like it is designed to work, but I can't get either to fly. > > > > Also can you have 2 toggle items on a report, like 1st group level State > > expand to show Counties and then expand that to show cities? > > > > THANKS!!! for the help, > > > > Bob > > --
Did you set the hide parameter to:
=IIF(Parameters!Company.Value="All",False,True) ? [quoted text, click to view] "J Wood" wrote:
> I'm having the same problem > I have Company, Division, Department, Employee as groups > Company is the parent of Division > Division is the parent of Department > Department is the parent of Employee > > Employee toggleitem is set to Department (textbox) > Department toggleitem is set to Division (textbox) > Division toggleitem is set to Company (textbox) > > Each group and the textbox for toggle fields have the following expression > for initialtogglestate > > =IIF(Parameters!Company.Value="All",False,True) > > When entering a single Company all that happens is the toggle icon starts of > as '-' instead of '+' with no expansion. > > Can someone point me to documentation on how this should be set up or > explain what I have wrong? > > Thanks > > "Antoon" wrote: > > > What you have to do is put the toggle item on (at least) the first higher > > group level > > Fe. > > year country city value > > you make 3 row-groups: year, country, city > > you make year the parent group of country and country the parent group of city > > the togle item of city is the "country-textbox", the toggle item of country > > is the "year-textbox". > > You could also use a toggle item outside the matrix (fe title field or a > > seperate textbox). > > > > Hope this helps > > > > > > > > > > "Bob Hansen" wrote: > > > > > Hi SRS-ers, > > > > > > I have been trying to figure out how to have a 'Show Detail?' parameter to > > > control the inital look of a report that has the toggle drill downs. > > > > > > I can't get the expression to work for turning the toggle on from Collapsed > > > to Expanded. Also if I change the InitialToggleState to "Expanded' on my > > > ToggleItem, > > > it displays the "-" but doesn't have any affect on the Detail whose > > > visibility is tied to it. Has anyone figured out how to make this work. It > > > seems like it is designed to work, but I can't get either to fly. > > > > > > Also can you have 2 toggle items on a report, like 1st group level State > > > expand to show Counties and then expand that to show cities? > > > > > > THANKS!!! for the help, > > > > > > Bob > > > --
Thanks for the reply Antoon,
Yes, Initial Visibility is set to use the same expression. Based on the posts here asking for the same type of functionality, I thought I had everything covered, but it still isn't working. I couldn't find anything in the online docs, but if anyone knows where (if) this is documented that would be a big help (or suggestions on what else I might need to set). Thanks [quoted text, click to view] "Antoon" wrote:
> Did you set the hide parameter to:
I think the exression should be the inverse off the toggle item (its
'initialy hidden' instead off 'intial visibility'). If you click the '-' you'll probably get the details (?) [quoted text, click to view] "J Wood" wrote:
> Thanks for the reply Antoon, > > Yes, Initial Visibility is set to use the same expression. Based on the > posts here asking for the same type of functionality, I thought I had > everything covered, but it still isn't working. I couldn't find anything in > the online docs, but if anyone knows where (if) this is documented that would > be a big help (or suggestions on what else I might need to set). > > Thanks > > "Antoon" wrote: > > > Did you set the hide parameter to:
That was the problem. Thanks for the help
[quoted text, click to view] "Antoon" wrote:
> I think the exression should be the inverse off the toggle item (its > 'initialy hidden' instead off 'intial visibility'). If you click the '-' > you'll probably get the details (?) > > "J Wood" wrote: > > > Thanks for the reply Antoon, > > > > Yes, Initial Visibility is set to use the same expression. Based on the > > posts here asking for the same type of functionality, I thought I had > > everything covered, but it still isn't working. I couldn't find anything in > > the online docs, but if anyone knows where (if) this is documented that would > > be a big help (or suggestions on what else I might need to set). > > > > Thanks > > > > "Antoon" wrote: > > > > > Did you set the hide parameter to:
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |