<div>
Do you need to <a href="https://msdn.microsoft.com/en-us/library/dd207149.aspx" rel="ugc">add a Matrix </a>to your report?<br />
<br />
If you already have a Matrix, you may need to add a grouping. &nbsp;The article I linked above also has instructions for grouping.
</div>


Do you need to add a Matrix [https://msdn.microsoft.com/en-us/library/dd207149.aspx]to your report?

If you already have a Matrix, you may need to add a grouping.  The article I linked above also has instructions for grouping.

<div>
No matrix. Just show a few lines of data..the data is contact name. Nothing complicated.
</div>


No matrix. Just show a few lines of data..the data is contact name. Nothing complicated.

<div>
<div class="content wysiwyg-content">
My first SSRS project is going well :)<br />
<br />
Now, I want to show several rows of data for a field. I added a table and the SQL statement I added to the dataset brings back 2 different rows of data. This is correct. I see it in SQL Management.<br />
<br />
Now, I open the report, and I see 2 rows of data (2 rows is correct) but the 2 rows are the same. It's not like what SQL shows. I even tested the SSRS dataset and it brings back the correct rows. It's just when it's displayed in the table that the first row is repeated.<br />
<br />
This is SQL 2014<br />
<br />
So, am I using the correct control in SSRS? This is how it looks like:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/03_w12/1086798/ssrs_table.png" target="_blank" title="table (3 KB)"><img alt="table" class="file-block lazyload" style="max-width: 488px;" data-src="https://filedb.experts-exchange.com/incoming/2016/03_w12/1086798/ssrs_table.png" /></a>
</div>
</div>


ssrs_table.png

My first SSRS project is going well :)

Now, I want to show several rows of data for a field. I added a table and the SQL statement I added to the dataset brings back 2 different rows of data. This is correct. I see it in SQL Management.

Now, I open the report, and I see 2 rows of data (2 rows is correct) but the 2 rows are the same. It's not like what SQL shows. I even tested the SSRS dataset and it brings back the correct rows. It's just when it's displayed in the table that the first row is repeated.

This is SQL 2014

So, am I using the correct control in SSRS? This is how it looks like:



To show rows of data, I should use Table?

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.