Hello All,
My report requests a simple feature of "Toggle Visibility".
My data looks like Pic1(Attached).
I setup 2 groups in my report(parent and detail)
On the parent level, i setup the toggle visibility on the first cell. When the report is browsed as initial expanding, it looks good as attachment pic2.--But i wanna archive if no children under the group item, can I hide the "+" or "-" signs.
The worse part is (See attacment Pic3.) , when i collapsed the toggle item, it automatically shows me the "total line" , which is not expected becasue the calculation is not the simple adding up by the detail items. In the data set reurned to report , i have calculated the so-called "summary" by a complex business logic. can I not display this "total line" when I collapse the toggle item.
Also, BTW, I hide the rows in detail group if the children name is equal to the parent name. That is why , initially, the "commissions" line only shows on my group header level, which is expected.
My report requests a simple feature of "Toggle Visibility".
My data looks like Pic1(Attached).
I setup 2 groups in my report(parent and detail)
On the parent level, i setup the toggle visibility on the first cell. When the report is browsed as initial expanding, it looks good as attachment pic2.--But i wanna archive if no children under the group item, can I hide the "+" or "-" signs.
The worse part is (See attacment Pic3.) , when i collapsed the toggle item, it automatically shows me the "total line" , which is not expected becasue the calculation is not the simple adding up by the detail items. In the data set reurned to report , i have calculated the so-called "summary" by a complex business logic. can I not display this "total line" when I collapse the toggle item.
Also, BTW, I hide the rows in detail group if the children name is equal to the parent name. That is why , initially, the "commissions" line only shows on my group header level, which is expected.
1 Answer, 1 is accepted
0
Hi Derek,
Up to your questions - if the child group does not have any values, the parent group will not get rendered at all. For example in our Product Sales report if the Bikes group does not have any bikes it will not be displayed at all.
Regarding your second question - you can make the total a part of the group - when you add the parent group from the group explorer just check the Add footer option. Then enter the formula in that footer, add labels, merge cells, etc.
I hope that helps.
Kind regards,
IvanY
the Telerik team
Up to your questions - if the child group does not have any values, the parent group will not get rendered at all. For example in our Product Sales report if the Bikes group does not have any bikes it will not be displayed at all.
Regarding your second question - you can make the total a part of the group - when you add the parent group from the group explorer just check the Add footer option. Then enter the formula in that footer, add labels, merge cells, etc.
I hope that helps.
Kind regards,
IvanY
the Telerik team
BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >