FAQ Database Discussion Community


How to get overall total in row group

reporting-services,ssrs-2008,ssrs-grouping
I have a row group in SSRS that calculates totals by each group. However, I would like to get the percentage of each group out of the overall total. However, I do not know how to achieve getting the overall total to work within the same expression. Right now I...

Group by week separately for year

reporting-services,ssrs-2008-r2,ssrs-grouping
I have to group my sql query by week. But the record contains many years data. I used the query SELECT datepart(week, myDate) as week. But under the week 1 it shows data from every year How to group the weeks again having the same year...

SSRS Where can I place sub reports?

reporting-services,ssrs-2008,ssrs-tablix,ssrs-grouping,subreports
This is not the greatest question, but I have goggled and hunted and pecked for several days and have not found the solution. Where within a SSRS report can a sub-report be placed? Are there any locations that it might seam invisible or be hard to find? I have created...

Replace Null value with string in ssrs expression

reporting-services,ssrs-2008,ssrs-grouping
I have a row group of STATUS fields. There is a group that returns null that I would like to change to chat. I have tried: =Iif(IsNothing(Fields!STATUS.Value), "Chat", Fields!STATUS.Value) but the group still returns blank. Would anyone have any ideas on how to help me resolve this?...

How to create an interval in a matrix

reporting-services,ssrs-2008,mdx,ssrs-grouping
I am working with SSRS 2008, my source is a cube and I use this MDX query: SELECT NON EMPTY { [Measures].[Val] } ON COLUMNS, NON EMPTY { ([DimCl].[Cl].[Cl].ALLMEMBERS, [DDate].[Year].[Year].ALLMEMBERS ) } ON ROWS FROM [DW] I created a matrix with the following data 2014 2015 0 10 11 1...

SSRS Row Gropings Inverted (Export to Excel)

sql,excel,reporting-services,grouping,ssrs-grouping
When i run my report my report in SSRS all groupings work correctly however when i export this report to excel the proper rows are grouped but the grouping is inverted (i.e. the last item in the grouping has the '+' sign instead of the parent, top row) thanks for...