I have made a little crosstab query - that is tied to a live dataset in VB.NET. All of my data is coming through - totals are fine - etc... I only have a couple little issues with formatting that I can't seem to get. The information is production history - by day - for several different machines - all coming from a big database.
One of the main problems is the collumn titles - on the report itself. The query is made to look for certain machine numbers (mach_nmbr) - and that is what makes up the collumns left to right in the report. Only - it shows for each collumn header - the machine number. I know what I want to call each one - I just don't know how to tell it to show for example - instead of 42 as a collumn header - I want it to show #10 Saw...etc Would also like to center - both the collumn headers and the actual collumn line item detail.
Similar kind of kink in the chart. I have a basic bar chart - in the page header. It shows along the x axis each machine number - and along the y axis the total number of pieces for the month. For both the legend - and the x-axis labels - it is showing the actual machine number - and I want to tell it to use a more commonly known name - such as #10 Saw...etc.
see example of what I'm talking about here: http://www.fearonenterprises.com/report.JPG
Finally - it would be nice to add 1 little thing... to put the date range the report data includes - in a header or subheader. The thing is tied to a live dataset - and the date convention that is commonly used here is YYYYMMDD - and there isn't much need to change it. (would probably screw users up to change date scheme). The date range could be virtually anything.... there are 2 date/time pickers on the VB.NET main form - and I have variables that keep track of the user picked dates - StartActyDate and EndActyDate. Can I pass that into Crystal Reports and put it in the header? How?