how 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.
I 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 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.
how 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 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 do I create statistical charts from data in a database using ASP?
View Replies View RelatedThere 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 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 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:
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.
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 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 am not an expert in ASP but i am trying to generate a page in which i am able to generate an ID for any one viewing that page or entering the data.
View Replies View RelatedI wanted to know that is there someway in ASP that I can generate images on-the-fly without using ne 3rd party component?? Like its possible in CGI-Perl to generate ne type of image on-the-fly, is there a way 2 that in ASP? OK, if the 3rd party components r the only way, then r there ne free ones available?
View Replies View RelatedDoes anyone know how to generate a variable NAME?
I’m thinking of something along the ground of:
<%
myvar=�hello�
(“stuff�&myvar) = request.form(myothervar)
%>
Ive got a table in an access database and I want to generate my own autonumber
based on the number of records in the table. Code:
I've been surfing the web and this forum for methods to upload images through a form in a browser. I've come up with a few results, e.g. Dundas free upload component.
Besides that I've got the free product from ServerObjects.com to check the ImageSize and found some other non-component method to check the Image dimensions at: LearnASP.com.
Users should be enabled to upload a thumb for their profile. Since I can't expect each user to be a computer literate they might upload an image which is a bit too big. Are their free methods with ASP to reduce those images in size? I'm simply using ASP here with IIS. For now I can only give them an error stating that their image is too big.
A second matter might be a photogallery where there's bigger images and thumbnails. Right now I'm using Irfanview/Ifranview to quickly make thumbs for each regular image. Like with the example above it would be ideal if this can be automized as well, since users should be enabled to put up some small photogallery as well.
I know there's some fancy expensive methods to achieve this, but usually they offer loads more and all I need is something to crop or resize (resizing is best).
I'm looking for a code or a component that will enable me to generate images on the fly, through my ASP code.
For example:
Retrieve some textual data from a database and make an image out of it.
OR
Combine text and an existing image into one new image.
OR
Read an HTML file that contains text and image and generate an image from it.
I've found programs that do it (like ABC Amber Text2Image Converter), but I fail to make it work through a code and not through a software console.
I have been asked to produce reports which will be triggered and generated automatically via scheduled tasks against data in SQL SERVER.
The reports will be generated as CSV's to provide compatibility with Excel.
The reports will then e-mailed as attatchments to an agreed list of recipients.
This all has to be done with the use of ASP and SQL Server.
Can anyone advise on how the prolem should be approached?
How can I generate screenshots (.jpg) from a .flv file using asp?
View Replies View RelatedI'm generating excel spreadsheets online with many manufacturers. One
particular manufacturer has 5000 more records than the next highest. When I
query for that manuf the table does not form. Just plain text. It doesn't
time out. Just doesn't form properly.
Is there a cache or setting I need to increase to get this much data?
Does anyone know of any freely usable code that helps automate the
process of generating RTF files from ASP (particularly generating the
code needed for tables)?
Basically I have a site where the administrator adds new students to a college system. This code just adds a new student to the database. When they are added a username is generated by taking the first letter of the forename and the first from the surname and joining them to the date.
(ie, James Brown would generate JB2005) Obviously some people will have the same initials so i'm trying to get all the records from the student table in my database that has the first two letters as the student I'm trying to add and adding the value of the count of that recordset before the date of the new students initials. (ie, if Jane Bennett was added the username would be JB12005 because there is already a user with the initials JB in the database)
At the moment if i add a new member to the database, the fields are populated but the count of the recordset is not added so I end up with duplicate usernames. I'm not sure if the recordset is even being filled or whether the recordcount is not working. Code:
im currently trying to generate a list of links to files held within my database.The file itself is a pdf
Im currently using this code :
Code:
response.write "<A HREF='" & RS("file") & "'>" & RS("linkname") & "</A>"
and its giving me the error:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/irtwebsite/welcome.asp, line 27
I am working on a system which requires data to be entered for candidates. It stores the whole data about the candidates in database(MS Accesss). The system will be used on client-side.Now what Iam required to do is generate reports as required by the user.but i have heard about reporting tools which can be used with ASP to generate reports.
The reports can be in Excel format or word format.Please suggest me which one should i use and how to use it?I am very naive to anything like this. Where can i find more info about it?
I have a question about generating reportDates upon import succeed of text files to Access. In the tables that needs to be imported daily has a field name called reportDate.
I have done in such a way that an ASP page will call the Import Macro from Access & execute it. There is no data for reportDate in the text files because I want it to be updated by the codes itself(auto-generate).
I adventured into Access, double-clicked on one of the tables & then View it in Design View. I entered Now()-1 in the Default Value caption. And then, I try my Import code & went back to check on my tables to see if data has been imported into or not. I also check my reportDate & realized that Access enters the date as 1 day before.
When the user creates a new page, rather than go through every other page in the site and add a new link to the left hand navigation I want to use an include file and search the folder for all .asp and .htm files and display them in the navi as a link. If that makes sense?
I've been playing around with FileSystemObject, but am struggling to get the desired results. Rather than display the full name of the file in the navi, I want to remove the file extension and the path, and maybe convert the leading letter to a capital so it looks like a regular nav.
I am using dreamweaver MX to connect to a microsoft database with the typical data stored such as name, address etc. I gt this information to displlay via recordsets and thats all good.
BUt im having trouble exporting the data from the database inot an XML document. I know I can do it on Acces itself but i want to be able to generate it using ASP. How do I do this?