Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Page X of Y for Sales Invoice in NAV 2013 Error-Question
Lilithyan
Member Posts: 32
Hi Everybody,
so... I've been browsing the web and have been experimenting some myself to get a that problme of printing "Page X of Y" in the sales invoice solved. So far no luck sadly. But I did stumble over something that I didn't quite understand. Maybe it's just me still being in a func about getting booted out of my apartment after living only six months in it and having to find a new one in the next two and a half months. Anyway...
I had a thought about the main problem here, that being the TotalPages, which usually gives out the wrong value if you print one or more copies of an invoice or more than one invoice at a time. And I thought to myself: "Okay, if I go by the assumption, that only one invoice is printed at a time, but with an x amount of copies, can't I get the last value of the OutPutNo and divide the TotalPages through that?"
Rudementary example of my thought-process from above: Globals!TotalPages / Last(Fields!OutPutNo.Value). (for the second value actually a code.getdata, because it being in the Header and all that).
So I had the thought it would either work or not. The way I tried it didn't work but I don't understand the (wrong) value it prints. Insted of something like #Error I get "unendlich", which is the german word for infinite as I'm German and thus develope on a System with the base language being German.
Any idea just why I get that kind of error? Because I can't currently make either heads or tails of it.
Ciao,
Lilithyan
PS:I just tried it with the value in NoOfLoops, which the CopyLoop DataItem uses to find out how many prints there are (NoOfLoops := ABS(NoOfCopies) + 1;), but got the same result.
so... I've been browsing the web and have been experimenting some myself to get a that problme of printing "Page X of Y" in the sales invoice solved. So far no luck sadly. But I did stumble over something that I didn't quite understand. Maybe it's just me still being in a func about getting booted out of my apartment after living only six months in it and having to find a new one in the next two and a half months. Anyway...
I had a thought about the main problem here, that being the TotalPages, which usually gives out the wrong value if you print one or more copies of an invoice or more than one invoice at a time. And I thought to myself: "Okay, if I go by the assumption, that only one invoice is printed at a time, but with an x amount of copies, can't I get the last value of the OutPutNo and divide the TotalPages through that?"
Rudementary example of my thought-process from above: Globals!TotalPages / Last(Fields!OutPutNo.Value). (for the second value actually a code.getdata, because it being in the Header and all that).
So I had the thought it would either work or not. The way I tried it didn't work but I don't understand the (wrong) value it prints. Insted of something like #Error I get "unendlich", which is the german word for infinite as I'm German and thus develope on a System with the base language being German.
Any idea just why I get that kind of error? Because I can't currently make either heads or tails of it.
Ciao,
Lilithyan
PS:I just tried it with the value in NoOfLoops, which the CopyLoop DataItem uses to find out how many prints there are (NoOfLoops := ABS(NoOfCopies) + 1;), but got the same result.
0
Comments
=iif(First(Fields!NoOfCopies.Value, "DataSet_Result") <> 0,Globals!TotalPages / (First(Fields!NoOfCopies.Value, "DataSet_Result") + 1),Globals!TotalPages)
in preview u wil get wrong total but in print preview u wil get correct