Hello,
We are creating a report to show total weights between two dates, for all shipments per customer. We have two SUM fields to read the date and customer name, and pull the values off and sum them. The two formulas are:=NL("Sum","Sales Shipment Header","TotalWeight","Sell-to Customer No.",G16,"Posting/Tax Point Date",$F16)=NL("Sum","Sales Shipment Header","LeadWeight","Sell-to Customer No.",G16,"Posting/Tax Point Date",$F16)
Now for some reason, when we run this report it takes an infinite amount of time, I left it running for 15 hours and it hadn't done.
If you cancel the process though, and look at the data its all there within the first minute. So for some reason its doing a lot more with the data than it needs to.
We know these two calculations are the culprit because taking them out speeds up the report dramatically taking only 30 seconds.
Any ideas :)
Date
Votes
2 comments
-
Jet Reports Historic Posts You should probably turn on Jet logging to see what exactly is taking the time. I would actually recommend that you create a ticket with Jet Reports Support so that someone can help you read the Jet log file and figure out what is happening.
Regards,
Hughes -
Jet Reports Historic Posts Thanks for replying, I sent an email to support and the issue was found to be a corrupt Excel file causing all the bother. The SUM formula seems to be creating replicas of the sheet for some strange reason..
Please sign in to leave a comment.