Printing report for certain time

[roope099]

Hi,

i have one report, and now i should make something to that, so user can print it monthly, i mean that she can select the time period which she wants to print. e.g. stock movements during 1.12-31.12 ..

Please help me.

Tiina

 

[Madawc]

Crystal lets you get the month and year for a given date, e.g. as

Year({your.date})

Month({your.date})

You could then let them be selected using parameters. These can have an 'all' default, e.g.

@ParamYear = "All" or
@ParamYear = @Year

And the same for month

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[roope099]

Thank u for your answer, im really new in this, so can u tell me where i should put these?

And after this, user can select that she wants to print only report for 1.11.-31.11 ? And ofcourse report brings only numbers from that month?

 

[lbass]

You might want to just create two date parameters {?Start Date} and {?End Date} in the field explorer->parameter->new and then use them in your record selection formula:

{table.date} in {?Start Date} to {?End Date}

This assumes that your date field is a date datatype, and not a string.

-LB

 

[roope099]

I tried this one, insert dates 19.12 and 23.12 ... but it will bring also actions from beginning of month, not only between these days ....

Thank you !

 

[lbass]

What is your selection formula?

-LB

 

[roope099]

{StockEve1.EveDate} in {?Start Date} to {?End Date}
something like this i have .....

 

[lbass]

Where are you entering the selection formula? Should be in report->selection formula->record. Also, when you enter this, what exactly are you entering at the prompt? You seem to be using a dd/mm/yyyy format.

-LB

 

[roope099]

thank u, i made this finally ... thank u