Jump to content
Software FX Community

ChartFx5.5 crosstab


User (Legacy)

Recommended Posts

Are you using more than 1 column as RowHeading? Could you send us code that

duplicates the problem?

On the other hand, in order to download the latest service pack, make sure

you have cookies enabled and re-register your product.

Regards

IG

Software FX Support

"YLP" <prasad@hotmail.com> wrote in message

news:SMWVCCofBHA.1272@webserver1.softwarefx.com...

> Hi

> Iam using ChartFx5.5 Crosstab function on dates.

> I get some special character concatenated to dates.

> I couldn't even download servicepack. The page says I should register

again.

> How do I solve this problem.

> Thanks

>

>

>

Link to comment
Share on other sites

This is the code iam using in win2000, iis5.0,ie6.0,asp.

I did install service pack. I still have problem with dates in crosstab

-------------------------------------------------

<!--#include virtual="/Include/CfxIE.inc" -->

<!--#include virtual="/Include/SfxCrossTab.inc" -->

<% strsql = "SELECT code, BDate, EDate FROM tbl_Codes

rs.open strsql, conn

'INITIALIZE CHARTFX OBJECTS

Set Chart = Server.CreateObject("ChartFX.WebServer")

Chart.Gallery = LINES

Chart.Chart3D = False

Chart.AllowDrag = False

Chart.markershape = False

chart.linewidth = 2

Chart.DataEditor = True

'Chart.FONTS(CHART_TOPFT) = True

'Chart.Title(CHART_TOPTIT) = strSortBy

Chart.Toolbar = True

Chart.SerLegBox = TRUE

Chart.SerLegBoxobj.Docked = TGFP_FIXED

Chart.SerLegBoxobj.Top = 250

Chart.SerLegBoxobj.LEFT = 100

%>

<% 'Axis Settings

Chart.Axis(AXIS_Y).Grid = True

Chart.Axis(AXIS_X).Grid = True

Set CfxData = Server.CreateObject("CfxData.Ado")

CfxData.ResultSet = RS

Set CfxCrosstab = Server.CreateObject("SfxCrosstab.DataProvider")

CfxCrosstab.DataSource = CfxData

CfxCrosstab.DataType(2) = CTDT_ROWHEADING

CfxCrosstab.DataType(1) = CTDT_COLUMNHEADING

CfxCrosstab.DataType(0) = CTDT_VALUE

Chart.GetExternalData CfxCrosstab

RS2.Close

Set RS2 = Nothing

%>

<%= chart.GetHtmlTag("98%","98%") %>

Can you help me in fixing this prob.

Thanks

-----------------------------------------------------------------

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

news:kjJmpz5fBHA.1268@webserver1.softwarefx.com...

> Are you using more than 1 column as RowHeading? Could you send us code

that

> duplicates the problem?

>

> On the other hand, in order to download the latest service pack, make sure

> you have cookies enabled and re-register your product.

>

> Regards

>

> IG

> Software FX Support

>

> "YLP" <prasad@hotmail.com> wrote in message

> news:SMWVCCofBHA.1272@webserver1.softwarefx.com...

> > Hi

> > Iam using ChartFx5.5 Crosstab function on dates.

> > I get some special character concatenated to dates.

> > I couldn't even download servicepack. The page says I should register

> again.

> > How do I solve this problem.

> > Thanks

> >

> >

> >

>

>

Link to comment
Share on other sites

  • 4 weeks later...

Could you send the table (or a significant sample of it) used in your code?

IG

Software FX Support

"YLP" <prasad@hotmail.com> wrote in message

news:YD4QVVcgBHA.1272@webserver1.softwarefx.com...

> This is the code iam using in win2000, iis5.0,ie6.0,asp.

> I did install service pack. I still have problem with dates in crosstab

> -------------------------------------------------

> <!--#include virtual="/Include/CfxIE.inc" -->

> <!--#include virtual="/Include/SfxCrossTab.inc" -->

>

> <% strsql = "SELECT code, BDate, EDate FROM tbl_Codes

>

> rs.open strsql, conn

>

> 'INITIALIZE CHARTFX OBJECTS

> Set Chart = Server.CreateObject("ChartFX.WebServer")

> Chart.Gallery = LINES

> Chart.Chart3D = False

> Chart.AllowDrag = False

> Chart.markershape = False

> chart.linewidth = 2

> Chart.DataEditor = True

> 'Chart.FONTS(CHART_TOPFT) = True

> 'Chart.Title(CHART_TOPTIT) = strSortBy

> Chart.Toolbar = True

> Chart.SerLegBox = TRUE

> Chart.SerLegBoxobj.Docked = TGFP_FIXED

> Chart.SerLegBoxobj.Top = 250

> Chart.SerLegBoxobj.LEFT = 100

>

> %>

> <% 'Axis Settings

> Chart.Axis(AXIS_Y).Grid = True

> Chart.Axis(AXIS_X).Grid = True

>

> Set CfxData = Server.CreateObject("CfxData.Ado")

>

> CfxData.ResultSet = RS

>

> Set CfxCrosstab = Server.CreateObject("SfxCrosstab.DataProvider")

> CfxCrosstab.DataSource = CfxData

> CfxCrosstab.DataType(2) = CTDT_ROWHEADING

> CfxCrosstab.DataType(1) = CTDT_COLUMNHEADING

> CfxCrosstab.DataType(0) = CTDT_VALUE

> Chart.GetExternalData CfxCrosstab

>

> RS2.Close

> Set RS2 = Nothing

> %>

>

> <%= chart.GetHtmlTag("98%","98%") %>

>

> Can you help me in fixing this prob.

> Thanks

> -----------------------------------------------------------------

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

> news:kjJmpz5fBHA.1268@webserver1.softwarefx.com...

> > Are you using more than 1 column as RowHeading? Could you send us code

> that

> > duplicates the problem?

> >

> > On the other hand, in order to download the latest service pack, make

sure

> > you have cookies enabled and re-register your product.

> >

> > Regards

> >

> > IG

> > Software FX Support

> >

> > "YLP" <prasad@hotmail.com> wrote in message

> > news:SMWVCCofBHA.1272@webserver1.softwarefx.com...

> > > Hi

> > > Iam using ChartFx5.5 Crosstab function on dates.

> > > I get some special character concatenated to dates.

> > > I couldn't even download servicepack. The page says I should register

> > again.

> > > How do I solve this problem.

> > > Thanks

> > >

> > >

> > >

> >

> >

>

>

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...