I create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
Is any way to seperate it? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page, or create another drop down list to select for how many data to show in a page? and how to write that ?
I have a problem,i create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
is any way to seperate it ? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page , or create another drop down list to select for how many data to show in a page? and may i know how to write that ?? thank you very much
another question is , once created the chart , how to view it like a pic in a part of IE just like the stock market value?for your information, i connected to database and created the excel chart , and just link to show it in IE for whole.
i have a problem,i create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
is any way to seperate it ? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page , or create another drop down list to select for how many data to show in a page? and may i know how to write that ??
another question is , once created the chart , how to view it like a pic in a part of IE just like the stock market value?for your information, i connected to database and created the excel chart , and just link to show it in IE for whole.
I developed some code to export DataGrid to excel base on the html stream technology. But that one works only with worksheet cell. Is there any way to output Excel Chart based on the html stream?
I am tryign to create an excel spreadsheet/chart using office web components in asp. However I seem to have a registeration problem. I'm running office2003 and IIs is also running on my pc. When the following line exceutes an error "invalid string class is thrown" :
set objChartSpace = Server.CreateObject("OWC.Chart")
I have intalled owc again but still no luck. IS it a registeration problem ?
When the output is in excel format for an ASP page, some of the values displayed get transformed to decimal numbers instead of their true values. How to solve this problem? When the output is in plain html, the values are displayed correctly. Note that the values to be displayed are in TIME format. How can i change the format of excel cells in asp? For output in excel when the form method is POST, no parameter values get posted to the other page. But when it is GET the values get posted. Y? I even change use request.querystring for GET but the result is the same.
I have a asp page which will get the data from multiple tables (with functions and procedures)and display data in HTML tables <TABLE> on ASP page.Is there any way we can create a excel file from the output of this ASP file.I know how to export if this information on ASP page is coming from single query from a database table.
I am developing my application in ASP and there is a requirement to save the output in Excel. One option is to use Content-Disposition header but it prompts user for saving. As per our requirement the output should get automatically saved.
The website sends users through a series of questions. When they are done they can view there results and open a printer friendly version, but my boss wants the user to have the option to send their answers to Word or Excel so they can either change their answers or the layout of whatever. Is there a way to do this?
I have written an ASP script that connects to a database and runs a stored procedure and displays the results in text format ...using the <TABLE> tag. But I would like to have these results appear in a NEW Window in an Excel format. I used :
This opens up Excel in the same window and usually does not refresh my data ...even though the stored procedure is actually running on the database server.
I have a site that currently collects info from a form. The info is then emailed to an elected email address. It occurs to me that perhaps there is some way of collecting the information and sending to a spreadsheet that would keep updating. THe information is all word based (as in mostly yes or no answers).
i have created a quotation page where customer could view the quotation details and i just thinking to allow customer to print his/her quotation as a reference. all the data are fetched from db and displayed in the table.
I have one problem, that is i design a ASP report getting data from MS SQL Server 2000 and displays it as a desinged format and also "one option to export this same format to MS EXCEL". Before i seen it, but i dont know its code:
I'm trying to develop some graphs for my site and hoped this would be a solution.
I have one question really. We've installed the MS Office 2003 components on our webserver -2003- but i seem unable to create a reference to it in the code i.e.
dim owc set owc = createObject("owc.chart")
It comes back with an error which doesn't seem to make sense as the component is registered on the server, does anyone know what might be causing this?
I ve created a table of information and now i need to make a number of pie charts from this table.
Ive attatched an image of the table, to make it easier for you to know what i mean. a pie chart i want to make for example is, say, the number of red,yellow and green projects in Fixed Income, ie 14 red, 4 yellow and 4 green.
I have been making a dynamic chart in ASP, and it's working fine so far. However there's only one thing that is not working. The color of Plotarea! I don't know how to define the color of plotarea. I tried to specify the color of Plotarea as below but it didn't work.
set oChart = Server.CreateObject("OWC.Chart") set objChart = oChart.Charts.Add() objChart.PlotArea.Interior.Color ="#FFFFFF"
what the best way to produce radar charts from asp would be? I know that I will probably need to install a component on the server. Any comments on what the best / cheapest one would be?
I've heard conflicting stories on the ability of Office Web Components to access a data source that resides on the internet (as opposed to the intranet). Some say you can, some say you cannot. I can get the owc chart to connect to my database on IIS but I would like to publish this on my webpage.I'd like to insert a chart on a page which I like to use data from an Access database on my webpage. How do I get that chart to link to a data source on my website? I use the following line to connect to my database normally:
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("amsydb est.mdb"))
But where do I insert this in the data connection section so I can get my OWC chart to connect to this database?
I prepare a owc chart in asp. in category axis (x-axis) i want to adjust date format according to date range, For Example: if data is of 5 years then tick lables show Years as below Large data : 2005,2006 Medium : Jan, Feb Samll : Mon, Tue
I've tried by NumberFormat property Chartspace.Charts(0).Axes(0).NumberFormat = "dd,mm,yy" but it is not working. can it be done through ASP or via SQL statement. if SQL then how
I have been asked that every user in the site should have a chart that shows individual calories, fat, carbs of items that the user selects in any restaurant so And the user would be able to plan how those items would effect their diet plan.
Also the charts and graphs will be for Weekly Progress Chart , as the site is for diet progress for the users.If anyone knows how this can be done,please help as i am stuck here and i am a newbie to ASP.
is there any component available for creating Organisation Chart. I hope, I don't have to write code for creating boxes & lines for creating this Org Chart.
I have made a page to display a chart based on data from my SQL-server. I have used Office Web-component graph. Here I can set the correct SQL statement and the graph works fine.
Now I want the user to be able to input the WHERE part of the sql sentence. Can anyone point me to info or code on the web to do this ?
I need guidence regarding creation of PERT/CPM chart using technology ASP/PHP/VB. I just want to know if it is possible to create PERT/CPM chart using any of the above technology.
Anyone have code for a color chart. Specifically a chart that when clicked passes the hex value through querystring or a form. I could make one, but I'm just feeling lazy today.
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.