maks

Hi Dhruva: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> I appreciate your help and support. Another thing which is creating problem displaying my chart - when users brows site and post comments, they very natuarally press enter button to go to next line. And after that chart related with that data does no appear. I tested and figured it out that enter causes the problem to show up the chart. Is there any way that I can overcome the problem. I can't ask the users "please don't press enter when you submit comments". Thanking you, Maksuda...

Thank you Dhruva, thank you very much. Yes it worked for me and I'm getting perfect Tooltip now Thanks for the help again. Maksuda

Thank you Dhruva for the reply. I think It's FusionCharts Free (I downloaded the Trial Version from website- but I was it is also v3 I think, so I'm confused about FusionCharts Free and FusionCharts v3 ) Here is my generated XML code: - <chart labelDisplay="[b]Rotate[/b]" slantLabels="[b]1[/b]" caption="NETWORK[b] REPORTING[/b]" subCaption="[b]Quarterly[/b]" pieSliceDepth="[b]30[/b]" showBorder="[b]0[/b]" numberSuffix="[b][/b]" seriesNameInToolTip="[b]1[/b]" XAXISNAME="[b]Fiscal Quarter[/b]" YAXISNAME="[b]No of Events[/b]" lineThickness="[b]5[/b]" reverseLegend="[b]0[/b]" anchorAlpha="[b]100[/b]" anchorRadius="[b]5[/b]" setAdaptiveYMin="[b]5[/b]" drawAnchors="[b]1[/b]" numberScaleValue="[b]1000,1000,1000[/b]" numberScaleUnit="[b]K,M,B[/b]" formatNumber="[b]1[/b]" formatNumberScale="[b]1[/b]">- <categories> <category label="[b]Q1-2008[/b]" /> <category label="[b]Q2-2008[/b]" /> <category label="[b]Q3-2008[/b]" /> <category label="[b]Q4-2008[/b]" /> </categories>- <dataset seriesName="[b]A[/b]" showValues="[b]0[/b]"> <set value="[b]21376661[/b]" tooltext="[b][/b]" /> <set value="[b]16411446[/b]" tooltext="[b][/b]" /> <set value="[b]18035111[/b]" tooltext="[b][/b]" /> <set value="[b]17572169[/b]" tooltext="Test [b]A comment is posted[/b]" /> </dataset>- <dataset seriesName="[b]B[/b]" showValues="[b]0[/b]"> <set value="[b]3486329[/b]" tooltext="[b][/b]" /> <set value="[b]5320359[/b]" tooltext="[b][/b]" /> <set value="[b]10395536[/b]" tooltext="[b][/b]" /> <set value="[b]12248346[/b]" tooltext="[b]Good Maksuda3[/b]" /> </dataset>- <dataset seriesName="[b]C[/b]" showValues="[b]0[/b]"> <set value="[b]161565632[/b]" tooltext="[b]Obvious question here - please explain this huge spike in C activity. - Maksuda[/b]" /> <set value="[b]12527735[/b]" tooltext="[b]null[/b]" /> <set value="[b]6119261[/b]" tooltext="[b][/b]" /> <set value="[b]6236180[/b]" tooltext="[b]Good Maksuda4[/b]" /> </dataset>- <dataset seriesName="[b]D[/b]" showValues="[b]0[/b]"> <set value="[b]2339025[/b]" tooltext="[b][/b]" /> <set value="[b]2070100[/b]" tooltext="[b][/b]" /> <set value="[b]116600[/b]" tooltext="[b][/b]" /> <set value="[b]21551[/b]" tooltext="[b]Good Maksuda5[/b]" /> </dataset>- <dataset seriesName="E" showValues="[b]0[/b]"> <set value="[b]697762[/b]" tooltext="[b][/b]" /> <set value="[b]1024645[/b]" tooltext="[b][/b]" /> <set value="[b]1051015[/b]" tooltext="[b][/b]" /> <set value="[b]5321449[/b]" tooltext="[b]Test E comment is posted[/b]" /> </dataset>- <dataset seriesName="F" showValues="[b]0[/b]"> <set value="[b]897074[/b]" tooltext="[b][/b]" /> <set value="[b]3882617[/b]" tooltext="[b][/b]" /> <set value="[b]2861059[/b]" tooltext="[b][/b]" /> <set value="[b]1346998[/b]" tooltext="[b]Good Maksuda7[/b]" /> </dataset>- <styles>- <definition> <style name="[b]CanvasAnim[/b]" type="[b]animation[/b]" param="[b]_xScale[/b]" start="[b]100[/b]" duration="[b]1[/b]" /> <style name="[b]myHTMLFont[/b]" type="[b]font[/b]" isHTML="[b]1[/b]" /> <style name="[b]CapstionStyle[/b]" type="[b]font[/b]" face="[b]Arial[/b]" size="[b]18[/b]" color="[b]6A5ACD[/b]" bold="[b]0[/b]" bgColor="[b]FFFFFF[/b]" /> <style name="[b]SubCapstionStyle[/b]" type="[b]font[/b]" face="[b]Arial[/b]" size="[b]16[/b]" color="[b]6A5ACD[/b]" bold="[b]1[/b]" bgColor="[b]FFFFFF[/b]" /> </definition>- <application> <apply toObject="[b]Canvas[/b]" styles="[b]CanvasAnim[/b]" /> <apply toObject="[b]Caption[/b]" styles="[b]CapstionStyle[/b]" /> <apply toObject="[b]SubCaption[/b]" styles="[b]SubCapstionStyle[/b]" /> <apply toObject="[b]TOOLTIP[/b]" styles="[b]myHTMLFont[/b]" /> </application> </styles> </chart> Thanks, Maksuda

Thanks Dhruva: In this case my tooltip text is a database field. I'm retriving data as follow: DataTable myDataTable = DtSet.Tables[0]; foreach (DataRow dRow in myDataTable.Rows) { string comment = dRow["Comments"].ToString(); xmlData.AppendFormat("<set value='{0}' tooltext='{1}' />", dRow["Total"].ToString(), dRow["Comments"].ToString()); } xmlData.Append("</dataset>"); How could I use new line lag here that you told ? any kind of coding help is highly appriciated. Thanks, Maksuda...

Hi: Can any one tel me if it is possible to display a comment from database as a tooltip when chart runs. we can get the database value that we use to generate our chart as tooltip when our chart run. Instead of showing that database data, I want to show the comments as tooltip that are saved in my table. Thanks in advance Maksuda

Thanks Pallav for your reply. May I know when v3.1 will be available in market Please. What do you mean by permanent comment ? Now I can see the tool-tip when mouse roll over a data point. But my problem is when I click on Print Preview on File menu and close the print preview I can't see the tool-tip of all data point (specially data point which are at bottom of the stack chart). It's surprising......... Maksuda...

Thanks Rahul for your reply. I have the code like: ....... dbReader = cmdSelectTotal.ExecuteReader(); while (dbReader.Read()) { xmlData.AppendFormat("<set value='{0}' tooltext='{1}' />", dbReader["Total"].ToString(),dbReader["Comments"].ToString()); } I can see the tooltip(comment) from my database. But when I click on print preview and return to my chart after closing print preview window tooltip doesn't appear anymore. Stack bar which does't haa any comment in db shows the chart data when I place my mouse on each. Any help is highly appreciated. Maksuda

Hi: I'm creating chart in ASP.net(C#). Everything is working fine and my chart is appearing, but it's on left side of the page. How could I display chart at the center of the page? I tried....... xmlData.Append("<div align='center'>"); xmlData.Append("<chart labelDisplay='Rota......................... ....... xmlData.Append("</chart> "); xmlData.Append("</div>"); chart is not appearing in that case......... any help is highly appreciated. Regard

Thanks Arindam......thank you........ It's working..........

I rendered the chart using the following code: return FusionCharts.RenderChart("FusionCharts/StackedColumn3D.swf", "", xmlData.ToString(), "FactorySum", "450", "600", false, false); regards,

Tahnks for your reply Arindam. But I can't use the code in my C# page. String mVar="<div align='center' >" ; mVar += FusionCharts.RenderChart("FusionCharts/StackedColumn3D.swf", "", xmlData.ToString(), "FactorySum", "450", "600", false, false); mVar += "</div>"; gives me error.......... Error 1 'Quarterly_Report.GetQuarterlyEventSummaryChartHtml()': not all code paths return a value thanks again for the help. Regards,

Tahank you Arindam. Maksuda...

thank you very much........... my page is working and FusionChart is appearing........ For my curisity ........why I need to use <asp:Literal ID="Literal1" runat="server"></asp:Literal> <br /> I mean what is the function of that part in report? Another thing I want to know...... I am passing parameter from DropDownList and my chart is produced on that parameter..... when I call the chart it appears on the same page so at the bottom of the page my paramater fields and also button are still present. Is there any way to generate the chart in a new page ? See the picture below please...... Thank you very much again. Maksuda...

Thanks for the reply. Here is my full code: .aspx page <% @ Page Language="C#" AutoEventWireup="true" CodeFile="Quarterly_Report.aspx.cs" Inherits="Quarterly_Report" %><% @ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" Namespace="CrystalDecisions.Web" TagPrefix="CR" %><! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">< html xmlns="http://www.w3.org/1999/xhtml" >< head runat="server"> <title>FusionCharts - Quarterly Chart</title> <script language="javascript" src="FusionCharts/FusionCharts.js" type="text/javascript"></script> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /></ head>< body> <form id="form1" runat="server"> <div> <% -- <%=GetQuarterlySummaryChartHtml()%> --%> <br /> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click1" Text="Button" /><br /> <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" DisplayToolbar="False" /> <br /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SQLServerConnection %>" SelectCommand="SELECT * FROM [View_EventCount_FiscalQtr]"></asp:SqlDataSource> <br /> <br /> <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="TagTypeDesc" HeaderText="TagTypeDesc" SortExpression="TagTypeDesc" /> <asp:BoundField DataField="Q1-2008" HeaderText="Q1-2008" SortExpression="Q1-2008" /> <asp:BoundField DataField="Q2-2008" HeaderText="Q2-2008" SortExpression="Q2-2008" /> <asp:BoundField DataField="Q3-2008" HeaderText="Q3-2008" SortExpression="Q3-2008" /> <asp:BoundField DataField="Q4-2008" HeaderText="Q4-2008" SortExpression="Q4-2008" /> </Columns> </asp:GridView> <br /> <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False" DataSourceID="SqlDataSource1" Height="50px" Width="174px"> <Fields> <asp:BoundField DataField="TagTypeDesc" HeaderText="TagTypeDesc" SortExpression="TagTypeDesc" /> <asp:BoundField DataField="Q1-2008" HeaderText="Q1-2008" SortExpression="Q1-2008" /> <asp:BoundField DataField="Q2-2008" HeaderText="Q2-2008" SortExpression="Q2-2008" /> <asp:BoundField DataField="Q3-2008" HeaderText="Q3-2008" SortExpression="Q3-2008" /> <asp:BoundField DataField="Q4-2008" HeaderText="Q4-2008" SortExpression="Q4-2008" /> </Fields> </asp:DetailsView> </div> </form></ body></ html> .aspx.cs Page: using System;using System.Data;using System.Data.SqlClient;using System.Data.SqlTypes;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Text;using InfoSoftGlobal;using DataConnection;using System.Windows.Forms;using CrystalDecisions.CrystalReports.Engine;using CrystalDecisions.Shared;public partial class Quarterly_Report : System.Web.UI.Page{ public string GetQuarterlySummaryChartHtml(){ StringBuilder xmlData = new StringBuilder(); SqlConnection mySQLconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLServerConnection"].ConnectionString); SqlCommand mySqlSelect = new SqlCommand("SELECT TagTypeDesc as Type from TagType where TagTypeDesc<>'Delete' ", mySQLconnection); mySqlSelect.CommandType = CommandType.Text; SqlDataAdapter mySqlAdapter = new SqlDataAdapter(mySqlSelect); DataSet myDataSet = new DataSet(); mySqlAdapter.Fill(myDataSet, "Type"); ArrayList myArrayList = new ArrayList(); foreach (DataRow dRow in myDataSet.Tables[0].Rows){ myArrayList.Add(dRow);} xmlData.Append("<chart labelDisplay='Rotate' slantLabels='1' caption='Quarterly Report' subCaption=' ' pieSliceDepth='30' showBorder='1' formatNumberScale='0' numberSuffix='' "); xmlData.Append(" seriesNameInToolTip='1' XAXISNAME='Quarter' lineThickness='5' reverseLegend='0' anchorAlpha='100' anchorRadius='5' setAdaptiveYMin='5' drawAnchors='1'>"); xmlData.Append("<categories>"); xmlData.Append("<category label='Q1-2008' /><category label='Q2-2008' /><category label='Q3-2008' /><category label='Q4-2008' />"); xmlData.Append("</categories>"); foreach (Object objRow in myArrayList){ xmlData.AppendFormat("<dataset seriesName='{0}' showValues='0'>", (((DataRow)objRow)["Type"].ToString())); string quarterlyQuery = "select * from (select " + "case when month(EarliestEvent) in (11,12,1) then 'Q1' else " + "case when month(EarliestEvent) in (2,3,4) then 'Q2' else " + "case when month(EarliestEvent) in (5,6,7) then 'Q3' else " + "case when month(EarliestEvent) in (8,9,10) then 'Q4' end end end end +'-'+ " + "cast(case when month(EarliestEvent) in (11,12) then year(EarliestEvent)+1 else year(EarliestEvent) end as varchar(4)) as fiscyr," + "TagType.TagTypeDesc, isnull(Sum(EventCount),0) as ttl from TagType INNER JOIN " + "TagDetails ON TagType.TagTypeID = TagDetails.TagTypeID INNER JOIN " + "IdsDataTest ON TagDetails.[TagName (Unique)] = IdsDataTest.TagName INNER JOIN " + "SensorCategories ON IdsDataTest.AgentIP = SensorCategories.SensorIP " + "WHERE (TagType.TagTypeDesc = '" + (((DataRow)objRow)["Type"].ToString()) + "' ) group by " + "case when month(EarliestEvent) in (11,12,1) then 'Q1' else " + "case when month(EarliestEvent) in (2,3,4) then 'Q2' else " + "case when month(EarliestEvent) in (5,6,7) then 'Q3' else " + " case when month(EarliestEvent) in (8,9,10) then 'Q4' end end end end +'-'+ " + " cast( case when month(EarliestEvent) in (11,12) then year(EarliestEvent)+1 else year(EarliestEvent) end as varchar(4)), " + " TagType.TagTypeDesc)t " + " pivot ( " + " sum(ttl) " + " for fiscyr in ([Q1-2008],[Q2-2008],[Q3-2008],[Q4-2008])" + " )as p "; DataConnection.DbConn oRs = new DbConn(quarterlyQuery); if (oRs.ReadData.Read()){ xmlData.AppendFormat("<set value='{0}' />", oRs.ReadData["Q1-2008"].ToString()); xmlData.AppendFormat("<set value='{0}' />", oRs.ReadData["Q2-2008"].ToString()); xmlData.AppendFormat("<set value='{0}' />", oRs.ReadData["Q3-2008"].ToString()); xmlData.AppendFormat("<set value='{0}' />", oRs.ReadData["Q4-2008"].ToString());} xmlData.Append("</dataset>");} xmlData.Append("<styles><definition><style name='CanvasAnim' type='animation' param='_xScale' start='100' duration='1' /> </definition>"); xmlData.Append("<application><apply toObject='Canvas' styles='CanvasAnim' /> </application> </styles>"); xmlData.Append("</chart> "); return FusionCharts.RenderChart("FusionCharts/StackedColumn3D.swf", "", xmlData.ToString(), "FactorySum", "600", "600", false, false);} protected void Page_Load(object sender, EventArgs e){ ReportDocument myReportDocument; myReportDocument = new ReportDocument(); myReportDocument.Load(Server.MapPath("CRReportsGLOBAL_IDS_STATISTICS_FISCALQTR.rpt")); CrystalReportViewer1.ReportSource = myReportDocument;} protected void Button1_Click1(object sender, EventArgs e){ GetQuarterlySummaryChartHtml();} } Thanks.........