cancel
Showing results for 
Search instead for 
Did you mean: 

Freezing Column Headers in web reports

Former Member
0 Kudos

Hi Friends,

I have an urgent issue. I need Horizontal and vertical scrolling in web reports.I got these scroll bars. now i need to freeze the column headers in web reports.

I tried with the code given in the following link

,

but this doesn't work for me. if any body has better solution please suggest me.

is this problem resolved by SAP in new version i.e BI 7.0? If yes please send me the links or documents. my current version BW 3.5.

Thanks in advance

Sathya

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi Gopi,

Thanks for your mail. I tried with this code. still getting the error.

Thanks

Sathya

michael_koch9
Active Participant
0 Kudos

HI Sathya,

why doesn´t the solution of the forum doesn´t work for you? are they any errors, if you want you can post me your template code and i will check it.

Unfortunately i´am seconds away to run our 7.0 System, so i can´t tell if this is working in the new version, but i talked to an SAP Guy last dezember about this issue and post him the nearly the same solution like in the thread you post.

Regards

Marcus

Former Member
0 Kudos

The code will work with some change in the function

<i>function find_sap_table(table_name) {var i;var table;// get the original table table=document.getElementsByTagName("table"); for (i=0; i<table.length; i++) { if (table.getAttribute("name")==table_name) return table; }}</i>This function I tried but it is not working. I changed it to

<i>function find_sap_table( table_name ){

var all_tables = document.getElementsByTagName("table");

for( var i=0;i<all_tables.length;i++ ){

if (all_tables<i>.name==table_name)//we have found tbl

return all_tables;

}

return null;

}</i>

Regs

Gopi.

Message was edited by: Gopi

Former Member
0 Kudos

Hi Marcus Pospiech,

I will send the code i have written soon. today I am not getting access to my web template, because its locked. can you send me any documents related to BI 7.0 shows that this freezing column headers and locking headers problem solved. my mail id anumolu_s@yahoo.com.

Thanks

Sathya

michael_koch9
Active Participant
0 Kudos

Sorry, but i have no documentation in 7.0 for this problem, but our 7.0 system setup is finished this evening so i will check if the funtion exits and inform you.

Regards

Marcus

Former Member
0 Kudos

Hi Satya,

Can you give me the code or the solution that worked for you for freezing the headers to.

Thanks

Rashmi.

Former Member
0 Kudos

Hi guys,

I am also i search of the same requirement, so could any one help us out on this issue.

Thanks,

Kiran Gangavaram

Former Member
0 Kudos

Hi Friends,

any help on this issue. Please suggest me whether this problems are solved in BI 7.0, If yes please send me the documents.

mail: anumolu_s@yahoo.com

Thanks

Sathya

Former Member
0 Kudos

I have send a mail please check.

Regs

Gopi.

Former Member
0 Kudos

Friends,

any help on this...

Sathya

Former Member
0 Kudos

Sathya,

I tried with a sample of 10 records. The number of records to display I have restricted to 2.When I used the navigation button the Column Headers are freezed and they never disappear.

I never used the scroll bars as when reduced size of my browser less than the report size automatically IE is putting the scroll bars. I want to know the purpose why are you using the scroll bars when IE automatically sets up.Are you showing 2 or reports together in the Web?

Please excuse me if I don't understand the problem well.

Regs

Gopi.

Former Member
0 Kudos

Hi Gopi,

presently all webreports of my client is diaplaying 100 rows per page. when enduser viewing webreports, this is very inconvienient, so asked me to change. I changed it to 20 rows to display. if we have scroling to table display this is very helpful to view the data. I got the scrollbars by modifying the Div code in HTML. But when I use vertical scrollbar, the headers also moving up. i don't want this. I want to freeze the headers.

again one more new requirement. I want to add freeze function to context menu. so that whatever columns i want to freeze i can frrze it. it should work like excel freeze panes. can any body help on this....

Sathya

Former Member
0 Kudos

Hi Friends,

can any body he me on this issue????

Sathya