Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 19 Mar 2012 at 8:18am
i can only think of a manual way which could be a lot of work and not a good solution, but here it is any way
group on month formula
totext(month(table.date),0,"")
expend your group header
create 31 text boxes place them into your group header
then create 31 formulas something like
if table.date in date("01"+","+{@month}+","+"2011") to date("02"+","+{@month}+","+"2011") then table.value
place then place them next to the right text box
then right click on text boxes 29-31 (separately)go
format text > common tab >click x-2 next to suppress and write according to your calendar like
{@month} = "2"
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