PDA

Click to See Complete Forum and Search --> : Saving report as *.doc


cid
Oct 20th, 2003, 12:28 PM
How do you save a report as a *.doc so it can be viewed later by a person without crystal reports 8.5. I know that Seagate(CR) offers a *.dll that will do it for you but I dont know how to use it.
The *.dll is called: crxf_wordw.dll
You can dowload the file here:
http://support.crystaldecisions.com/communityCS/FilesAndUpdates/crxf_wordw.zip
Please help me...

Ken Bradford
Oct 22nd, 2003, 08:41 AM
Are you asking how you can convert a report from the full crystal reports program or how to have a stand alone vb app on the user pc to it?

cid
Oct 22nd, 2003, 11:46 AM
Im asking how to save a full blown report (created with CR 8.5) as a word document(*.doc) through vb. I am wondering if that *.dll(posted above) could help. And if so how do you use it.

Ken Bradford
Oct 22nd, 2003, 11:56 AM
This may help

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/scr_vb_rdc_export.exe.asp

cid
Oct 22nd, 2003, 02:27 PM
That example is pretty tough to understand is there anything else closer to a newbie level. That example does everything I need it to but...Its a little over my head. Maybe if you could give me a simpler version I will find it more useful.

Ken Bradford
Oct 22nd, 2003, 05:21 PM
None of my apps export reports. If a user wants to export one, they use the built in export method that comes with the crystal viewer and ocx.

Since you say you are a new to this, you might not know that you can export from any crystal report displayed either by the ocx or rdc method by clicking on the white envelope on the top left corner of the report.

cid
Oct 23rd, 2003, 08:35 AM
The report is built into a vb app. So the only time the user sees the report is when the report is in print preview. And in print preview there isnt a white envelope. Ill try to mess with the source you gave me. By the way do you know how to filter a Report?

Ken Bradford
Oct 23rd, 2003, 09:50 AM
So you are using the viewer?


If so, you need to enable the export button

CRViewer1.EnableExportButton = True

cid
Oct 23rd, 2003, 02:45 PM
Is their a way to call that button over another form. So when I click on a menu item it will run that button only (the envelope button; so it will export a report) and not the viewer. And if you have time will you take a look at this post...
http://www.vbforums.com/showthread.php?s=&threadid=262891

Ken Bradford
Oct 24th, 2003, 07:29 AM
Is their a way to call that button over another form. So when I click on a menu item it will run that button only (the envelope button; so it will export a report) and not the viewer.

Not that I know of.

Why do you have to export to a .doc?

From the other post


your detention date is actually a MEMO field


You need to change this field in your database to a date type.

cid
Oct 24th, 2003, 10:00 AM
I know about the memo field I changed it a while ago. If you want to click a command button via another form just change the private to public.
Public Sub Command1_Click()
I will post my updated project so you can take a look at it.

Ken Bradford
Oct 24th, 2003, 11:25 AM
I look at the ld.mdb. All your fields are text, size 50.

If id is a number, you should make it long integer.

Detention Date stills needs to be a date.

ddivers
Oct 25th, 2003, 08:27 AM
Your crystal reports code has a destination property that can be set to File. Once you set it to file, set the export type, and the destination file name. Then when you do .PrintReport it will export it to that destination.