Skip to Content
author's profile photo Former Member
Former Member

Date range parmeter

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

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.


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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2007 at 06:37 PM

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.