Hi,
I have been using the trial version today to review your product and found that if I have a master-detail type relationship based on business objects then if the first master record has no detail record all the fields associated with the detail record definition are not accessible anymore for the whole report dataset.
To reproduce change comment out the 3 emp.phones.add calls for Nicholas in the demo for Business Objects - BusinessObjects_IEnumerable.cs
Thanks
Jon
Business Objects IEnumerable type scenario has a problem
Business Objects IEnumerable type scenario has a problem
Thank you for the question.jonmoores wrote:Hi,
I have been using the trial version today to review your product and found that if I have a master-detail type relationship based on business objects then if the first master record has no detail record all the fields associated with the detail record definition are not accessible anymore for the whole report dataset.
To reproduce change comment out the 3 emp.phones.add calls for Nicholas in the demo for Business Objects - BusinessObjects_IEnumerable.cs
Thanks
Jon
In this case DataBand1.PrintIfDetailEmpty is false. Therefore, when detail bands do not exist then the master band (Nicholas) is not printed.
Thank you.
Business Objects IEnumerable type scenario has a problem
Hi,
That bit I understand and accept. What does not make sense is that when I look at the 'View Data' option nothing is shown (not even the column names) for the data only the 'system' fields. Maybe if I give you an example it makes more sense. The problem I am trying to explain is that when there are multiple master records of which only the first has no detail records then the whole report shows no children. In fact it looks like Stimul uses only the detail records of first master record to do some setup / config in the background. Taking the below-
Orders with OrderLines (assume fields QTY and AMT at this level)
- ORDER 1
- ORDER 2
x ORDERLINE 1
x ORDERLINE 2
- ORDER 3
x ORDERLINE 1
What I am saying is that because ORDER 1 has no ORDERLINE children it screws up the report for ORDER2 and ORDER3 even though they do have records. Looking at the 'View Data' screen for the data I would see there are indeed three ORDERLINE records available but the columns QTY or AMT are not shown only the 3 system fields (_ID, PARENT_ID and ...?)
Are you sure this is intended behaviour?
Thanks
Jon
That bit I understand and accept. What does not make sense is that when I look at the 'View Data' option nothing is shown (not even the column names) for the data only the 'system' fields. Maybe if I give you an example it makes more sense. The problem I am trying to explain is that when there are multiple master records of which only the first has no detail records then the whole report shows no children. In fact it looks like Stimul uses only the detail records of first master record to do some setup / config in the background. Taking the below-
Orders with OrderLines (assume fields QTY and AMT at this level)
- ORDER 1
- ORDER 2
x ORDERLINE 1
x ORDERLINE 2
- ORDER 3
x ORDERLINE 1
What I am saying is that because ORDER 1 has no ORDERLINE children it screws up the report for ORDER2 and ORDER3 even though they do have records. Looking at the 'View Data' screen for the data I would see there are indeed three ORDERLINE records available but the columns QTY or AMT are not shown only the 3 system fields (_ID, PARENT_ID and ...?)
Are you sure this is intended behaviour?
Thanks
Jon
Business Objects IEnumerable type scenario has a problem
Fixed. Thank you.
You can get fixed build from Downloads at our website (prerelease versions).
You can get fixed build from Downloads at our website (prerelease versions).