Account Schedule Report - Filters not visible

Ravi_Prakash_Goyal
Ravi_Prakash_Goyal Member Posts: 72
edited 2013-03-08 in NAV Three Tier
I am running Account Schedule report (Report ID 25) in NAV7. Everthing is fine except I cannot see the filters applied on Account Schedule Line. Which I can cleary see older versions of Navision. I checked this and found that in RDLC layout the hidden property is set to "=IIF(code.GetData(6,2)="",TRUE,FALSE)" for AccScheduleLineTABLECAPTION_AccSchedLineFilter text control. There is also a Setdata function defined, which was supposed to be called from some hidden control but I could not find any such control. Is this a standard bug or am I missing something? When I set hidden property to FALSE, it shows Acc. Schedule Line filters. Please advice.

Thanks
Ravi Prakash Goyal

Comments

  • clausl
    clausl Member Posts: 455
    Our beloved Code.GetData and Code.SetData does not upgrade 100% to NAV 2013 and Report Viewer 2010.
    So all values in Code.SetData fields in the header have been moved to the Visibilty Expression. So you need dig a little to find the expressions.

    Rendering of the Report has changed from Report Viewer 2008 to Report Viewer 2010. In Report Viewer 2008 hidden fields with expression are evaluated as the first thing when placed in top of the header. In Report Viewer 2010 hidden fields with expressions are not evaluated or evaluated completely of sync with the body. So we need to trick it to evaluate first so we move it to the Visibility expression, which is evaluated just like in Report Viewer 2008.

    Look at report 2006 and the empty textboxes in top of the header. The are not really empty, the expression have just been moved to the visibility expression.

    /Claus
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • Ravi_Prakash_Goyal
    Ravi_Prakash_Goyal Member Posts: 72
    Thanks for the clarification Claus!

    I was able to find empty textbox in report 206 with expression in hidden property, but still I could not find such textbox in report 25. I tried moving each and every control available on the report with no success. Is it possible that some of the reports are not completed or tested by microsoft? Can you please check specifically report 25 and let me know if you find the hidden control. Changing the standard object is always last thing in my list unless and until I have to. Please advice. Thanks.

Categories