I having this wired problem with report caster.

Here is my code for the report.

 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,

Try adding

ON TABLE SET COMPOUND BYTOC

and In report caster at the bottm of the TASK Tab check Burst Report

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.

quote:

ON TABLE SET COMPOUND BYTOC

Thank you for fast respond Prarie, I added

ON TABLE SET COMPOUND BYTOC  

on my Procedure.Now when I am running the report I am only getting second report, first report doesn't show up at all.

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,

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.

Cheers

This message has been edited. Last edited by: Jump_faster,

Jump Faster,

A thought occurred to me while I was looking at your screen shots. Are you bursting this report?

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.

Eric and PScott.

I am not Bursting this report it is just one report that is delivers to 3 client via email.

Two thing for you to try.
1. Add APP PATH to the beginning of your fex. Add the application folders where the master files are located.

 APP PATH appfldr1 appfldr2

2. Right click the Domain folder and select Properties. Add the application folders to path of the Domain folder.

Thanks Max for your input,
I have already tried:-

 APP SHOWPATH 

and

 APP PATH 

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.

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...

hth...

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.

I added

 WHENCE WF_RPT_COHORT_ATTENDANCE_TRACKING MASTER
-EXIT 

on the top of fex.

This is the file path I got.

 C:\ibi\apps\attendancetracking\attendancetracking.mas 

Do this: TABLE FILE ATTENDANCETRACKING
instead of: TABLE FILE WF_RPT_COHORT_ATTENDANCE_TRACKING

It look like its a error because I was using IE-10 to setup report-caster. Followed same exact steps on the IE 9 and it worked.

Looks like its has something to do with

IOException

which is the JAVA error.

It might me error on my IE-10 setup or might be error for everyone using IE-10.