ASP :: Generating Charts Dynamically Using A MS Office DLL In ASP

Generate Charts In Serverside Excel Dynamically, Advisable?
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?

Dynamically Generating GUID Online And Then Using Them In VB.NET How Might I Do This?
first, say I have a payment processing scheme, and after a value is returned letting the program know that a sucessful payment is made, that somehow I dynamically create a GUID, (or something of the like). I want to have it somehow embedded in the program as well as well as sent to the buyer so that he can enter in that GUID and it unlocks the program.

So somehow I want to generate a GUID, either inside the program or outside of it which either way is incorperated into the program, and so that I have a copy of it. I want this all to be able to be done dynamically and I assume it would have to be done in ASP.NET as it doesen't seem feasable to run a .exe program on the web.

Any leads? Or perhaps there is some sort of "shell" that I can embed my program in that will do this for me. Any ideas?

Error In Dynamically Generating Snapshot Code
i have a problem with devoloping an asp program ,that is dynamically generating snapshot files (in .snp format)from

a MS-access database.
database name is datafile.mdb.
Report name is "reportTarge".
here is the asp code for this.

<%
Dim objAccess
Set objAccess = Server.CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "D:Databasedatafile.mdb"
objAccess.DoCmd.OutputTo 3, "reportTarget", "Snapshot Format (*.snp)", "snapshotname.snp"
objAccess.DoCmd.Quit 2
%>

But while executing this asp code ,i am getting the following error in my IE browser.

Error Type:
Server object, ASP 0178 (0x80070005)
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.

What is the reason of this error (while creating instance of the access)?. Is there any problem with my IIS server setting ?If there, how to solve it?

Pie Charts
how to pull data from an sql database and create a labelled pie chart with the date?

Graphs And Charts
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?

Create Statistical Charts
How do I create statistical charts from data in a database using ASP?

Mock Ups Or Flow Charts
Generally 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

Create Charts/Graphs
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?

Charts And Graphs 3,000 Users
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.

Create Statistical Charts
How do I create statistical charts from data in a database using ASP?

ASP Working With MS Office
I want to read the MS Word and XLS documents with ASP code for searching. Is
there are any solution for me or any reference?

Office Web Components
One of my programmers is using Office Web Components in classic ASP to
create, fill and format an Excel spreadsheet. Everything is fine except when
he creates Merged cells the performance drops dramatically. He has
investigated the 'Center Across Cells' alternative but cannot get it working
using Office Web Comonents.
Has anyone come across this problem or even better has a solution?

Office Web Component
Using OWC version 2000 I am trying to input a recordset
into an OWC Spreadsheet. I can pass the variables and
create the SQL fine in the ASP page, but I need to pass
the SQL to a vbscript function outside of the <% asp code %[color=blue]
>. Is there any way to call the function? ASP doens't seem[/color]
to recognize the function.

Office Page
Does anyone now were I can get a script for an out of office page for an intranet. A very basic one would do, something that displays when they leave and other basic details,for a company of about 40. All staff would be using it.

Office Web Components
In office web components u can use Excel through web with almost the same functionality. I have an emergency in finding out if it is possible in asp to save the changes u make to the spreadsheet though web to the original file in the web server.

Office Web Components
some good detailed documentation (with examples) on programing OWC (Spreadsheet, Pivot Table and Chart controls) using ASP 3.0?

Creating A Large Number Of Charts Automatically
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:

Want To Create Circular Graphs And BullsEye Charts With ASP
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.

Creating Line Charts Of SQLServer Data
Is there a way to draw charts from SQL Server Data using ASP.? Is itpossible to use the SQL Reporting Services using ASP.

Saving .Doc (office) File
I have to allow users to download files after checking users validity and I
cannot give full URL of file to download e.g www.myserver.com/mydoc.doc

I have seen ASP code some where in MSDN where users has to enter URL like
www.myserver.com/mydoc.asp and this will download the doc file.

Graphs And Office Web Component (OWC)
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?

Office Chart Component
any decent resources for using the Office Chart components? I've had a look around the MSDN but it's not very comprehensive and doesn't actually have any reference guides. Most resources say to refer to the help file that comes with the package but I can't find any versions of this.

Accesing Office Document Properties With ASP
Does anyone know of a way to access the document properties of an office
document using ASP? I need to be able to read things like the Title,
Author, and Comments fields and pull that information into a web page.

Connnect ASP Page To Office Thesaurus
Is it possible to connect and asp page to the Microsoft Office Thesaurus? I would like to be able to pass a word to it and get back all of the synonyms as either a string, array, or collection.

View MS Office Files Online
Are there any asp scripts that I can use to allow people to view my powerpoint, excel, and word files over the internet without having to download then? The must run from the server.

Server-Side Automation Of Office
I am facing some problems with generating the word documents usin ASP pages. This is the automated process and it is breaking often Since Microsoft is not providing any support for this issue, I though using WordPerfect 12 for the automated document generation would hel me a lot. Is there any possibility of facing the same problem with wor
perfect too?

Access Metadata From Office Files
How easy is it to access the metadata from office files and PDF's? That is, Author, Title, Keywords, Comments etc...

I want to be able to scan a directory and provide links with descriptions (ie Comments field) for each file within. I can use automation to open and read the office files, but I imagine this would produce too big a load on the webserver. Is there a simple and slick way of doing this?

Office 2000 SP3 Excel Page Break
Since I updated Office 2000 to SP3, my ASP code has failed when executing this function:

(the HPageBreaks.Add line fails)
function insertPageBreak ( xlsObject, strLocation )
with xlsObject
.Range( strLocation ).Select
.ActiveWindow.SelectedSheets.HPageBreaks.Add .Range( strLocation )
end with
end function

Parameters:
xlsObject is a valid object of excel created with:
Set xls = CreateObject("Excel.Application")

strLocation is a string in the form "Axx" where xx is the current row number, e.g. "A54"

I had to uninstall and reinstall Office 2000 without service pack 3 in order for it to work....

Copy/Paste From Office Web Components Object In Web Page?
I have a dynamically-generated asp web page which uses Office Web Components
to display an Excel bar chart of the user-selected data. The page works
fine, but the users would like to copy-n-paste the displayed bar chart from
the web page and insert it into an email (MS Outlook) or report (MS Word or
MS PowerPoint).

Is there any way of supporting this copy/paste functionality? When you
right-click on the chart in the displayed web page (viewed with MSIE6), you
are only given the pop-up button [About...] which displays the "About
Microsoft Office Web Components" splash window ("Version 9.0.0.8028 SP-3"
etc.)

Currently, the only work-around is to "Print-Screen", trim using Paint, and
then paste into the destination. This is too tedious and beyond the
capabilities of some of the users.

Generating ID Under ASP
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.

Generating Images On-the-fly
I 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?

Generating A Variable Name
Does anyone know how to generate a variable NAME?

Iâ€™m thinking of something along the ground of:

<%

myvar=â€?helloâ€?

(â€œstuffâ€?&myvar) = request.form(myothervar)

%>

Generating Particular Autonumber
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:

Possible To Generating Thumbs?
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).

Generating Images
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.

Generating CSV Reports
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?

Generating Screenshots
How can I generate screenshots (.jpg) from a .flv file using asp?

Generating Excel
I'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?

Generating RTF Output From ASP
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)?

Generating Usernames
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:

Generating Hyperlinks
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

Generating Reports
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?

Generating ReportDate
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.

Generating Navigation
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.

Generating XML Code
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?

Generating Statistics From Access
I would like to do is to generate statistics from my access db.

Within the db there are fields for each of the 11 plaers in the team each week, i.e. p1, p2, p3 ...... in each one will be a name, i.e Bill Bloggs but the name could appear in any one of the 11 fields.

What I would like to do is count the number of occurances of bill bloggs in the 11 fields and return it on my site as a table, i.e.;

name - times played
bill bloggs - 6

ASP/Oracle And Generating PDFs
I have a project coming up soon where pdf files are stored in our oracle database. They want me to pull the pdf form out of the database and present it to the user on the screen. I've done a little searching on google, but haven't been able to find anything that helps. Can someone tell me if this is possible and if so, give a little example?