Sunday 23 June 2013

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.

No comments:

Post a Comment