Hi Experts, Is it possible to change order of records/groups in a result-set from a query using Group By? =>I have a query: SELECT Category, Subcategory, ProductName, CreatedDate, Sales From TableCategory tc INNER JOIN TableSubCategory ts ON tc.col1 = ts.col2 INNER JOIN TableProductName tp ON ts.c...
I use SQL 2008 I have report with few groups on the left, then some numbers and another numbers (further on the right) which has to be groupped as well. Field1 Filed2 Filed3 Num1 Num2 Num3 Num4 fff sss aaa 1000 2000 3000 4000 bbb 2000 3000 ccc 4000 5000 i.e. Num3 and Num4 are the same for eac...
Im working with a tablix in SSRS, but struggling to understand it. I've created two groups that filter out values for [Gained_Cus] for the previous month and the current month. In the last column I want to calculate the variance between these two columns. I have a problem referencing the correct values. How would i do this without refere...
this is the desired result in need to populate as a report. where xx is no of people. i have a table which has fields like : ---------- table1 ---------- id state year(as Quarter) gender so i need to determine the count from id and populate as a report. the year is like 20081,20082..20084(in quarter). i have created a dataset usin...
Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and each column is a field in a form for that person. The fields themselves are dynamic (and implemented as column groups on the matr...
We can implement drilldown report using grouping feature of SSRS 2008, where we just give SSRS filtered data and group expression and rest is doen by SSRS, great. Our problem is that we have very larg data even after giving filter, so it takes lot of time for SSRS to get data and group it. What can be ideal situation is that we have oppr...