Crystal Reports Grouping by week

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Grouping by week

Post Reply

Post New Topic

Author	Message
Gian Luca Newbie Joined: 20 Oct 2010 Location: Italy Online Status: Offline Posts: 6	Topic: Grouping by week Posted: 14 Feb 2011 at 11:25pm
	Hi I need to group payables by week. I have a list of invoices with their due date and I want to group the amount to pay by week. eg. week 1 week 2 week 3 total 100 25 85 Can anybody help me with that? Thanks a lot. Gian
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 15 Feb 2011 at 3:40am
	you probably want to use a crosstab column on the due date field set to 'for each week' summarized field would be wherever you are getting your 100,25,85 values
	IP Logged

Gian Luca Newbie Joined: 20 Oct 2010 Location: Italy Online Status: Offline Posts: 6	Posted: 15 Feb 2011 at 4:00am
	Thank you. I normally try to avoid cross-tabs as they do not allow drill down. However your suggestion worked fine. Thanks.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 15 Feb 2011 at 4:12am
	i only used the crosstab as you had columns ratehr than rows you can do the same thing with drilldown as group on the due date field set to 'for each week' insert summary wherever you are getting your 100,25,85 values at the group level
	IP Logged

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