DEFINE FILE ATTENDANCETRACKING
Class/A20=IF ATTENDANCETRACKING.ATTENDANCETRACKING.ISMAKEUP EQ '0' THEN 'Regular' ELSE 'Makeup';
Lab/A20=IF ATTENDANCETRACKING.ATTENDANCETRACKING.LABIND EQ '1' THEN 'Lab' ELSE 'Class';
END
TABLE FILE WF_RPT_COHORT_ATTENDANCE_TRACKING
PRINT
ATTENDANCETRACKING.TITLE AS 'Title'
ATTENDANCETRACKING.STUDENT AS 'Student Number'
ATTENDANCETRACKING.Married AS 'Lab'
ATTENDANCETRACKING.Class AS 'Class'
ATTENDANCETRACKING.1
ATTENDANCETRACKING.2
ATTENDANCETRACKING.3
ATTENDANCETRACKING.4
ATTENDANCETRACKING.5
ATTENDANCETRACKING.6
ATTENDANCETRACKING.7
ATTENDANCETRACKING.8
ATTENDANCETRACKING.9
ATTENDANCETRACKING.10
ATTENDANCETRACKING.11
BY LOWEST ATTENDANCETRACKING.ISMAKEUP NOPRINT
ON TABLE SUBHEAD
"Attendance Tracking"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
PAGECOLOR='WHITE',
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N1 EQ '1',
$..........( ALL THE FORMATTING STUFF).... $
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR='BLACK',
STYLE=BOLD,
$
ENDSTYLE
END
-* AttendanceSummary.fex
DEFINE FILE ATTENDANCESUMMARY
AttendanceType/A500=IF ATTENDANCESUMMARY.ATTTYPE EQ 'RegularEnrolled' THEN 'Regular Enrolled'
ELSE IF ATTENDANCESUMMARY.ATTTYPE EQ 'MakeupEnrolled' THEN 'Makeup Enrolled'
ELSE IF ATTENDANCESUMMARY.ATTTYPE EQ 'RegularAttended' THEN 'Regular Attended'
ELSE IF ATTENDANCESUMMARY.ATTTYPE EQ 'RegularNoshow' THEN 'Regular No Show'
ELSE IF ATTENDANCESUMMARY.ATTTYPE EQ 'MakeupNoshow' THEN 'Makeup No Show'
ELSE IF ATTENDANCESUMMARY.ATTTYPE EQ 'TotalAttended' THEN 'Total Attended'
ELSE IF ATTENDANCESUMMARY.ATTTYPE EQ 'MakeupAttended' THEN'Makeup Attended'
ELSE 'Opps! Something went wrong, Please contact your system Admin.';
END
TABLE FILE ATTENDANCESUMMARY
PRINT
ATTENDANCESUMMARY.ATTTYPE AS 'Attended Type'
ATTENDANCESUMMARY.1
ATTENDANCESUMMARY.2
ATTENDANCESUMMARY.3
ATTENDANCESUMMARY.4
ATTENDANCESUMMARY.5
ATTENDANCESUMMARY.6
ATTENDANCESUMMARY.7
ATTENDANCESUMMARY.8
ATTENDANCESUMMARY.9
ATTENDANCESUMMARY.10
ATTENDANCESUMMARY.11
ON TABLE SUBHEAD
" Attendance Summary"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=REPORT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$ ..........( ALL THE FORMATTING STUFF).... $
TYPE=REPORT,
COLUMN=N12,
SQUEEZE=0.180556,
$
ENDSTYLE
END
So if ran that Procedure it runs fine and give me this report
But when try to distribute the report via report caster on excel format ( EXL2K) it only distribute it only runs and distributes ATTENDANCE_TRACKING and doesn't distribute ATTENDANCE_TRACKING_SUMMARY (bottom part)
While checking log it shows this :-
Can any one please explain me what I am doing wrong. It been about a week I am trying to troubleshoot this problem got nothing but frustration and its driving me insane.
Thank you in Advance.This message has been edited. Last edited by: Jump_faster,
WebFOCUS 7.7. Windows Server 2008. All Outputs.
WEBFOCUS 7.6.11. Windows Server 2003. All Outputs.
March 15, 2013, 03:09 PM
Prarie
Try adding
ON TABLE SET COMPOUND BYTOC
and In report caster at the bottm of the TASK Tab check Burst Report
March 15, 2013, 03:44 PM
Mighty Max
Did a quick search in the help file for COMPOUND. It says the syntax you are using is for PDF. Something new to me. Anyways try the alternative way by using SET COMPOUND. Remove the compound phrases from the PCHOLDs. Place SET COMPOUND = 'OPEN NOBREAK' and SET COMPOUND = CLOSE before your two table requests.
on my Procedure.Now when I am running the report I am only getting second report, first report doesn't show up at all.
WebFOCUS 7.7. Windows Server 2008. All Outputs.
WEBFOCUS 7.6.11. Windows Server 2003. All Outputs.
March 15, 2013, 03:52 PM
eric.woerle
Jump Faster,
The error message sounds to me like there might be a permission issue with the master file. I would check your app path. When you run the report, are you running it from Developer Studio or from the BID/MRE? It may be that your app path is different from the app path being used by Report Caster. One thing you could do is run the command
APP SHOWPATH
to see what your app path is.
If its an issue with the app path issuing the command
APP PREPENDPATH [APPLICATION NAME]
will place the necessary application first in the app path.
Max,
quote:
Place SET COMPOUND = 'OPEN NOBREAK' and SET COMPOUND = CLOSE before your two table requests.
Jump has those set in the PCHOLD command
quote:
ON TABLE PCHOLD FORMAT EXL2K CLOSE
It will do the same thing. I've done this a number of times on reports. Granted that was in 7.6.7. Things may have changed since then, but I don't think so.
Also Prairie,
The SET COMPOUND BYTOC will seperate each BY statement into its own spreadsheet with an Excel report. I don't think that is the functionality that he is looking for.This message has been edited. Last edited by: eric.woerle,
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
March 21, 2013, 04:32 PM
Jump_faster
Sorry I was on vacation so I couldn't get back to you guys.
Thank you Max for your input.I tried your method but result was not different,I really appreciate your help.
Eric,
I want to really thank you for your detail information and trouble shooting. I try to run the report from both Dev Studio and MRE, report runs fine on both. I dont think we have permission issues because our admin deploys report to the production environment and sets the report caster;its a same person. We have done multiple report caster reports and never had this problem before; this is the first time we are encountering this. I look the app file path with command:-
APP SHOWPATH
And all the needed master file and procedure are on same app folder and file path seems to match.
Here is a screenshot of MRE
I am think about setting up a new domain that runs all our report caster reports, which we have never done before. Any thoughts on that or any thoughts on how to fix this problem.
Thank you all for your help.
CheersThis message has been edited. Last edited by: Jump_faster,
WebFOCUS 7.7. Windows Server 2008. All Outputs.
WEBFOCUS 7.6.11. Windows Server 2003. All Outputs.
March 22, 2013, 12:44 PM
eric.woerle
Jump Faster,
A thought occurred to me while I was looking at your screen shots. Are you bursting this report?
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
March 22, 2013, 01:07 PM
WF8Developer
Jump_faster..same thought as Eric. I can schedule a compound EXL2K. Now the users want to burst. I found this try to mitigate this problem: Release 7.7.02 > ReportCaster > ReportCaster End User's Manual > Tips and Techniques for Coding a ReportCaster Report Manually Coded Excel Compound Reports.....Bursting is not supported with Excel Compound Reports.
Under a separate post today, I have asked for advice mitigating the problem because it seems to whack our reporting server.
and application folder is also already added to Domain.Here is what it looks like:-
Report caster is sending report, but the report has two parts, Class Attendance Tracking and Class Attendance Summary. The problem is that Report Caster only sends Class Attendance Tracking report but fails to send Class Attendance Summary reports.
WebFOCUS 7.7. Windows Server 2008. All Outputs.
WEBFOCUS 7.6.11. Windows Server 2003. All Outputs.
March 22, 2013, 03:51 PM
Tom Flynn
Why are you using DEFINE FILE ATTENDANCETRACKING and then TABLE FILE WF_RPT_COHORT_ATTENDANCE_TRACKING? Even though you are not using the DEFINEd columns... Looks like the incorrect TABLE FILE name... By the code in the TABLE request, looks like you may need ATTENDANCETRACKING for the program to work...
Do this at the top of any fex in the correct DOMAIN: WHENCE WF_RPT_COHORT_ATTENDANCE_TRACKING MASTER -EXIT
This will tell you where the MASTER is, IF, this is the TABLE you are trying to access...
Thank you Tom for your input. The actual name of the report is WF_RPT_COHORT_ATTENDANCE_TRACKING but to make it easier to understand I changed to ATTENDANCETRACKING.