You’re offline. This is a read only version of the page.
130
We've got an issue where the head of accounting sends reports to multiple recipients. Each recipient receives different info based upon their security clearance. The report is being emailed just fine as an .xls file to most of the recipients. However, we had 3 people this time where the system tried to email a .tmp file instead of a .xls file. Our SPAM filter won't let a .tmp file through. We've tried all the usual FRx fixes (compacting the db, forcing a recompile, etc...). Nothing seems to be helping. Has anyone seen anything like this? We're on FRx 6.7 with the latest service pack, and our email agent is Microsoft Outlook 2003. Thank you!
*This post is locked for comments
Glad you got it resolved. Thanks for the follow up.
I think I may have figured this one out. The resolution was to check mark the option to "Export Formulas" on the Output Options tab. There are multiple segments that are producing divide by zero errors in Excel. By un-checking that box, it tells Excel it must resolve those errors before completing the transform. If you check it, it allows Excel to simply display the error message if it can't resolve it. Also, I also found the file that tells where the user's working directory is for FRx and told him he needs to delete it periodically. It was full of old FRx temp files.
This file holds the location of the working directory:
c:\Documents and Settings\[username]\Local Settings\Application Data\FRx Software\FRx 6.7\FRX.INI
This is the location of the working directory (that user needs to delete routinely)
c:\Documents and Settings\[username]\Local Settings\Temp
One other point to note on this issue:
If I rename the .tmp to .xls, it's garbage. However, if I rename the .tmp to .frd, I can indeed open it in the FRx Drill Down Viewer. Isn't that weird? I have read several places that you should only use the DDV for drill-through reports, but we have lots of other drill-through reports that work fine in the Excel format.
We thought that, too, but it shows as a .tmp in his Sent Items in Outlook. Yes, all of the recipients are on the same email server with the same settings. We had read that if the report was too large and ran out of "space" while being created that this could occur. So, we made very sure that the user had emptied his temp files and cleaned up C:/ just in case. That didn't help. This is a drill-through report and I read that you're not supposed to send drill-through reports as .XLS but rather as .FRD. However, he tells me other drill-through reports are being emailed out fine.
Hi,
It could be that the tmp file is a place holder for the XLS file and it's actually the XLS file that isn't being allowed through by your email security. Are all of your recipients on the same email server with the same settings?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (