I am trying to create a cost report which takes information from our job ledger entries, sums it and just shows the totals. I have got this to work with no problems. However, I need to show several date ranges on the same sheet - for example, the sum for just this month, the year to date, and the total to date. I tried to create three completely independent Navision Links, but that doesn't work - for every line in the first sum, it returns every line in the second - the results is that where before I had 5 lines, I now have 25 lines, most of which are rubbish.
Is there anyway of keeping the two compeltely separate? - I realise it wil be tricky with hiding rows and things.
Having multiple Navision links on the same sheet