Skip to Content
avatar image
Former Member

BI7 Workbook - Rows Hide

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 04, 2008 at 11:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded