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 connected with Store Procedure in asp.net

I have report which is connected with a parameterised StoreProcedure.The rpeort is called from asp.net page.

In asp.net page i have a text box where user give the date parameter, and have a button named "Download".After giving the data parameter in text box if user click on download button the report would be downloaded as per data parameter to the user selection path.

Can any one help how it should be possible.You can use SQLQuery property of the CR and write query based on the user selection and pass itsql

Report Builder field calculate problem

Hi,
I have a problems with the field calculations. NOT Work.
When i tried calculate total sales for a specific store, this duplicate or
3, 4, 5 times the total sales.Hello Guillermo,
I would look closely at you data source view and check that there is
nothing funny with the table joins you are basing your model on. This
is the main place where something goes wrong and causes the issue.
I would also review the report you are creating and check there are no
many to many possibilities with entries you have selected.
If you are still not having any luck have a look at the blog entry
describing how to trap the SQL generated by Report Builder.
http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx
Hope this helps
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/

Report Builder -- Can your data source be an Oracle database

Hi again -- I am just trying to set up my first Report Model. We use Oracle
to store all of our data that we want to report on (we use Reporting
Services). Can I build a report model for Report Builder using an Oracle
database as the data source? When I try to create the datasource, it looks
like it can only accept a SQL Server database.
Thank you,
--
LaurieTLaurie,
Unfortunately the SQL 2005 Model Designer can only generate report model
projects from SQL Server databases.
"LaurieT" wrote:
> Hi again -- I am just trying to set up my first Report Model. We use Oracle
> to store all of our data that we want to report on (we use Reporting
> Services). Can I build a report model for Report Builder using an Oracle
> database as the data source? When I try to create the datasource, it looks
> like it can only accept a SQL Server database.
> Thank you,
> --
> LaurieT