Discontinuous data for chart
Discontinuous data for chart
(OP)
I am using CR 2016
I am pulling in bank balances every day and need to chart the trends and do have a working report/hart
The issue I have is that the data is only captured on business days not weekends or bank holidays so my chart looks like a sine wave!
I cant modify the database so I need to modify the detail line in the crystal report I think to :
1. Show continuous days from a start date parameter
2. test balance on each of these days and if null (not zero!) then bring into that row the last non null balance - this needs to carry on every row, you may have weekend with bank hoidays straddling either side etc
I think from there I can create a decent chart :) but the question is how do I do this?
Another method maybe for the chart to ignore null dates which is my plan B as not strictly correct but how could you do this also?
I am pulling in bank balances every day and need to chart the trends and do have a working report/hart
The issue I have is that the data is only captured on business days not weekends or bank holidays so my chart looks like a sine wave!
I cant modify the database so I need to modify the detail line in the crystal report I think to :
1. Show continuous days from a start date parameter
2. test balance on each of these days and if null (not zero!) then bring into that row the last non null balance - this needs to carry on every row, you may have weekend with bank hoidays straddling either side etc
I think from there I can create a decent chart :) but the question is how do I do this?
Another method maybe for the chart to ignore null dates which is my plan B as not strictly correct but how could you do this also?
RE: Discontinuous data for chart
Outer join from that table to your daily balances table.
view, export, burst, email, and schedule Crystal Reports.
www.MilletSoftware.com