Inserting Blank Row in query?

[Former Member]

Dear BWers,

i have a query which needs to have blank rows between other rows in the query result. Is there a way to do this?

Thanks

Raj

[Former Member · Accepted solution]

Yes Bhanu. I am using a structure (based on the infoprovider) in my query. FYI there are other structures existing on the same infoprovider other than the one i am using.

Thanks

Raj

[Former Member · Accepted solution]

Hi,

yes you can include blank rows in between the others.

Just check the below example.

Rows

1 Row

2 Row

3 Row

4 Blank

5 Row

In the New selection, you must be using some objects. Suppose if you are using G/L Account Numbers which are under Chart of accounts, you can just drag chart of accounts and by "excluding from selection" option from context menu you can display blank row.

But you should be using a structure.

[Former Member]

Thanks AVR. That worked.

Raj

[former_member188975]

Hi Raj,

What is the definition of your query like? It is possible to have blank rows if you are using a structure.