Several options:

- add either a DISTINCT to your query, so that it returns one row for each unique set of values

- add a group to your report and put...

Change the format of the textbox from c2 (currency, two decimal places) to n2 (number, two decimal places)

This video shows you how to create subreports

https://www.youtube.com/watch?v=6S8Zzqthsbw

Given that what you're trying to do is conceptually very simple, you could do this really easily if you created a table in TempDB, indexed it and added your value...

Given that what you're trying to do is conceptually very simple, you could do this really easily if you created a table in TempDB, indexed it and added your value...

Please give an example of what "redundant" means to you based on the data you provided. Apologies, but "doesn't work" doesn't mean very much. In what context? ...

If you had the wizard configure SSRS for you, you're all set. Are you using thee installation to learn or to work? If it's for work, they may...

Nor with certifications. You just have to get experience building databases and dealing with problems that come up.

Since nobody else has ventured an answer, I guess I'll try it...

Importing the HTML text shouldn't be a big deal, because it's just ASCII text. If you declare...

Cant read it - maybe because I only have Excel 2010. Another reason to post table definitions and inserts for sample data.

If you really need help, read this article...

Can't help thinking this would be a whole lot easier if you had a date field in the EmployeeRoles table...

Then you could just get the EmployeeID and Role With the...

The union query was just to create records I could manipulate based on the data you provided. I added the identity column because I needed a way to connect...

How do you know which values go together? Is there a primary key for the table that matches the records?

DOB LNAMEFNAMEMNAME

20140109 NULLNULL NULL

NULL NULLNULL JACK

NULL NULLJOHN NULL

NULL SMITHNULL NULL

End...

No idea what's going on. Any chance you can upload a copy of the report with some fake data embedded? The data source would be a union query, e.g.

SELECT...

Here's how to post data so people can mock up your data:

SELECT '3-31-2013' AS EOM_Date

, 'RA' AS Logs

, 'Valid' AS Reason

, 5 AS Units

UNION ALL

SELECT '3-31-2013'

, 'MA'

, 'Need to Complete'

,...