The requirements for Jet Reports Certified Professional

1. Pass the Jet Reports Certified exam

Online Exam of 30 support and advanced functionality questions about Jet Reports. The successful candidate will achieve 80% on the exam.

Click here for exam topics:
http://www.jetreports.com/certification/jcp-topics

Sign up here:
http://partner.jetreports.com/jetcart/

2. Submit an original report to certification@jetreports.com

• The report must be written by you.
• You will receive a grade on your submission within two weeks.
• The following criteria must be met and highlighted in yellow.

Required Items (all items must be present in a single report)

• Options Page
• NP(“Eval”)
• NL(“Lookup”)
• NL(“Rows”), NL(“ Columns”), or NL(“Sheets”)

Plus use any 3 of the following Jet Reports features

• NL(“Filter”)
• NL(“Sum”)
• NL(“Count”)
• NL(“CountUnique”)
• GL function (Navision or Great Plains)
• NP(“Datefilter”)
• NP(“Union”)
• NP(“Intersect”)
• NP(“Difference”)
• Link=
• Conditional Hides

Plus use any 2 of the following Excel features

• OFFSET()
• SUBTOTAL()
• TEXT()
• IF()
• AND
• OR
• INDIRECT()
• Conditional Formatting