iLearn

Hi Folks, Hope you all are doing good. Would like to start with praying for all those who have been affected by a deadly earthquake in Nepal. Just when it seems that life is good something like this happens, to remind us of that we are not permanent here. Death is a bitter truth. Moving on this week I again ran into one of the bugs in reporting services 2005 i.e. we cannot have aggregates of aggregates in a situation where we have a parent group and a child group. Requirement -    See the resultset below pid pdesc cid cdesc 1 harish 1 ninu 1 harish 2 lovely 2 asha        3  ricky 2 asha   4 hina We have 2 groups one is parent having pid has the identifier and second group is child having cid as the identifier We want to calculate the sum of cids accross parent and child group (off-course at child level it would be the individual cid itself) Implementation -  so I have written the expression sum(Fields!...

Hi Folks Greetings to everyone!!! So last week one of the report was having a performance issue. It had 10 datasets ,5 data regions and a report parameter. Regions displayed cascading information based on user's selection of parameter. For example,. lets assume the parameter name to be ReportLevel, it would have 3 possible values - Country, State, City. This being a multi valued parameter will decide which data region to be displayed. In this example we will have 3 datasets binded to 3 tablix or tables or data regions. So if user selects Country only than country data region will be displayed and like wise Country and city level details will only be shown if the user selects the value as country, city. Now I assumed (most of you guys would already know the correct behaviour :-) ), only those datasets or queries would be executed which are being displayed. On further having a discussion with one of my friend and an expertise in SSRS, I came to know that all datasets will ...

Hi Folks Highlighting on the issue that I faced last week while working on reporting services 2005. Requirement :- A data region (table) is to be displayed based on the parameter value. Table has a toggle facility on detail rows of a group like so on export to excel it should look like this  Solution :- I found out that is a known issue in ssrs 2005. On adding an expression at the visibility property of the data region it looses the toggle functionality in the excel. However it works fine with 2012 reporting services. Your comments and feedback are welcome here.