slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Web Forums - ASP/ASP.NET/Web Services/Other
Forum to discuss building external web applications for SalesLogix. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to ASP/ASP.NET/Web Services/Other | New Thread

View: Search:

Author

Thread: Beautiful Charts on Saleslogix WEB

Jose Urena
Posts: 92

Beautiful Charts on Saleslogix WEB Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Mar 09 5:58 PM

Ok. First i have to thank Ryan for the 3.5 SP2 problem help!

Lets add some fancy graphics to Saleslogix. See the following url http://weblogs.asp.net/scottgu/archive/2008/11/24/new-asp-net-charting-control-lt-asp-chart-runat-quot-server-quot-gt.aspx

Wouldnt be great to have them in Saleslogix WEB ?

Ok. Here's how i did it with Saleslogix 7.2.2.

First. Be sure to download Net Framework 3.5 SP2 (Note the SP2 is mandatory). Install it.

Download and install the free Microsoft Chart Controls. Do it faster, before they start to sell it.

Be sure to follow the steps of the installations. If you are asked to reboot... DO IT!

Now here comes the tricky part... again Thanks Ryan! http://slxdeveloper.org/forum.aspx?forumid=4001&postid=21677

Remove the action="javascript:void(0);" of login.master, default.master, dialog.master and base.master files of your portal.

Locate the web.config file and add the following:

To the <Controls> section: <add tagPrefix="asp" namespace="System.Web.UI.DataVisualization.Charting" assembly="System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

To the <httpHandlers> section: <add path="ChartImg.axd" verb="GET,HEAD" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>

To the <appSettings> section: <add key="ChartImageHandler" value="Storage=file;Timeout=20;Url=~/tempImages/;"/>

Save and close your web.config.

Create a folder on your portal's root called... you guessed it... "tempImages"...

Do the "iisreset" trick just to be sure. After iis restarts, test your portal. It should be running fine.

Now, lets add the fancy graphics.

Take any smartpart you want. I made a new smartpart to show a funnel dashboard on the campaign section. I don't enter in details about how to do that because that's for another writeup. Lets just say, i've created Dashboard as a custom smartpart.

Open both Dashboard.ascx and Dashboard.ascx.cs.

Add using System.Web.UI.DataVisualization.Charting; to Dashboard.ascx.cs, save it.

To Dashboard.ascx add:

<asp:CHART id="Chart1" runat="server" BackColor="211, 223, 240" BackGradientStyle="TopBottom" BackSecondaryColor="White" BorderColor="#1A3B69" BorderDashStyle="Solid" BorderWidth="2px" Height="296px" ImageLocation="~/TempImages/ChartPic_#SEQ(300,3)" ImageType="Jpeg" Width="412px" PaletteCustomColors="RoyalBlue; SeaGreen; Firebrick; Khaki">
<titles>
<asp:Title ShadowColor="Transparent" Font="Trebuchet MS, 14.25pt, style=Bold" ShadowOffset="3" Text="Resultados" ForeColor="26, 59, 105" BackImageAlignment="Top" Name="Title1">
</asp:Title>
</titles>
<legends>
<asp:Legend Enabled="False" IsTextAutoFit="False" Name="Default" BackColor="Transparent" Font="Trebuchet MS, 8.25pt, style=Bold"></asp:Legend>
</legends>
<borderskin skinstyle="Emboss"></borderskin>
<series>
<asp:Series IsValueShownAsLabel="True" XValueType="Double" Name="Default" ChartType="Funnel" CustomProperties="FunnelMinPointHeight=1" BorderColor="180, 26, 59, 105" LabelFormat="F0" YValueType="Double" ChartArea="ChartArea1" Legend="Default" ShadowColor="Transparent">
<points>
<asp:DataPoint YValues="1" CustomProperties="FunnelLabelStyle=Inside" IsValueShownAsLabel="False" LabelFormat="F2" MapAreaAttributes="" ToolTip="" Url="" />
<asp:DataPoint YValues="1" CustomProperties="FunnelLabelStyle=Inside" IsValueShownAsLabel="False" MapAreaAttributes="" ToolTip="" Url="" />
<asp:DataPoint YValues="1" CustomProperties="FunnelLabelStyle=Inside" IsValueShownAsLabel="False" MapAreaAttributes="" ToolTip="" Url="" />
<asp:DataPoint YValues="1" CustomProperties="FunnelLabelStyle=Inside" IsValueShownAsLabel="False" MapAreaAttributes="" ToolTip="" Url="" />
</points>
</asp:Series>
</series>
<chartareas>
<asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BackSecondaryColor="White" BackColor="Transparent" ShadowColor="Transparent" BorderWidth="0">
<area3dstyle Rotation="10" Perspective="10" Inclination="15" IsRightAngleAxes="False" WallWidth="1" Enable3D="True" LightStyle="Realistic" />
<position Y="12" Height="81" Width="89.43796" X="5"></position>
<axisy LineColor="64, 64, 64, 64">
<LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" />
<MajorGrid LineColor="64, 64, 64, 64" />
</axisy>
<axisx LineColor="64, 64, 64, 64">
<LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" />
<MajorGrid LineColor="64, 64, 64, 64" />
</axisx>
<InnerPlotPosition Height="96.90312" Width="97.35575" X="2.37221" Y="0.4185" />
</asp:ChartArea>
</chartareas>
</asp:CHART>

Save it and close Dashboard.ascx.

Now, you can locate the Page PreRender of Dashboard.asc.cs and place some code like this:

double[] yValues1 = new double[] { Convert.ToDouble(vigentes), Convert.ToDouble(cumplidas), Convert.ToDouble(incumplidas), Convert.ToDouble(vencidas)};
Chart1.Series["Default"]["FunnelLabelStyle"] = "Inside";
Chart1.Series["Default"].Points.DataBindY(yValues1);
Chart1.Series["Default"]["FunnelMinPointHeight"] = "10";

Notice that all the variables i was using (vigentes, cumplidas, incumplidas and vencidas) are being converted to DOUBLE!!! VERY IMPORTANT!!! And notice that you can add as many points to your yValues1 as you want.

Save, close, deploy,

OPEN YOUR PORTAL!!!

ENJOY THE FANCY GRAPHICS!!!