Topic: Section Expert Posted: 29 Oct 2013 at 9:04am
Hello, my report looks through the sales history file by selected customer and 2 different date ranges, to compare one date range to the next. I have 2 running totals called rtotal0 and rtotal1, which adds the qty to each selected date range, resetting after the part #. it is working perfectly EXCEPT I am showing all parts for this customer, even when nothing shipped within either of the date ranges. I tried to do a section expert to suppress if rtotal1=0 and rtotal1=0. which should work, right ? I've tried other combinations which brought about different results, but none were correct. I am almost where I need to be, just need to get rid of the lines where nothing shipped. I can't think of any other way to do this. Any help would be greatly appreciated!
I think I have worked it out...will have to do some checking when I have a chance, but it looks like it will be correct. :) so thank you all again for your replies. I will let you know if it didn't work out.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum