Joined: 23 Aug 2012
Online Status: Offline
Posts: 1
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!
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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)
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
IP Logged
