1. stored procedure with run time parameters or

2. a crystal command with run time parameters or

3. a group select

 

optiosn 1 and two are more efficient but require more techincal skill and possibly rights tio the DB you so not have.

option 3 is less efficient but easier.

your choice

 

Update: The run time parameters are assuming you want to be able to change your date range each time you run the report.

just wanted to make sure you picked which one works for your set up.

ifyou want to hard code these to the last month youc an chaneg it, either wise you will want to use 2 paramters fields as date types

 

create a formula field as

//groupflag 

if {PURCHASE_ORDER.DESIRED_RECV_DATE}  in {?startdate} to {?enddate} then 1

sum this at the group PO level

any group hat has a value >0 has at least one row of data that falls in your run time parameter dates so you can use this to do a group select

open the select expert and expans it to show formula if it is not already

select the 'group selection' radio button

add your group selection here

sum(groupflag,po)>0

 

This measn you are always pulling in all of your PO rows first, grouping and then doing a group select (not efficient). If you have a way to limit the data on PO that you know will not meet your group selection use it too as it will speed thing up.

Also note that all groups still appear in your group tree even if they do not appear in the report (omitted via the group select). The group tree is created before the group select is applied.

summarization formulas are applied to all of the data (hence the ability to use it in the group select statement) but Running Totals and variable formulas should only be applied to data that 'is left' after the group select is applied.

 

2. don't just drop the 'groupflag' formula field onto your group footer, you have to insert a summary using that formula field.

select the summary button (blue sigma/E)

use the flag formula as the field to sumamrize

set it to a sum

summary location as the group footer (for the po group)

 

once you create it will appear on your group footer

if you select it on your group footer then click on the select expert button it will be the default field to be used

set it to 'is greater than' and enter "0" in the value

 

when I run the report it is still asking me for a date range (which I enter) then it is giving me all kinds of data  form dates I don't need to see. It looks like the sum groupflag formula is adding up each receivng line of the po (over all po lines). How do I get the report not to show me all the info not within my date range?