Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 14:26 Go to next message
Uwe Suckow is currently offline Uwe Suckow
Messages: 15
Registered: July 2013
Junior Member
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
Re: Index Cards with different dataset on front and back page [message #1068295 is a reply to message #1067983] Fri, 12 July 2013 22:40 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

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?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1086050 is a reply to message #1068295] Tue, 13 August 2013 18:42 Go to previous messageGo to next message
Uwe Suckow is currently offline Uwe Suckow
Messages: 15
Registered: July 2013
Junior Member
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 05:50 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

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?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1087921 is a reply to message #1086355] Fri, 16 August 2013 09:32 Go to previous messageGo to next message
Uwe Suckow is currently offline Uwe Suckow
Messages: 15
Registered: July 2013
Junior Member
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 04:28 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

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

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1093026 is a reply to message #1091883] Fri, 23 August 2013 13:08 Go to previous messageGo to next message
Uwe Suckow is currently offline Uwe Suckow
Messages: 15
Registered: July 2013
Junior Member
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 23 times)
  • Attachment: hr_popul.sql
    (Size: 45.56KB, Downloaded 63 times)
Re: Index Cards with different dataset on front and back page [message #1093045 is a reply to message #1093026] Fri, 23 August 2013 13:45 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

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

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1097246 is a reply to message #1093045] Thu, 29 August 2013 12:37 Go to previous messageGo to next message
Uwe Suckow is currently offline Uwe Suckow
Messages: 15
Registered: July 2013
Junior Member
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 19:07 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

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

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1097500 is a reply to message #1097459] Thu, 29 August 2013 20:26 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

Oh. What is your BIRT version?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1101229 is a reply to message #1097500] Wed, 04 September 2013 07:10 Go to previous messageGo to next message
Uwe Suckow is currently offline Uwe Suckow
Messages: 15
Registered: July 2013
Junior Member
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] Fri, 06 September 2013 02:29 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

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.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1103049 is a reply to message #1102714] Fri, 06 September 2013 10:26 Go to previous messageGo to next message
Uwe Suckow is currently offline Uwe Suckow
Messages: 15
Registered: July 2013
Junior Member
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 16:49 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

If you have questions, feel free to ask. Smile

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1103903 is a reply to message #1103346] Sat, 07 September 2013 14:11 Go to previous messageGo to next message
Uwe Suckow is currently offline Uwe Suckow
Messages: 15
Registered: July 2013
Junior Member
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
Re: Index Cards with different dataset on front and back page [message #1106060 is a reply to message #1103903] Tue, 10 September 2013 16:30 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

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.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1106084 is a reply to message #1106060] Tue, 10 September 2013 17:12 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

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.


Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1106147 is a reply to message #1067983] Tue, 10 September 2013 19:18 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

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.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Index Cards with different dataset on front and back page [message #1107634 is a reply to message #1106147] Thu, 12 September 2013 18:11 Go to previous messageGo to next message
Uwe Suckow is currently offline Uwe Suckow
Messages: 15
Registered: July 2013
Junior Member
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 19:27 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1639
Registered: July 2009
Senior Member

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

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:Dealing with empty data cells in BIRT
Next Topic:Report generation Javascript error
Goto Forum:
  


Current Time: Sat Oct 25 04:25:44 GMT 2014

Powered by FUDForum. Page generated in 0.03038 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software