Report equivalent of a <BR> or a vbCrLf

What do I have to embed in my data to get a report cell to line break?

If I have:
ABC?XYZ

what do I have to store in the ? position to get it to look like:
ABC
XYZ

in my report?

Try with \n or \r or \n\r.
But I don't understand how you convert ? to this characters. Are you evaluating an expression or this is data from a dataset?
If you are evaluating an expression put "first string"+CHAR(13)+"last string"
Can you be more specific?|||

The data is from a Dataset. What I'm trying to figure out is what can I put in the data to make a Report perform a line break? Whatever I put in there is just take as part of the data. I've tried putting:ABC\n\rXYZ and that's exactly what shows up in the cell on the report.

|||If you are using T-SQL and you are making the dataset from a query try this:
SELECT field1+CHAR(13)+field2
or
SELECT field1+CHAR(10)+CHAR(13)+field2
tell me if it works!!!|||Yeah close enough. I embeded char(13) & char(10) when I save the data and it displayed fine in the report.

Thanks
Steve|||I think you can also split the column in an expression and use vbcrlf. e.g string1 & vbcrlf & string2|||It's faster solving that in the dataset than in the report side.
But it's valid too and it's good to know as many ways to solve problem as you can.sql

Report Builder Designer problem

Hello,
When I create a new matrix report in the Report Builder, then the height of
the title cell of the dimension on the left of the matrix, is half height.
If you want to see, I have a pdf to illustrate it.
Is this a bug in the designer? Or can I solve this?
Regards,
JaapHello Jaap,
I would like to get the screenshot to understand this issue better.
And I also would like to know whether the title cell in the Preview is
still half height?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Jaap,
I did not reproduce this issue. When I add a column into the Report
Builder, it appeared correct.
Did you applied the latested services pack for reporting services?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

ReporItems referring to a cell containing a subreport?

Hi guys,

i have a column in a report that must calculate a percentage based on two columns that follow them. I am aware that i can use the ReportItems! collection for this, but one of the columns i need to reference is actually a subreport because its data comes from a different source. It is just a single cell subreport, which makes it appear totally part of the table it is in. Is this possible? Just to be clear, what i want is an expression like this in my cell:

= FormatPercent( ReportItems!CurrentEarnings / ReportItems!BudgetedEarnings )

the BudgetedEarnings cell is actually a subreport, but all i want is the text it is showing.

Thanks for any help or suggestions!

sluggy

No, referring to a report item in a subreport is not allowed.

|||Dang! Thanks |||Hi, how did you get around this issue? I am trying to do the same thing.

ReporItems referring to a cell containing a subreport?

Hi guys,

i have a column in a report that must calculate a percentage based on two columns that follow them. I am aware that i can use the ReportItems! collection for this, but one of the columns i need to reference is actually a subreport because its data comes from a different source. It is just a single cell subreport, which makes it appear totally part of the table it is in. Is this possible? Just to be clear, what i want is an expression like this in my cell:

= FormatPercent( ReportItems!CurrentEarnings / ReportItems!BudgetedEarnings )

the BudgetedEarnings cell is actually a subreport, but all i want is the text it is showing.

Thanks for any help or suggestions!

sluggy

No, referring to a report item in a subreport is not allowed.

|||Dang! Thanks |||Hi, how did you get around this issue? I am trying to do the same thing.