0

I have an SSRS report with a dataset that I cannot modify. I can only change the report's format.

I am trying to figure out how to have one of the reports fields display its many values inline in a list or csv fashion. Right now it prints a value and does a line break, then the next value and another line break, and so on... I would like my values to print without the line breaks.

I've tried using the Replace function in an expression (replace vbcrlf with ", ") with no success...

theog
  • 1,064
  • 2
  • 20
  • 33
  • Why can't you change the dataset? – Jeroen Apr 25 '13 at 19:42
  • Also: what is your current report structure? What controls are you using for the current layout? – Jeroen Apr 25 '13 at 19:42
  • I can't change the dataset because it's a report embedded in a vendor-provided product. I am only allowed to change the layout/format of the report. I can use any appropriate control. It's currently a textbox in a tablix. – theog Apr 25 '13 at 19:49

2 Answers2

1

You're not quite providing enough information to reliably answer the question. Most likely, your question is a duplicate of this question, and my answer there will answer your question as well. The basics are:

  1. Create a multi-value parameter @MyParameter
  2. Set the default values for the parameter to be retrieved from your dataset
  3. In your textbox use the expression =Join(Parameters!MyParameter.Value, ", ")

Same disclaimer holds here as well: if there are a lot of values this solution may not work very well.

Community
  • 1
  • 1
Jeroen
  • 60,696
  • 40
  • 206
  • 339
1

It sounds like you just want an expression to remove the line feed characters in your source data so that it prints on one line. You'll probably need a bit of trial and error to work our what the characters actually are but you probably want to start with replacing:

vbCrLf

vbLf

vbCr

More on replacing line breaks in this question

You could create a Code function in the report to do the replacing, similar to the answer in this question.

Community
  • 1
  • 1
Nathan Griffiths
  • 12,277
  • 2
  • 34
  • 51