SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Report Designer Toggle Item Error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

srucker
Starting Member

USA
26 Posts

Posted - 10/07/2009 :  17:17:48  Show Profile  Reply with Quote
I have a few tables which reference unique datasets so I should be able to leverage groupings in tables w/ no issues; however I seem to be encountering the following when I compile.

[rsInvalidToggleItem] The table ‘table7’ has ‘ProgramName’ as a toggle item.
Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent.

Any ideas?

Edited by - tkizer on 10/07/2009 17:34:28

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 10/07/2009 :  17:34:13  Show Profile  Visit tkizer's Homepage  Reply with Quote
Moving this to the RS forum.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

TDBrighton
Starting Member

1 Posts

Posted - 12/13/2010 :  23:13:04  Show Profile  Reply with Quote
Over a year later; but, if anyone else is looking for the answer... This error happens when you rename the textbox that is the toggle item from e.g. 'ProgramName' to e.g. textbox18. I got the error when I moved (cut and then re-inserted) the item to a new place in my table. Suddenly, I got the error. It took a while, but I finally figured out that I could change the name of the textbox from 'textbox18' back to e.g. 'ProgramName' textbox and the report would work again.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 12/13/2010 :  23:51:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
A year later or not, thanks for posting a solution!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

lastt
Starting Member

1 Posts

Posted - 03/23/2012 :  06:23:04  Show Profile  Reply with Quote
Have the same problem when i try add to "Visibility can be toggled by" item from details of group. I only can add item group header.

Go to Top of Page

Jeff Stubing
Starting Member

USA
1 Posts

Posted - 07/25/2012 :  13:02:11  Show Profile  Reply with Quote
This worked for me. I was getting an error about my table1 having an invalid toggle item. The GUIs were of no help, and I was really pulling my hair out! Finally I went into the code and pulled out the highlighted section below:

<ReportItems>
<Table Name="table1">
<DataSetName>Report</DataSetName>
<TableGroups>
<TableGroup>
<Grouping Name="table1_Group1">
<GroupExpressions>
<GroupExpression>=Fields!Department.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Header>
<TableRows>
<TableRow>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>Site</ToggleItem>
</Visibility>

<TableCells>
<TableCell>

It ran fine after that.

Jeff Stubing
Go to Top of Page

rarascon
Starting Member

USA
6 Posts

Posted - 01/28/2014 :  13:34:54  Show Profile  Reply with Quote
I needed to edit this reply. I'm really glad this post is here whether it's old or not; however, when removing the code, which did seem to work but also caused some weird memory error. So, I'm reverting from that statement to try that option. However, I did notice that although you can remove the Toggle item in the Group properties, the Toggle item property for the text box was still set to the field causing the error. After I removed the field in that property, I was able to deploy. You might want to try that first. However, I'm still getting a memory error now.

Cheers,
Rob

Edited by - rarascon on 01/28/2014 18:50:27
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000