Crystal Reports Summing Issue

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Summing Issue
	<< Prev Page of 5 Next >>

Author	Message
cheryla Groupie Joined: 23 Oct 2013 Online Status: Offline Posts: 51	Posted: 28 Oct 2013 at 8:06am
	ugh I tried editing that formula it's really sum(0">{@groupflag})>0
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Oct 2013 at 8:15am
	I just reread your other posts and I think I missed part of what you wanted to achieve. You wanted to exclude any PO where the first row of data is NOT in the date range. you will need to add in another group select condition. first though are you grouping on the month at all? and if so is your PO group 1? or below the month?
	IP Logged

cheryla Groupie Joined: 23 Oct 2013 Online Status: Offline Posts: 51	Posted: 28 Oct 2013 at 8:25am
	actually I need to select via a specified date range a group of po's that can have multiple lines and multiple receiving dates for each of those lines. Part of my criteria is to check if the po is "late". Meaning we need to look at the first receipt date per line per po. If any one of the lines are late then the whole po is late. I was able to get the report to see all of the late po's. The problem I ran into is that when I ran my report by a 3 month time period It looked fine but when I ran each month individually it didn't match up to the 3 month report. I noticed that if there was a recpt date (out of multiple dates) that fell into my date range it would grab it even though it really should've fallen into the previous months data. ie: po 123 line 1 recvd 1-1-12 line 1 recvd 2-2-12 this po would should up during a january month and the february month reports when it should only show up on the january report. I hope this all makes sense. Let me know if I can clarify any further. Thanks!
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Oct 2013 at 8:32am
	so when you run a 'date range' you want to see any PO that had the minimum date associated to it falls in that range? so you need to see all of teh PO detail rows (even if they fall outside the range, which I believe would always have to be later than the date range)?
	IP Logged

cheryla Groupie Joined: 23 Oct 2013 Online Status: Offline Posts: 51	Posted: 28 Oct 2013 at 8:35am
	yes! :) and hopefully not see the latter dates on the next month
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Oct 2013 at 8:42am
	change your group select to minimum(datefield,po) in ?startdate to ?enddate this should give you any PO that "starts" in the raneg you enter. let m eknow if that works for you and then what you need to do with the any 'extra' rows you see that are part of that PO but fall outside your range. NOte that if yourun it for a month at a time Any given PO should only show up one time in in the month that it 'started' in and never in any month that the extra rows appear in. Sorry for the confusion.
	IP Logged

cheryla Groupie Joined: 23 Oct 2013 Online Status: Offline Posts: 51	Posted: 28 Oct 2013 at 8:46am
	I think I just figured out my solution!!!! I entered the select criteria to select on the minimum (recvr.recvd. date), purc_order_line_no) in beg date and end date and it all seems to be working! Woohoo!! I rechecked by running the report by a 3 month periord and then again by each indivisual month and everything seems to be matching/adding up correctly!! I'm going to add my finishing touches (cosmetics, etc) Thank you sooo much for all your help!! This site is amazing! I always find something to help me. This project finally made me have to sign up. :)
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Oct 2013 at 8:50am
	glad you got it. Edited by DBlank - 28 Oct 2013 at 8:50am
	IP Logged

cheryla Groupie Joined: 23 Oct 2013 Online Status: Offline Posts: 51	Posted: 21 Nov 2013 at 3:23am
	well I jusr received this report back from the requester with all the cosmetic changes that they want done. But now I have a new situation hopefully someone can help with. I need to hide all ontime po's. I have been able to do this but with the concept of if one line is late the whole po is late.... how do I show all of the po lines when one is late and one is ontime? currently I can either hide all the ontime or all the late po lines but not if the po has one of each. Any ideas? If I can solve this I will hopefully done with this report-never having to see it again :) Thanks in advance!!
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 21 Nov 2013 at 10:01am
	how do you define "if one line is late" in data terms? Edited by DBlank - 21 Nov 2013 at 10:05am
	IP Logged

<< Prev Page of 5 Next >>

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.031 seconds.