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.