I am linking in a subreport that uses the same SQL View as the main report (Mainly so the headings look good on the drill down). The field that I'm linking on has 10 records with a null value. So the drill down for that field shows all 10 fields 10 times. It's like it repeats the whole report for every instance of the null.
I've tried putting an actually value into the view with a CASE statement in SQL and still get the same results. I just want the 10 records to show up once, like all of the other linked values do. Any suggestions?
IP Logged