Crosstab toggle visibility

21 posts, 0 answers
  1. Tobie
    Tobie avatar
    8 posts
    Member since:
    Feb 2012

    Posted 17 Jan 2013 Link to this post

    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
  2. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 17 Jan 2013 Link to this post

    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

    HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

  3. DevCraft banner
  4. Tobie
    Tobie avatar
    8 posts
    Member since:
    Feb 2012

    Posted 17 Jan 2013 Link to this post

    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
  5. Tobie
    Tobie avatar
    8 posts
    Member since:
    Feb 2012

    Posted 18 Jan 2013 Link to this post

    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
  6. Stef
    Admin
    Stef avatar
    3044 posts

    Posted 22 Jan 2013 Link to this post

    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

    HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

  7. Tobie
    Tobie avatar
    8 posts
    Member since:
    Feb 2012

    Posted 22 Jan 2013 Link to this post

    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.
  8. Stef
    Admin
    Stef avatar
    3044 posts

    Posted 25 Jan 2013 Link to this post

    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

    HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

  9. Madhuri k. chaube
    Madhuri  k. chaube avatar
    8 posts
    Member since:
    Mar 2014

    Posted 13 Mar 2014 Link to this post

    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
  10. Madhuri k. chaube
    Madhuri  k. chaube avatar
    8 posts
    Member since:
    Mar 2014

    Posted 13 Mar 2014 Link to this post

    this is the screen shot......
  11. Stef
    Admin
    Stef avatar
    3044 posts

    Posted 14 Mar 2014 Link to this post

    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
     

    DevCraft Q1'14 is here! Watch the online conference to see how this release solves your top-5 .NET challenges. Watch on demand now.

     
  12. Madhuri k. chaube
    Madhuri  k. chaube avatar
    8 posts
    Member since:
    Mar 2014

    Posted 20 Mar 2014 in reply to Stef Link to this post

    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
  13. Stef
    Admin
    Stef avatar
    3044 posts

    Posted 25 Mar 2014 Link to this post

    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
     

    Build cross-platform mobile apps using Visual Studio and .NET. Register for the online webinar on 03/27/2014, 11:00AM US ET.. Seats are limited.

     
  14. Divya
    Divya avatar
    9 posts
    Member since:
    Mar 2014

    Posted 09 Apr 2014 in reply to Stef Link to this post

    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
  15. Stef
    Admin
    Stef avatar
    3044 posts

    Posted 09 Apr 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  16. Nimish
    Nimish avatar
    10 posts
    Member since:
    Jun 2015

    Posted 23 Jul 2015 in reply to Steve Link to this post

    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 

  17. Stef
    Admin
    Stef avatar
    3044 posts

    Posted 27 Jul 2015 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  18. Nimish
    Nimish avatar
    10 posts
    Member since:
    Jun 2015

    Posted 27 Jul 2015 in reply to Stef Link to this post

    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. 

     

     

  19. Stef
    Admin
    Stef avatar
    3044 posts

    Posted 28 Jul 2015 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  20. Naureen
    Naureen avatar
    5 posts
    Member since:
    Oct 2016

    Posted 01 Nov Link to this post

    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

  21. Katia
    Admin
    Katia avatar
    305 posts

    Posted 02 Nov Link to this post

    Hello Naureen,

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  22. Naureen
    Naureen avatar
    5 posts
    Member since:
    Oct 2016

    Posted 02 Nov in reply to Katia Link to this post

    Thanks - it worked for me
Back to Top
DevCraft banner