Hi all, I have a RDL report and on one of the Textboxes in the Tablix I have a reference to another report in the current project. I want to display in a tool tip the selected report name, which has been selected (from the list of existing reports in the current project) in Actions. Is this possible? Thank you in advance, Eddie

hi Eddie.R, It is possible to achieve this requirement in Reporting Services, supposing the datafield name in the textbox is Category, just click the textbox which has action, then press F4 button to open the property window, then find out the Tooltip, type in below sample expression =SWITCH(Fields!Category.value="A","SubreportA",Fields!Category.value="B","SubreportB",Fields!Category.value="C","SubreportC",Fields!Category.value="D","SubreportD") This is just a sample, you can replace the value and subreport name based on your own report. Of course this method is only suit for several subreport, if your main report contain many many subreport, you should store your suberport's name in your main report's dataset, then make sure of this field for textbox's tooltip property. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Challen Fu, thank you for reply, but this is not what i meant. suppose that I've already chose a report name from an existing list in Action. My purpose is, get the report name dynamically, so if the name of report will be changed in the future, the tooltip will be updated automatically. I tried using built in code expression, I couldn't figure out the correct way to write the code though (no intelisense support). This is the approach I tried: ReportItems("TextBox6").GetType()

Hi Eddie.R, Thanks for your feedback, here I want to confirm with you how do you get the subreport name dynamically? where do you want to show the tooltip? on main report or suberport? what's your currect tooltip expression? There information is a big help for us supply further assistance. Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Challen Fu, Today the expression in the tooltip is a simpe text. The tooltip should display a simple information - Go to "ReportA" report. So once i put the mouse on the current cell, it will display the message [Go to "ReportA" report]. Once I click the cell, it will execute a drillthough report and will render the "ReportA" report. If in the future, I"ll want to choose a different report in Action, The tooltip should display the new report name without changing anything in the expression.

Hi Eddie.R, Ok, I get it currently, now you changed your subreport name, you still want to change the tooltip relevant to it, right? If so I think there is no build-in feature to achieve it, the easiest way to change the tooltip directly. However here I still would recommend you to submit a feedback to Microsoft Connect at this link at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release. Regards, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Ok, Thank you Challen Fu. Regards, Eddie