Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Matrix
97 results found
SQL Server Reporting Services - Green bar matrix report
Here's how I've created a 'green-bar' style cross-tab/matrix report. I'm basing the new report on this one: 1) Create an inner row grouping, in this case named 'Count' and given a grouping expression of =1 2) for the cell 'Count', set the property Value =
Author:
domhorton
Date: 1/27/2011 Section:
Blog
tags :
RunningVal
,
CountDistinct
,
Green Bar
,
Green Bar Matrix
,
Matrix
,
Sql Server Reporting Services
,
SSRS
SSRS Interactive Sorting a
Matrix
Sorting a matrix report can be done interactively. To perform interactive sorting, your report will need a cell to click on to perform the action. In the image below you can see a basic matrix report with State as the row group, with year and quarter as t
Author:
MikeDavis
Date: 2/7/2011 Section:
Blog
tags :
interactive
,
matrix
,
sorrting
,
ssrs
SSRS Nulls in a
Matrix
In a recent SSIS class one my students ask me, if you are reporting off a table and using it in a matrix, does the matrix show null rows. The answer is yes. Here is an example table and the resulting report. This is the table used. All rows were selected
Author:
MikeDavis
Date: 7/14/2010 Section:
Blog
tags :
Matrix
,
Null
,
SSRS
Nested Blocked Layout to Stepped: SSRS Hint
The tablix feature provides a level of flexibility that can be very powerful to the knowledgeable SSRS user. It combines all of the aspects of a table, a list, and a matrix into one easy to manipulate tool. Now, if you were to look at the BIDS toolbox for
Author:
RCharCox
Date: 6/4/2012 Section:
Blog
tags :
Matrix
,
SSRS 2008R2
,
Table
,
tablix
Building a Report from the Ground Up - Part 4: Creating a Template & Displaying Data in a
Matrix
In Part 4 of Building a Report from the Ground Up, Dustin covers how to create a template to give your reports a consistent look and feel as well as how to use a Matrix to display data.
Author:
DustinRyan
Date: 12/28/2009 Section:
Article
tags :
Matrix
,
Report Development
,
SSRS 2008
Sorting Column Headers from Left to Right
Hello everybody! I wanted to show you how you can quickly sort your column headers when you bring back data that has the Month Name in your column groupings and your product name in your row groupings. Pop quiz….When I mention row and column groups, am I
Author:
SMcDonald
Date: 4/29/2011 Section:
Blog
tags :
Pragmatic Works
,
Reporting Services
,
Sorting Column Headers
,
SSRS
,
Sherri McDonald
Installing Data Tools and SSIS
DIEGOCTN, I have not done this particular configuration, however you may find this helpful: http://msdn.microsoft.com/en-us/library/ms144259.aspx -- how to install SQL 2012 from the command line. The switches listed on that page may help you determine how
Author:
KeithHyer
Date: 1/17/2013 Section:
Forum
tags :
Reporting Services
,
side-by-side
,
sql 2012 tools
,
upgrade
Google distance matrix using SSIS
Has anyone used the google distance matrix using SSIS? How to you set the xml to a variable? Thanks similar article: http://www.sqlmusings.com/2011/03/25/geocode-locations-using-google-maps-v3-api-and-ssis/ example string: http://maps.googleapis.com/maps/
Author:
nesmad
Date: 12/19/2012 Section:
Forum
tags :
google
,
google distance matrix
SQL Server Analysis Services Webinar
Join me tomorrow, April 2. 2013, at 11:00 PM EST for a free webinar which is part of an entire month of Back to Basics themed free training. This webinar is for anyone trying to understand the basics behind Analysis Services and how to get started design
Author:
DevinKnight
Date: 4/1/2013 Section:
Blog
tags :
Decision Matrix
,
Webinar
SSRS 2008
Norendra, If you have a method of filtering out the three different tables in your resultset, you can add a "filter" for the specified table in the properties of the matrix. Just remember inside your dataset, only one resultset is returned to the report l
Author:
briankmcdonald
Date: 8/27/2010 Section:
Forum
tags :
Datasets
,
Matrix
,
SSRS
GROUP BY WITH ROLLUP
The ROLLUP operator is useful when summarizing data. Its useful when generating reports that contain subtotals and totals. I use it a lot in my audit/daily queries, because table/matrix/tablix has subtotals. Basically ROLLUP generates a result set that sh
Author:
marcoadf
Date: 2/7/2010 Section:
Blog
tags :
FIFA
,
ROLLUP
,
subtotal
,
total
,
WITH ROLLUP
,
GROUP BY
Dynamic Columns in SSRS
Devin is absolutely correct. You will need to set the return columns at the report layer to the maximum amount of columns returned or have some method of grouping in the horizontal axis of the matrix. This is what I have done when using the results of a d
Author:
briankmcdonald
Date: 8/17/2010 Section:
Forum
tags :
Dynamic columns
,
Visibilty
,
SSRS
How to display the
Matrix
and its relevant Chart together on separated pages according to different groups?
You could try this: Add a blank row to the bottom of the matrix Merge the detail columns Insert a rectangle in the merged column Add your chart into the rectangle I think this would work for your situation, but you may have to add some filtering on the ch
Author:
briankmcdonald
Date: 6/9/2012 Section:
Forum
tags :
Brian K McDonald
,
Charts
,
Reporting Services
,
SQLBIGeek
Can I automatically create a chart based on the data of a matrix?
A matrix can have a chart in a cell which is located based on its column and row level group. So, technically it is generated dynamically. However, you will need to put the chart in with your group. For each grouping that is returned, you'll have a differ
Author:
briankmcdonald
Date: 6/9/2012 Section:
Forum
tags :
Brian K McDonald
,
Reporting Services
,
SQLBIGeek
Showing Total in some Cells (and hinding in some) in
Matrix
reports
This article is about showing/hiding total in cells in Matrix report in SSRS 2005.
Author:
ashishnaik1
Date: 1/5/2010 Section:
Article
SSRS 2008
If you have a field that identifies the tables and how you want the data broken out, you can then create three different matrices in your report and put a filter on each matrix so that only data from a single table is shown in each matrix. To place a filt
Author:
DustinRyan
Date: 8/27/2010 Section:
Forum
Learning/Relearning BI Part ...Um three
The hesitation is because I have no brain cells left. Three letters for you....M D X. Oye! Seriously tho, it's not as bad as I thought it was, and conceptually it is relatively straightforward. So we got in today and started in on Reporting Services using
Author:
mattcushing
Date: 6/23/2011 Section:
Blog
tags :
bi
,
SSAS
,
SSIS
,
noob
How to Export
Matrix
report to Multiple Excel Worksheets
I have a matrix report (2008) containing about 30 columns and 200,000 rows. I came accross an article on how to populate the data on multiple worksheets. http://msdn2.microsoft.com/en-us/library/ms157328.aspx It requires that you set a group with a grup e
Author:
mlevitt
Date: 6/1/2010 Section:
Forum
tags :
Matrix to Multiple Excel Worksheets
trying to calculate a group item's percent in relation to its group/column intersection total ... a scope issue
I'd built a matrix report that works well, but I want to include the Group1/yyyyMn cell's percent of the Group1/yyyyMm total for that group. I'm having a hard time figuring out the scope to use in an expression similar to: =myCount/Sum(Fields!myCount.Valu
Author:
Christian
Date: 12/9/2011 Section:
Forum
tags :
Aggregating
,
Scope
,
textrun
column / vertical scroll in table / matrix
I have a table / matrix that has a large number of columns. Can I add a scroll bar so the columns extend to multiple pages? I am using SSRS 2008 / SSRS report viewer Correction:Can I add a scroll bar to the table / matrix so the columns DON'T extend to mu
Author:
atresso
Date: 7/26/2010 Section:
Forum
tags :
table matrix scroll bar
Summing Values in a Tablix
I have included a picture of my current report. My issue is that the Total columns and rows are incorrect. They are currently the totals of all the rows that I process in the SQL in the background. I really need them to be the totals of the counts in the
Author:
bluize76
Date: 8/3/2011 Section:
Forum
tags :
ssrs
,
total
Exporting matrix report to CSV in SSRS 2005
I am having an issue with exporting a matrix to CSV in 2005. I have named all of the textboxes, but when I open the CSV file, the first row is just a bunch of commas (,,,,,,,,,,,,) and then the results are showing below that. I thought by naming the textb
Author:
britmccullar
Date: 10/20/2010 Section:
Forum
How to display a subreport on the same report when a link is clicked.
I have a report that has a matrix and a chart on it. I have the report setup so that when you click on the Reject field in the matrix it will open up the detail report in a seperate window displaying the detail for those rejects. The client would like to
Author:
danamatson
Date: 4/21/2010 Section:
Forum
SSRS 2008
Hi Brian McDonald, Thanks for your immediate response. My requirement is the folowing data is contained in data set.But the data set contains 3 data tables. i want to provide each data table for different matrix region.For the last region i want to provid
Author:
NarendraReddy
Date: 8/27/2010 Section:
Forum
SSRS 2008
I have data set. In that data set i have 3 data tables. I would like to take 3 matrix regions. how can i add these 3 data tables to matrix regions in ssrs 2008. Please help me. Thanks, Narendra
Author:
NarendraReddy
Date: 8/27/2010 Section:
Forum
Page 1 of 4 (97 items)
<< Prev
1
2
3
4
Next >>
Go to page:
[Go]