Create/Print Form data

**Rebelle** · Rebelle, December 4th, 2008 04:27 PM

Ok, this post could go here but probably somewhere else….what I want to know what is the best way to do the following…..

I have a web form users fill in and upload files…when submitted this go to database/server. Currently, they can search the records in the database but no form output for a record. I want to know what is the best tool/way to create/print out the form data in a form report output?

I have crystal reports 8.5 on my server but never have had to use it. Although a few years ago, I use to create the layout of the reports but just sent them to someone else to place on the server/connect.

Would crystal reports be the best option? Or is there something else I should use? I've exported to data to excel before..using Response.ContentType = "application/vnd.ms-excel"...wonder if its ok to use this with word?

**Rebelle** · Rebelle, December 5th, 2008 05:20 PM

Ok...I started on something but not sure I'm heading in the right direction....I tried to use : Response.ContentType = "application/vnd.ms-word" but didn't know how/where to place it and have it come up...so I started on an asp page that layouts out the form data in a more form like looking document...but only thing is when I print it, it prints the page name at the top and the url info/date at the bottom, anyway to not have this print? when i'm viewing the asp page in IE, I just hit the IE printer button.

**jmurrayhead** · jmurrayhead, December 5th, 2008 05:57 PM

What would be best to use depends on the requirement. Crystal Reports allows you to do things like graphs, charts, export to desired file, etc.

If you don't need any of this, then it may be better to export to Word, Excel or another file type.

You need to make this decision first.

**Rebelle** · Rebelle, December 8th, 2008 03:50 PM

Hiya JMH,

Okie dokie, think I'm going to just try the export to word, using:

Response.ContentType = "application/vnd.ms-word"

I'll give it a try again...I have a file but need to test it..and hope it works. will let ya know.

Thankies!

**Rebelle** · Rebelle, December 9th, 2008 05:11 PM

hey,

is export to word the same as excel? using the

Response.ContentType = "application/vnd.ms-word"

for some reason, if get my prompt, do you want to export? then click ok to open or save to save file...but keeps trying to come across as ...

MyForm.asp?FormID="122"....instead of MyForm.doc?FormID="122"...I know I had this issue with excel before but I've checked those issues so its not any of those.

**Rebelle** · Rebelle, December 10th, 2008 10:25 AM

Got it!

didn't think i need the extra line because i don't use one for excel...but looks like that was the trick.

needed line in blue:

Code:

<%
Response.ContentType = "application/vnd.ms-word"
Response.AddHeader "Content-Disposition","inline;filename=Myword.doc"
%>

Thread: Create/Print Form data

LinkBack

Thread Tools

Display

Create/Print Form data

Similar Threads

print option

print problem

The data source 'ObjectDataSource1' does not support sorting with IEnumerable data

Print out data on a letterhead format

Maintaining Form Data after forms authentication timeout

Bookmarks

Bookmarks

Posting Permissions