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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
: )
MIke V
ASKER