Line Numbers in Table

Sorry but new to RS and need to have each detail line in a table to be
numbered. Can somebody please help me with some code or point me in the
right direction. Not totally sure if it's done via expression or not.Try using the Function Rownumber.
HTH; Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Nat Johnson" <NatJohnson@.discussions.microsoft.com> schrieb im Newsbeitrag
news:AB24ED87-BBF6-4A3D-A8A5-4770AF92CB54@.microsoft.com...
> Sorry but new to RS and need to have each detail line in a table to be
> numbered. Can somebody please help me with some code or point me in the
> right direction. Not totally sure if it's done via expression or not.

Line Count in Crystal Report

Is there any function or way to get the no of lines displayed in the detail section of the report.

Hlp me.

Thx in advance.

Ashok Sis that not a group function.. something you would put in the group footer (a total)?

i cant be too specific because im still learning crystal myself!|||You need to use two formulae
Formula1 @.Reset having the code
Numbervar n;
WhilePrintingRecords;
n:=0;
Formula2 @.Count having the code
Numbervar n;
WhilePrintingRecords;
n:=n+1;
Now Place Formual1 at PageHeader
Formula2 at Details Section.
Now the last value is the total number of records of that page|||Or you could just use the inbuilt RecordNumber function. It works fine if you are not hiding any records in your record set

- Jukka|||My Problem is not getting the recordcount. I need to get the line count.
A Record may be displayed in multiple lines.

To be Specific, I have four Detail sections, and in that for three sections i have used can grow property except the first one. In this case I need to get the Line nos of the detail section.

Thx,

Ashok

Line break after group

I need to insert a line break in a detail row after certains groups of data.
example:
Week Day Detail
1 Mon 1
1 Tue 1
1 Wed 2
1 Thu 2
1 Fri 1
2 Mon 1
2 Tue 1
2 Wed 2
2 Thu 2
2 Fri 1
I need it to have a line break after week 1, 2, etc. Also, the detail column
has aggregates, runningvalues etc. There can't be a runningvalue on the line
break. I want the data to look like this:
Week Day Detail
1 Mon 1
1 Tue 1
1 Wed 2
1 Thu 2
1 Fri 1
2 Mon 1
2 Tue 1
2 Wed 2
2 Thu 2
2 Fri 1I would create a group on Week with no group header but a single blank row
group footer. This should be your innermost group. Outer groups will
calculate the aggregates properly. You'll need to scope any running values
to outer groups.
"Dutch" wrote:
> I need to insert a line break in a detail row after certains groups of data.
> example:
> Week Day Detail
> 1 Mon 1
> 1 Tue 1
> 1 Wed 2
> 1 Thu 2
> 1 Fri 1
> 2 Mon 1
> 2 Tue 1
> 2 Wed 2
> 2 Thu 2
> 2 Fri 1
> I need it to have a line break after week 1, 2, etc. Also, the detail column
> has aggregates, runningvalues etc. There can't be a runningvalue on the line
> break. I want the data to look like this:
> Week Day Detail
> 1 Mon 1
> 1 Tue 1
> 1 Wed 2
> 1 Thu 2
> 1 Fri 1
> 2 Mon 1
> 2 Tue 1
> 2 Wed 2
> 2 Thu 2
> 2 Fri 1

Line across Table

How do I get a line to go across the detail in a table?
If I set the underline for each cell, I get the value in each cell
underlined, I don't want that. I want an underline to go across the detail
section of my table. So, the user can see a line between each row in the
detail.Mike, you need to set the border style for the detail row cells. Select the
cells then set the bottom to solid.
=-Chris
"Mike L" <MikeL@.discussions.microsoft.com> wrote in message
news:E745059D-A68A-4BCD-B1C1-689956BA1351@.microsoft.com...
> How do I get a line to go across the detail in a table?
> If I set the underline for each cell, I get the value in each cell
> underlined, I don't want that. I want an underline to go across the
> detail
> section of my table. So, the user can see a line between each row in the
> detail.

Limit rows in detail section

I'd like to limit the number of rows in my detail section based on a
parameter.
For example, if I might have region and state as groups, and for each
store
I wanted to show the top 5 products (obviously different products in
each store)
by number sold.
But it could be 10 instead of 5 depending on what the user requested.
Any quick thoughts about this?
TIA,
JimMy first choice would be to limit the sql using a dynamic query ie
="select top " & Parameters!NumRows.Value & " * from mytable"
Of course the sql would have to be much fancier to get the top N for each
group..
The other thing you could do is filter in the group..
something about runningcount for the Group < Parameters!NumRows.value
should do it..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jhcorey@.yahoo.com" wrote:
> I'd like to limit the number of rows in my detail section based on a
> parameter.
> For example, if I might have region and state as groups, and for each
> store
> I wanted to show the top 5 products (obviously different products in
> each store)
> by number sold.
> But it could be 10 instead of 5 depending on what the user requested.
> Any quick thoughts about this?
> TIA,
> Jim
>