0

Filter Options - can you have more than one reference field?

Jet Reports Historic Posts

June 02, 2009 21:19

None

Follow

Hi, I am working on something new. I have a problem connecting my options page to the fields I need filtered.

The first 3 Options are referring to information obtained in Report!B6.
The last Option needs to refer to information obtained in Report!I7.

Report!I7 is also using referring back to Report!B6.

Does anyone else use Sales Desk Worksheets? A sales desk worksheet has 2 parts, a header and a line. I am trying to filter 3 of my options by the sales header and the last by the sales line. Is this possible?

I have attached 2 copies of the report.
1. The first is the original working report, with only 3 opwions referring to Report!B6.
2. The second is the modified version that I cannot get to work.

Please help!!! :shock:

• SDWs.xls
• SDW, incorrect.xls

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Jet Reports Historic Posts June 03, 2009 15:14 Official comment

  Hi Charmillion,
  
  I think this might be correct. I also can't run the report because you have fields that I don't have, but I added some NP("Eval") formulas and a Link= to your NL("Rows","Sales Header") that should help.

  • SDW, incorrect(Corrected).xls
• 0
  
  Jet Reports Historic Posts June 03, 2009 08:13

  The report as modified should work. Our database does not have the fields Entered Date and Entered User ID so I could not run the report as full.
  I have added Named Ranges for the filters then referenced it with NP("Eval") then also copy the Document Type and No. to line level too prevent loosing reference.
  I am a $-freak, always using as much a possible locked Columns and Rows where applies. So I am in full control of what expands…

  • SDWs.xls
• 0
  
  Jet Reports Historic Posts June 03, 2009 14:13

  Thanks, but I think you updated the original report that I created. :)
  
  I need help with the modified version I have attached to this post. I cannot seem to apply the Posting Group option. I have never created a report that had an options page that referred to different parts of a document. The first three "options" are filtering the sales header, but the last "option" filters the sales line.
  
  Any suggestions?

  • SDW, incorrect.xls
• 0
  
  Jet Reports Historic Posts June 03, 2009 15:41

  Thanks, Chuck! You rock!
  That's exactly what I needed!
  :D