You need to move the next boxes from the body section to lowest body section. Change the source expression for each box to the correct one.
For exampe if item is the first dataItem, and you are moving the Description to another body section bellow it. You need to go to the source expression of the text box and change it from Description to item.Description.
Ahmed Rashed Amini
Independent Consultant/Developer
I know it has been awhile since this was posted, but I tried doing this to an existing report and it didn't work. I'm working on report 10138 Inventory to G/L Reconcile.
I need all of the information to display on one line. So I grab the item number from Item, Body and physically move it to Item Ledger Entry, Body (the lowest body section). Then I change the source expression to Item."No." When I run the report the item number is just missing. Same thing with description. Did I miss something in these instructions?
Cant see the problem, and why use variables if the tables are indented correctly, just use the current records to set the source expression of the text box.
Lets say I had:
Customer
>Sales Shipment Header
>>Sales Shipment Line
As a source expression on the "Sales Shipment Line" section, I could have a text boxes with say:
Customer.Blocked and "Sales Shipment Header"."Contact No."
Well, the problem was actually in the original instructions of this post. I tried using the source expression, I tried using the variable, and none of it worked. Why? Because I was putting the source expression/variable on the Item Ledger Entry, Body line, instead of the Item Ledger Entry, Footer line. I only tried the variables on the footer line, and it's working great. Thanks for the help, turned out just how I needed it to, and I'm not a developer!
Comments
For exampe if item is the first dataItem, and you are moving the Description to another body section bellow it. You need to go to the source expression of the text box and change it from Description to item.Description.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I need all of the information to display on one line. So I grab the item number from Item, Body and physically move it to Item Ledger Entry, Body (the lowest body section). Then I change the source expression to Item."No." When I run the report the item number is just missing. Same thing with description. Did I miss something in these instructions?
See if setting the SourceExpr to the global variable(s) shows up your desired information
Lets say I had:
Customer
>Sales Shipment Header
>>Sales Shipment Line
As a source expression on the "Sales Shipment Line" section, I could have a text boxes with say:
Customer.Blocked and "Sales Shipment Header"."Contact No."
Mobile: +44(0)7854 842801
Email: david.cox@adeptris.com
Twitter: https://twitter.com/Adeptris
Website: http://www.adeptris.com