Home Ask Login Register

Developers Planet

Your answer is one click away!

Daniel February 2016

Getting first 3 chars from "Job No." to use as filter - Jet Reports

I am struggling to get the Quantities from the Job Ledger Entries Table which I need to filter on the first 3 letters of the Job No. pulled from the Item Budget Entries..

I am new to Jet Reports and using Express.. I have tried the function:

Attempt to get first 3 chars

Should I add it as a line of code = to a variable then use the variable?

My table query looks like this so far:

=NL("Table";"Item Budget Entry";$E$12:$I$12;"Headers=";$E$11:$I$11;"TableName=";"Item Budget Entry";"Filters=";$C$5:$D$6;"InclusiveLink=Item Budget Entry";$E$10;"IncludeDuplicates=";"True")

With Filters:

Filters for the table


gbierkens March 2016

I think this will be hard to achive with the express version. In the Essentials version you are able to add Excel formulas to your table.

What I would do is create two tables, one with item budget entry and one with job ledger entry. And then use excel to calculate the sums.

Or use the Essentials version, which will make your life a lot easier.

Post Status

Asked in February 2016
Viewed 3,685 times
Voted 12
Answered 1 times


Leave an answer

Quote of the day: live life