Fixed Rows/Columns in Web Interfaces

[Former Member]

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

[tom_peng]

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

[olaf_fischer]

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=SYACC77Q1K474W1ZZO1YKPB5FOX152005UN4IQI7IXPAKQN...

Best regards, Olaf

[Former Member]

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

[Former Member]

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.

[olaf_fischer]

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

[Former Member]

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

[Former Member]

Dear Olaf,

I would like to use your solution. Please send me the active link/ zip file.

My email address is: [email protected]

Thanks,

Sujoy

[Former Member]

Hi Olaf,

The link has expired. Can you please send it to me at [email protected]? I would greatly appreciate it as we have been needing this for quite some time.

Thanks

Kory Squire

[Former Member]

Hi Olaf,

your solution for fixing columns/rows works so far. But a big problem is performance. In your posting you mentioned to have a few ideas about that issue and to work on that. How far did you get already? I need a solution necessarily. If you haven´t a solution already you can give me your hints and I will try to improve performance by myself.

Best regards,

Alex