Hi All, https://docs.google.com/leaf?id=0B9kG9JjPJGAvMjhiMGI3MjItMmI5Ny00ODNjLTkxMWUtMDVlOTBiYzU3ZjAx&hl=en&authkey=CKCo-aAC I have attached a sample rdl file. Everything is looking perfectly expect the toggle sign in front of "2" & "4". As ID 2 & 4 don't have sub-data I don't want to display toggle sign ( plus sign '+' ) in front of them, which makes users happy saying, without clicking on any button he/she can say that these ID's (2 & 4) don't have any dependent data. So how to achieve it? Please let me know if you have any concerns. Thanks Kumarkk

Any thought please Thanks Kumarkk

Hello Kumar03, There is no straight way to do this. But there is a workaround, you can do this by adding a column and make the empty cell of the column to be used as toggle item and make the visibility of the cell false if there is no data for an ID. But believe me you'll not like the report appearance. Another thing that you can do if it suits your need: make the section expanded if there is no data so that your client can easily come to know about it without expanding it.Thanks Salman http://muhammadsalmanx.wordpress.com

Can you show me an example, with what you have meintioned your reply as "workaround", if possible for both of your solutions? Thanks Kumarkg

you can do this by adding a column and make the empty cell of the column to be used as toggle item and make the visibility of the cell false if there is no data for an ID. But believe me you'll not like the report appearance. Another thing that you can do if it suits your need: make the section expanded if there is no data so that your client can easily come to know about it without expanding it. Thanks Salman http://muhammadsalmanx.wordpress.com

Hi Kumar, As Salman posted, we can adding a column which dedicate to be used for the toggle item, and hide the toggle cells dynamically based on the count of DEP ID in the group. To achieve this, please refer to the steps below: 1. Right click the handle of the ID column and select Insert Column to the Left. 2. Check the textbox name which is located in the first column and second row. For example, in my report is textbox7. Set the to the Hidden property of the textbox to the expression like =IIf(Count(Fields!DEPID.Value,"table1_Group1")>0,false,true) 3. Select the handles of both the detail row and the second group header row. 4. Specify the ToggleItem property to textbox7. After that, the Toggle plus sign would be displayed in the new column. And it also would be hidden if the count of the DEPID is 0 in the group. I have uploaded the report file which has been modified, it is available at the link below. Since I changed the datasource, please correct it before preview. http://cid-1e189c82ae92dfd8.office.live.com/self.aspx/.Public/Reporting%20Services/Toggle.rdl Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

Hi Tony Chain, Although I have marked your previous reply, but still I have one issue, when I deploy to SSRS 2005 Report Server everything looks perfect as it looks under BIDS 2005, but when I deploy same report to SSRS 2008 as well as on R2 Report Server I see the one critical issue, rows are shifting one column left, please see screenshot below:- https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B9kG9JjPJGAvYWFmNGM1ZDYtZDcyNy00NTg3LWI2MjUtOWU1OTNmMDFiZWE1&hl=en&authkey=CMuhr-UC Can you please tell me is this the bug in 2008 & R2 Report Server? Thanks KumarKG

Hi Tony Chain, Although I have marked your previous reply, but still I have one issue, when I deploy to SSRS 2005 Report Server everything looks perfect as it looks under BIDS 2005, but when I deploy same report to SSRS 2008 as well as on R2 Report Server I see the one critical issue, rows are shifting one column left, please see screenshot below:- https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B9kG9JjPJGAvYWFmNGM1ZDYtZDcyNy00NTg3LWI2MjUtOWU1OTNmMDFiZWE1&hl=en&authkey=CMuhr-UC Can you please tell me is this the bug in 2008 & R2 Report Server? Thanks KumarKG

Hi Tony Chain, Did you got any change to deploy the same report to 2008 or on R2 Report Server? Looks like things are getting messy on both of the Report Servers but but everything is working perfectly on Report Server 2005!!! Wow strange can you justify more or little bit what is happening any WHY? Thanks KumarKG

Hi Kumar, Sorry for delay. Generally, in order to get more replies, please ask the new question in a new thread. Based on my testing, it works fine if deploy the report in BIDS 2005 to Report Server 2008. However, as you posted, rows are shifting one column left if deploy to Report Server 2008 R2. Currently, I’m afraid Reporting Services 2005 only support deploy report to Report Server 2005 and 2008. Please refer to the table below: Product Authoring environment Author RDL version Deploy RDL version Deploy to report server versions SQL Server 2005 Report Designer in BI Development Studio 2000 RDL, upgrades to 2005 RDL 2005 RDL 2005 RDL SQL Server 2005 Reporting Services SQL Server 2008 Reporting Services SQL Server 2008 Report Designer in BI Development Studio 2000 RDL, upgrades to 2008 RDL 2005 RDL, upgrades to 2008 RDL 2008 RDL 2008 RDL SQL Server 2008 Reporting Services SQL Server 2008 R2 Report Designer in a BI Development Studio 2000 RDL, upgrades to 2010 RDL 2005 RDL, upgrades to 2010 RDL 2008 RDL, upgrades to 2010 RDL 2010 RDL 2008 RDL 2010 RDL SQL Server 2008 Reporting Services SQL Server 2008 R2 Reporting Services If it also doesn’t work fine after deployed to Report Server 2008, please check the specific version of the Report Server 2008. We can get the version at the bottom of the Report Server homepage http://<servername>/reportserver. By the way, SQL Server 2008 Service Pack 2 is now available, please refer to the link below and we recommend applying the latest update. http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/11/23/sql-server-2008-service-pack-2-is-now-available-on-microsoft-update-mu.aspx Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

Hi Tony Chain, So in order to work with the functionality which I'm requesting, Do I have create report from scratch using BIDS 2008 or BIDS 2008 R2? And than after developing which deployment Report Server will work correctly 2008 or 2008 R2? Please let me know so that I can work accordingly. Thanks KumarKG

Hi Kumar, We can use BIDS 2005 to deploy report to Report Server 2005 and Report Server 2008. However, if you need to deploy report to Report Server 2008R2, please use BIDS 2008R2 which can deploy report to Report Server 2008 and Report Server 2008R2. Additionally, please be aware that BIDS 2008 can only deploy report to Report Server 2008. Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Kumar, We can use BIDS 2005 to deploy report to Report Server 2005 and Report Server 2008. However, if you need to deploy report to Report Server 2008R2, please use BIDS 2008R2 which can deploy report to Report Server 2008 and Report Server 2008R2. Additionally, please be aware that BIDS 2008 can only deploy report to Report Server 2008. Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Tony, Thanks you for your response. Will work with the same as per your reply and will update this thread. Thanks KumarKG

Hi Tony, I tried created same example from SCRATCH using BIDS 2008 R2 but my o/p while doing Preview on BIDS 2008 R2 is different than the Preview on Report Server 2008 R2, here my example what I'm trying:- https://docs.google.com/leaf?id=0B9kG9JjPJGAvNmNkYzAyOGYtOTMwMi00OTg0LTgxNDItZDgzY2M4YTkxOWY4&hl=en&authkey=CNjH0YsC I want both on BIDS as well as on the Report Server o/p to be EXACTLY/SAME as what we have tried so far using BIDS 2005. Please let me know what I'm doing wrong. Thank Your for your help. Note:- This question is totally related to 2008 R2 (BIDS as well as Report Server) Regards, KumarKG

Hi Tony, I tried created same example from SCRATCH using BIDS 2008 R2 but my o/p while doing Preview on BIDS 2008 R2 is different than the Preview on Report Server 2008 R2, here my example what I'm trying:- https://docs.google.com/leaf?id=0B9kG9JjPJGAvNmNkYzAyOGYtOTMwMi00OTg0LTgxNDItZDgzY2M4YTkxOWY4&hl=en&authkey=CNjH0YsC I want both on BIDS as well as on the Report Server o/p to be EXACTLY/SAME as what we have tried so far using BIDS 2005. Please let me know what I'm doing wrong. Thank Your for your help. Note:- This question is totally related to 2008 R2 (BIDS as well as Report Server) Regards, KumarKG

Hi Tony, I tried created same example from SCRATCH using BIDS 2008 R2 but my o/p while doing Preview on BIDS 2008 R2 is different than the Preview on Report Server 2008 R2, here my example what I'm trying:- https://docs.google.com/leaf?id=0B9kG9JjPJGAvNmNkYzAyOGYtOTMwMi00OTg0LTgxNDItZDgzY2M4YTkxOWY4&hl=en&authkey=CNjH0YsC I want both on BIDS as well as on the Report Server o/p to be EXACTLY/SAME as what we have tried so far using BIDS 2005. Please let me know what I'm doing wrong. Thank Your for your help/replies. Note:- This question is totally related to 2008 R2 (BIDS as well as Report Server) Regards, Kumar KG

Hi Tony, I tried created same example from SCRATCH using BIDS 2008 R2 but my o/p while doing Preview on BIDS 2008 R2 is different than the Preview on Report Server 2008 R2, here my example what I'm trying:- https://docs.google.com/leaf?id=0B9kG9JjPJGAvNmNkYzAyOGYtOTMwMi00OTg0LTgxNDItZDgzY2M4YTkxOWY4&hl=en&authkey=CNjH0YsC I want both on BIDS as well as on the Report Server o/p to be EXACTLY/SAME as what we have tried so far using BIDS 2005. Please let me know what I'm doing wrong. Thank Your for your help/replies. Note:- This question is totally related to 2008 R2 (BIDS as well as Report Server) Regards, Kumar KG

Hi Tony, I tried created same example from SCRATCH using BIDS 2008 R2 but my o/p while doing Preview on BIDS 2008 R2 is different than the Preview on Report Server 2008 R2, here my example what I'm trying:- https://docs.google.com/leaf?id=0B9kG9JjPJGAvNmNkYzAyOGYtOTMwMi00OTg0LTgxNDItZDgzY2M4YTkxOWY4&hl=en&authkey=CNjH0YsC I want both on BIDS as well as on the Report Server o/p to be EXACTLY/SAME as what we have tried so far using BIDS 2005. Please let me know what I'm doing wrong. Thank Your for your help/replies. Note:- This question is totally related to 2008 R2 (BIDS as well as Report Server) Regards, Kumar KG

Hi Tony, I still tried but not luck yet so far :( Please let me know how to make it work. Thanks KumarKG

Hi Tony, I still tried but not luck yet so far :( Please let me know how to make it work. Thanks KumarKG

Hi Kumar, I can reproduce the scenario you posted. After deployed the report to Report Server 2008R2, rows are shifting one column left if the toggle sign in the first column is hidden. So, it is my pleasure to help you to reflect this issue to the proper department. You can also submit the issue on our product team at https://connect.microsoft.com/SQLServer/ to get official confirmation. However, since Tablix is introduced in Reporting Services 2008 and 2008R2, we can also achieve the requirement by placing the toggle in the Tablix row groups area. I also created a sample based on the report you posted, it is available at: http://cid-1e189c82ae92dfd8.office.live.com/self.aspx/.Public/Reporting%20Services/Toggle%202008%20r2.rdl For more information about Tablix Data Region Areas, please refer to: http://msdn.microsoft.com/en-us/library/cc645966(v=SQL.100).aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.