How to create a subreport using BIRT Report Designer on ClearQuest v7.1.2

Hi. I am new using BIRT Report Designer on ClearQuest 7.1.2. I am trying to create a report with two(2) subreports in it.

First Dataset I have the Id
Second Dataset I have Id, Project, Status

I want that for example:
Id = 0001

Create a report like
Id 0001

Project ABC
Status Active

Id 0002

Project BCD
Status Closed

I tried several ways using the the table binding without luck. Can any one knows how to create this kind od report using BIRT Report Designer on ClearQuest v7.1.2?

Find more posts tagged with

Comments

juanotero

mwilliams

I responded to your email, as well, but the attachment in here shows me more of what you're already doing. It would appear that you're doing it correctly. What is the issue you're having? What is happening when you run the report with it set up like in your pdf attachment?

juanotero

When I run the report all the records from the second table are tie tho each id in the first table. Is like the parameter binding is not working.

Ex My current report:

Id 001

Project ABC
Status Active
Project BCD
Status Closed

Id 002

Project ABC
Status Active
Project BCD
Status Closed
For each Id the subreport show me ALL the records in the second table, not the records tie with the Id.

Id 001 is tie only for Project ABC

Id 002 is tie only for Project BCD

I want the following results:

Id 001

Project ABC
Status Active

Id 002

Project BCD
Status Closed

mwilliams

Can you attach your actual report design? You might try using a filter to limit the embedded table's data, rather than the parameter binding, if it's not working.

juanotero

Attached the report design. I have a table with a data from the data set SCRInformation, then I added a nested table with data from the data set History. The binding paramenter is the Id on both datasets.

mwilliams

I don't see the .rptdesign attached. All I see is the pdf.

juanotero

Attached the report.

mwilliams

I cannot see your dataSet query or parameter setup because I cannot access your dataSource, but it appears that you've got it set up correctly. I'm not able to reproduce your issue though. Can you try to recreate the issue with the sample database? I also don't have a copy of 2.2.0. I did my test in 2.2.2. If you can reproduce the error with the sample database, I'll download 2.2.0 and test it. As long as you have a dataSet parameter to link to and set the value, as it appears you've done, it should work though. If you cannot get this to work, you can try bringing in the entire result set into your embedded table and just use a filter to limit it, rather than the dataSet parameter.

juanotero

Hi I recreated the report using the database example. I attached the report design.

mwilliams

You needed to have a '?' marker in your query to have a dataSet parameter. Look at the where statement I added into the query for the embedded table. This is where the dataSet parameter binding actually affects the query.

juanotero

Hi I added the filter to the table and that fixed the issue. Thanks a lot.

Now I am facing a new challange. I need to pick the latest date based n the Id. For example

Id 001 Order 001 Date 2012-31-12
Id 001 Order 001 Date 2013-01-01
Id 001 Order 001 Date 2013-01-02
Id 001 Order 001 Date 2013-01-03
Id 001 Order 001 Date 2013-01-04

I have a field called Last Order Date and I want that shows 2013-01-04

I tried the MAX function but I'm not received the expected results.

mwilliams

What are the results you received? If you get the last date from the entire table, rather than just the group, you'll either need to add the dataSet parameter marker to your query's where statement and use the dataSet parameter binding (like in the example above) instead of just the filter.

Or, you could put the same filter criteria on your aggregation as you put on the table. Those are the possibilities I see to solve the issue. Let me know.

juanotero

Hi, I put the same filter criteria on my aggregation as you recommend and now I have the correct data. I appreciate all your support. Thank you so much.

mwilliams

Great! Glad to help! Let us know whenever you have questions!

juanotero

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="113977" data-time="1360175827" data-date="06 February 2013 - 11:37 AM">
Great! Glad to help! Let us know whenever you have questions!

</blockquote>
 
 
Hi Michael, I am trying to figure out the following: In my output report I see the following 
ID 001 2013-06-02 
2013-06-02 
2013-06-02 
2013-06-02 
 
ID 002 2013-04-02 
2013-04-02 
2013-04-02 
2013-04-02 
 
I used the supress duplicates option and I received the following 
 
ID 001 2013-06-02 
(I have this space with blank rows) - Apparently is adding the rows even when they are blank. I want to remove them. 
 
 
ID 002 2013-04-02

mwilliams

Try grouping your table on the date field, and delete the detail row, rather than using the suppress duplicates.

juanotero

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="114037" data-time="1360281601" data-date="07 February 2013 - 05:00 PM">
Try grouping your table on the date field, and delete the detail row, rather than using the suppress duplicates. </blockquote>
 
 
Excellent that works!!! Thanks

mwilliams

Not a problem!

Srikanthbv

Hello EveryOne

I am using IBM ClearQuest version 7.1.2.5, i would like to know the steps are involved in Integrating ClearQuest with BIRT. Can some one provide me steps

I am very new to CQ and BIRT

Best Regards
Srikanth
9880192256

mwilliams

You might look into these pages:

http://pic.dhe.ibm.com/infocenter/cqhelp/v8r0m0/index.jsp?topic=/com.ibm.rational.clearquest.reporting.doc/topics/t_rpt_rd4cq_install_on_birtdsgner.htm

AND

http://pic.dhe.ibm.com/infocenter/cqhelp/v8r0m0/index.jsp?topic=/com.ibm.rational.clearquest.reporting.doc/topics/t_rpt_rl4birt_configlrptdrvr_on_WAS.htm