• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 469
  • 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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