Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Section Expert Post Reply Post New Topic
Author Message
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet 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!
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 29 Oct 2013 at 2:13pm
maybe
isnull(rtotal1)
or
trim(totext(rtotal1))=""
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 30 Oct 2013 at 1:50am
Hi
-Where you are restting your running totoal ?  Are you resetting it for each row ?
 
Running total can't suppress your orders not shipped. 
 
Try with a flag like :
 
If Shipped Qty > 0 then 'Y' else 'N'  // create a formulas for each date range and use this formula to suppress
 
if {@daterange} = 'N' then true else false
 
 
Thanks,
Sastry
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 30 Oct 2013 at 5:39am
Hi, thanks for your reply. still not working (unless I'm doing something wrong - I'm pretty new at this )
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 30 Oct 2013 at 5:58am
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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.063 seconds.