I'm looking fo a solution to generate automaticaly a PDF file.
My aim is to use a template define by a user and to insert dynamicly
datas form SQL server in this document.
Can you tell me if it exist PDF template like .dot for word ?
If such file exist is it possible to generate list of information like
aacount report with datas coming for Database like Sql server.
Is it possible in a global.asa file (or some other way) to have an xml file generated by an asp script and saved to the server some how?
<%
Dim xmlDoc, rootEl, child1, child2, p'Create an XML document
Set xmlDoc = Server.CreateObject("Microsoft.XMLDOM")'Create a root element and append it to the document
Set rootEl = xmlDoc.createElement("root")
xmlDoc.appendChild rootEl'Create and append child elements
Set child1 = xmlDoc.createElement("child1")
Set child2 = xmlDoc.createElement("child2")
rootEl.appendChild child1
rootEl.appendChild child2'Add an XML processing instruction
'and insert it before the root element
Set p=xmlDoc.createProcessingInstruction("xml","version='1.0'")
xmlDoc.insertBefore p,xmlDoc.childNodes(0)'Save the XML file to the c directory
xmlDoc.Save "c: est.xml"
%>
THis seems to be what i am after but when I try to modify the xmlDoc.Save line to either "/images/listings/test.xml" or imageslistings est.xml" and it comes back saying it can't find the path. If I just leave "text.xml" it comes back saying permission denied. If I can solve this path issue so as to be able to save the file to a directory I think I will have it solved.
help to slove the multiple posting
i have to run three .asp in seperate server to save the Orders in .mdb file. when user submit the order form on web page[Orders.htm] it should post it to
1. http://[ server1 ]/[file1].asp
2. http://[ server2 ]/[file2].asp
3. http://[ server3 ]/[file3].asp
4. to its own
how can i read the datas in specific columns and rows from excel(.csv) file and then use that datas to calculate the min(example) and write the results into the same excel(.csv) file.
View Replies View Relatedi wrote this code to read the datas from excel(.csv file). but it read all the datas as 1 line. i don't undestand why.is there any function that i can use to stop it read the datas in the next line?? can anyone help me?? thanks a lot.
Do While Not TextStream.AtEndOfStream
line = TextStream.readline
if line <> "" then
arr_User(i) = trim(line)
splitline = split(arr_User(i), ",")
for j=0 to 5
response.Write splitline(j) &"nbsp;nbsp;"
next
i = i + 1
redim preserve arr_User(i)
end if
Loop
currently, i export data from ASP to Excel. but i want to change it to RTF. i have looked at microsoft website and tried whay i have studied but failed to make it. at microsoft website, the table is created using rtf script but in my case, i just want to create it using html script.
and then, when user click PRINT button, i want my system shows the detail contents of rtf file and then open the Print window later. so user does not need to click File->Print and so on. is there any example script i can study?
how to generate a text file with data from the db in asp and save that file in clients system.
View Replies View Relatedi get data with ado i need to get a xml string from the recordset how can i get it without having to persist the recordset in a (xml) text file is there a simple way ?
View Replies View RelatedI have an application form that when filled out is being written to a singular HTML file. I want to convert it to generate a unique file name each time a user fills it out.
Secondarily, I want to be able to attach the unique file to the email that is sent to us when it is submitted.
Here are the current snippets of code:
set ObjFS = server.createobject("Scripting.FileSystemObject")
set objTheFile = objFS.OpenTextFile("e:credapp2.html",2,-1)
objTheFile.WriteLine(FileToWrite)
objTheFile.Close
and...
objMail2.AttachFile "e:credapp2.html"
With response.contenttype = "application/vnd.ms-excel", I can easily export my data to Excel which is embeded and shown within a browser. If I'm going to save the Excel file through ASP programming, which method can I use? I need to save the data to Excel file with dynamic name (the file name should contain key values and appended with system datetime).
View Replies View Relatedhow to create (generate) .html file by using asp. I am not sure if this possibility even exists... if not, is there any other way I could generate .html files? The thing is that I have to retrieve info from database and the generate .html file.
I know I could have it as .asp, but this woudl my index page and I would like to use it for search engine, which are not very happy with other extensions than .html.
how to create (generate) .html file by using asp. I am not sure if this possibility even exists... if not, is there any other way to do it?
View Replies View RelatedIs it possible to get information from a database and generate it to
unicode text files using ASP?
Is there any product/COM out there that can do this? If not, is there
any other solutions? It doesn't have to be ASP, but it would be nice.
generate an ms word file for an asp output?
<%
x=date
response.write(x)
%>
- is it possible for the date (code above) to be displayed on ms word?
On each site there is a global.asa file that ties into an Access database. The fields from the Access database instantiate the values of session variables used in the site. I am trying to do away with the need for a database and was wondering if when I set up a site I also set the .asa file for that site.
Then if a shop wants to change something like an address, phone, number, directions, etc., they would go a toolbox area of the site and there would be a form whose field values would be populated by the session variables from the global.asa file.
When the form was submitted I was thinking I could somehow use asp to write a new global.asa file and store it in the server. Is this feasible? Also, what would this mean insofar as permissions on the root directory of the site? I'd imagine they'd have to have write permissions no? Code:
i collect datas (user input) from the form say form1.asp and if i press submit button it should straight away go to the emailid say contact@abc.com.
View Replies View RelatedPlease someone tell what is maximum lenght of Session- [item {field} ].
I am working on extreme binary data and it holding Session Variables.I don't no how much length should i give to the session variable.
Note: Binary data is nothing but a Image data: Code:
I have recently developed a web application across my clients intranet. We used ASP with Interdev 6.0 and SQL server as the backend.
They have now come to me asking me to develop some reports that can be accessed via a drill down within the app. They don't have Crystal Reports so this is not an option. Can anyone suggest an alternative to using crystal reports to publish dynamic reports via the web and ASP?
What is the best option for report in classical asp.
View Replies View RelatedI need suggestions to allow my users the ability to print reports from my ASP application that will be quick and easy setup. I need them to choose an option such as
Print all checks for the current week
and receive an output of 1 page per employee . Currently I have the page so someone can view 1 employee on the screen and manually print. But I am looking for some web based report delivery method that will be quick to implement so the user can preview the batch of reports and then print. Similiar to if you were running a report in access.
I have a need to develop a reporting application that has static and
parameterized reports that I want my users to be able to access and retrieve
through a web interface.
I'm trying to find out the standard/preferred way of displaying reports. My
original thought process pointed me towards generating xml files for the
static reports and having standard xsl files to display them.
How should I build the form-submitted report requests using asp? Should I
generate xml from asp and have standard xsls for displaying them? Or should
I iterate through the result recordsets and just build html with
response.write?
Essentially I'm just looking for a high level summary of how ASP reporting
applications should be developed, and I feel confident that I could go from
there.
i want to use crystal reports in asp application
how to do it
and can anybody tell me resources on this
Can i make us of the sql reporting services in asp? If so then how do i make
a call since what i know is that sql reporting services are available as web
services?
is there a way to turn on error messages from the server without having access to the server? When I get an error on my webserver all I get is a page that says "HTTP 500 - Internal Server Error" without giving me any details about the snafu.
View Replies View RelatedI am looking for a way to create reports using ASP pages or some third party component. I am taking a look at crystal enterprise 8, but I am not sure about the licencing etc. I have used this to create a web report, but the 5 user licence seems to restrict you for just having 5 explorer windows open.
I.e. it doesn't seem to be 5 concurrent users and to have more would get very expensive. Has anyone done any reporting with ASP pages? Ideally, using barcharts, pie charts etc.etc.
Has anyone constructed a SOAP request with Classic ASP and sent it to SQL Server Reporting Services to render a report formatted as PDF to a browser and dealt with the SOAP response?
I'm not talking about URL access, but accessing the SSRS web service directly with SOAP passing credentials, parameters, format, etc. There seems to be nothing out there for ASP 3.0 - it's ALL .NET.
i am working on a project and client just decided to use SQL Reporting Services 2000 for reporting but his application is developed in Classic ASP and SQL Server 2000.
how to view parametrized report in classic asp page and i want these paramters to be sent by URL not in report manually.
I am using ASP and I need the ability to make several dozen reports. I get the feeling that trying to produce somewhat attractive-looking reports in HTML and ASP code would not only be hair-splitting, but quite possibly could be impossible as well.
Does anyone know of any software/tool/package that would be compatible with ASP and allow me to retrieve reports from data that is stored in a database and called in the ASP page?
I am building a ASP financial reporting application. Here the user inputs
quarterly financial information. The data obtained is being used for
uploading a separate in-house application. The end-user should be in a
postion to run reports on their own based on the quarterly information they
furnish via the web applciation.
My question here is what is the best way to devleop reports in the asp
applications so that users can view their own report online? Somebody
suggested pure html reports. However, I believe there should be better ones
which would be web based.
I'm having an issue with my Web application. It's deployed
using Crystal Reports 8.0 Developer edition.
I have an RPT file with a relatively large number of
formulas (30+). I did not create this RPT file and I
loathe to change it as I am not very well versed in the
field. I also did not create the ASP to generate reports,
but inherited it too, so I am really speaking from what I
have gathered at looking at the code.
The Report designer wanted a switch to determine if they
should show a certain field as an average or a total.
Instead of making this switch a parameter as I was
expecting them to, they made it a formula, which stumped
me for an hour or so. As the product shipped, this formula
is set equal to false, which means the user always
generates this field in Averages. If the formula is set to
true then the field will be set to Totals.
Now the problem has arisen that there are a large number
of formulas in the Report, and when you use Crystal 8.0
with ASP you must reference the formulas by their index
number as opposed to by the formula name or id. I have no
idea what this formula number would be. Code:
I am trying to setup an error reporting system for our Intranet. We have a
Windows 2000 Server with SQL Server and we have an Exchange Server 5.5. I
need to set it up so I can use CDO mail. I have used CDO before, but have
never set it up to work. I built a small little page with some CDO code on
it, but I get an error when I try to run it. How can I set this up to send
mail from the webserver to people in our facility?
Reading te article about sql injections and sanitizing I found that one of great recommendations is to "Configure error reporting" to do not allow public to read the entire sql statement. How can I do this? Can I do this if I keep my websites on hosting company server?
View Replies View RelatedAny one know if there is any way in asp to create a way to report information on any unclosed recordset instances or unclosed database connections etc...?
View Replies View Related