Has anyone tried to link to create 2 links to the same source table in table builder…
People really seem to like the table builder reports and the ability to quickly filter results. However we have a contact table for each of our jobs. What I want to be able to do is return the first record matching the job no. and a specific role code, and the first record that matches the job no. with another specific role code. Standard jet reports work fine with this behaviour, but I want to be able to do this with table builder, however there doesn't seem to be an option to give a nav table an alias.
Any thoughts?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
Nope, there is currently no way to do this in the Table Builder (or in NL(Table) in general). Things like aliasing were considered, but were left out for simplicity. In this case, you should use other Jet functions to achieve this result. I suppose you COULD do it in the Table Builder if you just added a formula and typed in an NL(First) formula to get the value. You'd have the add the Job No. as a field so you could filter by it in the NL(First) formula. This should work if you really want to use a table, but it's not too pretty. Does that answer your question?
Regards,
Hughes -
Jet Reports Historic Posts Thanks for the response
I won't try to do it anymore and fall back to using a more standard report layout.
Please sign in to leave a comment.