Jump to content
Software FX Community

I think I'm slow...

User (Legacy)

Recommended Posts

I have an ADO recordset set has three colums - Year, Quarter, and Sales

amount. I am looking to get a bar that groups the data by year, and then

puts the 4 quarters in 4 different bars. Something like this :

| |

| || | | ||

|||| | || ||||

2003 2002 2001

But after hours of experimenting, I cannot figure it out. I think I should

be looking at the CfxDataType, but I don't know. Can someone please give me

a hand with this? I am betting its really easy and I missed some sort of

easy readme.



Link to comment
Share on other sites

Thank you for your help.  I have discovered one more problem.  If my

recordset has 8 records inidicating 2 full years, everything works perfect.

But if I change my date range to only run from Q2 2002 to now, the first

quarter in 2003 is moved to the end of the year instead of showing first .

Here is an example.

If I run 1/1/02 to 12/31/03 I get:

Q12002 Q22002 Q32002 Q42002 Q12003 Q22003 Q32003 Q42003

But if I run 4/1/02 to 12/31/03 I get:

Q22002 Q32002 Q42002 Q22003 Q32003 Q42003 Q12003

I would hope to get:

Q22002 Q32002 Q42002 Q12003 Q22003 Q32003 Q42003

Any ideas? Here is my code (fx is the control):

Dim cfx As New CfxDataAdo

Dim x As New CrosstabProvider

Dim rs As ADODB.Recordset

Set rs = GetAvgRespTimeChart(sDate, eDate) 'Returns proper recordset

cfx.Resultset = rs

x.DataSource = cfx



x.DataType(2) = CTDT_VALUE

fx.ClearData (CD_ALLDATA)

fx.GetExternalData x



"SoftwareFX Support" <support@softwarefx.com> wrote in message


> You need to use the Cross-Tab Data Provider. See the docs. for details.


> You want your Column Header to be the Quarter, your Row Header will be the

> Year and your Value will be the Sales.


> You need to order the Recorset by Year + Quarter before passing it to the

> cross-tab provider.


> --

> FP

> Software FX, Inc.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...