Hi Community,
I have a report with an options sheet in which the user can input a date range. The report then generates new sheets for each salesorder within the range. However the original design sheet is also visible, it is renamed to '(2)' and it gives an 'empty filter is not allowed' error. Is there any way to hide the original designsheet or am I missing something else?
Date
Votes
2 comments
-
Jet Reports Historic Posts To me this sounds like you retrieved an empty field from the database for which Jet generates a separate sheet.
In your NL(Sheets…) function you entered a field in the Field argument, didn't you? The unique values for this field are retrieved from your database. Jet Reports generates a new sheet for each unique value. The name of the sheet is the value returned. One of these values is blank / empty. Jet Reports names this sheet (2) instead of leaving the name of the sheet blank. It would be good if this would be added to page 191 of the Jet Reports V7 PDF file.
You probably have an NL function that uses the unique values of the NL(Sheets…) as a filter. Because of the blank / empty value you get the error message that an empty filter is not allowed. Add "@@"& to your Filter argument to avoid this error message - see page 71 of the Jet Reports V7 PDF file.
Please let us know if this works for you. -
Jet Reports Historic Posts Thank you for pointing me into the right direction. I changed my original link:
=NL("Sheets";"Sales Shipment Header";"Order No.";"Order Date";Options!$C$9)
to:
=NL("Sheets";"Sales Shipment Header";"Order No.";"Order Date";Options!$C$9;"Order No.";"<>@@")
I've just started out with JetReports so I'm still learning by trail and error.
Please sign in to leave a comment.