Page 1 of 1

ReportBuilder LargeInt fields for Axis

Posted: Fri Oct 02, 2009 9:01 pm
by 12048851
Hi all,
D7
TeeChart Standard v8.02.10861
ReportBuilder 10

When editing a chart in a ReportBuilder End-user report, the drop-down for the X and Y axis' only contains integer or date fields. However, since switching to mySQL5 (as apposed to 3), RB has swithched the field type of calculated fields (ie: Count(*)) to LargeInt, instead of Int. Do the newer versions of Teechart allow a LargeInt field to be chosen as an Axis? Iv'e trie using the mySQL CAST function, but still shows up as LargeInt in RB. If Teechart does not allow LargeInt's, shouldn't it?

Thanks.

Re: ReportBuilder LargeInt fields for Axis

Posted: Mon Oct 05, 2009 8:04 am
by yeray
Hi mgkrebbs,

I'm not sure to understand what drop-down are you talking about. Could you please specify it?

Re: ReportBuilder LargeInt fields for Axis

Posted: Mon Oct 05, 2009 1:44 pm
by 12048851
Dropped a DPTeeChart in the report(reportbuilder end-user, runtime)
, rt. Click "Edit Chart">dblclick "Series1">"Datasource" tab, Choose Datapipeline, Then in the box below, there is Label (any field from the datapipeline shows up in this drop-down) , X and Y (any int field form the pipeline show up in these dropdowns.) However when running with mySQL5, Reportbuilder classifies any calculated field like Count(*) as a LargeInt, and these do not appear in the drop-downs. mySQL3, RB classifies them as Int.

Re: ReportBuilder LargeInt fields for Axis

Posted: Mon Oct 05, 2009 2:03 pm
by yeray
Hi mgkrebbs,

As you'll probably know, the ReportBuilder wrapper for TeeChart is supported by Digital Metaphors so first of all, we'd need to know if the problem is reproducible in an application without any ReportBuilder.
On the other hand, we don't have access to your database so it would be difficult for us to reproduce the problem here without more information.

So, knowing the both tips above, please try to reproduce the problem in a simple example application we can run as-is to reproduce the problem here and we'll be glad to try to see what's happening. Note that this simple application shouldn't have any ReportBuilder.

Thanks in advance.