cancel
Showing results for 
Search instead for 
Did you mean: 

Freezing columns in web reports

Former Member
0 Kudos

HI

We are using Analasys item in our Web report got many columns , they have to scroll horizontally. when they scroll right side they cant see labels , so i have to freeze 2 column which has labels so that even when they scroll horizontally they can see labels.

pasting only ANALYSIS_ITEM source code

-


<p >

<bi:ANALYSIS_ITEM name="ANALYSIS_ITEM_1" designwidth="621" designheight="233" >

<bi:WIDTH value="621" />

<bi:HEIGHT value="233" />

<bi:DATA_PROVIDER_REF value="DP_5" />

<bi:LINKED_DATA_PROVIDER_REF_LIST type="XXXXT" />

</bi:ANALYSIS_ITEM>

</p>

-


Can some one help me urgently.

Thanks

Babu

Edited by: babloo babu on Nov 17, 2010 3:50 PM

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member241911
Participant
0 Kudos

Hi,

as Priya mentioned, there´s a modification for the analysis item in BI 7.0 which implements scrollbars inside the data table.

Please lookup thread [6647720|; for further information.

The full docu is availible at Tobias Kaufmann as mentioned there.

It works fine.

Best regards

Arne

Former Member
0 Kudos

Hi Babu,

What version of WAD are you using? If using WAD 7, you can fix the header rows and leading columns in Analysis webitem using the Fix Rows and Columns module (com.sap.ip.bi.rig.Scrolling) .

--Priya

Former Member
0 Kudos

Hi Priya

Do you have any step by step procedure to do this.

Thanks

Babu

former_member241911
Participant
0 Kudos

Hi,

try out this code.

I added the Scrolling functionality to your example. Just ask Tobias.kaufmann(at)sap.com for the full documentation.

Best regards

Arne


<bi:ANALYSIS_ITEM name="ANALYSIS_ITEM_1" designwidth="621" designheight="233" >
<bi:WIDTH value="621" />
<bi:HEIGHT value="233" />
<bi:DATA_PROVIDER_REF value="DP_5" />
<bi:LINKED_DATA_PROVIDER_REF_LIST type="XXXXT" />
<bi:MOD_SINGLE_MODULE type="COMPOSITE" >
<bi:ACTIVE value="X" />
<bi:MOD_SELECT type="CHOICE" value="MOD_GENERIC_MODULE" >
<bi:MOD_GENERIC_MODULE type="COMPOSITE" >
<bi:MOD_REFERENCE value="com.sap.ip.bi.rig.Scrolling" />
<bi:MOD_PARAMETER_LIST type="ORDEREDLIST" >
<bi:MOD_PARAMETER type="COMPOSITE" index="1" >
<bi:MOD_PARAM_NAME value="WIDTH" />
<bi:MOD_PARAM_VALUE type="CHOICE" value="STRING" >
<bi:STRING value="document.body.clientWidth" />
</bi:MOD_PARAM_VALUE>
</bi:MOD_PARAMETER>
<bi:MOD_PARAMETER type="COMPOSITE" index="2" >
<bi:MOD_PARAM_NAME value="HEIGHT" />
<bi:MOD_PARAM_VALUE type="CHOICE" value="STRING" >
<bi:STRING value="document.body.clientHeight / 2" />
</bi:MOD_PARAM_VALUE>
</bi:MOD_PARAMETER>
</bi:MOD_PARAMETER_LIST>
</bi:MOD_GENERIC_MODULE>
</bi:MOD_SELECT>
</bi:MOD_SINGLE_MODULE>
</bi:MODIFICATION>
</bi:ANALYSIS_ITEM>

Former Member
0 Kudos

Hi Babu,

As I understand, you wish to have the first 2 columns fixed with a horizontal scrollbar for the remaining columns - the below code will help you achieve the same: (plz. note, this refers to WAD 7 - I assume you are on WAD 7)


            <bi:ANALYSIS_ITEM name="ANALYSIS_ITEM_1" designwidth="621" designheight="233" >
                <bi:WIDTH value="621" />
                <bi:HEIGHT value="233" />
                <bi:DATA_PROVIDER_REF value="DP_5" />
                <bi:LINKED_DATA_PROVIDER_REF_LIST type="ORDEREDLIST" >
                    <bi:LINKED_DATA_PROVIDER_REF index="1" value="XXXXT" />
                </bi:LINKED_DATA_PROVIDER_REF_LIST>
                <bi:MODIFICATION type="CHOICE" value="MOD_SINGLE_MODULE" >
                    <bi:MOD_SINGLE_MODULE type="COMPOSITE" >
                        <bi:MOD_ALIAS value="MOD_SCROLL" />
                        <bi:ACTIVE value="X" />
                        <bi:MOD_TARGETS type="CHOICE" value="ALL" />
                        <bi:MOD_SELECT type="CHOICE" value="MOD_GENERIC_MODULE" >
                            <bi:MOD_GENERIC_MODULE type="COMPOSITE" >
                                <bi:MOD_REFERENCE value="com.sap.ip.bi.rig.Scrolling" />
                                <bi:MOD_PARAMETER_LIST type="ORDEREDLIST" >
                                    <bi:MOD_PARAMETER type="COMPOSITE" index="1" >
                                        <bi:MOD_PARAM_NAME value="COLUMN" />
                                        <bi:MOD_PARAM_VALUE type="CHOICE" value="BOOLEAN" >
                                            <bi:BOOLEAN value="X" />
                                        </bi:MOD_PARAM_VALUE>
                                        <bi:MOD_PLACEHOLDER_LIST type="ORDEREDLIST" >
                                            <bi:MOD_PARAM_VALUE type="CHOICE" index="1" value="CHARACTERISTIC" >
                                                <bi:CHARACTERISTIC value="0XYZ" text="0XYZ" />
                                            </bi:MOD_PARAM_VALUE>
                                        </bi:MOD_PLACEHOLDER_LIST>
                                    </bi:MOD_PARAMETER>
                                </bi:MOD_PARAMETER_LIST>
                            </bi:MOD_GENERIC_MODULE>
                        </bi:MOD_SELECT>
                    </bi:MOD_SINGLE_MODULE>
                </bi:MODIFICATION>
                <bi:BLOCK_COLUMNS_SIZE value="0" />
                <bi:BLOCK_ROWS_SIZE value="0" />
            </bi:ANALYSIS_ITEM>

Plz. replace 0XYZ with the characteristic in DP5 that specifies the last fixed column. Inorder to have the columns scroll, you would first need to deactivate pagination by setting parameters BLOCK_COLUMNS_SIZE and BLOCK_ROWS_SIZE to 0 - it has been done thru' the above code.

If you are not comfortable pasting the XHTML code in the XHTML window, I can provide steps to achieve the same thru' the Property window.

--Priya