iReport multiple copies of same report with different label -
i using ireport 4.1.3. have created invoice report , want have 3 copies of same invoice report. first invoice should have label "original", second should have "duplicate" , third should have label "triplicate" on it.
thank you.
if show 3 copies every time open report, here creative if not elegant solution.
add cross join clause of query returning 3 different copies. in mysql looks this:
cross join ( select 'original' copy, 1 sequence union select 'duplicate' copy, 2 sequence union select 'triplicate' copy, 3 sequence ) x
then add "copy" field select statement. cause query return 3 records each record returning. 1 record "original" in copy field, 1 "duplicate" , 1 "triplicate". add "sequence" order clause.
then in report, group "copy" field. force new page each group , should set. variables totaling @ report level need change group level ("copy" group). , if have controls in summary section, move them new group footer section. create text field display "copy" field in page or group header.
it's not pretty, should work.
Comments
Post a Comment