No announcements
Found 2357635 threads
-
0 VotesSSRS Grouping Problem with Joined Data
I also merged the data in a table, to be sure its not a problem of the union join of the data set... in fact, the problem was the ...Answered | 3 Replies | 5468 Views | Created by Lukas.BIZ - Wednesday, March 30, 2011 8:58 AM | Last reply by Ursa Pangos - Thursday, March 31, 2011 7:19 AM
-
1 Votes
SSRS 2008R2: Problem getting detail-data in groups
[Article] inner join (select * from [DataRanks] where [ArticleSupplierRank] = 1) [ArticleSupplierMin] on [records].Answered | 12 Replies | 1733 Views | Created by sql_pet - Wednesday, July 31, 2013 8:16 AM | Last reply by Srini Koduru - Friday, August 2, 2013 11:42 AM -
2 Votes
[SSRS] Export data to CSV with column group data
SSRS is a reporting service only, so, it doesn't seem to be a good idea to expect doing that type of manipulation through SSRS.Answered | 5 Replies | 10935 Views | Created by Didier Esteves - Wednesday, September 19, 2012 8:08 AM | Last reply by Sanjeewan Kumar - Thursday, September 20, 2012 10:42 AM -
0 Votes
SSRS grouping problem
Having a problem figuring out a way to format groups in SSRS.Answered | 1 Replies | 4605 Views | Created by Sean Fullman - Thursday, March 18, 2010 3:25 AM | Last reply by Alex Feng (SQL) - Thursday, March 25, 2010 3:48 AM -
0 Votes
SSRS - Line chart - Group data
Hi, You need to add this expression in Category group expression..Answered | 6 Replies | 3329 Views | Created by Nadim2522 - Tuesday, August 28, 2012 11:57 AM | Last reply by Chintak Chhapia - Tuesday, August 28, 2012 6:13 PM -
0 Votes
Grouping SQL data for SSRS in different age groups
You could define a (table/matrix) group expression in Reporting Services like this: =iif(Fields!Answered | 1 Replies | 5555 Views | Created by GurunGuns - Friday, July 17, 2009 4:10 PM | Last reply by Robert Bruckner - Sunday, July 19, 2009 12:14 AM -
0 Votes
How to Group Data in an SSrS Tablix?
The answer is, "Use row grouping.Answered | 2 Replies | 877 Views | Created by Doug Pruiett - Friday, January 8, 2016 2:43 AM | Last reply by Qiuyun Yu - Monday, January 11, 2016 3:06 AM -
0 Votes
Grouping In SSRS
Hi JEALISL, As Ram and Spandan posted, if you need to control the data of each group display on different pages, you can add a page break to a ...Answered | 3 Replies | 3302 Views | Created by BIRL - Wednesday, June 15, 2011 3:05 PM | Last reply by Elvis Long - Friday, June 17, 2011 9:22 AM -
0 Votes
Grouping Problem in SSRS reports
Hi fadnan, In a report, a matrix is used to display aggregate summaries for grouped data in a report dataset, similar to a PivotTable or ...Answered | 4 Replies | 3261 Views | Created by MadnanM - Friday, July 1, 2011 2:43 PM | Last reply by Elvis Long - Tuesday, July 5, 2011 6:14 AM -
1 Votes
group by /join
If I understand what you have said correctly then you need something like this: SELECT V.entity, V.vcnt, V.vamt, C.ccnt, C.camt FROM (SELECT entity, ...Answered | 2 Replies | 4710 Views | Created by Brian32 - Saturday, May 15, 2010 9:10 PM | Last reply by Brian32 - Monday, May 24, 2010 3:24 PM -
0 Votes
SSRS report grouping problem
I create a SSRS report with Visual Studio 2017 with SQL Server Data Tools.Answered | 1 Replies | 1415 Views | Created by tonylck - Friday, November 30, 2018 8:18 AM | Last reply by Guido Franzke - Friday, November 30, 2018 8:58 AM -
0 Votes
Please correct my JOIN expression in SSRS
Product.Value,",")& )"' AND["& "Group]= '"& JOIN(Parameters!Answered | 3 Replies | 4072 Views | Created by RP Reddy - Friday, November 11, 2011 12:42 PM | Last reply by Debbie Napoli - Friday, November 11, 2011 1:23 PM -
1 Votes
Problem with native SSRS security and AD groups in SQL 2012
I can not add Local group also in SSRS.Answered | 5 Replies | 3392 Views | Created by Hrvoje Kusulja - Saturday, October 5, 2013 8:39 PM | Last reply by Hrvoje Kusulja - Sunday, November 24, 2013 7:08 PM -
1 Votes
SSRS 2012 - group data in chart by month or week
Hello, you are right Then you need to have derived column in your sql query to bring these values Once its there then in your report you can use it for the category ...Answered | 4 Replies | 1783 Views | Created by Aleks Roth - Thursday, June 21, 2018 2:06 PM | Last reply by Visakh16 - Sunday, June 24, 2018 3:48 AM -
0 Votes
SSRS, Grouping, and Objects as Dataset
We can create a dataset by join the two tables and retrieve all columns we need.Answered | 6 Replies | 4751 Views | Created by kw_uh97 - Thursday, February 28, 2013 2:20 PM | Last reply by Fanny Liu - Thursday, March 7, 2013 3:36 AM -
0 Votes
Double grouping + export in SSRS
What happened I was doing lot of testing some in SSRS 2005 and some in SSRS 2008 yesterday and then left home for the day and replied from home.Answered | 12 Replies | 3529 Views | Created by Teleute00 - Thursday, May 3, 2012 2:34 AM | Last reply by Syed Qazafi Anjum - Friday, May 4, 2012 3:59 PM -
2 Votes
join two tables by data and groups
[a-01], DAY(EOMONTH(CAST(a.data1 AS DATE))) AS [count_dayof Firstday_in_data], DATEDIFF(DAY,(CONVERT(DATETIME, data1, 103)),(CONVERT(DATETIME, data2, 103))) AS [subtract second and first ...Answered | 1 Replies | 560 Views | Created by Jury Wox - Tuesday, March 26, 2019 2:43 PM | Last reply by Arulmouzhi - Tuesday, March 26, 2019 5:33 PM -
0 Votes
Outer Join in SSRS
col1.value,"dataset2") Then add a new dataset to the report using below query ;With ...Answered | 4 Replies | 2039 Views | Created by RuchikaG - Wednesday, June 17, 2015 10:13 AM | Last reply by Visakh16 - Wednesday, June 17, 2015 1:13 PM -
0 Votes
How to Apply grouping in ssrs
If so, you can try to use nested data region or subreport.Answered | 2 Replies | 1457 Views | Created by Rajni Kaushal - Friday, April 5, 2013 1:14 PM | Last reply by Fanny Liu - Monday, April 8, 2013 8:10 AM -
2 Votes
SSRS Role assignment to user group
To put it simply, The SSRS only recognizes Universal or Global Security Groups, so go to your AD, create a new security ...Answered | 1 Replies | 5501 Views | Created by Mr Vivek Singh - Friday, November 20, 2015 7:29 AM | Last reply by Andrey Langovoy - Friday, November 20, 2015 7:39 AM - Items 1 to 20 of 2357635 Next ›
No announcements
