$V{pid}.setValue($F{PID});
$F{PID}=$V{pid}.getValue() ? " " : $F{DATE_OFF_SYS_TRIP}


пытаюсь записать в переменную пид, затем сравнить со следующим приходящим пидом
если равны, то оставлять строку пустым, а иначе записать дату


Errors compiling D:\act.jasper!
Compilation*exceptions:*com.jaspersoft.ireport.designer.compiler.ErrorsCollector@223f9b net.sf.jasperreports.engine.JRException:*Errors*were*encountered*when*compiling*report*expressions*class*file: org.codehaus.groovy.control.MultipleCompilationErrorsException:*startup*failed,*calculator_act_1347001368169_815981:*216:* class*org.codehaus.groovy.ast.expr.CastExpression,*with*its*value*'(java.math.BigDecimal)*field_PID.getValue()',*is*a*bad*expression*as*the*left*hand*side*of*an*assignment*operator*at*line:*216*column:*45.*File:*calculator_act_1347001368169_815981*@*line*216,*column*45. 1*error ****at*net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:101) ****at*net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:188) ****at*net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215) ****at*net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:131) ****at*com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:514) ****at*org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) ****at*org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused*by:*org.codehaus.groovy.control.MultipleCompilationErrorsException:*startup*failed,*calculator_act_1347001368169_815981:*216:* class*org.codehaus.groovy.ast.expr.CastExpression,*with*its*value*'(java.math.BigDecimal)*field_PID.getValue()',*is*a*bad*expression*as*the*left*hand*side*of*an*assignment*operator*at*line:*216*column:*45.*File:*calculator_act_1347001368169_815981*@*line*216,*column*45. 1*error ****at*org.codehaus.groovy.control.ErrorCollector.failIfErrors(ErrorCollector.java:296) ****at*org.codehaus.groovy.control.CompilationUnit.applyToSourceUnits(CompilationUnit.java:787) ****at*org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:438) ****at*net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:97) ****...*6*more
Compilation running time: 33!


помогите пжл, первый раз делаю отчет в jasperrepots

у меня так написано
$V{pid}.setValue($F{PID});
$F{PID}==$V{pid}.getValue() ? " " : $F{DATE_OFF_SYS_TRIP}
опечатка была

$V{pid}=$F{PID};
$F{PID}==$V{pid}.getValue() ? " " : $F{DATE_OFF_SYS_TRIP}

так тоже работает

у меня так написано
$V{pid}.setValue($F{PID});
$F{PID}==$V{pid}.getValue() ? " " : $F{DATE_OFF_SYS_TRIP}
опечатка была

$V{pid}=$F{PID};
$F{PID}==$V{pid}.getValue() ? " " : $F{DATE_OFF_SYS_TRIP}

так тоже не работает

сорри, за опечтаку

^{Errors compiling D:\act.jasper!
Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@223f9b net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: org.codehaus.groovy.control.MultipleCompilationErrorsException:*startup*failed,*calculator_act_1347001368169_815981: 216: class org.codehaus.groovy.ast.expr.CastExpression, with its value '(java.math.BigDecimal) field_PID.getValue()', is a bad expression as the left hand side of an assignment operator
at line:216 column: 45. File: calculator_act_1347001368169_815981 @ line 216, column 45. 1 error
at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:101)
at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:188)
at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215)
at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:131)
at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:514)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed, calculator_act_1347001368169_815981: 216: class org.codehaus.groovy.ast.expr.CastExpression, with its value '(java.math.BigDecimal) field_PID.getValue()', is a bad expression as the left hand side of an assignment operator at line: 216 column: 45. File: calculator_act_1347001368169_815981 @ line 216, column 45. 1 error
at org.codehaus.groovy.control.ErrorCollector.failIfErrors(ErrorCollector.java:296)
at org.codehaus.groovy.control.CompilationUnit.applyToSourceUnits(CompilationUnit.java:787)
at org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:438)
at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:97) ****...*6*more
Compilation running time: 33!}

$V{pid} - тип BigDecimal
$F{PID} - тип BigDecimal
" " - String
$F{DATE_OFF_SYS_TRIP} - String

Blazkowiczdavy johnsat line:216 column: 45. File: calculator_act_1347001368169_815981 @ line 216, column 45. 1 error

И 216я строка эта которая из двух? 45й символ какой? ИЛи это координаты в уже скомпилированом шаблоне и здесь смысла не имеют?

davy johns$V{pid} - тип BigDecimal
$F{PID} - тип BigDecimal
" " - String
$F{DATE_OFF_SYS_TRIP} - String
Т.е. переменной типа BigDecimal (число) вы хотите присвоить строку (пробел!) или какую-то другую строку (дата?)
Как оно вам должно пробел в число преобразовать?


$V{pid}=$F{PID} - я BigDecimal присавиваю BigDecimal


$F{PID}==$V{pid} тут BigDecimal сравниваю с BigDecimal

? " " : $F{DATE_OFF_SYS_TRIP} -
то " " , а иначе $F{DATE_OFF_SYS_TRIP}

первый раз пришел пид надо вывести дату, второй раз если приходит тот же пид, то надо вывести пробел, а иначе дату

sanBez,

нет, пид не вывожу в самом отчете, он приходит для того, чтобы сортировать, и решить выводить дату или нет

select
a.name_group,
a.date_off_sys_trip,
a.date_fact_on_sys_trip,
a.all_time,
a.Note_Sys_Trip,
a.name,
a.adr,
a.date_1,
a.org_name,
a.id_org,
a.pid
from (select trunc(t.date_fact_on_sys_trip) as date_1,
p.pid as pid,
fGetAdrString(r.adr) as adr,
g.name as org_name,
g.ext_id as id_org,
(decode(r.name_group, null, ' ', ' ' || r.name_group)) as name_group,

(decode(t.date_off_sys_trip,
null,
' ',
decode(to_char(t.date_off_sys_trip, 'DD.MM.YYYY HH24'),
null,
' ',
to_char(t.date_off_sys_trip, 'DD.MM.YYYY HH24') || 'ч.') ||
decode(to_char(t.date_off_sys_trip, 'DD.MM.YYYY HH24'),
null,
' ',
to_char(t.date_off_sys_trip, 'mi') || 'мин.'))) as date_off_sys_trip,

(decode(t.date_fact_on_sys_trip,
null,
' ',
decode(to_char(t.date_fact_on_sys_trip,
'DD.MM.YYYY HH24'),
null,
' ',
to_char(t.date_fact_on_sys_trip,
'DD.MM.YYYY HH24') || 'ч.') ||
decode(to_char(t.date_fact_on_sys_trip,
'DD.MM.YYYY HH24'),
null,
' ',
to_char(t.date_fact_on_sys_trip, 'mi') || 'мин.'))) as date_fact_on_sys_trip,

decode(t.date_fact_on_sys_trip - t.date_off_sys_trip,
null,
' ',
decode(round((t.date_fact_on_sys_trip -
t.date_off_sys_trip) * 24),
0,
' ',
round((t.date_fact_on_sys_trip -
t.date_off_sys_trip) * 24) || ' ч. ') ||
decode(mod(round((t.date_fact_on_sys_trip -
t.date_off_sys_trip) * 24 * 60),
60),
0,
' ',
mod(round((t.date_fact_on_sys_trip -
t.date_off_sys_trip) * 24 * 60),
60) || ' мин. ')) as all_time,
(decode(t.Note_Sys_Trip, null, ' ', ' ' || t.Note_Sys_Trip)) as Note_Sys_Trip,
(decode(f.name, null, ' ', ' ' || f.name)) as name
from do_proc_sys_tripping_1 t,
ref_group_address r,
ref_providers f,
do_journal_proc p,
do_list_value l,
do_orgs g
where t.pid = p.pid
and g.ext_id = r.uk_group
and t.group_address = l.list_id
and l.list_value = r.group_address_id
and f.provider_id = t.provider_sys_trip

union
select trunc(e.date_fact_on_emer_trip) as date_1,
p.pid as pid,
fGetAdrString(r.adr) as adr,
g.name as org_name,
g.ext_id as id_org,
(decode(r.name_group, null, ' ', ' ' || r.name_group)) as name_group,

(decode(e.date_off_emer_trip,
null,
' ',
decode(to_char(e.date_off_emer_trip, 'DD.MM.YYYY HH24'),
null,
' ',
to_char(e.date_off_emer_trip, 'DD.MM.YYYY HH24') || 'ч.') ||
decode(to_char(e.date_off_emer_trip, 'DD.MM.YYYY HH24'),
null,
' ',
to_char(e.date_off_emer_trip, 'mi') || 'мин.'))) as date_off_sys_trip,

(decode(e.date_fact_on_emer_trip,
null,
' ',
decode(to_char(e.date_fact_on_emer_trip,
'DD.MM.YYYY HH24'),
null,
' ',
to_char(e.date_fact_on_emer_trip,
'DD.MM.YYYY HH24') || 'ч.') ||
decode(to_char(e.date_fact_on_emer_trip,
'DD.MM.YYYY HH24'),
null,
' ',
to_char(e.date_fact_on_emer_trip, 'mi') ||
'мин.'))) as date_fact_on_sys_trip,

decode(e.date_fact_on_emer_trip - e.date_off_emer_trip,
null,
' ',
decode(round((e.date_fact_on_emer_trip -
e.date_off_emer_trip) * 24),
0,
' ',
round((e.date_fact_on_emer_trip -
e.date_off_emer_trip) * 24) || ' ч. ') ||
decode(mod(round((e.date_fact_on_emer_trip -
e.date_off_emer_trip) * 24 * 60),
60),
0,
' ',
mod(round((e.date_fact_on_emer_trip -
e.date_off_emer_trip) * 24 * 60),
60) || ' мин. ')) as all_time,
(decode(e.note_emer_trip, null, ' ', ' ' || e.note_emer_trip)) as Note_Sys_Trip,
(decode(f.name, null, ' ', ' ' || f.name)) as name
from do_proc_emer_tripping_1 e,
ref_group_address r,
ref_providers f,
do_journal_proc p,
do_list_value l,
do_orgs g
where e.pid = p.pid
and g.ext_id = r.uk_group
and e.group_address= l.list_id
and l.list_value = r.group_address_id
and f.provider_id = e.provider_emer_trip) a
where ($P{org_id} = '-1' or a.id_org=$P{org_id}) and a.date_1 between trunc(to_date($P{Dat1}, 'dd.mm.rrrr')) and
trunc(to_date($P{Dat2}, 'dd.mm.rrrr'))

вот мой запросик

вот бьолее четкий вид

мне нужно сохранить текущее значение пида в переменную и сравнить его с последующими пидами)
может меня не так поняли

оператор присваивание не поддерживается в jasper'e как я понял, или поддерживается?

Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@1dd6ab4 net.sf.jasperreports.engine.JRException:

Too many groovy classes were generated. Please make sure that you don't use Groovy features such as closures
that are not supported by this report compiler.
at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:114)
at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:188)
at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215)
at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:131)
atcom.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:514)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)

davy johnsCompilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@1dd6ab4 net.sf.jasperreports.engine.JRException:

Too many groovy classes were generated. Please make sure that you don't use Groovy features such as closures
that are not supported by this report compiler.
at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:114)
at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:188)
at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215)
at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:131)
atcom.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:514)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)

$V{pid}.setValue($F{PID});
$F{PID}==$V{pid}?" ":$F{DATE_OFF_SYS_TRIP}