MOUSE OVER REPORT (or) TOOL TIP REPORT STEP BY STEP

MOUSE OVER REPORT  (OR) TOOL TIP REPORT IN SSRS

I am showing you that how to create Mouse Hover or Tool Tip report in this article.

Here is an example from  AdventureWorks Database.

SQL Scripts : 

SELECT     Person.Contact.ContactID, (Person.Contact.FirstName+' '+ Person.Contact.MiddleName+' '+Person.Contact.LastName) As FullName,

                      Sales.ContactCreditCard.CreditCardID, Sales.CreditCard.CardType, Sales.CreditCard.CardNumber, convert(varchar(10),Sales.CreditCard.ExpMonth) as months, Sales.CreditCard.ExpYear

FROM         Person.Contact INNER JOIN

                      Sales.ContactCreditCard ON Person.Contact.ContactID = Sales.ContactCreditCard.ContactID AND

                      Person.Contact.ContactID = Sales.ContactCreditCard.ContactID INNER JOIN

                      Sales.CreditCard ON Sales.ContactCreditCard.CreditCardID = Sales.CreditCard.CreditCardID AND

                      Sales.ContactCreditCard.CreditCardID = Sales.CreditCard.CreditCardID AND Sales.ContactCreditCard.CreditCardID = Sales.CreditCard.CreditCardID AND

                      Sales.ContactCreditCard.CreditCardID = Sales.CreditCard.CreditCardID

                     where Person.Contact.MiddleName <> 'NULL'

                     order by ContactID

Select the Header Row of the table in the report.

Go to Properties Window.

Under the BackgroundColor property, Select color from drop down.

Repeat previous step for data row to set color for better look

Now select the ContactID column and go to the properties window.

Select Expression from Tool Tip

Set the expression for Tool Tip

Expression :

=("FULL NAME :  " & Fields!FullName.Value & chr(10)

 &"EXPIRY MONTH :  " & Fields!months.Value & chr (10)

 & "EXPIRY YEAR :  " & Fields!ExpYear.Value & chr (10))

Click Ok

Now Run the report

Above the preview of report.