Dynamic Tooltip for TextBoxes in Reports?

Hi,

I want to add dynamic tooltip for the textboxes on a report where the tooltip text comes from a database lookup or maybe a resource file?

How can this be done. This is a required feature for our client and we do not want to add "Constants" as tooltip text which can be done in min as the drawback would be if the value for the tooltip changes, it has to be changed in all the reports wherever it appears.

Thanks again.You can do this by creating a second data set and binding the tooltip to aggregate expressions, i.e. =First(Fields!Tooltip1.Value, "TipQuery"). Or you could write a cusom assembly and get them from a custom resource file (would require additional permission in the assembly on the server).