Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Bi-Monthly DateTime Formula Post Reply Post New Topic
Author Message
bleap
Newbie
Newbie
Avatar

Joined: 23 Aug 2012
Online Status: Offline
Posts: 1
Quote bleap Replybullet Topic: Bi-Monthly DateTime Formula
    Posted: 23 Aug 2012 at 4:00am
I'm a relative noob to using CR XI and am trying to get the date range in my report to run from the 1st to the 15th, then from the 16th to the 31st. So basically a first half of the month range and a second half of the month range. Currently the data is too large to be received via email by the recipient, so we were trying to split it up to run bi-monthly. What would be the best way to 1) Have the report run bi-monthly, and 2) Have the report show only the first and second half of the month date ranges. If it requires 2 reports that would be fine as well. Any help would be appreciated!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 23 Aug 2012 at 4:24am
one option,
you can use a parameter to help with this. If you make it numeric just allow for a 1 or 2, then add into the select expert what you want those two values to do.
something like:
({?param}=1 and datepart('d',{table.datefield})<16)
or
({?param}=2 and datepart('d',{table.datefield})>15)


Edited by DBlank - 23 Aug 2012 at 4:25am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.