Linefeed Issue

All,
Why does chr(13) +chr(10) create a new line feed in Visual Studio, but does
not when you render using IE with the HTML viewer?
Any ideas'
JimWhich build are you running?
Did you try using the predefined VB constant VbCrLf ?
E.g. ="First line" & VbCrLf & "second line"
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim_OLAP" <JimOLAP@.discussions.microsoft.com> wrote in message
news:0EF1FE67-E355-49B6-BB08-18C247E7E321@.microsoft.com...
> All,
> Why does chr(13) +chr(10) create a new line feed in Visual Studio, but
> does
> not when you render using IE with the HTML viewer?
> Any ideas'
> Jim
>|||Robert,
Thanks for the reply; Yes, I tried the Vb constant but I still get
inconsistent line feeds in IE. As a solution, I had to make each line the
same character length using a combination of left() and format().
Thanks,
Jim
"Robert Bruckner [MSFT]" wrote:
> Which build are you running?
> Did you try using the predefined VB constant VbCrLf ?
> E.g. ="First line" & VbCrLf & "second line"
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jim_OLAP" <JimOLAP@.discussions.microsoft.com> wrote in message
> news:0EF1FE67-E355-49B6-BB08-18C247E7E321@.microsoft.com...
> > All,
> >
> > Why does chr(13) +chr(10) create a new line feed in Visual Studio, but
> > does
> > not when you render using IE with the HTML viewer?
> >
> > Any ideas'
> >
> > Jim
> >
>
>

Line numbers in Report Builder

I have a report in which the user community would like line numbers associated with each row. Has anyone done this or have any ideas how to accomplish this?

Line Item Manufacturer
1 Mazda
2 Ford
3 BMW

ThanksThis seems like something you want to do in the sql query rather than the report. Not sure, exactly how...|||Since you drag elements into the design area and Report Builder is not based on a query, there is no way to create line item numbers within Report Builder.

Is that what you are saying?|||Hi,

You can use RunningValue function as the text value of the line number column.

If you want a numbering for rows within a dataset, you can use

=RunningValue(1, SUM, "Employees")

where Employees is the dataset name.

If you have groups in your reports, say one of the groups has a name "EmployeesByCity", then you can replace the last part of the RunningValue with this group name shown as below

=RunningValue(1, SUM, "EmployeesByCity")

You can check the below link for a sample

http://www.kodyaz.com/article.aspx?ArticleID=40

Eralper|||Thank you for your assistance. "RunningValue" is not available in Report Builder.|||

I've got a similar issue that RunningValue won't work for. Basically, what the business users want is a line number for each line in the report. Independant of the groupings. I believe this has to be done during the rendering of the report as it has to cross groups after all the report processing has been done. Here's a small sample of what they want it to look like.

Column A Column B Column C

1 Group 1 Header

2 Group 2 Header

3 Detail

4 Detail

5 Detail

6 Group 2 Footer

7 Group 1 Footer

The count can reset at the begging of each page, or continue, doesn't really matter. I'm trying everything I can think of.

Any ideas out there?

|||

If you add RowNumber("DSName") in the first column then it should work...

|||

Unfortunately, it's not that easy. Doing that, you get the total #f rows for each group on the group level headers. I need the count to be a straight rendered line number count and not be tied the underlying data set or grouping structure.

Line numbers in Report Builder

I have a report in which the user community would like line numbers associated with each row. Has anyone done this or have any ideas how to accomplish this?

Line Item Manufacturer
1 Mazda
2 Ford
3 BMW

ThanksThis seems like something you want to do in the sql query rather than the report. Not sure, exactly how...|||Since you drag elements into the design area and Report Builder is not based on a query, there is no way to create line item numbers within Report Builder.

Is that what you are saying?|||Hi,

You can use RunningValue function as the text value of the line number column.

If you want a numbering for rows within a dataset, you can use

=RunningValue(1, SUM, "Employees")

where Employees is the dataset name.

If you have groups in your reports, say one of the groups has a name "EmployeesByCity", then you can replace the last part of the RunningValue with this group name shown as below

=RunningValue(1, SUM, "EmployeesByCity")

You can check the below link for a sample

http://www.kodyaz.com/article.aspx?ArticleID=40

Eralper|||Thank you for your assistance. "RunningValue" is not available in Report Builder.|||

I've got a similar issue that RunningValue won't work for. Basically, what the business users want is a line number for each line in the report. Independant of the groupings. I believe this has to be done during the rendering of the report as it has to cross groups after all the report processing has been done. Here's a small sample of what they want it to look like.

Column A Column B Column C

1 Group 1 Header

2 Group 2 Header

3 Detail

4 Detail

5 Detail

6 Group 2 Footer

7 Group 1 Footer

The count can reset at the begging of each page, or continue, doesn't really matter. I'm trying everything I can think of.

Any ideas out there?

|||

If you add RowNumber("DSName") in the first column then it should work...

|||

Unfortunately, it's not that easy. Doing that, you get the total #f rows for each group on the group level headers. I need the count to be a straight rendered line number count and not be tied the underlying data set or grouping structure.