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

Limiting the Number of rows displayed per table.

Dear Report Pros,

I am New to the world of report viewer.

Problem : I have placed 3 tables on top of each other on the rdlc document, done the binding to my business Objects every thing is ok EXCEPT THAT:

the number of rows displyed by the top table are big to the point that the table would stretch Vertically (grow) to accomodate them and It would cover the other 2 tables under it , so basically the first table gets expanded so much to the point that it consumes the rest of the page and hiding / moving the other 2 tables.

I NEED a WAY to LIMIT the number of rows to be displayed per each table regardless of the resultset size, for example I just need to display the first 4 rows of the result comming to this table which might contain 20 rows, and I am hoping that there is a Scrolling / Next mechanizm that that if the user is interested to review the rest of the resltset in this particular table he can.

I understand that this can be achieved through the use of Grups and expressions, but I am not sure how to do this exactly what and where to I place my expression on the table.

Thanks very much in advance for your time and help.

HI,

I suppose you need a custom page break in this scenario. You can have a look at "Page Break " section in the following article:

http://msdn2.microsoft.com/en-us/library/ms251668(VS.80).aspx

|||

HI,

We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

Limiting tables displayed in new window for SQL 2000 Enterprise Manager

Can anyone tell me if there's a way to create new windows from the
tables section of a database in Enterprise Manager such that I can
limit the tables included in that window? Ultimately, I'm looking for
a solution whereby I can group tables, stored procedures, etc. into
logical groups that can then be displayed using different MMC
consoles. I'm looking for either a GUI-level or programatic approach.

Thank you,
Dax WestermanUsing EM as is no. You can build your own version of EM though and display
whatever you want using SQL-DMO.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Dax Westerman" <daxw@.bellsouth.net> wrote in message
news:273bcb55.0404300435.7ac4ba6b@.posting.google.c om...
> Can anyone tell me if there's a way to create new windows from the
> tables section of a database in Enterprise Manager such that I can
> limit the tables included in that window? Ultimately, I'm looking for
> a solution whereby I can group tables, stored procedures, etc. into
> logical groups that can then be displayed using different MMC
> consoles. I'm looking for either a GUI-level or programatic approach.
> Thank you,
> Dax Westerman

Limiting Number of Items Displayed in Report

ey there, quick question...

is there any way to limit the number of items displayed in a single page?

say i want to display up to 10 items, and then the rest of the items are then displayed on the next page?

any help and suggestions would be greatly appreciated.

thanks!

Tim

It's possible if you group on an expression rather than a field:

nest your table inside a list control|||thanks for replying sir

i got it already. thanks very much for your help|||I posted a working example in the other thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=157571&SiteID=1

Limiting no of rows in a page

Hi All
We have requirement where a user restrict no of rows which can be displayed
on a page on a report in this report we will be showing invoices for the
check on the top and corresponding check at the bottom. Here a user can set
no of invoices to be displayed on a page. This will always be less or equal
to actual limit which can be displayed.
For example we have 15 invoices but limit set to show on a page is 6 then
report should display only 6 rows in 1st page and another 6 on second page
and remaining on 3rd page.
Can any body let me know how can we restrict no of rows to be displayed on
single page. and also show check at the bottom.
Thanks in advance
Thanks and regds
Rehan Mustafa KhanI have placed several examples of this on www.msbicentral.com Go to
downloads,Reporting Services, RDL
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rehan Mustafa Khan" <RehanMustafaKhan@.discussions.microsoft.com> wrote in
message news:E46DEAC4-A036-4D6B-9052-C2218B2ED052@.microsoft.com...
> Hi All
> We have requirement where a user restrict no of rows which can be
displayed
> on a page on a report in this report we will be showing invoices for the
> check on the top and corresponding check at the bottom. Here a user can
set
> no of invoices to be displayed on a page. This will always be less or
equal
> to actual limit which can be displayed.
>
> For example we have 15 invoices but limit set to show on a page is 6 then
> report should display only 6 rows in 1st page and another 6 on second page
> and remaining on 3rd page.
>
> Can any body let me know how can we restrict no of rows to be displayed on
> single page. and also show check at the bottom.
>
> Thanks in advance
>
> Thanks and regds
> Rehan Mustafa Khan
>