Date Parameter

[jomarelectric]

cr10

hello all;

if i use a date parameter to retrieve data between a start & end date, can i still use formula to keep a running total elsewhere in the footer with the user {?end} date but use a hard coded date for a fixed start date?
(i.e., user enters april 1/07 to april 31/01: i want to show the users end date, but hard code a start date of jan 1/07)

i tried the below in a running total and it dosen't seem to work. any ideas.

{INIH.INVDAT} in [(Date(2007, 4, 1)) to {?end}]

thanks in advance for any help

 

[jomarelectric]

sry, that code should read:

{INIH.INVDAT} in [(Date(2007, 1, 1)) to {?end}]

 

[Madawc]

What's your formula for record selection? Records not selected can't be included in the running total.

You can select records, suppress some from the printed report using section suppression and still use them for a running total.

If a running total seems not to work, try putting it in the detail line and see which records it is picking up.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[jomarelectric]

{INIH.SALREP} = {?rep} and
{INIH.INVCDAT} in {?start} to {?end} and
{INIH.ARTOT} <> 0.00 and
(
not(isnull({INIH.OUTVAL}))
or
{INIH.OUTVAL} <> 0
)

this is the record selection.

 

[Madawc]

So post your running total against the detain records it selects.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[jomarelectric]

i'm not sure i follow what you're saying.

thank you for the help btw.