|
|||||||||
|
|
![]() |
|
|
|
![]() |
![]() |
|
Crystal Reports Tools: Improve Performance While Saving Time and Money |
|
Crystal Reports: Calendar, Traffic LightCalendar Format Report to highlight performance thresholds If you are designing a report like this, make the threshold a parameter or even a constant formula. There are 35 fields with conditional formats for the traffic lighting, so by doing this, you don’t have to change all 35 formats each time the targets change. So the report has a Threshold parameter and other parameters for record selection. The Calendar starts with seven text objects in the Group Footer. These display the days of the week. The convention seems to be to start the week on Sunday, but that is entirely up to you. A different start of the week doesn’t require major redesign of the report. Critical to the entire process are a pair of formulas to calculate the start and end of the month for each month group. Start of Month is calculated as: Date(Year({Table.DateField}), Month({Table.DateField}),1) The end of the month is calculated as:
You then need seven formulas to calculate the date of the first row of the calendar. You could manage with one formula, but we believed that made the report more difficult to design and it could increase the risk of errors in writing the formulas. You do not need to put these on the page as they will be used elsewhere. The formulas are called {@Sunday}, {@Monday} etc. One for each day of the week. The {@Sunday} Formula looks like:
More.... |
These keywords may have brought you here: date differences, date problems, date inconsistencies, date differences, date schemes, date formats, crystal reports tutorials, crystal reports tips, crystal reports articles, crystal reports information, crystal reports tips, crystal reports help, crystal reports training
|