Skip to Content
0
Former Member
Jul 17, 2008 at 06:09 PM

EvDRE Question -- Inserting Blank Rows

28 Views

Hi all,

Here's a good question that we've run into a couple of different times with EvDRE: Say you are specifying a Memberset to expand on that will consist of a comma-delimited list like:

bas(Accounts_Receivable), Accounts_Receivable,

bas(Accounts_Payable), Accounts_Payable,

bas(Notes_Receivable), Notes,Receivable,

bas(Fixed_Assets), Fixed_Assets ...etc.

This would expand each of the four account groups, and follow each of them with their respective parent.

Question: What's the best way to insert a blank row after each parent/subtotal?

It turns out that if you use the SUPPRESS=Y for that Expansion, that the Blanks get suppressed (since the suppression is . Also, I'm not sure if there is a good Before/After Range option... But, how about maybe using INSERT ?

Thanks,

Garrett