New to Jet reports and need a report...

[m3mccann]

Hello all,

I am a complete bewbie to Jet Rports. I need a custom rport out of Nav and it was recommended that I use Jet reports as another person in the office uses them. I have gone to them for help but they day that their report template was written by someone else and they have just used the template for the last couple of years. So in the hopes that some one can help me ... here I am. What I am trying to do is get a list of all of our employees, matched with there employee number and in there payroll card under the payroll function there is a field named rates where we enter their salary for caculating their employment benefits dedeuctions. The particular rate that we have set up is named "BENEFITS". As we have recently found that these values may not be updated between Nav and our benefits provider we are trying to get an export out of each system and then cross reference by employee number. What I am looking for out of Jet I hope to have looking like this:
ex.
Employee # Last name First name Benefits Rate
1552 Doe Jane 50,000.00

I am not sure if I have expained this well enough but if anyone could help it woud be greatly appreciated.

[rmw]

To get Jet working for you, you have to tell it the exact table and field names. And if you need information of more than one table, you should also know how the tables are linked together.

You want this in you report:

Employee # Last name First name Benefits Rate
1552 Doe Jane 50,000.00

What you need to know is which field and which table is the information is coming from.
Assuming it is all coming from the employee table it should look something like this

Code: Select all

C4=NL("Rows";"Employee")
D4=NF($C4;"No.")
E4=NF($C4;"Last Name")
F4=NF($C4;"First Name")
G4=NF($C4;"BenefitRate")

I am guessing the names of fields and table here, so you need to check the exact names within Nav!!

rmw