Group Wise Page Numbers

Hi,
Iam printing a report having grouping, a group will spread over many pages and I want No. of pages for that group and also page number. for ex.

A report has 50 pages,

group 1 of 20 pages
group 2 of 10 pages
group 3 of 20 pages

I want No. of Pages 20 and current page as 1 of 20, 2 of 20. and for the second group again No. of Pages 10 and current page as 1 of 10, 2 of 10 and so on.

How do I do this.? can anyone help me on this.

thanks for ur suggestions in advance.Hi,

put Special Field "Page N of M"

now, Open Section Expert and navigate on first group level. there is one event "Reset Page Number After". Write below code on that

eg.
Previous({S_EVT_ACT.OWNER_LOGIN}) <> GroupName ({S_EVT_ACT.OWNER_LOGIN})

Using this code u get group wise Page N of M value.

-Yags|||Thanks ! it worked really.
I have one more question, which book is good for developing reports under vb 6.0 using crystal reports. suggest me one.

thanks again.|||Hi,

I have not prefered any book for Crystal Reports b'caz there is no book which
suitable for real crystal report development.

Sorry and most welcome for any issue regarding crystal reports

-Yags

Grid vs Text output

In SQL Query Analyzer, there is a Query drop down window that gives you
the option to change the output from grid to text for printing if
needed. My question is, can this be programmed so a stored procedure
will always print in text without having to manually change the window
each time the procedure is run? I could find nothing under the logical
searches in books online.

Thanks JABYou can modify the QA to use text or use a grid regardless what you are
running in the QA. You can't set default behavior for each object or
each type of object.

Adi
jab wrote:

Quote:

Originally Posted by

In SQL Query Analyzer, there is a Query drop down window that gives you
the option to change the output from grid to text for printing if
needed. My question is, can this be programmed so a stored procedure
will always print in text without having to manually change the window
each time the procedure is run? I could find nothing under the logical
searches in books online.
>
Thanks JAB