Solved

Crystal Report Cross tab format

Posted on 2011-02-26
5
460 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

623 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