Sorry if I'm missing something obvious but I'm a newbie to SSRS (SQL Server 2012 R2) and SharePoint 2010.
My boss wants some basic reports from our internal SP site (list data) and I'm doing some research on SP + SSRS. Fields from more than one list are needed so I used the LookUp expression on Report Builder/BIDS to generate a sample report.
Here's the details. I've got two separate lists:
- PROJECT (containing columns "ProjectID" and "TasksID") and
- TASK (containing "TaskID", "Description" and "Hours")
I want to generate a basic report displaying the total Hours (mini tasks) spend on different Tasks grouped by Project, on which they are belonging to.
Here's what I got so far: http://imgur.com/b44mFRj (bypass the Greek nonsense, its Projects - Tasks - Description - Hours)
For the last 2 columns I used the expressions:
=Join(LookUpSet(Fields!TaskID.Value, Fields!TaskID.Value, Fields!Description.Value, "Dataset2"), " " + vbcrlf)
=Join(LookUpSet(Fields!TaskID.Value, Fields!TaskID.Value,Fields!Hours.Value, "Dataset2"),"" + vbcrlf)
The result is an array of strings so as a first step I joined them with Join and separated them by newline. This messed things up cause I cant get the totals I need (total Hours spend on Task, total Hours spend on Project, total Hours for all Projects etc).
Are there any ways to get the results on different cells so I can work with them?
Thanks - Sorry for the big intro.