0

Pivot reference to NL table

Jet Reports Historic Posts

October 03, 2012 18:35

None

Follow

Hi,
when i create a table using NL(Table,…) from the Table builder, how do I reference the table name as a pivot data source when in design mode (i.e. Jet hasn't created the table in the report yet?

thanks,

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts October 03, 2012 20:35

  Hi,
  
  So you should add a filter to your NL(Table) function like this: "TableName=","Name" like this:
  
  =NL("Table","Customer",,"TableName=","Name")
  Then when it expands, Jet will set the name of the table to be the name you specify. Then you create a pivot table in report mode which references the table by name. This way when you go back and forth between design and report mode, the pivot table will keep its reference to the table since the table will have the same name. Does this make sense?
  
  Regards,
  Hughes