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

Hello,

Is it possible to reference a textbox from the embedded code of a ssrs report. I would like to show or hide the textbox based on a condition.

Thanks.

Seth

Hello,

Is there a proper way to reference the fields of a ssrs report from the embedded code of an ssrs report?

When I try to use Fields!Program.Value I get the following error --

There is an error on line 3 of custom code: [BC30469] 
Reference to a non-shared member requires an object reference.

Upon googling I found you could reference the Parameters of a report by prepending Report. at the beginning. So I tried this Report.Fields.Program.Value. That results in the following error...

There is an error on line 3 of custom code: [BC30456] 'Fields' is not a member of 'Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IReportObjectModelProxyForCustomCode'.

So...in summary, is there a way to reference the fields from the embedded code. I figured out I could pass the field vals to the function itself but I would prefer to reference the fields directly.

Seth

Hello,

SUMMARY: I have created a SSRS Report. I want to be able to supply parameters for the report at DEPLOYMENT time rather than just design time or runtime.

DETAILS: I want to create ONE report and deploy it multiple times with the only difference being that I want to change one of the query parameters. I do not want to prompt the user for the value.

Can this be done?

Seth