Post Author: rcoleman
CA Forum: Charts and Graphs
I have very limited knowledge of formulas. I have to write some new reports using new report writiing standards. These requirements are over my head at this stage in my learning process. I would appreciate any help I can get. Some system inforamtion is provided below. If additional information is required please let me know.
Crystal Developer 11.0.0.1282
SQL Server 2000
MS Windows XP Professional-
version 2002 Service Pack 2
The formulas I need help with are:
1.) For date range parameters we need a formula to calculate what the graph's time interval will be. For example if date range is less than 3 weeks then daily. If date range is more than 3 weeks but less than 4 months then weekly, if date range is more than 4 months but less than 24 months then monthly, if date range is greater than 24 months then quarterly, if date range is more than 24 quarters then yearly.
and
2.) For date range default to a date then run the date through a formula. If the formula detects that the user did not adjust any of the date range the automatically select -12 months from current for lower date, and current date for upper date.
Post Author: V361
CA Forum: Charts and Graphs
look at the sample reports included with CR... there is one report that has some custom record functions for date ranges. see... sample reports, feature examples, Record Selection on DateRange.rpt.... edit the formula in the example, then look at the report custom functions, both date and format... This should get you started.
Add a comment