COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sai.karthik-1980 on 23 Feb 2010 04:22:36 AM

Title: how to freeze the cross tab headers using java script in cognos 8.4
Post by: sai.karthik-1980 on 23 Feb 2010 04:22:36 AM
hi Team


we want to freeze the  cross tab headers using java script.The scenario is horizontal scroll bar is moved
the headers should not move only data has to get moved.but when ever the vertical scroll bar is moved
the header should also move.
can you pls provide me the solution
regards
karthik
Title: Re: how to freeze the cross tab headers using java script in cognos 8.4
Post by: paddhu on 25 Feb 2010 07:07:36 AM
Why JavaScript? Try if this workaround suits your requirement...

- Set the Box Type of the Crosstab Row Node Members to None (or hide it)
- Add a list/table beside the crosstab and imitate it's row headers.
- Fit the Crosstab into a Block item and set the Block's size appropriately.
- Don't forget to set the 'Use Scrollbars when necessary' option.
Title: Re: how to freeze the cross tab headers using java script in cognos 8.4
Post by: kauvasques on 31 Jan 2013 12:13:42 PM
Here a scrip for help
Title: Re: how to freeze the cross tab headers using java script in cognos 8.4
Post by: blom0344 on 01 Feb 2013 03:10:48 AM
Quote from: kauvasques on 31 Jan 2013 12:13:42 PM
Boa noite fiz um relatório que segue em anexo,
nele contem um scrpit modificado para funcionar o congelamento de painéis tanto no cognos 10 quanto no cognos 8.

I'm not sure posting in Portugese is strictly prohibited  ;)  on Cognoise, but very few may be able to read your contribution. Could you try and give us an english version of your message? Doesn't need to be perfect. I know mine isn't ;)
Title: Re: how to freeze the cross tab headers using java script in cognos 8.4
Post by: MFGF on 01 Feb 2013 03:22:54 AM
Quote from: kauvasques on 31 Jan 2013 12:13:42 PM
Boa noite fiz um relatório que segue em anexo,
nele contem um scrpit modificado para funcionar o congelamento de painéis tanto no cognos 10 quanto no cognos 8.

To a muppet like me, this message is just as unintelligible as javascript :) Truthfully, it's difficult for moderators to determine whether the content of posts like this is appropriate, so we'd prefer posts in English if possible. Take no notice when Ties says his posts are not perfect - his English is way better than mine! ;)

Thanks,

MF.
Title: Re: how to freeze the cross tab headers using java script in cognos 8.4
Post by: blom0344 on 01 Feb 2013 07:32:53 AM
Just to let the community know: kauvasques edited his message. You might otherwise wonder why those 2 mods were reacting on   ;D

Title: Re: how to freeze the cross tab headers using java script in cognos 8.4
Post by: MFGF on 01 Feb 2013 11:43:58 AM
Quote from: blom0344 on 01 Feb 2013 07:32:53 AM
Just to let the community know: kauvasques edited his message. You might otherwise wonder why those 2 mods were reacting on   ;D

Thanks kauvasques :)
Title: Re: how to freeze the cross tab headers using java script in cognos 8.4
Post by: bvk.cognoise on 06 Feb 2013 12:55:29 AM
Hi Karthik,
Please try below method hope this helps you

Have 2 blocks, one with crosstab having only header (with deleted measures) and second one have the crosstab with hidden headers. For the second block set the properties 'Size&overflow' height as 13 cm and select 'Use scollbars when necessary'. Execute ur report n see if it works.
The width of the cells need to be adjusted so that both header n body align properly. For me this works perfect.
For fomatting the cell, select the whole crosstab and in table properties select fixed width for both crosstabs. that should work.

Regards
bvk
Title: Re: how to freeze the cross tab headers using java script in cognos 8.4
Post by: bvk.cognoise on 06 Feb 2013 12:56:55 AM
Karthik please try below link as well
http://www.ibm.com/developerworks/data/library/cognos/reporting/advanced_report_design/page622-pdf.pdf

Regards
bvk