Dual vertical and horizontal summarized fields

I haven't been able to find a resolution for this crystal reports issue I am having with a recent project.

I have a report that will have multiple crosstab reports of varying rows and columns, but one thing is static in all of the crosstabs, each row and column each needs a total and a %.  

The report needs to be in this basic format.

          XSM, SML, MED, LRG, XLG, 2XL TOTAL COLOR%
Black      0        5       6      8       7    4           30           54%
Red        1        4       4      6       5    3           23            46%
---------------------------------------------------------------------
TOTAL   1        9      10    14     12   7           53           100%
Size%    7%  14% 19% 26% 22% 12%     100%

Now with the crosstab expert, I am able to select either horizontal or vertical summarized field and get the %'s to show up like I would like with some tweaking.  I can't seem to get both to show up no matter what I've tried.

Data is in the format: (and I have control over it, using a sql stored procedure at the moment)
Color  Size  Qty Sold   Qty On Hand, etc, etc
Black  XSM       0
Black  MED       6
Red    LG          6
Red    2XL        3

etc, etc

I've looked through a lot of material and am amazed that I haven't found another situation where another user documented this.  Thanks for any help in advance.
LVL 3
sr22gerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wykabryanCommented:
In the convensional sense of the crosstab, this functionality does not exist.  You can only choose row or column.  The only way around it is to create your own crosstab type report.  You can recreate everythign that is withing a crosstab with formulas and running totals.  This will give you the most flexiblity and scalablity.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
Have you checked the cross tab sample that comes with Crystal.  It is displaying a % like you want.

mlmcc
0
sr22gerAuthor Commented:
The sample only shows the horizontal summarized fields, not both.

I will have to figure something out manually.  I was just hoping to save some time.  Thanks gents.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.