Asp Creating Charts Dynamically
There are two files here.. TEST_CHART_RUN.HTM calls the second file. Please copy and paste these files as needed to htm and asp files.
View RepliesThere are two files here.. TEST_CHART_RUN.HTM calls the second file. Please copy and paste these files as needed to htm and asp files.
View RepliesI have found a Help and Support for How To Use Server-Side Charting to Generate Charts Dynamically in MSDN;
http://support.microsoft.com/default...b;en-us;244049
I have generated Bar, Line and Pie charts using the MSOWC.DLL and its fantastic.
The ONLY problem I have encountered is when generating Pie charts it shows the quntities of each piece inside the Pie chart and its very hard to read. But in Excel it shows outside the Pie chart. So, I want to find out a solution for this.
I have a new approach to saving charts from server-side Excel when ASP pages are processed. The charts show weather data that is updated every 15 minutes in a database, and instead of just automating the chart production so that every chart is generated every 15 minutes, 24 hrs/day, it seems smarter to generate up to date charts when people want to look at them. But I'm not sure if this is the best approach.
This is what I can do from an ASP page to dynamically chart data:
- run Excel on the server
- open a Worksheet that has a customized chart for a range of cells.
- insert new data in the charted range of cells (chart auto-updates).
- save the chart to a gif file.
- insert the gif into the html page viewed by the client.
Using this approach is convenient because I can customize charts to look exactly as I want without having to find the documentation to automate the chart formatting.
Is it possible to run Excel once on the server, and let all requests for charts use this one running instance of Excel? The alternative is that Excel will run once for each chart request, this seems like it could get out of hand pretty quickly if a lot of people are trying to look at charts at the same time.
Are there better ways to generate charts dynamically on the server?
I'm looking for a way to create over 100 Excel *charts* programmatically.
We've just run a large online survey and the data is being fed back to us in
a single spreadsheet - each respondent on a row and their dimensions
(division, department, etc) and each of their responses in columns.
This data has to be sliced by a number of dimensions - this will require
that just over 100 separate charts will have to be created. I'm looking for
a way to create these charts in the most efficient way. I'm happy to
normalise the data and load it into SQL Server, and can then easily extract
each required subset. The output of the extract process will probably be
spreadsheets in TSV format.
Last time I had to graphically report this sort of data I loaded it into a
mart and used PivotCharts. The owners of they survey don't need the
flexibility of Analysis Services so I'm happy to pre-define the charting
requirements if it'll mean I'm able to create these charts automatically.
Manipulating 100 PivotCharts was too much for them. Each chart will
ultimately be fed back to users in a Word document or Powerpoint
presentation with the appropriate analyses. Code:
Is there a way to draw charts from SQL Server Data using ASP.? Is itpossible to use the SQL Reporting Services using ASP.
View Replies View RelatedI am tryimg to create a RadioButtonList dynamically. My code below gives an "Index was out of range" error. Where am I going wrong?
Sub CreateRadioButtons(ByVal dr)
' Instantiate RadioButtonList
Dim DynamicRadioButtonList As New RadioButtonList
Dim t As Integer
t = 0
Do While dr.Read()
DynamicRadioButtonList.Items(t).Text = dr("PRO_en")
t = t + 1
Loop
'Add radio button
PlaceHolderGroup.Controls.Add(DynamicRadioButtonLi st)
End Sub
Is it possible to create tabs dynamically using asp. eg .i m working on three projects. so when i open the portal, it will show me information of each project in three diff tabs with the name of project displayed on the tab. If tomorrow i ll be working on 2 or 4 projects it will display me only 2 or 4 tabs.
View Replies View RelatedI want to update Excel file when i update database.
View Replies View Related I am using a repeated field to bring in to my page repeated records, and I have been able to retrieve values that are entered into text boxes that are associated with these repeated fields. I would like to post these values into a database, but I'm not sure how to set up my table as I know that each employee's values as well as number of fields will be different.
I thought about setting up two tables. One that houses the dynamic question and the other to house the answers, but I'm not sure if that will work. I could really use help as to the syntax to write a loop statement that will insert my returned variables and create the field names dynamically into my database table. I believe this is what i need to do.
I am generating a series of tables in CSS. The tables should repeat
themselves for a number of times governed by a counter that is
calculated at runtime by the ASP code. The problem is that I have used
top margins to position the tables in the ASP page.
So the tables when repeated super-impose on the tables that are
already placed at that margin position. Can someone suggest me a
better way out to resolve this?
my ASP code creates a form and an array of chekbox with this statement response.write "<input type='checkbox' name='chkProduct" & Cstr(counter) & "' value='delete'>" all goes well and i also have a button that points to a VBScript function passing one parameter the counter start value so i can loop throught the checkboxs on the client side and determine if checked or not.
Ok i can display my command "document.frmProductCart.chkProduct & (Cstr(counter)) & .checked" as a string in alert but cannot make it as a command like it should be, anyone got any pointers ?
I need to implement the following functionality in asp. I have got an asp page which renders some html onto the browser.Now instead of rendering the html to the browser i should save that as an html file in server itself.
View Replies View Relatedhow to pull data from an sql database and create a labelled pie chart with the date?
View Replies View RelatedI'm building a site in our intranet that reports out hits and issues in our loaders coming from a SQL Server and I was exploring the use of MS Charts, but unfortunately, all the example I got from MSDN was MS charts used in VB. Is there a way you can call the MS chart in an ASP page?
View Replies View RelatedI need to generate some reports with graphical charts (line, pie, bar and polar). I want to generate those charts which represent database values. Hope I have to use a 3rd party control for this.
View Replies View RelatedI am trying to figure out how do I create graphs and charts in ASP without having to use third party solutions. I was told that I can create dynamic graphs and charts using ASP.Net but when I read up on this, came up at a dead end. Any ideas anyone?
View Replies View Relatedhow I can generate xl bar charts from ASP page. For example, just a click, take the input (recordset), put in a chart and open up/open a xl sheet, show the chart through excel application.
I tried with user defined class, but this isn't working with excel.
How do I create statistical charts from data in a database using ASP?
View Replies View RelatedGenerally before going for development, i like to put everything on paper.
something like a flow are there any tools by which i can create these flow chart or mock ups with less pain
I want to display the data from Access in form of Bar charts and Pie charts. I know this is possible by using the OWC components. But i am not familiar to them.Can anybody give me an outline/example of how to do this?
View Replies View RelatedI have recently found myself involved with a very small company who is being contracted by a very large company to develop a PowerPoint type application for their sales people (18 slides and about 3,000 active users) which must include charts and graphs. It doesn't have to be in real time and we may render the graphics each night instead of on the fly. The slides will be dynamic and represent up to 30 different companies querying about 29,000 rows of data per company.
I oddly enough don't feel as worried as I probably should be.
Suggestions, Possible Pitfalls, and Previous Experience building an application like this.
Working off of MS SQL and planning to do it all in ASP.
How do I create statistical charts from data in a database using ASP?
View Replies View RelatedI looking for a tutorial on charts/graphs which would take information from the DB table. I have a column about 31000 records and numbered field of 001-0022. I hav another field which contains texts.
What I'm looking for is to show graphically on a scale of 001-022 as in the first field how many time does the search criteria appear.
For example: I search a keyword "hello"
and the graph would show 001: 30 times, 002: 4 times...022: 1 time, but as a chart.
I think it would be nice to add a percentage calculation too.
I'm in desperate need of knowing if its possible to generate
custom circular diagrams and BullsEye charts using ASP (or
ASP.NET) on a webpage.
I must be able to build a graph that is constructed with
several inner circles, segments and bars that start from the
center.
Any method will do as long as I get the right shape. The graph
doesn't have to be intelligent in anyway.
I have the following piece of code:If RS.EOF or RS.BOF Then
Session("Authenticated") = False
Response.Write "Sorry, your userid or password did not match"
Response.Write "<BR>"
Response.Write " or you have not registerd yet, please register"
Response.Write <a href="default.asp">Clik here
Response.End
Here, I need to build the line (Response.Write <a href="default.asp">Clik
here)
dynamically, so that the html output from asp page
gives us <a href="default.asp">Clik here
i have a long recordset that i want to page through. can sql pass back say, 5 records from 20 to 25 out of 1000?
i can then pass 2 variables between the pages to dynamically generate the sql and thus page through the results. can someone post up a simple example of this if its possible?
With ASP is it possible to dynamically change the <title> tag depending on what record I am viewing? I know that you can do this isn ASP.net and PHP but was wandering if its possible in ASP too
View Replies View RelatedI am currently struggling with dynamically naming a zip file. Basically I want someone on my ASP site to be able to choose to download a zip file and the zip file to be renamed before it is sent to them with their login name. Does anyone know how I might accomplish this. Code:
View Replies View Relatedi have a form with two pull-down menus. when the user chooses a value from one, I need to go to the db and execute a query, and then populate the 2nd pull down menu with the retrieved values.how would I go about this? where do I add the listener function that will catch the selection event, and what should go in it?
View Replies View RelatedDoes anyone know if there are any IIS components out there that run on
IIS 5.0 that will convert LaTeX to PDF? I have written a script in ASP
that produces the LaTeX document, but am unsure of how to go about
converting it to PDF and delivering it to the client.
If you don't know of one, do you have any idea of how I might implement
such a transform? I would have to use a WshShell to run pdflatex on
the source twice before I could deliver the PDF to the user. However,
pdflatex outputs a PDF, so I would have to redirect the client to the
PDF, and then somehow come along later and clean it up. I'm not sure
if this would be the optimal process to take.
I have a form where there are 2 dropdowns. Based upon what you select in the 1st dropdown, that selection populates the 2nd dropdown. I want to change it so that if you select 'Loan Officer' in the first drop down, the 2nd dropdown turns in to a textbox, rather than the huge dropdown it becomes now
View Replies View Relatedthis form I need to create, I have very little experience in ASP. I will basically need to have a form that collects hours for a specific Week End Date.Also a running total for hours.
Dropdown with week end dates
Dropdown of Task, Mon, Tue, Wed, Thurs, Fri, Sat, Sun
Default 5 rows
Add Row Submit
Since I will need to dynamically add a row of data, I am not sure how to submit. What would you do in this scenario? Im so new to this and of course this is due ASAP.
I have an asp page in which if i click on add row i call a javascript function and create a new table row.This works well if i do not have to retrieve any dynamic data from my database. ie if i just have to insert for input type ="text" then no problem but when i have to do the same thing for a input type ="select" i have no idea what to do for the select has to retrieve records from the databse to allo the user to choose. How can i do this ?
my javascript function
function addrows()
{
var cellRight = row.insertCell(1);
var el = document.createElement('input');
el.setAttribute('type', 'text');
el.setAttribute('name', 'comment' + iteration);
cellRight.appendChild(el);
}
how can i adjust this to allow for select tag ?