0

Sales Price

Jet Reports Historic Posts

May 22, 2009 02:17

None

Follow

Hi Everyone,

I'm trying to create a Report that will bring back the current Sales Price for a Specific Customer Grouped by "Item Category" then by "Product Group"
Multiple items share a Group and Multiple Groups are in 1 Category.

I Would do NL("Rows","Sales Price","Item Category",……
but on the Sales price Table there isn't "Item Category" and "Product Group" Fields.
the only other way I can think of is to check every line, but this could be time consuming for a 600 Line Sales Price

is there a simpler way of doing this that i'm missing out of??

-Bromy

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts June 02, 2009 06:01

  I haven't had any replies, but i'm sure Someone would have some ideas.
  
  -Bromy

• 0
  
  Jet Reports Historic Posts June 12, 2009 12:45

  Maybe a little bit late but do you have a sheet with a layout how you want to see your report?
  
  Greetings
  Hans Dütting

• 0
  
  Jet Reports Historic Posts September 01, 2009 08:38

  Hi,
  
  Apologies for the Extremely late reply.
  
  attached is a copy of the report I have currently.
  however this report now returns NAME# errors everywhere for some reason.
  
  :(

  • Contract Expiry.xls