Hi all,
I've created a report that has an option to look at multiple companies. Each company is returned as a separate sheet. Within each company sheet is an NL(rows) function with a return limit (these are sorted on a sum).
If I run the report for one or two companies it works fine. Anything more and only the first and last sheets return up to the limit with the sheets in between only returning one or two records. If I run the report for only one/two companies using the companies that on the full report only return 1/2 records it works fine?
Just in case I've done something daft the sum/sort and NL functions are below:
Cell E5 (sum/sort)="+=NL(""Sum"",""SubContractor Ledger Entry"",""Value of Work (Movement)"",""Sub-contractor No."",NF(,""No.""),""Posting Date"",D3,""Document Type"",""Valuation"",0,C3)"
NL(Rows) with limit=NL("Rows","Subcontractor",,"Limit=",D3,0,B3,E3,"*")
Any pointers would be gratefully received!
Running version 5.2.8
Regards,
Q
Date
Votes
8 comments
-
Jet Reports Historic Posts Your formulas should include the "Company=" filter so that they reference the company that the current sheet represents.
-
Jet Reports Historic Posts Hi Sebastiaan,
Thanks for the reply.
I thought the "0" performed exactly the same as "Company="? Or do you mean that it's missing from one of my formula or nested formula?
Regards,
Q -
Jet Reports Historic Posts Dont know about the 0, but it seems to be missing from your Rows with limit.
-
Jet Reports Historic Posts Tried with "Company=" but no change.
Confused! -
Jet Reports Historic Posts 0 and Company= are exactly the same, so I don't think this is the problem. I do see that your 0 filters are to different cells though which seems wrong. One is to cell C3 and the other is to cell B3. I would think these would both need to reference the same cell. Is this the problem?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
I noticed that and resolved it (I had orignally had the "+=NL(Sum)…" nested within the NL(Limit) function but broke them out into seprate cells which is were that error came from) yet still have the same issue?
I'll try and install and configure Jet 2011 on my machine and see whether that makes a difference.
Regards,
Q -
Jet Reports Historic Posts In trying to alter the layout of this sheet to overcome the issue it seems to run one company OK before returning a "C/front invalid handle" error.
Any ideas? -
Jet Reports Historic Posts Hmmm, are you running Jet Essentials 2011 now or are you still using Jet 5.2.8? What version of Navision are you using? This may be an issue you need to take to Jet Reports Support. I doubt we'll be able to find a solution to the C/Front problem on the community site.
Regards,
Hughes
Please sign in to leave a comment.