This website is not affiliated with, sponsored by, or approved by SAP AG.

Insert empty line in BW reports?

Business Warehouse

Moderators: Snowy, thx4allthefish

Insert empty line in BW reports?

Postby prylandsholm » Wed Nov 06, 2002 7:20 am

Hi, does anybody know if it is possible to insert empty lines in BW reports, both web and BEx reports?

Best Regards
PÃ¥l
prylandsholm
 
Posts: 16
Joined: Wed Oct 23, 2002 5:12 am
Location: Norway

Postby ds » Wed Nov 06, 2002 8:37 am

In Web Reports this can be done using TABLE INTERFACE and in BeX you can using VBA macros.

Thanks.
ds
 
Posts: 231
Joined: Tue Oct 22, 2002 10:23 am

Blank lines

Postby 1al1demo » Wed Nov 06, 2002 11:01 am

in 21c create a formula of 0. make the description blank ie use space bar and it works.

i think its easier in 3.0

Al.
1al1demo
 

Postby jai » Wed Nov 06, 2002 11:24 am

Try this code in VBA macros

Sub InsertRow()
Dim Rng
Rng = InputBox("Enter number of rows required.")
Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(Rng - 1, 0)).Select
Selection.EntireRow.Insert
End Sub
jai
 


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 6 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.