Hi,
I have a cross tab report in which some users are complaining that there are too many columns and rows, so when they scroll they lose sight of the column headers or row names and are forced to export to Excel.
Is there a way, without JavaScript, that I could add a dynamic tooltip that will return the column name and row name when the user does a mouseover the fact cell?
Thanks in advance.
I'm currently on 8.1 if that makes any difference...
anyone??? how about w/ javascript then...
I do not know a way of displaying it on a fact cell. However, have you considered freezing rows and/or columns of crosstab? This way they will not loose the sight of the fact cell. I remember there was a proven practice article detailing the steps.
check this out..it might help you ..but it is through scripting
Quote from: lrajana on 23 Jun 2009 03:18:24 PM
check this out..it might help you ..but it is through scripting
wow, that's awesome.
I followed the instructions (which I thought were quite straightfoward), but i get an error when I scroll.
"freeze_pane undefined".
Unfortunately I wasn't able to open the sample reports given so I wasn't able to check if I did anything wrong or placed the HTML tags wrong. The reason I can't is because I'm still on 8.1 and even after changing the report xlmns to schema 2.0 it still errors out.
of course, this is further compounded by me using IE6 so I'm not sure if this script is recognized.
Can someone please confirm that this works in IE6 or not? I'm trying to secure another workstation that has IE7+ but in the meantime if someone knows the answer, that would be great.
TIA
Quote from: kulkarni on 23 Jun 2009 01:03:48 PM
I do not know a way of displaying it on a fact cell. However, have you considered freezing rows and/or columns of crosstab? This way they will not loose the sight of the fact cell. I remember there was a proven practice article detailing the steps.
I know that I saw a video on freezing the column titles, but that was in a list report. I haven't seen one for cross-tabs until the one lrajana just suggested.
Quote from: Hakkaboy on 07 Jul 2009 06:29:08 PM
The reason I can't is because I'm still on 8.1 and even after changing the report xlmns to schema 2.0 it still errors out.
The technique works for only 8.3/8.4 ... see section 1.2. The way elements in a report are accessed has changed a lot when 8.3 was first introduced. So I doubt the JS will will work on your 8.1 environment.
Regarding your error, "free_pane" is the JS file name. What have you put in your SRC attribute?
The doc says
SRC="../common/freeze_pane.js" ... instead of using relative path try using the absolute path of the file and see if it works.
Quote from: kulkarni on 08 Jul 2009 08:07:28 AM
The technique works for only 8.3/8.4 ... see section 1.2. The way elements in a report are accessed has changed a lot when 8.3 was first introduced. So I doubt the JS will will work on your 8.1 environment.
Regarding your error, "free_pane" is the JS file name. What have you put in your SRC attribute?
The doc says SRC="../common/freeze_pane.js" ... instead of using relative path try using the absolute path of the file and see if it works.
oops, i made a total rookie mistake and copied the .JS into the webcontent of the app server instead of the web server :-[
of course when i was testing to see if i could link the images of the webcontent, the 2 were virtually identical so i thought i had placed it in the correct place doh!
anyways, the freeze panes works perfectly fine on version 8.1 and IE6.
thanks for all the help!