May 9, 2017 at 12:52 pm
I am using "Microsoft SQL Server Report Builder 3.0" on "SQL Server Reporting Services 2012" to create a drill through report. For the drill through action on main report (main.rdl) I am calling the drill through report (detail.rdl) and passing three parameters to run the detail.rdl
Two of these 3 parameters are values of data set fields so I am using =Fields!<DataSetFieldName>.Value
But for the third parameter I want to send the name of the dataset field which is also the name of the textbox in main.rdl
For example =Fields!hostname.Value will give me value of that dataset field name (which I am displaying in teble/textbox)
What I want is when this text box is clicked the third parameter sent to detail.rdl should contain name of the dataset field or value of the textbox as both are same in my case. So I need to send "hostname" in third parameter.
Is there any way to get the textbox name or dataset field name using "Report Builder 3.0"?
I have tried in some combination blindly (like =Fields!hostname.Name, =Fields!hostname.Title, =Field.Name) but I know I am missing something so they always gave error when I tried to run.
Interestingly the error message has string hostname in it. When I used "=Textbox3.Name" and tried to run the main.rdl I got error message:
"The ActionInfo.Action.Drillthrough.DrillthroughParameters.Value expression for the text box ‘hostname’ contains an error: [BC30451] Name 'Textbox3' is not declared."
May 9, 2017 at 1:11 pm
In "Text Box Properties" -> "General" -> "Name" I see what I need (that is string "hostname"). I am just not able to define it in expression.
May 9, 2017 at 1:49 pm
I got the solution at http://fuzzy-group.blogspot.ca/2012/04/ssrs-custom-code-to-get-textbox-name.html
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply