Home » Archived » 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  |
 Jeff Stouse
Messages: 28
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  |
|
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 #871072 is a reply to message #870860] |
Thu, 10 May 2012 17:13 |
|
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 #871091 is a reply to message #871089] |
Thu, 10 May 2012 19:37 |
|
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 #871249 is a reply to message #871097] |
Fri, 11 May 2012 16:06 |
|
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 |
|
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,
|
|
|
Goto Forum:
Current Time: Fri Apr 19 18:52:06 GMT 2024
Powered by FUDForum. Page generated in 0.03837 seconds |
] 
Search
Help
Register
Login
Home
