I am trying to create a report which makes it easy to select adresses for marketing activities. Therefor i need to know at least in which sector my contacts are. The Nav table"Contact sector" contains this information. This table does not contain any info concerning adresses etc. So I need to combine this table with the Nav table"Contacts". I also would like to create a filter. Let's say I want a list for all contacts from the Netherlands which speak Dutch (Table Contacts"and are working in the sector"Shoes" (Table Contact sector) I am able to do this in a standard report with options disables. As I am the only person who works with jet, I would like to let my collegaues create the files for them selves. Unfortunately I am not able to combine two tables when working with Options. Can someone help me?
Kind regards,
Stefan
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Stefan,
I'm not sure I understand what your delima is as far as combining the tables when creating the report for a viewer. The report itself will be exactly the same. I did notice that you need +Values (or the Dutch equivalent) in cell A1 (on any of the sheets). Before you give the report to a viewer you must add +Values, run the report, and save it in report mode. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi fhilton,
Thanks for the reply. I am sorry i did not discribe my problem accurate. Normally I make reports that combine two different tables together, for example to see the turnover per contact by combining tables Contact and Customer.When I try to do this while creating a report with Options, I do not know how to connect two different Tables and use it as a filter.
Many thanks for your other tip! -
Jet Reports Historic Posts Hi Stefan,
You say you are able to do what you want to do in a report without options. Could you attach the report without options with what you are trying to do?
Regards,
Hughes -
Jet Reports Historic Posts This one I learned from the staff at Jet and I probably tend to over use it but when trying to filter for data from two tables where there is a common variable and I think it maybe what you're trying to do
cell 1 NL("Filter", table1, field, Filters)
cell2 NL("Filter", table2, field, Filters)
cell3 NP("Intersect", Cell1,Cell2) This gives you an array of only those cases where field 1 is in both tables). Now you can use cell3 to filter your NL rows commands
Note you can filter cell1 and cell2 differently based on your criteria - only requirement is same field ( or value field ) Ie field could be No. fromn customer but CustomerNo from other table
There is also the link command but I'll leave that to Jet staff to explain <G>
Van
Please sign in to leave a comment.