I have a SQL database. I want to make the report form using ASP script. In my script, if i click the report button, i want to see the data that print into word document file with 2 or 3 columns. For that case, i 'm trying to export the data from SQL to MS Access datdabase and from Access database, can i merge these data into word document?
View RepliesOk, I currently have an ASP application. In this application, an administrator will need the capacity to print reports of the data stored in a MySQL database.
Let me note now that this is a college project, and I can only basically do what I am allowed to, rather than having full control over the server and making any necessary changes.
The problem is, I don't have permission to write files from my application. How dumb is that? Anyway, I need an alternative way. Are there any ASP PDF converters or any similar that I can query the DB, get the necessary data then present it as a printable document?
A temporary .txt file would have been sufficient, but now that that is ruled out, I need to find another way of doing this.
Can anyone here suggest me a solution to solve my follwoing problem?
1) I got a .aspx page and on that page i got a combo box and a command button.
Combo box displays records from the database.
I wanted to generate a report which is based on the record that user selects from the combo. The report is designed using crystal report correctly and saved in Inetpub
folder... Code:
Is it possible to generate crystal reports using the "Push" method? Can I retrieve data records from a database and then push that information out to a crystal report through an ASP interface?
View Replies View Relatedi am handling a project. front-end asp and back-end ms-access. now my
problem is I want to export a report from ASP to microsoft excel.
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:
View Replies View RelatedI have two questions on exporting data to Excel using ASP (w/o converting
formatted excel file into web page and then plug in the dynamic data):
1. Can we export data into different sheets at Excel?
2. Can we do graph at export?
I want to export data from SQL Server Database to Access Database through ASP code.
Will it be by running some sort of a batch file?The database structure of both the databases are the same, only there are 3 fields more in the SQL Server DB than the ACCESS DB which need not be exported.
I have all my databases in form of Access. But the Client sends it in the form of Excel. I can manually import the contents from the Excel to the Access. I would like to automate this by giving a front end where in I select the Excel file and when I click the upload button the data gets uploaded into the Access table. Can anybody give me an idea how I can do it using ASP?
View Replies View RelatedI retrieve data from the database and display on ASP, then I export these data to a file, like Excel (the best) or text file. Is it possible? I think it is possible, but how can I do that?
View Replies View RelatedI have a DB containing many records of customers' info. How can I pull these data to the MS Word mail merge letters containing the header (name, address, etc) and contents (description 1, 2, 3,...) page by page per record?
View Replies View RelatedDoes anyone know how to export data from an excel spreadsheet, straight into ms sql server database?
View Replies View Relatedhow can i export the result of query in a excel file(.xls) in asp page.
View Replies View Relatedwhen user click a button data will be fetched from database based upon condition and it will be exported to multiple sheets of a single excel work book. what I am doing, onclick of button in main page, I am invoking a new asp page through document.location.href=test.asp.
In test.asp page created a instance of excel.applicaion and then fetching data from backend and putting data to different workbook cells of the the excel and at the end making excel.visible=true but the problem is excel file not getting visible on client machine.
But when I remove some server side code and put the rest of code inside vbscripting tag in the main asp page then the excel file becomes visible on client machine. I am not getting the where the problem lies in the first part .
My asp/sql server application gets an error, but only when you use the
Excel export option:
<% Response.ContentType="application/vnd.ms-excel" %> (very popular w/
users)
I think somebody entered a string of characters that Excel does not
like:
So I believe (but not sure) some character(s) in a Ntext sql server
field "desc_text" is confusing the Excel file and causing it to error
(and crashes Excel)
So far, I have attempted three fixes with no success
1) Tried to convert the data type in the SQL query:
CAST(sr.desc_text AS VARCHAR(255))
2) Tried to convert the data type in the vbscript:
<% desc_text1 = Cstr(rs.fields.item("desc_text").value)%>
3) Tried append an apostrophe to the beginning of the field so that
Excel would not read it as a formula. (this might have worked, but
Excel does not treat an apostrophe the same from an export as it does
if you typed it in directly)
<%response.write "'"%> <% response.write desc_text1%>
Soliciting all ideas!
Also, if you have any ideas on how to isolate and identify the
specific record and character(s) that is causing the error, that would
be great. I have it narrowed down to a record set of 600 records, and
the error occurs if I include beyond the 130th character position. The
problem does not occur if I use CAST(sr.desc_text AS VARCHAR(129))
I am using an HTML form and creating a tabbed text file with the .xls extention.
only problem remaining is when multi-line text area is used the user might press 'return' to create new line in the text area but this also creates a new row in Excel.
what's the best way to replace the 'return' in the form data with the little rectangle that Excel uses to create a carriage return inside a cell?
I use ASP to create reports by interacting with a mySQL database..
View Replies View RelatedI am attempting to use the push model for a crystal report from a asp.net project.
I am having two problems. First when I attempt to use a sql command I am able to create the report but when I attempt to push the data to it I get a login failed error. When I correct this I get the original data that was used to format the report not the modified data that I am attempting to push to it. Code:
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
i want to generate bill for a user which needs to be in pdf format. so, i came across fdf toolkit......but i am not able to understand how to use it....i looked at the 15seconds.com sites.....also but no help. so, if anybody can give a nice tutorial for this, i would be very thankful.
secondly, is it better to use this fdf toolkit or third party pdf generating tools like asp-pdf from persits inc, aspeasy pdf...etc. if yes, then which tools are the best.
my requirements is that the pdf file should be generated from the database and also from the form....both.
Is there any way to generate a pdf document dynamically using ASP?? My client want a letter to be generated in pdf. I am able to generate the letter in rtf. So a method to convert the rtf to pdf is also fine. Is there any way to generate it using a library function or built in object (with out using Third part toolkit). Even if using any object library.
View Replies View RelatedI want to do it with an external stylesheet. I know I could do this using an internal stylesheet and if I can't crack the problem soon, will end up doing so.
Basically, I have a database table with site information, for example the site logo. What I would like to do is something along these lines: Code:
Does anybody know How can I generate Images from ASP?
View Replies View Related.CSV File Generation in ASP Hello, I am able to convert recordset into .csv file and download it. My problem is how I can display message to user that file download complete.
View Replies View RelatedI'm trying to sort a list of 10 people into two groups--RANDOMLY. I've gotten as far as to generate a random number and assign a name to it. I just need to know how to generate 9 more numbers, making sure no numbers/names repeat. Code:
View Replies View RelatedIn a form that is supposed to work online, my user would enter values in say 15 fields. Now when I click "Submit" button, this should create a table at runtime.Next,whenever this button is clicked,this table should be re-generated.
View Replies View RelatedIs there any way to create automatic generation number like, INW001.......INW002.... ans so on without using any code in ms-access using "autonumber" type with default value.
or
Can you give me the code for creating automatic generation of numbers for a column IDNO , using alphanumeric.
Eg: INW001 , Next should be INW002 ,....... INW010 and so on
Can anyone offer advice on how to make session ids not as predictable as usersession = session.sessionid?
View Replies View RelatedHow do I generate an email through outlook? My program now needs to send out an email to an outlook distribution list. Unfortunately, I neither know how to send an email through ASP let alone sending it via Outlook.
View Replies View RelatedWhat's a way to do a: Page generated in X.XXXXXXXXX seconds.
If I have 5 variables "SUB_1, SUB_2, SUB_3, SUB_4, SUB_5" and I assign them values from a SQL2005 database..
SUB_1 =(UPDATE.Fields.Item("SUB_1").Value)
SUB_2 =(UPDATE.Fields.Item("SUB_2").Value)
SUB_3 =(UPDATE.Fields.Item("SUB_3").Value)
SUB_4 =(UPDATE.Fields.Item("SUB_4").Value)
SUB_5 =(UPDATE.Fields.Item("SUB_5").Value)
I have a WHILE LOOP generating a dynamic table from a different database table
Code: ....
Does anyone know a script out there or a component that will generate a PDF file dynamically? I want to make a report from a database available online in PDF....
View Replies View Relatedwhile i'm munching on my thai green chicken soup i wonder if anyone can suggest any good code generator out there for producing asp code from microsoft access tables?
View Replies View Related