0

Creating an additional line

Jet Reports Historic Posts

August 05, 2013 21:31

None

Follow

Hello everyone,

I would like to add a blank line when using the following formula:

=NL("rows"; "Dimension Value"; "Code")


with "Dimension Value" table:

Dimension Code Code
TEST Name1
TEST Name2
TEST Name3

Currently, I have the following result:

Name1
Name2
Name3

I would like to have:

""
Name1
Name2
Name3


Thank you for your help,


Mat

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts August 07, 2013 21:56 Official comment

  Thanks for the help Gerard,
  
  What I came up with in the end:
  
  
  =NL("rows";NP("Union";G13;H13))
  
  with G13: =NL("Filter"; "Dimension Value"; "Code")
  and H13: =0

• 0
  
  Jet Reports Historic Posts August 06, 2013 07:24

  You could use a nested Rows. First a "rows=2" with on the first line a statement returning the double quotes and on the second line the real rows-function.
  
  For example:
  - Cell B3: =NL("Rows=2";"Date";;"Period Start";TODAY()) 'Or some thing like this.
  - Cell C3: =CONCATENATE("""""")
  - Cell C4: =NL("Rows";"Dimension Value";"Code")
  
  Just a suggestion!
  
  Regards,
  Gerard