February 5, 2009 at 9:49 am
Hi. I am fairly new to Reporting Services and wanted to find out how to make my reports show all data, even when duplicates exist. In example, if I am reporting on employees and their total sales and include other information like their office site or other; the report runs and returns the table and there is a lot of white space. It appareas as though the user has multiple sales records, so they are listed once, at the start of their data, then not again. Yet, in some instances, the employee's name appears multiple times (with the same spelling and casing).
The second issue is with a formula. I am simply trying to join the firstname and lastname in a single new field. I create the new field and use the following: firstname + lastname. I get an error that this is an invalid argument. What am I missing? Please help.
February 5, 2009 at 10:02 am
If you run the raw sql output, does it show the duplicates? You may need to share your select statement with us....
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply