Report Lines problem.

upasanisandipupasanisandip Member Posts: 405
Hi,

I have created 1 report using 5 tables.

My prob. is that the part of body of every table is not coming in 1 line.
There is slight difference between them.

Any suggessitions welcome.



Thanks,
Sandip.

Comments

  • ara3nara3n Member Posts: 9,256
    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


    blog: https://dynamicsuser.net/nav/b/ara3n
  • AlexWileyAlexWiley Member Posts: 230
    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?
  • XypherXypher Member Posts: 297
    Try assigning a global variable (per field you want to show) to the field value within the OnAfterGetRecord of the DataItems.

    See if setting the SourceExpr to the global variable(s) shows up your desired information
  • David_CoxDavid_Cox Member Posts: 509
    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."
    Analyst Developer with over 17 years Navision, Contract Status - Busy
    Mobile: +44(0)7854 842801
    Email: david.cox@adeptris.com
    Twitter: https://twitter.com/Adeptris
    Website: http://www.adeptris.com
  • AlexWileyAlexWiley Member Posts: 230
    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! :D
Sign In or Register to comment.