Divide by Zero occurs upon Detail Delve - Work Around? 2

[Jcfx]

Crystal 10, sql 200.

Customer top 10 report, with a subreport set up per this thread:

http://www.tek-tips.com/viewthread.cfm?qid=1137227&page=1

Layout is as follows.

Group Header: Customer Name Amount %fromSubreport Transactioncount

Detail <hidden drill down ok> Contains the details of each purchase

Group Footer: Empty

Report footer: various grand totals.

This report works perfectly as long as someone does not attempt to drill down to the transaction details. Once they do so, a division by zero error occurs, which points to the shared variable coming from the sub report. If I un hide the details, the report runs without errors, if I re hide the details and do not attempt to drill down, no errors.

Still newbish to crystal so I am not quite sure how to get around this error. I've found two other threads from users having the same issue, but there were not any replies .

Any assistance is appreciated.



Julie
CR 9,10 CE10 Sql DB

 

[Madawc]

The normal fix of division by zero is something like

if IsNull({divisor}) or {divisor} = 0 then 0 else {amount} / ({divisor})

In your case it seems to be more complex. A shared variable from a subreport will always be zero in its own section and only have a value in the section below.

To stop unwanted drill-downs, create a large blank text-object and place it over the account or whatever, the value that can be drilled down on. I assume that you can just change from <hidden drill down ok> to <suppress> because you need the subreport value.

Note that subreports eat up machine-time, sending a separate request to the server each time the subreport is run, whereas the main report does just one. If there's a way round using them, take it.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Change your shared variable formula to:

if <shared var> > 0 then
<your summary> % <shared var>

This will appear as 0 during zero. No way around that.

-LB

 

[Jcfx]

Thanks to the both of you.

Will try changing the shared variable formula.

At the moment, management wants to keep the drill down capability.

Thanks again,

J


Julie
CR 9,10 CE10 Sql DB