I created a rows NL function to generate purchase lines data in Excel and then used corresponding NF functions for each column header. In Design mode it shows up the correct data, however, when I 'Run' the report it creates lots of new rows, but the data under each column is blank.
Do you know how I can fix this?
I would wager that your NF function has a absolute reference to your Rows replicator. Assume your Rows function is in cell C4.
The NF should look like NF($C4, "FIELDNAME") and your's probably has a $ sign before both the column and row reference ($C$4).
Its an odd "bug" of Jet that when you do an absolute reference to a key value, it returns nothing.
