Hi All,
I have the data as below.
col a col b
sep 2007 100002
Oct 2007 100001
Oct 2007 100003
Aug 2008 100004
Aug 2008 100005
In the report I have grouped on cola and I am displaying the colb according to the group on cola. I have kept colb in details and supreesd it with drilldown ok. Now for example if I click on Oct 2007 I am able to see colb tetails as 100001, 100003. What I want to see is all the previous months accts till the month the user clicks on. cola is grouped and sorted ascending.
Ex: If user clicks on Oct 2007, he should be able to see the accounts 100002,100001,100003.
Please let me know.
Thanks,
M
I have the data as below.
col a col b
sep 2007 100002
Oct 2007 100001
Oct 2007 100003
Aug 2008 100004
Aug 2008 100005
In the report I have grouped on cola and I am displaying the colb according to the group on cola. I have kept colb in details and supreesd it with drilldown ok. Now for example if I click on Oct 2007 I am able to see colb tetails as 100001, 100003. What I want to see is all the previous months accts till the month the user clicks on. cola is grouped and sorted ascending.
Ex: If user clicks on Oct 2007, he should be able to see the accounts 100002,100001,100003.
Please let me know.
Thanks,
M