Hello one and all,
I'm new to this forum and new to Jet Reports. My company has just installed NAV and its now down to me to build them a suite of reports. I've watched some of the videos on the Jet website and I'm 99% there with the first few reports but I'm having one big issue. If anyone can help I'd be very grateful and will repay the favour in a year or two when I'm a Jet Master!
I'm using Tablebuilder (which is great for a beginner btw). We have two reporting dimensions that we've set up, both of which are numeric codes (for department and division within our business). These appear on our general ledger entries table so I'm pulling them into my report using Tablebuilder. However in the report I also want to bring in the name of the department and division. The names are held in a table called Dimension Values. So I'm linking the table and building a link where "Code = department code", then dragging the "Name" field into my table. This works.
Next I need to build another link to the same table and build a link where "Code = Division code" and drag the "Name" field into my table. But obviously I can't because the name field is already in my table as its being used to lookup the name of the department code.
If anyone has a solution I'd be really grateful.
Thanks
The Frenchman
0 comments
Please sign in to leave a comment.