tercarlson
Technical User
Have database with employee anniversary dates. Want to create Crystal report to pull up "monthly" anniversaries, i.e., all february anniversaries, etc. Can anyone help a new Crystal reports user???
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
formula/parameter problem
- Thread starter tercarlson
- Start date
- Status
synapsevampire
Programmer
Create a date type range parameter.
Group on the {table.date} field, and select this section will be printed for each month.
This will allow you to show groups of dates for more than one month.
In the record selection formula (Report->Edit Selection Formula->Record) place something like:
{table.date} = {?DateRangeParameter}
Now the report will prompt for a range of dates, and group them by month for that range.
-k kai@informeddatadecisions.com
Group on the {table.date} field, and select this section will be printed for each month.
This will allow you to show groups of dates for more than one month.
In the record selection formula (Report->Edit Selection Formula->Record) place something like:
{table.date} = {?DateRangeParameter}
Now the report will prompt for a range of dates, and group them by month for that range.
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question