Use 8.0.0.1 to export as Email or find an older version?

tmersinger

I believe I am experiencing similar errors to some other posters, but with no recent entries, I am going to be brave and start a new thread....

I really like the features of this app. but could use some help getting started. I've scheduled a report and can view it fine but can't get it to export.

Initially I configured my report to export and be emailed and I was getting an error that read:
"Value cannot be null
Parameter name:filename"

Which led me to the real problem... the export file is not being created.

So I unchecked the "to email" box in the Export Directory tab, thinking that I could eliminate a layer of functionality, but that leaves me with this more generic error:

"CrystalCMD has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of something, the information you were working on might be lost."

My OS is Windows XP Professional.

What other information can I provide to aid in tracing this?

OR

Should I uninstall 8.0.0.1 and try installing an older version? And if so, where can I get an appropriate older version? (Googling has lead to many a dead download link... grrr...)

Thanks for any help.

kgroff · Site Admin

Can you give me some insights to your schedule so that I can debug?

What is your export name and export type?

tmersinger · Posted: Fri Oct 24, 2008 8:04 am Post subject:

OK, here are some tab-by-tab details:

report is scheduled to run daily (unit=days, value=1), M-F, between 9 and 9:15 AM, allow remote export = false

the main report passes one parameter to a subreport (the parameter "name" column populated automatically - I didn't change any other settings on that tab and I know it's working correctly based on the results in the report view)

login to connection is successful (although I noticed this morning that I had to re-enter the password field, but after that no logon error)

export directory is a folder I stuck on my local hard drive, export name is open_tickets and type and type is rtf, like this: c:DailyReportsopen_tickets.rtf
(I will use dynamic text but left it off to try and sort out the root problem)
email file = false

Didn't use export printer tab

Export email - from and to are filled in with my email address (even though I'm not attempting to email right now), subject and body say "report testing"

And here is the command line
"C:Program FilesGroff AutomationCrystal DeliveryCrystalCMD.exe" "SOURCEREPORT" "R:CrystalRptsWFLHEATOpen_Tickets.rpt" "DISCRETE" "Pm-CallLog.CallID" "" "CONNECTION" "heat" "HEAT" "klr6cJT2WOrE+Ob38RAw3w==" "klr6cJT2WOrE+Ob38RAw3w==" "EXPORTDIRECTORY" "C:DailyReportsopen_tickets.pdf"

Other details:
the source report is created in Crystal XI
the data is pulled from a SQL Server 2005 DB

Did I miss anything?

kgroff · Site Admin

One issue I see is the export name. You say you are exporting as rtf (c:DailyReportsopen_tickets.rtf), but if I look at the command line, the export is C:DailyReportsopen_tickets.pdf I am not sure why those are not the same.

tmersinger · Posted: Fri Oct 24, 2008 12:06 pm Post subject:

Good catch. I was trying different export types to see if maybe just one format was creating issues while others worked. I must've pasted details from two different "trys".

In any case, to double check, I tried it again, making sure I first had matching info:

export dir = C:DailyReportsopen_tickets.rtf
and
command line =
"C:Program FilesGroff AutomationCrystal DeliveryCrystalCMD.exe" "SOURCEREPORT" "R:CrystalRptsWFLHEATOpen_Tickets.rpt" "DISCRETE" "Pm-CallLog.CallID" "" "CONNECTION" "heat" "HEAT" "klr6cJT2WOrE+Ob38RAw3w==" "klr6cJT2WOrE+Ob38RAw3w==" "EXPORTDIRECTORY" "C:DailyReportsopen_tickets.rtf"

This still results in the generic error.

Any ideas on what else I could test or any workstation config. changes I'm missing?

As a side note - I DO have Microsoft .Net Frameworks 1.1, 2.0, 3.0, and 3.5

Does CD version 8.0.0.1 create a process log I could send to you?

tmersinger

I installed version 7.0.7.0 and it works great. Is there a change in system requirements in order to make 8.0 work properly? I just wanted to follow up with this bit of information and pose that question in case it helps at all with debugging your newer version.

Also - can you offer any additional information on the intended use of the remote export option using a trigger file? I set up a trigger file using my report description and it exported immediately - twice in a row in fact - even though the trigger file was added at a time outside of the scheduled export time window. So is it fair to assume that the presence of a trigger file overrides the report's schedule settings? Or is the trigger file intended to work in conjuction with the scheduled export time somehow?

I also noticed that the trigger file was deleted after the exports executed. So... in a possible different line of thought... does that mean the trigger file is kind of a "1 shot deal" and I have to add the .tgr files into the selected folder every time I wish to use that feature? If that's true, could I schedule a batch file to create those file names in my chosen directory and use that to control the scheduled export time instead of the settings on the schedule tab?

Thanks for any additional info, this is a great feature and I'm interested in exploring how to use it.

kgroff · Site Admin

Versions 7 & 8 are based upon different development code. V7 used .Net 2005 with Crystal Reports Developer and V8 uses .Net 2008 with the included Crystal Reports .Net.

The trigger files are a one-shot deal and they are not tied to any scheduling limitations such as time or day. The development framework I had in mind was utilizing it as a remote admin tool. I would send a .tgr attachment to my email address which could then be saved to the trigger folder using the email rules in Outlook.

tmersinger · Posted: Mon Nov 17, 2008 2:42 pm Post subject:

Thanks for the insight on the trigger file option. I have had success using this option but I continue to see that the export is being created twice (within the same minute, according to the timestamp) and I am receiving the same email twice. I was wondering if this could be because the "monitoring" or "polling" process works so quickly that it finds the .tgr file a second time before the .tgr is deleted? If not, is there something else I could try to prevent the duplicates?

A different question - is there some setting or registry edit I can try to get CD to always open with the Delivery Mode set to Auto? I can successfully use a scheduled task to launch the app, but it always opens into Manual delivery mode so the scheduled reports won't execute without my intervention to switch the mode.

Thanks!

kgroff · Site Admin

I have not experienced the duplication effect in my testing but I will look into it.

The option to open in auto mode already exists. Under the Options menu, check the Auto Deliver on Start option.