need ideas about this manula x-tab report

[yehong]

I am using crystal 9 to develop a x-tab report. The required layout is as follows:

Apr ... and so on for 12 months

Mar P#014(2) P#010(13),P#001(15)

Feb P#010(12),P#012(15) None

Jan P#002(5),P#003(40), P#001(6)
P#001(45)
2005 2006

The data is in the following form:
Year Month Part_Number Quantity
2006 Jan P#002 5
2006 Jan P#003 40
...and so on

I have some ideas in my mind and I am still playing around with those but have not reached on a solid solution.I would really appreciate if someone can give some ideas to do this report correctly. Thanks.

 

[synapsevampire]

A convbentional crosstab seems like a better format than the one above, looks very unreadable to me.

So you want years at the bottom, but in no way correlated to the data, or are you tryng to say that you'll concatenate data for one year on one side, and concatenate data for the other year on the other side, however the annual column labels are below the data itself?

Very strange indeed.

I would suggest just using a crosstab with the date by year as the column, then the date by month and then the part number for the rows, and the sum of the quantity in the summary field.

Should look much better than the above.

If you prefer that sort of look and feel, including partnumbers with parentheticals around the quantities and the partnumbers comma delimited we'll be using formulas at the month group level to sum and then concatente, purdy unappetizing stuff, visually and to code.

-k

 

[yehong]

Hi Snapsevampire, the years are on x-axis and months on y-axis. The problem is there is on more x and y diemension that encloses months on y-axis and years on x-axis. For example:
Apr
xyzx Mar
Feb
Jan
2004 2005 2006
xabcdxx

 

[lbass]

Not sure what you mean. Use a formula for the row field in the crosstab:

month({table.date})

In the group options tab, use descending order, and then customize group name:

monthname(month({table.date}),true)

-LB