Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srucker
Starting Member
26 Posts |
 Posted - 2009-10-07 : 17:17:48
|
| 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? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
TDBrighton
Starting Member
1 Post |
Posted - 2010-12-13 : 23:13:04
|
| 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. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lastt
Starting Member
1 Post |
Posted - 2012-03-23 : 06:23:04
|
| 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. |
|
|
|
Jeff Stubing
Starting Member
1 Post |
Posted - 2012-07-25 : 13:02:11
|
| 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 |
|
|
|
rarascon
Starting Member
6 Posts |
Posted - 2014-01-28 : 13:34:54
|
| 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 |
|
|
|
|
|
|
|
|
Report Designer Toggle Item Error