Skip to Content
0
Former Member
May 02, 2008 at 04:23 PM

How to design customize Cross tab in Crystal 9

22 Views

hi guys,

i'm having a big problem in designing this format in cross tab, coz it causes a lot of space that i wouldnt need in displaying the report in my application here's i want to show on my report,

this is just a sample data, but this is supposed the designed, or the output in crystal cross tab

SM gl orieta buyer and soon.....

sales TX PX sales TX PX sales TX PX

Mar-1 Mon 1000 1 1 200 2 3 400 4 5

Mar-2 Tue 200 10 11 300 4 8 220 5 8

-- -- -- -- --

--

--

--

--

--

Mar-31 Sun

Running Total 1200 500 620

Discount 200 300 400

Net sales 2000 3000 5000

Quota 100000 1200000 250000

TX 11 6 9

PX 12 11 13

the upper is the name of the stores which supposed to be dynamic, each store have 3 column which are the sales,TX and PX, on the left side is date which is my parameter is filtering sales by date, under the last date of the month is the running total followed by discount, net sales and soon.. Now my problem is how i'm going to design it in cross tab format in crystal report 9..any suggestion or other way to do it...