I am trying to create a pivotchart with a timescale axis in an Access 2003 Data Project (ADP) connecting to an SQL Server 2000 backend.
When I go to the chart properties and try to set
The pivotchart seems to recognize the field as a date and sets the timescale to "Auto" but it doesn't work. Meaning, it doesn't insert space for the dates with no values. If I set the timescale to "none" then I cant' change it back to "Auto" or "Manual". I get an error message that says "Invalid Parameter"
The data in my axis field is in smalldatetime data type (it doesn't work with datetime datatype either).