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

Help with report please

I’m trying to create a report as follows:

This is the data:

Field: Company Name

Field: Account No.

Field: Survey Date (Date Field) – (example 1/15/17)

Field: Next Survey Date (Date Field)--(example 1/15/18)

Follow Up date (Text field converted to a date field format) – (2/15/17) *this date will be 30 days ahead of the ‘Survey Date’ field.

On the report:

I am trying to list the info. in the following format:


Company Name + Account No.

Survey Date (

Next Survey Date

Follow Up Date


Company Name + Account No.

Survey Date

Next Survey Date

Follow Up Date


The problem I’m having is with the Follow Up Date – It’s pulling in the 30 day ahead date, which is 2/15/17 .Is there a way to make it display only January dates for the 3 date fields mentioned above?

Basically I’m trying to capture – in the month of Jan – how many Survey Done, Next survey Due and how many Follow Ups due.

Sorry for the lengthy post. New to Crystal reports, and don’t know how else to describe what I’m trying to do. Thank you for your Help.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Feb 16, 2017 at 09:18 AM

    You need to provide a sample of your data set and how you want to display it.

    I get the impression you want to display a single record twice. Once in January for original survey date and then again in February for the followup date. If that is correct that will NOT be possible.

    If you do want to do that you will need to build a command and union data together to effectively create two records from one.


    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.