Crosstab toggle visibility

[Tobie]

Hi, I have a report consisting of a crosstab in the reportheader section, with 3 row groups and 1 data column. I applied Toggle Visibility on  the second row group so that it should expand or collapse the third row group, but the report loads with all rows expanded. I tried changing the toggle mark initial expanded setting, but it just changes the + to -. Is it possible to load the report with rows not expanded initially?

Thanks

[Steve]

Hi Tobie,

As explained in the Drilldown Report Action help article, "To define if the item exposing the action will be rendered initially with expanded or with collapsed mark, use the DisplayExpandedMark property." In other words the "Toggle mark initially expanded" checkbox defines if the item exposing the action will be rendered initially with expanded or with collapsed mark. It does not control the Visibility of the actual item. In other words, in order to achieve your goal, you should hide the row group initially (Visible=false) and uncheck the "Toggle mark initially expanded" checkbox.

Greetings,
Steve
the Telerik team

[Tobie]

Hi Steve, thanks for the reply. It works on the 3rd row group that I want to hide, but the data column still shows individual values for each of the rows that are now hidden. What I want when the rows are hidden, is a total for the 2nd row group to show in the data column. I have not been able to find a solution to this. Thanks

[Tobie]

To better explain my issue - I use a crosstab to show monthly vehicle fuel data over 6 or 12 months for a company with 2 levels of sub-companies. So I have 3 row groups displaying the 3 company levels and a data column for the months with total kilometres per row.

When I preview the report with no actions set and all groups/columns visible, the report shows all monthly total kilometres for all companies down to 3rd level. I want the report to initially display only the 1st and 2nd level compnaies with totals for the 2nd level companies. Upon expanding the toggle mark, the report must then expand the 3rd level companies with their totals.

I set the 3rd row group (3rd level companies) visibility to false and the 2nd row group Toggle Visibility target to the 3rd row group with toggle mark expanded unticked.

Now when I open the report, it displays the 1st and 2nd row groups, but it still shows total kilometres for each 3rd row group with toggle mark collapsed. When I click the toggle mark to expand the 3rd row group, all it does is to collapse the monthly totals, So now I have the first 2 levels companies with totals for the 2nd level company - its how I want the report to open initially. When I now click the toggle mark again (to show collapse sign +) the monthly totals expand to show total kilometres for each 3rd level company and the 3rd row group is still hidden.

I also tried other settings - when I leave the 3rd row group visible and set the Toggle Visibility target for the 2nd row group to the 3rd row group. Now the report opens with all row groups and totals expanded and toggle mark collapsed (+ sign). When I click the toggle mark to expand the 3rd row group, it collapses the totals and hides the 3rd row group.

Is there any other setting I can change to fix this issue?

Thanks

[Stef]

Hi Tobie,

Thank you for the thorough description, however we're not sure we follow your scenario. If by any chance you have not checked this demo illustrating Crosstab item and drill down action functionality, please give it a look: Sales by Product Line per Period. Please note how the ProductCategory textbox hides both the ProductSubCategory table group and the Total TextBox for it. The example can be found locally on your machine under C:\Program Files (x86)\Telerik\Reporting Q3 2012\Examples\CSharp\ReportLibrary\Crosstab.

If this does not solve your issue, please send us a runnable sample and explanations what should be or should be not shown and when.

Regards,
Stef
the Telerik team

[Tobie]

Hi,

I looked at the demo and it works the way I want my report to work as well. The problem is my report opens with all data columns expanded with totals for my 3rd row group, irrespective whether it is hidden or not. In the demo the report opens with a grand total amount for Bikes and when expanded shows the amounts for the types of bikes. What happens in my report is that the report would open with the amounts for the different types of bikes expanded, not collapsed as like I want it to.

I'm attaching a screenshot of how the report opens ,,, the CostCentre row group has been hidden, but the Costcentre Total Distances are still expanded instead of collapsed to show a total for the Branch. It is a trdx of the same report which behaves the same, but I'm not sure how I can send the trdx because it reads data from an SQL database.

[Stef]

Hello Tobie,

According to your screenshot you have set Drilldown action on the second level for the "Branches". In the sample we referred to (also available in trdx format under C:\Program Files (x86)\Telerik\Reporting Q3 2012\Report Designer\Examples\Product Sales.trdx) the drilldown action is set to a parent group and control the visibility of rows related to sub group. If you want for example the two rows for 'Aviation' to be collapse and their visibility to be toggled from 'Aviation', all related items in the row should be associated as targets for the action.
If you still need help, open a support ticket and send us the trdx file. We will update the forum thread in the end for all interested in the discussion.

All the best,
Stef
the Telerik team

[Madhuri k. chaube]

I have make a report that use toggle visibility,but when i view this report it show all the information is in expanded form.I want that inforamtion firstly in collapse and when i click on + button it shows the information

[Madhuri k. chaube]

this is the screen shot......

[Stef]

Hi Madhuri,

The ToggleVisibilityAction would not change the visibility of the target, before clicking the controlling item. Thus to show initially sections hidden, you need to set the target items/sections/groups Visible properties to false, and set the controlling item action's DisplayExpandedMark property.

I hope this information helps you.

Regards,
Stef
Telerik

 

 

[Madhuri k. chaube]

Thanx sir....Its a working

but the again problem is that it show information in collapse form and after clicking on '+' it does not show information in expanded form
how It  will

[Stef]

Hi Madhuri,

Please check if the target of the action is set correctly to the item/section you need to hide. For more details check the Drilldown Report Action and How to: Add a Drilldown Action help articles.

Regards,
Stef
Telerik

 

 

[Divya]

i am new to use telerik how to add cross tab report using storedprocedures with userdefined parameters i.e,dynamic parameters then click the button shows "The source of the report definition has not been specified.' error occur so please find the related code
and also  add reportsource i.e typereportsource name of report not showing how to add report to typereportsource

[Stef]

Hi Divya,

This question seems to be related to the one in your support ticket #806737 - run the project not showing report, please refer to my post there.

In general, you can assign the ReportViewer.ReportSource property to a TypeReportSource object, where the report is specified by its assembly qualified name. This name consists of <namespace>.<report_object_name>, <assembly_name>.
Using this assembly qualified name of the report type, internally we create an instance of the report, using its default constructor, and pass it to the viewer.

Regards,
Stef
Telerik

 

 

[Nimish]

I have the same scenario. But instead of sub group hide and show, I want to put sub report in that. Means on clicking of any acyion, my sub report should be show or false. 

I am able to do the same thing another control, But in case of sub report, On expanding the action control, my sub report is still invisible.

ANy help 

[Stef]

Hi Nimish,

Test setting the sub report's Visible property to the same as the SubReport item's Visible property. Then on toggling the visibility of the SubReport item (the target of the action), the sub report's visibility will be toggled as well.

Our developers are going to further investigate the scenario to determine if this is the correct behavior or there are required improvements.

I hope this helps you.

Regards,
Stef
Telerik

[Nimish]

Hi Stef, 

Thanks for your reply, I think the problem is with sub report only. It is hidden somewhere. The problem may due to the reason, that it may be taking it as new page. I am not sure about the reason. 

 

 

[Stef]

Hi Nimish,

Rest assured our developers will take care of the issue and will investigate the current behavior. If there is a need of improvement, a fix will be provided in a consecutive release.

For the time being, please use the suggested approach where the SubReport item and sub report's Visible properties are synchronized.

Regards,
Stef
Telerik

[Naureen]

I have an update version of Telerik reporting (10.2.16.914). 

I am testing one of my reports that were developed in a older version using report designer. The report has a crosstab on it with initial expanded mode. In terms of functionality everything works fine (i.e. expand and collapse options), but when it comes to display  +/- marks, it show - when all items are expanded and + when all items are collapsed. I tried using setting value for DisplayExpandedMark to both true and false but it stills displays otherwise. 

Just to mention this happens when initial state is expand, but if initial state is collapse then it works fine

[Katia]

Hello ,

This is a known issue that was introduced in R3 2016 release (10.2.16.914). A fix has been already provided in version R3 2016 SP1 (10.2.16.1025) that is available for download in your Telerik account -> Downloads -> Reporting.

If you create reports in Visual Studio Designer, run the Upgrade Wizard to update Telerik Reporting references to the latest version.


Regards,
Katia
Telerik by Progress

[Naureen]

Thanks - it worked for me