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

Popular posts from this blog

How do you change vbulletin's home page to the forums instead of the default (CMS or Activity Stream)? -

c++ - Troubles when compiling phash program -