Footer Report

hydhart
Member Posts: 20
Hi,
I have a report with 3 pages in NAV 2016 and create this report using SQL Report Builder. I have set footer to print only in last page, but why the footer are also print at page 2? is it bug? if i only have 2 pages, it's worked well. How do I solve this?
Thanks
I have a report with 3 pages in NAV 2016 and create this report using SQL Report Builder. I have set footer to print only in last page, but why the footer are also print at page 2? is it bug? if i only have 2 pages, it's worked well. How do I solve this?
Thanks
0
Best Answers
-
You can put a visible condition as if globals!page number = totals!page number then print. it will solve your caseThanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/5 -
Hi,
You can bind all the textbox (controls) inside a rectangle in the footer.
Then you can specify the expression which @RockWithNAV suggested in the Visibility of Rectangle.
And that is what @Sowkarthika & @binilabraham are suggesting on a standard Report, but that is an NA version Report.
Thanks & Regards,
Saurav Dhyani
Do you Know this About NAV?
Connect - Twitter | Facebook | Google + | YouTube
Follow - Blog | Facebook Page | Google + Page5
Answers
-
Hi,
Are you dynamically hiding Page Footer? What expression are you using ?0 -
Please take a look at the standard NAV reports (like 10074) which uses a solution to print footer only at last pages.
Else try to use a visibility condition with the help of a developer on footer controls to hide it dynamically based on the TotalPages.Software Developer,
Archerpoint India Pvt. Ltd,Chennai.0 -
Thank you all for your respond,
No, i just set this on Footer Properties. In footer Properties there are only option to check if you want to print this footer on first or last page only.
What Version are you using binilabraham? I can't found any standard report with ID 10074. How can I set dynamically based on TotalPages?0 -
You can put a visible condition as if globals!page number = totals!page number then print. it will solve your caseThanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/5 -
thanks RockWithNAV,
can you spesifically show where I have to put that code? Sorry I'm a little confused here.
0 -
Hi,
You can bind all the textbox (controls) inside a rectangle in the footer.
Then you can specify the expression which @RockWithNAV suggested in the Visibility of Rectangle.
And that is what @Sowkarthika & @binilabraham are suggesting on a standard Report, but that is an NA version Report.
Thanks & Regards,
Saurav Dhyani
Do you Know this About NAV?
Connect - Twitter | Facebook | Google + | YouTube
Follow - Blog | Facebook Page | Google + Page5 -
You can try the way @Saurav and @RockWithNAV suggested. Bind all the controls inside a rectangle and set the visibility condition as RockWithNAV suggested. Please note, before setting up the condition, change the 'RestPageNumber' property to TRUE in the parent group which you used for Page Break.Software Developer,
Archerpoint India Pvt. Ltd,Chennai.1 -
Thanks all for your answers.0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions