Pages

Sunday, 2 September 2012

MOUSE HOVER REPORT OR TOOL TIP REPORT STEP BY STEP



MOUSE HOVER 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.


1 comment:

  1. It’s the best time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I want to suggest you few interesting things or suggestions.You can write next articles referring to this article. I desire to read even more things about it..

    MSBI Training in Chennai

    ReplyDelete