NAV 2013 Report not rendering some controls

MrBill1962

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

mohana_cse06

USe Cstr(Fields!Sales_Header_Order_Date.Value) + Chr(177) + for all date fields instead of format/blank

MrBill1962

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

Any other suggestions?

awarn

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

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