Link to home
Start Free TrialLog in
Avatar of JMO9966
JMO9966

asked on

Crystal Reporting - Cross-Tab report question

I'm working with a Crystal Report and it's in Cross-Tab format using the wizard.

For the most part, the wizard is doing what I want it to do except I'm trying to add fields in the design view window.

Let me explain.  I have a DataTable in VB.Net that lays out like this:

Part      Week    OnHandQty     Demand Qty     AvailQty
ABC        1                100                 25                 75
ABC        2                100                 40                 35
ABC        3                100                 10                 25
ABC        4                100                  5                  20
ABC        5                100                  3                  17

I create my Cross-Tab report as follows:
COLUMNS = Week
ROWS = Part
SUMMARY = AvailQty

I then get a report that looks like this:

Part     Week1     Week2      Week3      Week4      Week5
ABC       75            35             25             20              17

That is good but now I'm trying to add the beginning OnHandQty onto the row but I don't necessarily want to display this for each Week, just once right after Part # as the beginning balance.

I can't figure out if there's a way to add fields within this DataGrid type control that Crystal creates on the Report Header or not ??  I can't expand the borders or add fields to the report.

Any thoughts to accomplish this would be great.

Thanks,
JMO9966  
ASKER CERTIFIED SOLUTION
Avatar of Marcus Aurelius
Marcus Aurelius
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JMO9966
JMO9966

ASKER

Thank You guys!


    : )

MIke V