NAV 2013 Report not rendering some controls

MrBill1962
MrBill1962 Member Posts: 28
edited 2015-09-23 in NAV Three Tier
Hi all,

I have a report similar to a Sales Invoice where there is a large header area that uses a Code.GetData function to display various information. I have a report that doesn't print some of the information on page 1 but it does print on page 2 or any other pages properly. The first 5 listed below don't print but the rest do except the Shipping Agent which never prints on any page. Any assistance will be greatly appreciated.


=Fields!Sales_Header_No.Value + Chr(177) +
FORMAT(Fields!Sales_Header_Order_Date.Value) + Chr(177) +
Fields!TempLocation_Code.Value + Chr(177) +
Fields!Sales_Header_Sell_to_Customer_No.Value + Chr(177) +
Fields!Sales_Header_Shipment_Date.Value + Chr(177) +
Fields!SalesPurchPerson_Name.Value + Chr(177) +
Fields!ProjMgr.Value + Chr(177) +
Fields!Sales_Header_External_Document_No.Value + Chr(177) +
Fields!Sales_Header_Contract_No_And_Change_Order_No.Value + Chr(177) +
Fields!Sales_Header_Contract_Description.Value + Chr(177) +
Fields!Sales_Header_Shipping_Agent_Code.Value

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    USe Cstr(Fields!Sales_Header_Order_Date.Value) + Chr(177) + for all date fields instead of format/blank

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • MrBill1962
    MrBill1962 Member Posts: 28
    I did make the change as you suggested. But sadly no change. Everything prints fine from page 2 on but page 1 is always missing the first fields. ](*,) Also, it always displays properly if previewed.

    =Fields!Sales_Header_No.Value + Chr(177) +
    Cstr(Fields!Sales_Header_Order_Date.Value) + Chr(177) +
    Fields!TempLocation_Code.Value + Chr(177) +
    Fields!Sales_Header_Sell_to_Customer_No.Value + Chr(177) +
    Cstr(Fields!Sales_Header_Shipment_Date.Value) + Chr(177) +
    Fields!SalesPurchPerson_Name.Value + Chr(177) +
    Fields!ProjMgr.Value + Chr(177) +
    Fields!Sales_Header_External_Document_No.Value + Chr(177) +
    Fields!Sales_Header_Contract_No_And_Change_Order_No.Value + Chr(177) +
    Fields!Sales_Header_Contract_Description.Value + Chr(177) +
    Fields!Sales_Header_Shipping_Agent_Code.Value
  • MrBill1962
    MrBill1962 Member Posts: 28
    Any other suggestions?
  • awarn
    awarn Member Posts: 261
    I will assume you have a textbox in the header that does the Code.SetData. The trick I have found on this is that it has to be in the top left hand corner of the screen. If it is at the bottom of the header, then all of the header textboxes / objects that appear before it will be blank. If you print a second page, those objects will all appear properly becuase the textbox has 'printed' (I know it is not visible), already once.

    So try moving it to the top left hand corner and making it very thin and see what happens.
  • vishy_cybereagle
    vishy_cybereagle Member Posts: 3
    The issue could be that the Code.SetData in the header was written as an expression instead of in the visibility settings. We changed this and it worked. The reason being when the report is rendered it executed this to check for visibility of the textbox first rather than the expression. Hope this helps
    Vishy S

    Technical Director | Cyber-Eagle Management
    Crows Nest, NSW 2065
    http://www.cybereaglemanagement.com.au/

Categories