2 Replies Latest reply: Oct 3, 2013 7:35 PM by 1002077 RSS

    Activate Report Section by using page number- hyperion IR

    1002077

      Do we have java script to activate report section by page number. I find the below script but i was really hoping if we could put a page number in it, so upon activating the report section it would directly take me to eg: Page 2.

      ActiveDocument.Sections["Report"].Activate();

        • 1. Re: Activate Report Section by using page number- hyperion IR
          WVanSluys

          Unfortunately there is no standard way.

           

          you could fake it by embedding a version of the report on a dashboard.  Then in the results that support the report create a couple calculated items. 

          name: x

          value: 1

           

          name: row

          value: Cume(x)

           

          Not sure on syntax here

          name: page

          value: row % 60 // the number of rows per page using mod

           

          then build table from results so that these columns hold static value.

           

          now build a duplicate copy of report from this table.

          put filter on page.  Use control on dashboard to change the value to "page" through the report. 

          • 2. Re: Activate Report Section by using page number- hyperion IR
            1002077

            I Have around 15 tables in the report coming from 15 different result sections. Do I need to insert 15 tables for each result section? when I drag the report on to dashboard a scroll bar automatically shows for the report. Is there any JavaScript to control the scroll bar in web client mode? Thanks for your help.