Skip to Content
author's profile photo Former Member
Former Member

How to fix column headers in Portal

Hi Guru's,

do you know is there a way to fix the report headlines like in Excel.

E.g. I have a report with about 2000 rows and when the user scrolls down the headlines are out of the screen and he doesn't know what is in which column.

So, we know about the possibility to restrict the rows per page to 20 rows or whatever, but then the jumping from side to side takes too much time.

So, is there a possibility to "fix the cells" like in Excel, so the User scrolls down and always sees the column headers?

Thanks in advance!

Sandra

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 17, 2008 at 01:24 PM

    In 7.0 Analyzer, open the workbook and go into Designer Mode. Double-click on the analysis grid to bring up the properties screen. Under the range field, replace the 2nd row number to the row where you want to limit the table. Then go to the tab called Clipping, select "Scroll and Keep Lead" under Vertical.

    Dunno about 3.5.

    Edited by: Andrew Zhou on Jul 17, 2008 9:25 AM

    Oops you wanted to do this on web, not the other way around. In WAD 7.0, open the web template (if you're using standard template, it's 0ANALYSIS_PATTERN). Select the analysis grid and go into it's properties, change the "Number of Data Rows Displayed at Once" to your liking.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2008 at 01:32 PM

    Hello,

    thanks .... but is there also a solution fot the web application designer as we ant to use it in the Portal? We can not use the Design Mode in Excel as we are working with Excel 2000....but BI 7.0...this combination doesn't work!

    Thanks in advance

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2008 at 11:23 PM

    There are some threads and sample code for how to set the Web Template in a box with scrolling functions. However this code was for old version. I am told that the new version uses different HTML and that the API's are hidden. I am not sure what this means as usually new versions are an improvement not a step backwards.

    What you are asking is a common problem, and instead of waiting for BI 8.0 I would suspect SAP would consider an enhancement to their product if enough customers complained directly.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.