• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

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
0
Mr_Shaw
Asked:
Mr_Shaw
  • 5
  • 3
1 Solution
 
VikramMullickCommented:
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.
0
 
Mr_ShawAuthor Commented:
the option to hide duplicated is greyed out.
0
 
Auric1983Commented:
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

0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Mr_ShawAuthor Commented:
still not working....
0
 
Auric1983Commented:
Can you take a screenshot of your table in design mode?

Check the textboxes and see if you see something along the lines of this

=First(Fields!EmployeeKey.value)

0
 
Mr_ShawAuthor Commented:
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.
0
 
Mr_ShawAuthor Commented:
thanks
0
 
Auric1983Commented:
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)

0
 
Mr_ShawAuthor Commented:
thanks for the tip.

do you think you could help me with my other question

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_24288565.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now