rlesmoore

I have a main report and one subreport that work fine in iReports however I cannot make the correct connection between the two in the Repository. The JasperServer Ultimate Guide says to append the string 'repo:' to the resource's URI in the repository. Could someone give an example of exactly where this append should appear? Thanks

When I specify an input parameter to have multiple values, I get the message jsexception.unknown.parameter.type.for.multiple.value.input. I currently have a java.lang.String. What should it be instead of String?

I have a crosstab with the same items for rows and columns and a total column for each row. I would like to add a new total column (Total2) that is the same as the previous total column (Total) except to exclude the count where the row item equals the column item. I can't figure out the Expression to use for this calculation. Any ideas are appreciated? For example a b c d e Total Total2 a 1 2 3 4 5 15 14 b 1 2 3 4 5 15 13 c 1 2 3 4 5 15 12 d 1 2 3 4 5 15 11 e 1 2 3 4 5 15 10

Excellent - apparently it doesn't understand an sql alias. Thanks so much. Les

The following SQL code results in error "ENROLL_STUDENT_KEY: Invalid Identifier". Moving the WHERE statements around indicates that the WHERE clause is not allowed at all. This makes iReports rather unusable for most reporting. Any help is appreciated. Les Code:SELECT DTBL_STUDENT."DISTRICT_CODE" AS STU_DISTRICT_CODE, DTBL_STUDENT."STUDENT_KEY" AS STU_STUDENT_KEY, FTBL_ENROLLMENTS."STUDENT_KEY" AS ENROLL_STUDENT_KEYFROM "K12INTEL_DW"."DTBL_STUDENTS" DTBL_STUDENT, "K12INTEL_DW"."FTBL_ENROLLMENTS" FTBL_ENROLLMENTSWHERE STU_DISTRICT_CODE='2082' AND STU_STUDENT_KEY=ENROLL_STUDENT_KEY

Doesn't the magnification capability provide the solution to this problem?

I am a brand new iReport user and beginning with release 3.7.4. When trying to use the Report Query I am running into the following problems: 1) When using the Filter Expression I can only enter one condition. For example I want to filter on two different fields such as district_code=xxx and grade_level=yy. I can actually enter both of these conditions but the XML that is generated produces errors. 2) When I create a new Filter Expression or Sort Option, neither of them show in the top display window. To see what I have set I either need to go back into these options or look in the XML. 3) I am accessing an Oracle database with very long field names. When using the Query Designer it cuts off the field names requiring me to rename most of the fields. Item 1) is the most serious and a real stumbling block for me. Thanks for any help, Les