Hello,
I have built a report that contains four sub-reports in it's detail section.
Under certain circumstances it seems to get out of synch or merge two groups that should be separate.
I have been trying to isolate where the problem occurs, but haven't been very successful.
Here are a few things I have noticed, and I am wondering if anybody else has seen this type of thing and might have a hunch as to what causes it:
Here is a screenshot of the report set and the report:
report_set_and_design.png
When I look at the report set using a browse, I see the following weird behaviour:
browse_bug.png
Why is the browse behaving so weirdly. If I export it to excel, I see the correct ids.
These two ids are where the report behaves weirdly, too:
I should see two separate groups for AHI (Id P000001184) and for AHI Longmont Farms (P000001080). The correct groups are shown if don't filter the report by year:
AHILongmontFarms_filter_all.png
AHI_filter_all.png
...but if I add a year filter, all of a sudden they get mixed together:
AHI_filter_2013.png
Is this related to the weird browse behavior?
This is one of two problems: the report also gets out of synch, such that totals from one group are shown in the next group. The beginning of the report is fine, then at a certain point it gets out of synch.
I wouldn't ask anyone to get into the details of my set-up. I am just wondering, if this is something people have seen and if anyone has a hunch about this and can point me in the right direction.
(By the way, I did pack all tables and rebuild all indexes, and that didn't fix anything... Running the application in Version 12 also didn't fix this...)
Thanks a lot for any suggestions you might have!
Simone
I have built a report that contains four sub-reports in it's detail section.
Under certain circumstances it seems to get out of synch or merge two groups that should be separate.
I have been trying to isolate where the problem occurs, but haven't been very successful.
Here are a few things I have noticed, and I am wondering if anybody else has seen this type of thing and might have a hunch as to what causes it:
Here is a screenshot of the report set and the report:
report_set_and_design.png
When I look at the report set using a browse, I see the following weird behaviour:
browse_bug.png
Why is the browse behaving so weirdly. If I export it to excel, I see the correct ids.
These two ids are where the report behaves weirdly, too:
I should see two separate groups for AHI (Id P000001184) and for AHI Longmont Farms (P000001080). The correct groups are shown if don't filter the report by year:
AHILongmontFarms_filter_all.png
AHI_filter_all.png
...but if I add a year filter, all of a sudden they get mixed together:
AHI_filter_2013.png
Is this related to the weird browse behavior?
This is one of two problems: the report also gets out of synch, such that totals from one group are shown in the next group. The beginning of the report is fine, then at a certain point it gets out of synch.
I wouldn't ask anyone to get into the details of my set-up. I am just wondering, if this is something people have seen and if anyone has a hunch about this and can point me in the right direction.
(By the way, I did pack all tables and rebuild all indexes, and that didn't fix anything... Running the application in Version 12 also didn't fix this...)
Thanks a lot for any suggestions you might have!
Simone
Comment