Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
EV4 Hosted - Crash when saving to Excel, CSV and Dif
Are you saving to your local hard drive? When I do that (I'm running on Citrix also)it crashes. I have to save as csv or xls to the I: drive, then open an explorer window and copy the file and paste it into my hard drive. VERY annoying, but it seems to be the only way to do it.- jazcastle
- Post #2
- Forum: Strategic Reporting Systems(SRS): ReportSmith
-
Need Help - Dividing 2 derived fields
Nevermind! I got it - it was crashing since it was trying to divide zeros for some people, i guess. I nested it in a case statement: CASE WHEN (TO_NUMBER(NVL( (SELECT SUM("PS_AL_CHK_HRS_ERN"."EARNINGS") FROM "PS_AL_CHK_HRS_ERN" WHERE ((("PS_AL_CHK_HRS_ERN"."CHECK_DT" BETWEEN <<BeginDate...- jazcastle
- Post #2
- Forum: Strategic Reporting Systems(SRS): ReportSmith
-
Need Help - Dividing 2 derived fields
I am trying to get an average of money paid over a number of checks that had certain earnings codes. So I added the sum of the earnings as one derived field and the the count of the check numbers that meet the critera as the other derived field. They work just fine alone but I want to divide...- jazcastle
- Thread
- Replies: 1
- Forum: Strategic Reporting Systems(SRS): ReportSmith
