Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Do not give your attention to what others do or fail to do; give it to what you do or fail to do
 
Dhammapada
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

31
May

How Do I Display the Previous Current and Next Month data in Crystal Reports XI?

I was recently asked "How do I display the previous, current and next months data in a cross tab, based on a parameter date in Crystal Reports XI?"

Solution:

  1. Create the parameter field, ensuring it the data type is either Date or Date/Time

  2. Add the Cross tab object to the report canvas

  3. Add the required fields to the cross tab sections

  4. Ensure the Date or Date/Time field is grouped by month

  5. Press the Select Expert button, Crystal Reports Select Expert button.

  6. Press the Show Formula button

  7. Type the following formula, in the section:

    {Tablename.Field Name} > DateAdd("m",-1 ,{?Parameter Field}) and
    {tablename.Field Name}<= DateAdd("m",1,{?parameter Field})


  8. Press the OK button of the Select Expert dialog box


If you have any questions, or need any assistance, please do not hesitate to
Contact Us
1

Jico Yescas

20
April
Hola, Estoy interesado en saber si ustedes imparten cursos de Crystal Reports
2

Julia

22
April
Hola Jico,

Sí lo hacemos entrega de Crystal Reports cursos, pero sólo en Inglés, usted puede encontrar todos los detalles en la siguiente página: http://www.maximumimpactsolutions.co.uk/courses.asp
3

Rakesh

26
September
It is very good. But how can i calculate the difference between the two months

MAKE A COMMENT

Name *

Email Address *

Comment *