Dynamic ToolTip and hyperlinks for summary fields in Crosstab

Hello,

For summary field in crosstab i need to add tool tip which contains various values also i need to add a hyperlink for the summary field. (For example row are having the customers, columns the products and quantity as summay)

First i tried using the aggregation elements of crosstab. I was able to add the hyperlink, but for tool tip I was able to display only the current cell value.

then i removed the aggregation element and added a html text, now i am able to display tooltip (using div) with multiple values but i am not able to add a hyperlink to it

Also is it possible to add atooltip to customer (row) which shows all the products ordered by the respective customer.

Could you please suggest how to do this.

Attaching the sample report for the same

Thanks in advance for the help

Find more posts tagged with

Comments

nppk

<blockquote class='ipsBlockquote' data-author="'nppk'" data-cid="112411" data-time="1355413500" data-date="13 December 2012 - 08:45 AM">
Hello, 
 
For summary field in crosstab i need to add tool tip which contains various values also i need to add a hyperlink for the summary field. (For example row are having the customers, columns the products and quantity as summay) 
 
 
First i tried using the aggregation elements of crosstab. I was able to add the hyperlink, but for tool tip I was able to display only the current cell value. 
 
then i removed the aggregation element and added a html text, now i am able to display tooltip (using div) with multiple values but i am not able to add a hyperlink to it 
 
Also is it possible to add atooltip to customer (row) which shows all the products ordered by the respective customer. 
 
 
Could you please suggest how to do this. 
 
Attaching the sample report for the same 
 
Thanks in advance for the help </blockquote>
 
 
By adding a href tag I am able to add hyperlink too for the summary field along with the tooltip. But still I am not able to show all the products order by a customer as tooltip for customer.

kclark

You might be able to do what you need by building an HTML table as a tooltip. <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/443-birt-table-tooltip-examples/'>This devshare</a> shows how you can do that. Once you build you're html table you can put the data you need in there, in this case products ordered.

nppk

Hii,
Thanks for the reply.

As suggested I added a html tag for tool tip.
<div id="textcontrol" title="Cust Info: <VALUE-OF>row["CUSTOMERNUMBER"] </VALUE-OF> PRODUCT: <VALUE-OF>row["PRODUCTCODE"] </VALUE-OF> Quantity <VALUE-OF>measure["QUANTITYORDERED"]</VALUE-OF> "> <VALUE-OF>row["CUSTOMERNUMBER"]</VALUE-OF>
</div>

It shows the customer number as well. But it is not displaying the products and the quantity.
How to access the products and quantity in tool tip ?

Since for a customer there will be multiple products ordered and multiple values of quantity,
will it need some special handling ?

Please suggest solution for this. Attaching the sample for the same.