Hi,
I have designed a sales report which has 3 sections on the same tab, one below the other, all 3 of which use the NL Rows function.
Until recently it worked fine, however now when I run it the top section won't make the rows, I just get 1 line with #VALUE errors. When I use Debug it will find the first line fine.
The other 2 sections still work fine, and the only difference in the sections is that they filter differently on Customer Posting Group.
I am really confused! I have tried copying and pasting the formula from one of the other rows and then just changing the Customer Posting Group filter but it still won't work :(
Any suggestions?
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Claire,
try to copy the top section to a new a excel sheet and let it run….
Do you get values then?
regards -
Jet Reports Historic Posts Hi,
Yes, if I copy the top section to a new sheet it will run and create the rows with no problem.
At the moment if I copy and paste one of the lower sections into the top section and then manually change the Customer Posting Group it will run fine the first time but not afterwards, and while I don't mind copying and pasting each time I want to run the report it is a bit annoying :( -
Jet Reports Historic Posts hi,
thx for the feedback.
If you copy the complete sections into a new workbook, does it work then normally?
i've had that problem a few times in the past, and could solve it by copy the lines to a new workbook…however…
regards
Please sign in to leave a comment.