I am receiving the attached error while trying to run my jet report. The report was created using the JetReports Wizard. I didn't design this formula. Can anyone help me determine how to fix this? The results should only return about 120 rows, so I am not sure what I can do here.
I believe the formula/cell causing the error is this:
=NL("Rows=2","Sales Invoice Header","Shortcut Dimension 1 Code","Posting Date",Options!$D$5,"Shortcut Dimension 1 Code",Options!$D$6,"Inside Salesperson Code",Options!$D$7,"Bill-to Customer No.",Options!$D$8,"ZIP Code",Options!$D$9,"Customer Posting Group",Options!$D$10)
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi,
I'm assuming you are you using an old version of Jet Reports (v7 or earlier). In older versions of Jet Reports, replicator formulas cannot exceed 255 characters in length. The formula in question is 271 characters long, thus it is too long to be replicated. In order to get around this limitation, you can either remove some of your field names from the formula and put them in other cells and then refer to them by cell references or you can change the field names to use Nav field numbers if you know the numbers for the fields in question. I believe that Jet Reports 2009 and newer do not have this limitations.
Regards,
Hughes -
Jet Reports Historic Posts Thank you!!!
Please sign in to leave a comment.