Question Re: Fixed Rows/Columns in Web Interfaces in Technology Q&A

Fixed Rows/Columns in Web Interfaces

Former Member — Thu, 10 Nov 2005 09:21:13 GMT

We are implementing web based BPS-applications for different customers integrating the BPS interfaces into SAP Enterprise Portal. One of the main problems when using web interfaces is that you're not able to fix leading colums/rows in a way that the user only scrolls through the data cells of a layout.

Does anyone know of a way to fix leading colums or rows in BPS-Web Interfaces (either using pure HTML or Excel web component)?

HTML: When using Web Interfaces I would suggest that you have to work with frames. Has anyone done this and can provide a code example?

Excel OWC: Excel-based layouts work well with fixed rows/colums in SAP GUI. But as far as I know the Excel web component doesn't support this feature.

Thorsten

Re: Fixed Rows/Columns in Web Interfaces

former_member93896 — Sat, 12 Nov 2005 01:24:49 GMT

Hello Thorsten,

HTML layouts do not provide this functionality. The best you can do is use styles to format them so they fit on screen.

Excel layout however can be set to fixed columns/rows. Make the change to the layout in BPS0. On the third screen of the layout builder, select "publish to web" (button above the layout).

Regards

Marc

SAP NetWeaver RIG

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Sat, 21 Jan 2006 14:16:44 GMT

Hello Marc,

we have the same problem. Either the layout Key columns are to numerous or to big or the physical screen of the planners computer is too small.

I mean It should be possible using javascript and the OWC to fix the layout! Is there any built in javascript/or not to fix the column view?

Best regards

Yannick

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Mon, 23 Jan 2006 03:21:53 GMT

Hi,

Please check out the below link:

http://web.tampabay.rr.com/bmerkey/examples/locked-column-csv.html

This could help you to identify the HTML changes needed, to ge the scrolling. If it worked let me know. I am yet to use this one.

HTH,

Regards,

Nataraj.

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Mon, 23 Jan 2006 06:55:42 GMT

Hello Nataraj,

can you please send the .csv file to this email-address:

yannick.sigwalt@de.bosch.com

I have some trouble with the firewall

Best regards

Yannick

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Mon, 23 Jan 2006 09:37:32 GMT

Hi,

Sent the files to you. If it worked let me know, I am in the process of finalizing this approach.

regards,

Nataraj.

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Mon, 23 Jan 2006 21:15:55 GMT

Hi Thorsten,

You can use freeze panes in the web interface.

You have to freeze panes (window - freeze pane) in the third screen of your planning layout in BPS0.

The freeze pane will then be active in the web if you use the office web component.

Thanks for your points if this helped you,

Filip

Re: Fixed Rows/Columns in Web Interfaces

former_member93896 — Mon, 13 Feb 2006 22:14:38 GMT

Hello everyone,

here's an update on the topic. The SAP NetWeaver RIG is working on a how-to paper to address the issue. We are currently testing and will publish the paper shortly. I will make an announcement in this group.

Regards

Marc

SAP NetWeaver RIG

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Mon, 20 Feb 2006 13:29:03 GMT

It seems like the topic of fixed rows/colums is quite interesting for a lot of BPS-applications.

We finaly came to the following solution:

1. Modifying each web interface by using the freezepanes-method might work, but we wanted a flexible solution giving the user the opportunity to freeze whatever cell he likes.

2. So we decided to modify the template BPS uses to create new business server pages from web interface builder (BSP "SEM_UPWB"). We added two buttons: the first one freezes the cell the user selected, the second one removes the freeze.

3. Now whenever a new BSP is generated, the two buttons are added automaticaly.

Here's the code we used for the modification:

<img onclick="javascript:layout_sheet.ActiveWindow.FreezePanes = true"

title="Zeilen/Spalten fixieren"

class="bpsBtnIcn"

src="../PUBLIC/BC/Icons/s_brdins.gif">

<img onclick="javascript:layout_sheet.ActiveWindow.FreezePanes = false"

title="Fixierung aufheben"

class="bpsBtnIcn"

src="../PUBLIC/BC/Icons/s_brdout.gif">

Just insert the code into the Object "Layout2.htm" of BSP "SEM_UPWB" after line 492 ("...src="../PUBLIC/BC/Icons/s_f_ehlp.gif"><%endif. %>") and activate the BSP.

If you have problems adding the modification, contact me. I can also supply a short word document (only in german) describing the steps.

Regards

Thorsten

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Tue, 21 Feb 2006 20:13:49 GMT

Hi Thorsten

Did you het this done based on HTML or Excel component? If you can send the detail information to sem_bps2000@yahoo.com, I would be veru much appreciated.

Thanks,

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Wed, 22 Feb 2006 07:21:12 GMT

Hello Thorsten,

simply GREAT

That was exactlky what I was looking for.

The next step would be have the possibility to de/activate the functionality.. .just in case some user

Great job.

Best regards

Yannick

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Thu, 23 Feb 2006 08:26:42 GMT

Hi JW,

the described modification only works for web interfaces based on Microsoft Office Web Component (OWC). So you have to select Excel for all layouts in your web interface.

Regards

Thorsten

Re: Fixed Rows/Columns in Web Interfaces

olaf_fischer — Thu, 23 Feb 2006 17:07:22 GMT

Dear all,

as Mark mentioned I am working an a How to Paper for freezing pane (header and lead) which offers an almost footprintless solution - just include a style sheet section and one javascript section, that's all - no exit class etc.

What to to?

1. Insert a text component at the very beginning of the page and an other one at the very end (attribute html = true)

2. Insert the content of file freezeLayoutStyles.txt into the first text component.

3. Insert the content of file freezeLayoutScript.txt into the second text component.

That should be really all !!!

Prerequisites:

- Internet Explorer

- New Design as of Release BW3.5 (using the SAPBEx styles)

- The front end PC should not be too old

- The text files are located at (for the next 100days):

http://sapmats-de.sap-ag.de/download/download.cgi?id=KYWV2IXL9UWABTEI55GIPOF0ASQK7Z2FKBWN4URC5098ZU1NMC

Have fun ...

Best Regards, Olaf Fischer

Re: Fixed Rows/Columns in Web Interfaces

tom_peng — Thu, 23 Feb 2006 19:17:23 GMT

Olaf, thank you very much for posting a solution. However, we tried it in our 3.5 BW-BPS system and could not get it to work. Our web layout does NOT use the Excel web component -- it is strictly HTML. After implementing your solution, all we see is a grey block where the layout should be. We are using IE 6.0. Any ideas what the problem might be? Anybody else with success using this solution?

Thanks,

Tom

Re: Fixed Rows/Columns in Web Interfaces

olaf_fischer — Fri, 24 Feb 2006 13:29:20 GMT

Dear Thomas,

I have added a test html page to the zip file that contains a simple example using the same techniques as the provided code for web interfaces.

Please try this simple page first to check if your current browser installation supports the techniques used.

Here is the new link (valid for the next 100 days):

http://sapmats-de.sap-ag.de/download/download.cgi?id=SYACC77Q1K474W1ZZO1YKPB5FOX152005UN4IQI7IXPAKQNK03

Best regards, Olaf

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Thu, 02 Mar 2006 10:34:21 GMT

Hi Olaf,

Nice one...!

I have created a similar solution for locking columns/rows in the HTML web pages (using the relativity concept of cells), but these little javascripts are 'killing' the performance of the page.

I have noticed that installing your solution has the same 'bad performance' effect on the page. Do you know any tricks or concepts in order to improve page performance when using javascripts.....?

Thanks,

Rael

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Fri, 03 Mar 2006 07:40:31 GMT

Hi,

I'm using BW 3.5 (Support Pk 11) and we seem to be having a similar problem to Thomas, in that the layouts are not appearing (or are appearing as grey blocks) after following Olaf's instructions. When I load the test HTML page provided by Olaf this functionality works fine, so it can't be a browser problem.

I've tried setting the layouts to ALV from BPS0 and also have played with the layout settings in BPS_WB, again no help there. The web pages are using the new design.

In the file 'freezelayoutscript' it is mentioned that this functionality requires additional style sheets to work. I think this may be the problem, and if so what are they and how are they installed?

If anyone has any ideas, please let me know.

Message was edited by: Marinos Tsiplakis

Hi Again,

Just realised the problem. In BPS_WB, for the Page component the "Arrangement in Table Form" needs to be set to FALSE.

Re: Fixed Rows/Columns in Web Interfaces

olaf_fischer — Sun, 05 Mar 2006 08:50:35 GMT

Dear all,

thanks to all for the feedback about the scrolling solution.

Hints about layouts invisibility:

The example contains a rule to automatically adjust the width of a layout according to the browser window. Unfortunatly this doesn't work in some cases (see post of Marino - arrangemant in table form) with a resulting width zero - nothing is shown.

To come around this insert the line '<i>divWidth = 800;</i>'

directly after the comment '<i>// insert div section around the layout body and seperate footer table</i>'

The other topic is about performance for larger layouts. I have some ideas and work on that.

Best Regards, Olaf

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Thu, 16 Mar 2006 11:05:00 GMT

Hi Olaf,

Your last post mentioned that you were going to work on 'performance issues' for the locking scenario.....?

Even if you can't provide me with a solution, can you at least point me in the right direction to improve performance....? I will work on it myself (until you provide us mere earthlings with the ultimate solution to our problems)..

Thanks,

Rael

Re: Fixed Rows/Columns in Web Interfaces

Former Member — Fri, 07 Apr 2006 19:04:55 GMT

Hi all. I have implemented this and I have 2 issues.

1) when i go to the layout, it appears and it looks like it should work. However my screen does not respond. I cannot scroll or click any other buttons.

2) performance. It takes a very long time for my layout to appear. It is not a lot of data. Only 15 or 20 lines by 20 columns.

Message was edited by: Michael Svolos