• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

Crystal Report Cross tab format

Dear Experts,

I have to  summarize my data according to 2 columns as i mentioned in my image.
column1 : Date(ex : feb 11)
Column2 : Week(ex : wk1,wk2,wk3,wk4)
Data Column : days(12,89)
row : Item(item1,item2)

i need to summarize the' days' according to  'date' and 'week'


Please help me

thanks CrossTabFormat
0
mahmood66
Asked:
mahmood66
  • 3
  • 2
1 Solution
 
peter57rCommented:
How do you decide what is tha start of week 1 for each month?
0
 
mahmood66Author Commented:
Dear Peter57r,

For your info the table will be like this

item         Date                Week           Days
----           ---------         ------         -------
Item1      28/feb/2011     wk1            12
tem1      28/feb/2011     wk2            10
tem1      28/feb/2011     wk3            5
tem1      28/feb/2011     wk4            10
item2      1/mar/2011     wk1            14
item2      1/mar/2011     wk2            11
item2      1/mar/2011     wk3            74
item2      1/mar/2011     wk4            58
0
 
peter57rCommented:
In that case this is standard crosstab report using the crosstab wizard.

Are you having problems with it?  If so what?
0
 
mahmood66Author Commented:



yes i got it.

thank you

0
 
mahmood66Author Commented:
Solved
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now