Grouping by Page Count in CR 8.5

Datasource: Access 2000
CrystalReports: 8.5
Language: Visual Basic 6

I wonder if someone can help with this.

I am have a report that collates customer details and it is currently grouped on customer number.

These details are used to generate mail shots and it is now a requirement that the report is ordered by page count.

Is there a way that the total number of pages printed for each customer number can be used to sort the report.

So far the formulas I have tried cannot be completed because the report needs to generated first so the page numbers can be calculated.

The solution can be either in code or in the report but if in the report I need to be able to obtain the page totals for each customer number into code.

Many thanks in advance.Do you want to know how many pages does Report have for each Customer?sql

Group header won't repeat

I have a report with a List with Group Headers i want to repeat on every
page, even if the group spans more than one page.
-In the Visual Studio preview the same group header won't repeat
on every page.
-In the Reporting services HTML preview the group header WILL
repeat on every page (even if the group is the same).
-Exporting the report to PDF format won't repeat the List's Group Header
on every page.
I have Reporting services and Visual Studio 2003.I ran Reporting services
SP2 on all machines.Hi there
U can use the TableRow Property: RepeatOnNewPage=True In the Layout section.
"FattoreK" wrote:
> I have a report with a List with Group Headers i want to repeat on every
> page, even if the group spans more than one page.
> -In the Visual Studio preview the same group header won't repeat
> on every page.
> -In the Reporting services HTML preview the group header WILL
> repeat on every page (even if the group is the same).
> -Exporting the report to PDF format won't repeat the List's Group Header
> on every page.
> I have Reporting services and Visual Studio 2003.I ran Reporting services
> SP2 on all machines.|||we don't use table, but "list".
the problem is that the group header repeats in preview and html mode,
but doesn't do it in pdf mode.
"ש×?×?×?" wrote:
> Hi there
> U can use the TableRow Property: RepeatOnNewPage=True In the Layout section.
> "FattoreK" wrote:
> > I have a report with a List with Group Headers i want to repeat on every
> > page, even if the group spans more than one page.
> >
> > -In the Visual Studio preview the same group header won't repeat
> > on every page.
> > -In the Reporting services HTML preview the group header WILL
> > repeat on every page (even if the group is the same).
> > -Exporting the report to PDF format won't repeat the List's Group Header
> > on every page.
> >
> > I have Reporting services and Visual Studio 2003.I ran Reporting services
> > SP2 on all machines.

Group Count

Good Morning.

This should be fairly easy but for the life of me, I can't figure it out...

I am using SQL reporting Services 2000 and Visual Studio 2003.

I have a very simple report that is grouped by a users name. What I can't figure out is how to get the count of records in a group. I have already got the total number of records for all groups but I also need to have the Group count as well.

Any help would be greatly apprceiated

Try the inscope function?

http://devauthority.com/blogs/chrisslatt/archive/2005/07/06/Reporting_Service_Using_InScope_to_do_custom_subtotals.aspx

|||

For table like this:

Table Header:
Group Header:
Detail:
Group Footer:
Table Footer:

I do the following: add COUNT() into Group Footer line. It will calculate you number of rows for each group. If you put COUNT to Table Footer it will calculate you total number of rows. It's for simple situation. In case of complicated calculation and table structure you can use InScope, as Andrew told you.