asked on

SSRS- repeatng rows

I have just built my first report without using the SSRS report wizard.

I built my dataset using the following SQL:

SELECT EmployeeKey, FirstName, LastName, MiddleName
FROM DimEmployee

I placed a table on the Layout view and inserted a number of fields into the details section.

However the results which I get is repeating rows. Here is a screenshot of my problem.
Is there a setting which I have missed.

I have followed the basic outline of the tutorial

http://msdn.microsoft.com/en-us/library/ms167559(SQL.90).aspx

SSRS-Repeating-Rows.bmp

VikramMullick

It looks like table DimEmployee has more columns than the 'EmployeeKey, FirstName, LastName, MiddleName'.
Hence your select query must be giving multiple rows.
If you wish to hide , duplicates , then for each textbox , go to properties
and there is a checkbox by the name hide duplicates. Tick it.

Mr_Shaw

ASKER

the option to hide duplicated is greyed out.

Auric1983

Mr.Shaw

one way to ensure you get unique rows for the report would be to modify your dataset to use the a query like the one below. I added the word "Distinct" that will give you a unique list so you shouldn't end up with duplicates.

select distinct EmployeeKey, FirstName, LastName, MiddleName
FROM         DimEmployee

Open in new window

Mr_Shaw

ASKER

still not working....

ASKER CERTIFIED SOLUTION

Auric1983

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mr_Shaw

ASKER

yes it was =First(Fields!FirstName.Value)

I changed it to =Fields!FirstName.Value and It worked...

It seems that =First(Fields!FirstName.Value) is the default when I dragged and dropped the field from the dataset...

Thanks for your help.

Mr_Shaw

ASKER

thanks

Auric1983

If you create a table on the report you need to be aware that it creates a header/detail/ and footer row automatically.

You also need to assign the table to your dataset in the properties window prior to dragging in your fields. (If you don't it will use the "First" prefix)

Mr_Shaw

ASKER

thanks for the tip.

do you think you could help me with my other question

https://www.experts-exchange.com/questions/24288565/SSRS-Enable-Matrix-drilldown-manual.html