Hi all,
During working on NAV 2013 Report, i faced an issue. The issue was weird so i thought sharing same with all of you.
I created a report with all the same techniques that we used to use till NAV 2009 R2. Everything was fine and was previewing fine.
Just for your information while creating Report Header and Footer i used GetData and SetData as we used till now.
The preview was great, then i thought to print report in Printer/Excel/Word/PDF Format.
But to my surprise the report header and footer was Blank in all the above mentioned formats.
I was looking for solution for next 4 hours but was unable to find same, then i look in standard report and tried to find difference in SETDATA and GETDATA in NAV 2013 than NAV 2009.
Finally i was able ti find resolution.
PROBLEM -
Report Header is not getting printed while trying to print report in Printer / Excel / Word and PDF Format.
RESOLUTION -
1) Design Report 407.
2) Open Layout.
3) In the Header open the textbox property top left box.
4) You will find nothing under Value in General Tab.
5) Now navigate to Visibility Tab and you will find an expression.
6) Open the expression and you will find Code.SetData there.
7) Do these changes in your Report and it should work, Put the expression in visibility instead of value.
* worked for me, should work for you. :)
Follow the steps as shown below for SETDATA.
Regards,
Saurav Dhyani
www.sauravdhyani.com
During working on NAV 2013 Report, i faced an issue. The issue was weird so i thought sharing same with all of you.
I created a report with all the same techniques that we used to use till NAV 2009 R2. Everything was fine and was previewing fine.
Just for your information while creating Report Header and Footer i used GetData and SetData as we used till now.
The preview was great, then i thought to print report in Printer/Excel/Word/PDF Format.
But to my surprise the report header and footer was Blank in all the above mentioned formats.
I was looking for solution for next 4 hours but was unable to find same, then i look in standard report and tried to find difference in SETDATA and GETDATA in NAV 2013 than NAV 2009.
Finally i was able ti find resolution.
PROBLEM -
Report Header is not getting printed while trying to print report in Printer / Excel / Word and PDF Format.
RESOLUTION -
1) Design Report 407.
2) Open Layout.
3) In the Header open the textbox property top left box.
4) You will find nothing under Value in General Tab.
5) Now navigate to Visibility Tab and you will find an expression.
6) Open the expression and you will find Code.SetData there.
7) Do these changes in your Report and it should work, Put the expression in visibility instead of value.
* worked for me, should work for you. :)
Follow the steps as shown below for SETDATA.
Regards,
Saurav Dhyani
www.sauravdhyani.com
Comments
Post a Comment