Hello I have a report that give numerical summaries of sales reps activities and pipelines. This reports is accessing a GoldMine SQL backend.
The main report uses the history table and counts things like calls, appts, sales. The subreports (there are 5) that use date parameters that count pending/closed sales and units. I have the main report grouping by formula for region and group2 conthist.userid and the sub reports grouping by either conthist.userid or cal.userid. I have the subreports linking to the main report by userid.
My problem is that the subreports do not print 0's for all of the users. It shows all of their sales but if the value is 0 it does not print "0's" for everyone. I have all of the usual stuff checked - convert NULL to default (made sure that was 0) I even created a formula that said if the value was NULL then totext "0" that didn't do it either. If I run the subreport by itself it reacts in the same exact way (thought it was my linking) some users show 0 some don't.
any thoughts?
The main report uses the history table and counts things like calls, appts, sales. The subreports (there are 5) that use date parameters that count pending/closed sales and units. I have the main report grouping by formula for region and group2 conthist.userid and the sub reports grouping by either conthist.userid or cal.userid. I have the subreports linking to the main report by userid.
My problem is that the subreports do not print 0's for all of the users. It shows all of their sales but if the value is 0 it does not print "0's" for everyone. I have all of the usual stuff checked - convert NULL to default (made sure that was 0) I even created a formula that said if the value was NULL then totext "0" that didn't do it either. If I run the subreport by itself it reacts in the same exact way (thought it was my linking) some users show 0 some don't.
any thoughts?