hansdebadde
Technical User
I am using CR 2008, and a sql dataset. I am passing print time data to a subreport with the OnChangeOf formula pulling datetime values across. My Group selection formula in the subreport is totext({TABLE.DATE}) in split({?Pm-@OnChangeOf},"^")
When I do a crosstab of the datevalues i get what i expect, sept 2009 to present, one month at a time.
When i include a value that i summarize a few months are dropped? For example it goes, Sept-Oct-Dec-Feb-Mar-Jun-Sep-Oct.
When i look at the show value field i summarized, it has values for evey month? Some are zero but there are enough values.
My OnChangeOf formula is tonumber(split({?Pm-@ShowValue}, "^")[groupNumber])
So i am stumped again...anyone?
When I do a crosstab of the datevalues i get what i expect, sept 2009 to present, one month at a time.
When i include a value that i summarize a few months are dropped? For example it goes, Sept-Oct-Dec-Feb-Mar-Jun-Sep-Oct.
When i look at the show value field i summarized, it has values for evey month? Some are zero but there are enough values.
My OnChangeOf formula is tonumber(split({?Pm-@ShowValue}, "^")[groupNumber])
So i am stumped again...anyone?