Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Detail records in Master-Detail report do not change(Detail records in Master-Detail report do not change when Master Record does)
Detail records in Master-Detail report do not change [message #870617] Wed, 09 May 2012 05:25 Go to next message
Jeff Stouse is currently offline Jeff Stouse
Messages: 13
Registered: May 2012
Junior Member
(I posted this in the Newcomers section, but no answers - as a first-timer, I think it belongs better in this forum- please forgive the cross-posting.)

Eclipse 3.6.2

The purpose of the report is to list all matters that are in litigation, and any associated note records for each matter.

I inserted a Grid and then inserted master record fields from my first data set - using a query from the Matter table.

Then, I inserted a table in one of the detail rows of the same Grid. (to hold the detail Note records.)

In that table, I inserted one field (memo field) from the detail records coming from the second data set - a query from the Notes table. In that query, I used a ? in the Where clause to be used to link to the key field in the Matter table (the key field in both tables - Matter and Notes - is the Matno (MatterNumber) field.)

I then created a DSP parameter (Data Set Parameter)on the Detail table - and provided a default value ('2012-101') to test the query. The query returns the appropriate number of detail records for whatever default value I provide the parameter.

I then bound the DSP_MatNo parameter to the MatNo row in the Available Column Bindings (Matter table) -
the expression is: row["MatNo"].

Now, when I preview the report, I see the correct Matter records. There are the correct number of Notes (detail) records under each Matter (Master) records, but the detail records are always the first detail record, and then that same detail record is repeated as many times as there are detail (Notes) records for each Matter record.

For example, if there are four matter records:

Matter No
2012-097
2012-098
2012-099
2012-101

And for each matter record there are a different number of detail records:

Matter No Note records
2012-097 1
2012-098 2
2012-099 2
2012-101 4

Then those same number of note record memos will appear-but if there is more than one record, the same memo is repeated the correct number of times.

So, the link between the two tables has to be working - to some degree - but I cannot get the correct detail records to be displayed.

I'm sure this is something stupidly simple, but I cannot figure it out.

Please help.

Thanks,




Re: Detail records in Master-Detail report do not change [message #870809 is a reply to message #870617] Wed, 09 May 2012 18:33 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Jeff,

Can you post the report? BTW is the outer table a table item or a grid
item?

Jason

On 5/9/2012 1:26 AM, Jeff Stouse wrote:
> (I posted this in the Newcomers section, but no answers - as a
> first-timer, I think it belongs better in this forum- please forgive the
> cross-posting.)
>
> Eclipse 3.6.2
>
> The purpose of the report is to list all matters that are in litigation,
> and any associated note records for each matter.
>
> I inserted a Grid and then inserted master record fields from my first
> data set - using a query from the Matter table.
>
> Then, I inserted a table in one of the detail rows of the same Grid. (to
> hold the detail Note records.)
>
> In that table, I inserted one field (memo field) from the detail records
> coming from the second data set - a query from the Notes table. In that
> query, I used a ? in the Where clause to be used to link to the key
> field in the Matter table (the key field in both tables - Matter and
> Notes - is the Matno (MatterNumber) field.)
>
> I then created a DSP parameter (Data Set Parameter)on the Detail table -
> and provided a default value ('2012-101') to test the query. The query
> returns the appropriate number of detail records for whatever default
> value I provide the parameter.
>
> I then bound the DSP_MatNo parameter to the MatNo row in the Available
> Column Bindings (Matter table) - the expression is: row["MatNo"].
>
> Now, when I preview the report, I see the correct Matter records. There
> are the correct number of Notes (detail) records under each Matter
> (Master) records, but the detail records are always the first detail
> record, and then that same detail record is repeated as many times as
> there are detail (Notes) records for each Matter record.
> For example, if there are four matter records:
>
> Matter No
> 2012-097
> 2012-098
> 2012-099
> 2012-101
>
> And for each matter record there are a different number of detail records:
>
> Matter No Note records
> 2012-097 1
> 2012-098 2
> 2012-099 2 2012-101 4
> Then those same number of note record memos will appear-but if there is
> more than one record, the same memo is repeated the correct number of
> times.
>
> So, the link between the two tables has to be working - to some degree -
> but I cannot get the correct detail records to be displayed.
>
> I'm sure this is something stupidly simple, but I cannot figure it out.
>
> Please help.
>
> Thanks,
>
>
>
>
>
Re: Detail records in Master-Detail report do not change [message #870860 is a reply to message #870809] Thu, 10 May 2012 03:22 Go to previous messageGo to next message
Jeff Stouse is currently offline Jeff Stouse
Messages: 13
Registered: May 2012
Junior Member
Jason,

Thanks for replying. The outer table is a grid. The detail data is in a detail row, in a table (but only uses one field.)

When you say, post the report, I'm not sure what you mean. I've added the rptdesign file - is that what you want?

If not, let me know.

Thanks again.
Re: Detail records in Master-Detail report do not change [message #871072 is a reply to message #870860] Thu, 10 May 2012 17:13 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Jeff,

I believe your issue is that the outer table is a List and you have your
nested table in the list footer which is only getting executed once.
Select the list detail row and using a right click insert a new detail
row. Move your nested table to the new detail row and try that.

Jason

On 5/9/2012 11:22 PM, Jeff Stouse wrote:
> Jason,
>
> Thanks for replying. The outer table is a grid. The detail data is in a detail row, in a table (but only uses one field.)
>
> When you say, post the report, I'm not sure what you mean. I've added the rptdesign file - is that what you want?
>
> If not, let me know.
>
> Thanks again.
Re: Detail records in Master-Detail report do not change [message #871089 is a reply to message #871072] Thu, 10 May 2012 19:24 Go to previous messageGo to next message
Jeff Stouse is currently offline Jeff Stouse
Messages: 13
Registered: May 2012
Junior Member
Jason,

I tried moving the detail table above the caption and immediately below the Brief Facts row - no luck. I agree that something is making the program not bring in the data from the other records - even though it is making the correct number of detail records - just copying the data.
Is there some sort of buffer that holds the data that can be emptied?

Jeff
Re: Detail records in Master-Detail report do not change [message #871091 is a reply to message #871089] Thu, 10 May 2012 19:37 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Did you move it to a detail row of the outer list? As a test copy the
report and delete the contents on the canvas, leaving the data sets and
source. Drag the outer table data set to the canvas and delete all
columns but two. In the second columns detail row delete the data item
and drag your inner dataset into the column. Bind your data set
parameter for the inner to the outer column and run the report.

Jason

On 5/10/2012 3:24 PM, Jeff Stouse wrote:
> Jason,
>
> I tried moving the detail table above the caption and immediately below
> the Brief Facts row - no luck. I agree that something is making the
> program not bring in the data from the other records - even though it is
> making the correct number of detail records - just copying the data. Is
> there some sort of buffer that holds the data that can be emptied?
>
> Jeff
Re: Detail records in Master-Detail report do not change [message #871097 is a reply to message #871091] Thu, 10 May 2012 20:20 Go to previous messageGo to next message
Jeff Stouse is currently offline Jeff Stouse
Messages: 13
Registered: May 2012
Junior Member
When I make a copy and delete everything from the page and then drag the master table to the layout screen, I get a table. My original report is based on a grid. the Report works when I drag the detail table into the second column, but not in my original report when I have a grid.

I was following the Field Guide (I purchased the book) on setting up the master-detail type of report - so it doesn't work if you use a grid -but does if you use two tables (one for the master and one for the detail)?

So I should re-create this using the two-table approach, with the master table having the detail table in one of its detail rows?

I've uploaded two screen shots of my original report:

1 - No detail rows in grid
2 - Displaying detail rows in grid

According to those views - my detail table is in the detail rows of the grid.

Still confused, but I think I have a way to fix this - just re-create using two tables - right?

Thanks,
Re: Detail records in Master-Detail report do not change [message #871249 is a reply to message #871097] Fri, 11 May 2012 16:06 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Grid should work to. I think the issue is that it is in the footer of
the list. Look at the attached example.

Jason


On 5/10/2012 4:20 PM, Jeff Stouse wrote:
> When I make a copy and delete everything from the page and then drag the master table to the layout screen, I get a table. My original report is based on a grid. the Report works when I drag the detail table into the second column, but not in my original report when I have a grid.
>
> I was following the Field Guide (I purchased the book) on setting up the master-detail type of report - so it doesn't work if you use a grid -but does if you use two tables (one for the master and one for the detail)?
>
> So I should re-create this using the two-table approach, with the master table having the detail table in one of its detail rows?
>
> I've uploaded two screen shots of my original report:
>
> 1 - No detail rows in grid
> 2 - Displaying detail rows in grid
>
> According to those views - my detail table is in the detail rows of the grid.
>
> Still confused, but I think I have a way to fix this - just re-create using two tables - right?
>
> Thanks,
Re: Detail records in Master-Detail report do not change [message #871250 is a reply to message #871097] Fri, 11 May 2012 16:06 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Grid should work to. I think the issue is that it is in the footer of
the list. Look at the attached example.

Jason


On 5/10/2012 4:20 PM, Jeff Stouse wrote:
> When I make a copy and delete everything from the page and then drag the master table to the layout screen, I get a table. My original report is based on a grid. the Report works when I drag the detail table into the second column, but not in my original report when I have a grid.
>
> I was following the Field Guide (I purchased the book) on setting up the master-detail type of report - so it doesn't work if you use a grid -but does if you use two tables (one for the master and one for the detail)?
>
> So I should re-create this using the two-table approach, with the master table having the detail table in one of its detail rows?
>
> I've uploaded two screen shots of my original report:
>
> 1 - No detail rows in grid
> 2 - Displaying detail rows in grid
>
> According to those views - my detail table is in the detail rows of the grid.
>
> Still confused, but I think I have a way to fix this - just re-create using two tables - right?
>
> Thanks,
Previous Topic:Annotation/Comments addition on chart
Next Topic:Problem in previewing report in Birt designer 3.7 in Eclipse Indigo
Goto Forum:
  


Current Time: Thu Oct 23 11:45:03 GMT 2014

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

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