I'm trying to find thorough documentation for creating graphs using
serverside Excel from ASP. Any book recommendations?
A well-documented COM wrapper would be nice if it allowed us to create
may different types of graph, e.g. Wind Rose (for wind direction),
thermometer, as well as standard pie, line, bar charts. I've found a few
examples of charting code on websites and at MS, but none of them
contain a thorough explanation, and our database/ASP guy wants more
documentation.
I've done all the reporting bits on counting and all. I would like to know how to create graphs for that information. I m at a total lost on how to display a graphs on the web page.
Does anyone know of an easy way to display graphs using asp code. Is there any free packages on the web that can be downloaded for the purpose of displaying results in a graphical format. Or is it better to use pure asp code??
I have a db of prices for a material updated weekly, i am trying to create a graph to show the prices visually. i tried with JavaScript Diagram Builder, but didnt succeed, does anybody have other ideas to how to do so? or have good knowledge on how to do it with the Diagram Builder?
I have managed to succesfully return data from a database with an SQL SELECT string, and now I was wondering if there is a simple way to graph the data?
Does ASP have any objects that will help out with graphing, or would I have to to draw it out manually?(if that could be done). Or should I not try to do it myself and look at a 3rd party solution for graphs?
I 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?
Does any one perhaps know how to display data from a db in a asp page in graphs, or perhaps know of a resource where I can find more information on this topic?
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?
Does any one perhaps know an easier way of showing 6 different graphs that all display different information with out having to execute 6 different connections to the db?
Does anyone have any experience building bar graphs or charts in asp? Or has anyone used a dynamic bar chart generator that is easy to use and easy to integrate into a webpage?
I'm trying to use Activer Server Pages (ASP) to display a graph based on user's selection criteria. To achieve this, I would like to use Office Web Components (OWC 9 or 10), a Microsoft ActiveX component. My questions are:
* Can you use it with NT operating systems or Must it be in Windows 2000/XP? * Do anyone has experience in using it? and if yes, Are they easy and reliable to use? * Are there any other free components out there?
I 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.
I need to create a chart/graph with the following data from my database:
Each record is opened and then closed at a later stage. I then calculate the time it took from when the record was entered to when it was closed.
Now i need a pie chart to display how many records was closed in certain times. for example 10 records was closed within the first 10 minutes, 2 in 20 minutes and so on.
this also is to happen for dates that the user entered. i.e a Weekly report and a monthly report.
Any advice and help will be appreciated. I found alot of examples of hardcoded graphs but none extracting data from database.
So first i need to count the records that fits each section of minutes and then use that data to draw my graph?
i have a project i am currently working on, basically what i am doing is i have an excel spreadsheet with 2 fields a number that coordinates with another field which is a url, currently i have to copy paste the url in my browser to get what i want, which is a picture, each url is a picture and picture only, what im trying to do is create an asp web app that i can use that spreadsheet connect using asp and automatically download every url in the spreadsheet to a directory, while also renaming all the pics as the first field.jpg,so basically an asp downloader that downloads contents of url and renames it a certain number
I've an asp page which brings back a query and displays it in a table. The query takes around 30 seconds. Once the page displays they will have an option to send it to excel.
From the examples I've seen they all require the query to be re-ran again in asp (i.e. server side scripting) and as it takes 30 seconds to start with I want to try and take out the repeat of the query. Does anyone know of any way you can do this in asp by passing the already executed table to asp or via any other method?
I want to access the data contained in the MS excel by giving a field value that has to be got from one HTML file including a textbox and one button -SUBMIT to submit the required field value. Finally i want to display the details of that particular field value which is recieved from the first file in HTML. Is it possible ?
I have an ASP file which is opened in MS Excel. I have used the "formatNumber" function to set the number of decimals for variables which are displayed. however Excel cuts off any zeros at the end. e.g 4.650 displays as 4.65
the number of decimals I want to display to varies across the page, e.g. I cant say "display the whole with 3 decimal places" Is there any code I can put in my ASP page to stop Excel truncating zeros at the end?
i have a Print button to allow user to save reservation detail in ms excel. currently, when user clicks Print, a Save menu which allow user to open and save will appear. how can i skip this window? i want my system automatically open ms excel and at the same time open the Print window in ms excel and user also cannot modify any detail in ms excel. is it posible to that?
I'm working on some reports, and have added the ability to "download" the reports to excel. Not a big deal, fairly straight forward. However, PHB wants to be able to create some pivot tables from said reports (again.. no biggie) and when he goes to save the file, Excel wants to save the file as a web page instead of and Excel spreadsheet.
Now.. I know the simple thing here is to just pick Excel from the drop down box in the save as dialog.. but.. PHB would "prefer" to not have to do that.
Has anyone been able to jump this hurdle before? My good friend google hasn't turned anything up. My preference is to give PHB the middle finger.. but alas.. the paycheck is keeping me from doing that.
I have an asp, sql business application. Want to give export option of all reports to excel and pdf. Can I get that code which can embedd in the asp pages to create this function?
I need on-site manager's to be able to view a list of records on our website (which they already can do). They need to be able to select any/all fields and then export these items to an excel spreadsheet. The spreadsheet will have dynamically created columns/rows to append and life is good.
What's the best way to go about this? I've used DTS to do this before, but it's been a long time and I can't remember if there's a way to handle this kind of stuff on a dynamic basis.
I guess my real question is: Is there a way to do this via ASP or should I stick with a more SQL based approach?
Is it possible to copy all info on a page into excel so that it can be sorted?? I know how to get the page to load automatically into excel, using the -: Code:
however I lose some functionality if I do this, i know i could add a button that just re-runs the pages to load the info into excel, however some of the pages may take a while and I want to reduce time and load on the server. So I justed would like to know if it is possible using a script of somesort so that clicking a button will copy the whole page and then paste it into excel??
I need to write an ASP page that will allow users to upload an Excel file, the contents of which should then be imported into an SQL database. Problem I am facing is how to do this efficiently. So far I have a page that will accept an upload, then display the data from the Excel file, my first thought was to loop each row, then run an update/insert based on the data found...Obviously this is not going to be very efficient, I'd exepect time outs often Has anyone got any ideas to get round this?
