Method Community

 

Print Only Specific Line Item on Report

Last post 04-15-2020 12:51 PM by Method_Inderdeep. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 04-10-2020 3:23 PM

    • Geekoid
    • Top 25 Contributor
    • Joined on 06-02-2010
    • Phoenix, AZ
    • Posts 420

    Print Only Specific Line Item on Report

    How can I print only one specific detail line item in a report? For example, I only want to print a chosen row in the ItemReceiptLine grid for an item receipt. I tried using the TxnLineID as a filter in the Generate Report action but that didn't work. I was able to test showing the TxnLineID saved as an action result from a loop through the grid in a message though. 

    Thanks,

    Brett

    Brett
    Go Get Geek!


  • 04-14-2020 9:47 AM In reply to

    • Geekoid
    • Top 25 Contributor
    • Joined on 06-02-2010
    • Phoenix, AZ
    • Posts 420

    Re: Print Only Specific Line Item on Report

    Is this forum dead? Sad

    Brett
    Go Get Geek!


  • 04-14-2020 11:04 AM In reply to

    Re: Print Only Specific Line Item on Report

    Hi Geekoid,

    Apologies for the delay in answering this post. I can do a bit of testing on my end to offer some solution to this query. 

    -Inder

  • 04-14-2020 11:14 AM In reply to

    • Geekoid
    • Top 25 Contributor
    • Joined on 06-02-2010
    • Phoenix, AZ
    • Posts 420

    Re: Print Only Specific Line Item on Report

    No worries...thanks Inder!

    Brett
    Go Get Geek!


  • 04-15-2020 10:54 AM In reply to

    Re: Print Only Specific Line Item on Report

    I take it that the report header is different than the detail table here? Your best bet is to probably use the filter criteria on the detail band within report designer.

    So to set something like this up, within method have an extra field on the detail table that you can set to true, and then in report designer using the filter criteria on the band only display the lines that = true.

  • 04-15-2020 11:35 AM In reply to

    • Geekoid
    • Top 25 Contributor
    • Joined on 06-02-2010
    • Phoenix, AZ
    • Posts 420

    Re: Print Only Specific Line Item on Report

    I don't have a report header; however, I didn't know you could filter the DetailReport band. Embarrassed I did what you said with a filter and it worked! 

    Thanks so much for your help, as usual. 

    Brett
    Go Get Geek!


  • 04-15-2020 12:51 PM In reply to

    Re: Print Only Specific Line Item on Report

    Glad it worked!

Page 1 of 1 (7 items)