Eclipse Community Forums: BIRT » Index Cards with different dataset on front and back page

Home » Archived » BIRT » Index Cards with different dataset on front and back page

Index Cards with different dataset on front and back page [message #1067983]

Thu, 11 July 2013 10:26

Eclipse User

Hi,

do you know whether it's possible to print index cards with the results of dataset1 (DS1) only always on the front side (FP) and the results of dataset2 (DS2) only on the back side (BP) of an index card?
The index cards are A6 printed out on A5 paper which then gets cutted in the middle to get two A6 index cards printed with different data on front and back side.

Hope the attached illustration helps to understand my challenge ...

Thank you for any advice.

Regards,
Uwe

Attachment: index_card_double_side.txt
(Size: 0.69KB, Downloaded 346 times)

Re: Index Cards with different dataset on front and back page [message #1068295 is a reply to message #1067983]

Fri, 12 July 2013 18:40

Eclipse User

So, what you'd need is DS1 to print its first two pages worth, then DS2 print its two pages worth, then DS1 print its last page to get what you're wanting? Is this correct?

Re: Index Cards with different dataset on front and back page [message #1086050 is a reply to message #1068295]

Tue, 13 August 2013 14:42

Eclipse User

Sorry for the late response (vacation Smile

). Yes exactly that's what I need DS1 on first two pages then DS2 the next to pages and so on

Re: Index Cards with different dataset on front and back page [message #1086355 is a reply to message #1086050]

Wed, 14 August 2013 01:50

Eclipse User

I would think you could set something up with grouping and maybe some embedded tables. It probably depends on your data. Any way you could attach some sample data and let me know what you'd want where?

Re: Index Cards with different dataset on front and back page [message #1087921 is a reply to message #1086355]

Fri, 16 August 2013 05:32

Eclipse User

Ok I will work on an example and post soon. Thanks a lot.

Re: Index Cards with different dataset on front and back page [message #1091883 is a reply to message #1087921]

Thu, 22 August 2013 00:28

Eclipse User

Let me know if you get stuck and need me to create you a sample that might help.

Re: Index Cards with different dataset on front and back page [message #1093026 is a reply to message #1091883]

Fri, 23 August 2013 09:08

Eclipse User

Hi,

I've got an exmple in the meanwhile, it's based on Oracle's HR schema, see attachment

Front Page, Master Subreport:
department (Master) displays department_id, department_name, manager_name
employees (Subreport) displays employee_id, first_name, last_name

Page Break on departmend_id

Back Page, Master Subreport:
department (Master) location of department on front page
employees (Subreport) displays details of employees on front page like employee_id, email, phone_number, hire_date, salary

Page Break on departmend_id

Thanks a lot.

Regards,
Uwe

Attachment: hr_cre.sql
(Size: 9.49KB, Downloaded 291 times)
Attachment: hr_popul.sql
(Size: 45.56KB, Downloaded 225 times)

Re: Index Cards with different dataset on front and back page [message #1093045 is a reply to message #1093026]

Fri, 23 August 2013 09:45

Eclipse User

So you got it working? Or you're wanting me to use these files for an example? Let me know. Smile

Re: Index Cards with different dataset on front and back page [message #1097246 is a reply to message #1093045]

Thu, 29 August 2013 08:37

Eclipse User

Hi,

I got it working with workaround. I print the front pages into a pdf and the backpages into another pdf. then I use perl PDF::API2 to merge the pages in into the order I want create a booklet and then print it out. I didnt find a better direct way yet.

Regards,
Uwe

Re: Index Cards with different dataset on front and back page [message #1097459 is a reply to message #1097246]

Thu, 29 August 2013 15:07

Eclipse User

Ah. Okay. Let me see if I can get an example for you that might work.

Re: Index Cards with different dataset on front and back page [message #1097500 is a reply to message #1097459]

Thu, 29 August 2013 16:26

Eclipse User

Oh. What is your BIRT version?

Re: Index Cards with different dataset on front and back page [message #1101229 is a reply to message #1097500]

Wed, 04 September 2013 03:10

Eclipse User

Hi,

thanks a lot. It's 4.3.0 the latest one. I'm still in evaluating phase Smile

regards,
Uwe

Re: Index Cards with different dataset on front and back page [message #1102714 is a reply to message #1067983]

Thu, 05 September 2013 22:29

Eclipse User

Take a look at this example. I use embedded tables and filters to show the correct rows. The scripted dataSet determines how many pages there will be based on the rows in each of the individual dataSets. Let me know if you have questions.

Attachment: NoteCardFrontBack.rptdesign
(Size: 74.65KB, Downloaded 324 times)

Re: Index Cards with different dataset on front and back page [message #1103049 is a reply to message #1102714]

Fri, 06 September 2013 06:26

Eclipse User

Hi Michael,
thanks for the great help. I'll look into your example over the weekend. As I'm quite new to BIRT it'll take me some time to understand the design.
Regards,
Uwe

Re: Index Cards with different dataset on front and back page [message #1103346 is a reply to message #1103049]

Fri, 06 September 2013 12:49

Eclipse User

If you have questions, feel free to ask. Smile

Re: Index Cards with different dataset on front and back page [message #1103903 is a reply to message #1103346]

Sat, 07 September 2013 10:11

Eclipse User

Dear Michael,

when I try to open the report design file in RCP Designer I get the errors attached.
Any idea why this happens?

Regards,
Uwe

Attachment: GroupAlwaysStartsOnOddPage.log
(Size: 11.22KB, Downloaded 393 times)

Re: Index Cards with different dataset on front and back page [message #1106060 is a reply to message #1103903]

Tue, 10 September 2013 12:30

Eclipse User

4.3 RCP designer? I'll have to check that out. I created it with the normal 4.3 designer, I believe. I'll let you know. I think I'll have to download the RCP designer.

Re: Index Cards with different dataset on front and back page [message #1106084 is a reply to message #1106060]

Tue, 10 September 2013 13:12

Eclipse User

Hmm. It seems that the file was corrupted, even on my machine. So, I don't have a working version of it again. What I did was I created a scripted dataSet that took the row count from my other two dataSets and determined how many pages each would be. Whichever was largest was how many rows the scripted dataSet had. Two tables from each dataSet (representing the two index cards for each side of the page) were embedded into a two row grid in two separate detail row tables. They were spaced and sized appropriately to fit the page. The tables each had filters to make the appropriate data go to each one based on which table it was and what outer table value it was.

Hope this helps. If I find time to recreate this, I will post it in here again.

Re: Index Cards with different dataset on front and back page [message #1106147 is a reply to message #1067983]

Tue, 10 September 2013 15:18

Eclipse User

Try this. I copied the XML Source to a new design within the RCP designer and it seems to work fine. If this doesn't work copying it in, open the design in notepad or something and copy the xml source into a new design.

Attachment: NoteCards.rptdesign
(Size: 74.39KB, Downloaded 611 times)

Re: Index Cards with different dataset on front and back page [message #1107634 is a reply to message #1106147]

Thu, 12 September 2013 14:11

Eclipse User

Hi Michael,

thanks a lot it really looks good. I got it working. I guess I can forget my fallback solution via perl PDF:API2 postprocessing. I'm looking forward to work with BIRT.

Best regards,
Uwe

Re: Index Cards with different dataset on front and back page [message #1107673 is a reply to message #1107634]

Thu, 12 September 2013 15:27

Eclipse User

Great! Glad I could help! Let us know whenever you have questions! Smile

Previous Topic:	Dealing with empty data cells in BIRT
Next Topic:	Report generation Javascript error

Goto Forum:

-=] Back to Top [=-

Current Time: Sun May 11 02:50:21 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter