Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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:

  1. PROJECT (containing columns "ProjectID" and "TasksID") and
  2. 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)

and

=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.

share|improve this question
    
I think I'll have to code.. These expressions are too limiting. Please guide me here: link –  LePhleg Mar 29 '13 at 13:17
add comment

1 Answer

Here is a post that explains how to do this via code in the report: "Sum Result of SSRS LookupSet Function" http://salvoz.com/blog/2013/05/27/sum-result-of-ssrs-lookupset-function/

share|improve this answer
    
Please don’t add just a link as answer to a question. If the link breaks, the answer you provided will not be useful for future visitors. Provide an answer of your own and use the link as reference. If needed, you can block quote the content from your link. More information is found in our help center, especially How do I write a good answer –  Benny Skogberg Mar 20 at 6:59
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.