Solved

Crystal Report Cross tab format

Posted on 2011-02-26
5
447 Views
Last Modified: 2012-05-11
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
Comment
Question by:mahmood66
  • 3
  • 2
5 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 34990459
How do you decide what is tha start of week 1 for each month?
0
 

Author Comment

by:mahmood66
ID: 34990525
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
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 34990557
In that case this is standard crosstab report using the crosstab wizard.

Are you having problems with it?  If so what?
0
 

Author Comment

by:mahmood66
ID: 34990595



yes i got it.

thank you

0
 

Author Closing Comment

by:mahmood66
ID: 34990654
Solved
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now