http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help: Forum: How-To - Recent Topics en Tue, 06 Jan 2009 04:59:53 +0000 http://dashboard.infocaptor.com/topic/number-formatting-sql-server-dashboard#post-36 Tue, 30 Dec 2008 19:35:19 +0000 guest 36@http://dashboard.infocaptor.com/ <p>Thanks for helping out….I got the $ numbers to display correctly, but as far as the dates being pulled from the SQL tables they are in YYYMMDD format. I have tried various settings but they do not affect the display. I am looking for MM-DD-YYYY. (don’t mind the 2030 Year…it is a scheduling thing.) </p> http://dashboard.infocaptor.com/topic/dbcs-support#post-32 Mon, 29 Dec 2008 15:29:42 +0000 admin 32@http://dashboard.infocaptor.com/ <p>To whomever it concerns, does infocaptor support DBCs? </p> http://dashboard.infocaptor.com/topic/inventory-balance-trend-in-ms-sql#post-30 Fri, 26 Dec 2008 17:03:29 +0000 admin 30@http://dashboard.infocaptor.com/ <p>Happy Holidays...<br /> I have downloaded InfoCaptor, and it is exactly what I am looking for! thank you!<br /> quick question....<br /> I plan on using it to access MS SQL databases.</p> <p>How do you track items that do not have datebase fields.<br /> For example, I have a SQL query that looks at our inventory balance when the SQL statement is run. How would I track the results on let's say a weekly basis with a chart? TheSQL statement result is point in time. Where are the results stored so that I can monitor a trend? </p> http://dashboard.infocaptor.com/topic/changing-pie-chart-to-bar-chart#post-25 Fri, 25 Apr 2008 15:21:50 +0000 admin 25@http://dashboard.infocaptor.com/ <p>I have just downloaded the trial version of the software and it looks to be exactly what we are looking for within our small business.</p> <p>I could do with some advice regarding bar/line charts. I wrote a simple query which displayed ok as a pie chart but when I changed the chart type to anything except pie/pie 3D it is blank. I tried putting in a dummy third column as suggested in the tutorial but it still did not display. See screenshots below.</p> <p>I also tried creating a barchart using a basic spreadsheet as a data source but could still not get it to work. Am I doing something wrong or is it a limitation of the trial software? </p> http://dashboard.infocaptor.com/topic/display-percent-sign-on-the-portlet#post-23 Sun, 13 Apr 2008 20:27:16 +0000 admin 23@http://dashboard.infocaptor.com/ <p>I am trying to include a % in the output. I connected to excel that has a number of rows that represent percentages and other rows that are numbers. The formatting from excel is lost when I retrieve the data. How can I represent a perctage&gt; </p> http://dashboard.infocaptor.com/topic/connect-to-excel-file-as-sql#post-19 Thu, 10 Apr 2008 20:18:47 +0000 admin 19@http://dashboard.infocaptor.com/ <p>I need to know if this application will link to Excel as the data source as well as SQL. We hope to conduct a pilot program using Excel first and migrate to SQL after approval. </p> http://dashboard.infocaptor.com/topic/dashboard-traffic-light-widget#post-4 Thu, 10 Apr 2008 19:49:00 +0000 admin 4@http://dashboard.infocaptor.com/ <p>2) Is there some sort of traffic light widget that I can use to indicate is something is alright or not eg, green for everything is OK, Amber for some issues and Red for failures </p> <blockquote><p> You can use the Meter chart type and you can create sections for red,yellow, green etc </p></blockquote>