Fixing an SRS Report Error
Spent the morning today trying to alter an SSRS Report (SQL Server Reporting Services report) and got stuck for several hours on a problem.
I was getting the following error when trying to:
“The definition of the report is invalid. The table <TABLENAME> has as as toggle item <FIELDNAME>. 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.”
Googling was of no help. I could not find any property in any property sheet that was causing the problem. No <TABLENAME> was toggling <FIELDNAME> that I could find. I HAD set some groupings on the report but reversing that did not work.
In the end I had to manually open the RDL file (SSRS definition file) in Notepad++ and searched for the word “toggle”. I found the errant tag and deleted it. Fortunately, this did not invalidate the report definition and I was henceforth able to finish my edits without a hitch.
NOTES FOR NON-TECHIES – SSRS is a very cool tool that ships with SQL Server that allows you to easily edit and publish reports to an intranet web-server. On most days I like working SSRS. It is a great tool. But not today.
Seth
