Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Crystal Report Cross tab format

Posted on 2011-02-26
5
Medium Priority
?
468 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 1500 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

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. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

772 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