format lookupset expression

0
votes

In Report Builder, I have an expression using the lookupset function that pulls back either nothing, a date and description, or several dates and several descriptions. The data it is pulling is correct. I have searched this forum and MSDN. Using what I've found in both places, I have tweaked my expression to the following.

My expression: 

=Join(Lookupset(Fields!ProjectName.Value,
                Fields!ProjectNames.Value,
                Fields!TaskBaseline0FinishDate.Value & " - " & Fields!TaskName.Value, 
                "DsActivitiesCompleted"))

However, when this is displayed it doesn't have a carriage return, it just puts one after another after another. Example Below:

example of how it currently looks

08/05/2015 – Milestone: Kickoff meeting Complete 08/18/2015 – Milestone: PMT Test Planning Complete 08/26/2015 – Milestone: Set CCD Date 08/26/2015 – Sprint 0 Complete 09/18/2015 – Milestone: Wave 1 Complete 09/28/2015 - Milestone: Wave 2 Complete

What I want it to look like is below. If possible I would like to have bullet points in front of each line as well.

Example of how it should look

My question is how do I get it in the format above?

Thanks, MM

1
reporting-servicesssrs-2012

1 Answers

1
votes

You have missed the final (optional) argument of JOIN which states which character you want to use to join your string together. Changing your expression tyo use vbCrLf (the VB new line code) as follows

=Join(Lookupset(Fields!ProjectName.Value,
            Fields!ProjectNames.Value,
            Fields!TaskBaseline0FinishDate.Value & " - " & Fields!TaskName.Value, 
            "DsActivitiesCompleted"),
            vbCrLf)

Gives this output

enter image description here

Update

Use the below to use Chr(183) as a bullet character for each new line as well

=" " + Chr(183) + " " + 
 Join(Lookupset(Fields!ProjectName.Value,
            Fields!ProjectNames.Value,
            Fields!TaskBaseline0FinishDate.Value & " - " & Fields!TaskName.Value, 
            "DsActivitiesCompleted"),
            vbCrLf + " " + Chr(183) + " ")