BI7 Workbook - Rows Hide

[Former Member]

Hello Gurus

We need to hide 50 rows in Query Result set area. I am calculating percentage based on the result of each column . In the output we have 100 rows . user wants to see only 50 rows in the report.

Case 1

• I cannot use conditions . so I cannot use it .

Case 2

I cannot use filter on that column . Becasue i am calculating percentage for each cell based on the entire result of the column.

Option i am left with is to convert to workbook and hide the rows and use the result to calculate the percenatge for remaining rows.

I am unable to achive it in workbook. please through some light in tunnel .

We are on BI7.

Thanks

CC

[Former Member]

go in the Callback sub in VBa in the Workbook, and code the removal or hiding of the lines which are not of use.

To remove the 50 first lines of the result area

Sub CallBack(ParamArray varname())
On Error Resume Next
Dim lOld As Integer
Dim lRange As Range
Dim lRAnge2 As Range
Dim lcell As Range
Set lRange = varname(1)

lRange.Worksheet.Range(lRange.Worksheet.Cells(lRange.Row, lRange.Column), lRange.Worksheet.Cells(lRange.Row + 50, lRange.Column)).Rows.Hidden = True

end sub

To change the range of rows hidden, change offset of the lRange.Row and lRange.row + 50