0

Unique Rows

Jet Reports Historic Posts

January 11, 2010 04:35

None

Follow

Hello,

How can I return a Unique row when I am using a connector like this:
=NL("Rows=5","Item Ledger Entry",,"Lot No.",Options!$C$2,"Posting Date",Options!$C$3,"Document No.","SO*","Location Code",Options!$C$4,"Item No.",Options!$C$5, "Link=","Sales Header Archive","No.","=Document No.","Sell-to Customer No.",Options!C6,"Salesperson Code",Options!C7,"No.",Options!C8)
Currently when I do this, I am getting the same row multiple times… Is there a way I can just get the unique rows? I am using this query to group things…

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 22, 2010 16:08

  what do you mean that you are getting the same row multiple times. You should be getting one row for each "Item Ledger Entry" record in your filters? Can you provide more information?

• 0
  
  Jet Reports Historic Posts January 25, 2010 21:51

  =NL("Rows=5","Item Ledger Entry",,"Lot No.",Options!$C$2,"Posting Date",Options!$C$3,"Document No.","SO*","Location Code",Options!$C$4,"Item No.",Options!$C$5, "Link=","Sales Header Archive","No.","=Document No.","Sell-to Customer No.",Options!C6,"Salesperson Code",Options!C7,"No.",Options!C8)
  
  Try using this way!
  
  Enter this command into the filter area
  
  =NL("Filter","Sales Header Archive","No.","Sell-to Customer No.",Options!C6,"Salesperson Code",Options!C7,"No.",Options!C8,"No.","SO*")
  Enter this command into the detail area
  
  NL("Rows=5","Item Ledger Entry",,"Lot No.",Options!$C$2,"Posting Date",Options!$C$3,"Document No.","Cell reference","Location Code",Options!$C$4,"Item No.",Options!$C$5)
  
  OR
  
  NL("Rows=5","Item Ledger Entry",,"Lot No.",Options!$C$2,"Posting Date",Options!$C$3,"Document No.",NL("Filter","Sales Header Archive","No.","Sell-to Customer No.",Options!C6,"Salesperson Code",Options!C7,"No.",Options!C8,"No.","SO*")Location Code",Options!$C$4,"Item No.",Options!$C$5)
  
  Let me know if this works for you.