0

Join only return 1 of the rows for each Sales Header?

Jet Reports Historic Posts

September 09, 2015 10:51

None

Follow

Hi,

I tried to create a simple report that join 'Sales Header" and "Sales Line", but the report only return 1 of the rows for each Sales Header. Please help.

Thanks.

Using Jet Essentials 2015 Update 1 15.1.15224.0(32 bit) operating in Jet Express Mode

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts September 09, 2015 15:29

  Hello wy_w,
  
  If you link from the Sales Line to the Sales Header rather than from the Sales Header to the Sales Line does it produce the report you are looking for?
  
  Best regards,
  MWilson

• 0
  
  Jet Reports Historic Posts September 10, 2015 02:09

  Hi,
  
  I have tried your way, yes it can show all rows but it is not what I am looking for. Because I want to let users to filter by the fields in the Header table(eg. document date, status) to get only the required data. It seems that applying filter to the secondary table cannot prevent rows from the primary table to show. Any ideas?
  
  Thanks.

• 0
  
  Jet Reports Historic Posts September 10, 2015 19:26

  Hello wy_w,
  
  If I understand you correctly then it sounds like you need a feature of Jet Essentials to accomplish this which is not available in Jet Express.
  I have attached a screenshot of what this looks like.
  If you are running Jet Essentials in Jet Express Mode then you may want to switch back to Jet Essentials and see if this is the case.
  
  Best regards,
  MWilson