Problem with new TeeChartVCL-2015.16.150901

[MVBobj]

Hi,

I just installed this over my existing 2015.15.150420. I have an application with a TDBChart and a single series - Series1, Datasource: Crosstab.

Before installing the update, I would run it and a SQL query would load the crosstab and then Series1 would disappear and 6 series would be generated with 133 data points each and everything would work correctly.

Now, after installation, the exact same code now leaves Series1 listed in the legend and unchecked and all my source code, which was checking DBChart[0].Count to determine how to behave, Is reading a count of 6 and that is all that's displayed: the first 6 data points! So now I need to go through all my code and modify it because something was changed and is different in this new update?

How do I get this to work the way it used to without changing my source code?

Thanks
.

[Yeray]

Hello,

There were a lot of changes in TeeDBCrossTab and TeeDBCrossTabEditor units between v2015.15 and v2015.16.
I've added a new ticket to the public tracker:
http://bugs.teechart.net/show_bug.cgi?id=1333

[MVBobj]

Hi,

So this is a bug? Is this going to be fixed anytime soon - or should I roll-back to 2015.15 and update to 2015.16 after the bug has been fixed?

I could fix it in my code but that would take a while and I'd rather not if I don't have to.

Thanks
.

[Yeray]

Hello,

Yes, I'd say the two behaviours explained in the public ticket aren't expected, and they didn't happen before so I think we can consider them as bugs.
I'm afraid I can't tell you when this will be fixed. Feel free to add your mail to the CC list to be automatically notified when an update arrives.

[WarmBooter]

I have the same problem. The issue was added to the tracker months ago and seems that no fix is still available

Carlos

[Narcís]

Hello,

This bug is currently being investigated. A major redesign of TeeDBCrossTab unit was made last summer, which introduced this bug and made into build 2015.16. The only solution for now is using build 2015.15. I'll keep you informed about any progress we make.

[WarmBooter]

As a workaround for those who are suffering with this bug, and has access to the source code:

If you are a source code customer you can download build 2015.15 sources, get TeeDBCrossTab.pas, TeeDBCossTabEditor.dfm and TeeDBCrossTabEditor.pas from that build and replace 2015.16 source files with those ones. After that, use TeeRecompile to build the sources and install the packages in Delphi 10 Seattle. That should fix the bug at your end.

[Narcís]

Hello everyone,

After further investigation we consider this not being a bug.

Changes made to CrossTab source use new Series.Detail property. Therefore we have a main series with child series being the Detail property and the result of CrossTab work. Main series is set to be inactive as not to be rendered. Detail series (only one in this particular case) are being rendered.

Prior to that change, new series at chart level were being created. Casually, in this specific test, only one series was necessary. That's why TChart.SeriesCount now returns 2 instead of 1.

[MVBobj]

Okay - now that this "bug" has been re-classified as a "feature", just exactly what do I need to do to repair my code after moving from 2015.15 to 2015.16.

To summarize: I have an application with a TDBChart and a single series - Series1, Datasource: Crosstab. Before installing the update, I would run it and a SQL query would load the crosstab and then Series1 would disappear and 6 series would be generated with 133 data points each and everything would work correctly. Now, after installation, the exact same code now leaves Series1 listed in the legend and unchecked and all my source code, which was checking DBChart[0].Count to determine how to behave, Is reading a count of 6 and that is all that's displayed: the first 6 data points!

To repair my code do I just need to:

1) Not get total data points from DBChart[0].Count but rather from one of the child series.

2) Set Series1 visible to false in the legend so it doesn't show up.

Is that all I need or is there something else?

Thanks
.

[Narcís]

Hello,

Clearly this new Series.Detail functionality needs to be refined for CrossTab. The easiest option I can think of for now is using TeeDBCrossTab unit and maybe TeeDBCrossTabEditor unit from v2015.15 in your 2015.16 sources, if that fits your needs. I have checked it works fine to continue with the CrossTab behavior in v2015.15 and before. Doing so you'd eliminate Series.Detail code from CrossTab, which is what made the difference.

[WarmBooter]

Hello,

Clearly this new Series.Detail functionality needs to be refined for CrossTab. The easiest option I can think of for now is using TeeDBCrossTab unit and maybe TeeDBCrossTabEditor unit from v2015.15 in your 2015.16 sources, if that fits your needs. I have checked it works fine to continue with the CrossTab behavior in v2015.15 and before. Doing so you'd eliminate Series.Detail code from CrossTab, which is what made the difference.

I wonder how long it will take for this bug to be correct. Yes, it is a bug! Having a non-desired serie appearing in the chart and messing with the axis values is a bug for sure. It was reported more than 1 year ago, and seems that no attempt to fix it was done so far.

Carlos

[Sandra]

Hello Carlos,

About the bug, I would like inform you that we gave an answer in the Bug ticket, where we explained the reason why we closed the bug.

About the problem, you experiencing with legend check boxes and CrossTab Main series, firstly, I apologise with you. Secondly, I would like inform you I have reviewed that and I have decided open a new ticket in TeeChart VCL Bugzilla tracker to fix the problem for next maintenance releases. Here’s the link: http://bugs.teechart.net/show_bug.cgi?id=1758

Feel free to add your mail to the ticket CC list to be automatically notified when an update arrives.