I am attempting to create a CR.NET Line Chart.
I am working w/ three database fields in my line chart:
1. lTestID (this defines each series in the line chart)
2. lTestData (this is my numerical value - Y-axis)
3. dtDateAdded (this is a datetime stamp of when the test data (ie. lTestData) was derived)
My goal is to have the line chart use an auto range of numerical values in the Y-Axis that is based off of the lTestData field, and for the X-axis I would like to display an auto range of dates that is based off of dtDateAdded.
My current line chart auto generates my Y-axis with no problem. My X-axis, on the other hand, is receiving its value from the actual dtDateAdded field - CR is not creating an auto range of dates. I am guessing that if CR can generate a range of values for my Y-axis based on numerical values (lTestData) in my dataset, then CR should be able to generate an auto range of dates based on the date values (dtDateAdded) in my dataset. Am I guessing wrong here? Is CR capable of this task?
fyi: My Data selection in the CR Chart Expert is as follows:
On Change Of:
Command.dtDateAdded A
Command.lTestID A
Show value(s):
Sum of Command.lTestData
Thanks for any advice or leads to a solution.
I am working w/ three database fields in my line chart:
1. lTestID (this defines each series in the line chart)
2. lTestData (this is my numerical value - Y-axis)
3. dtDateAdded (this is a datetime stamp of when the test data (ie. lTestData) was derived)
My goal is to have the line chart use an auto range of numerical values in the Y-Axis that is based off of the lTestData field, and for the X-axis I would like to display an auto range of dates that is based off of dtDateAdded.
My current line chart auto generates my Y-axis with no problem. My X-axis, on the other hand, is receiving its value from the actual dtDateAdded field - CR is not creating an auto range of dates. I am guessing that if CR can generate a range of values for my Y-axis based on numerical values (lTestData) in my dataset, then CR should be able to generate an auto range of dates based on the date values (dtDateAdded) in my dataset. Am I guessing wrong here? Is CR capable of this task?
fyi: My Data selection in the CR Chart Expert is as follows:
On Change Of:
Command.dtDateAdded A
Command.lTestID A
Show value(s):
Sum of Command.lTestData
Thanks for any advice or leads to a solution.