Same report three times with different page headers. How? 1

[uczmeg]

Hi,

I need to be able to produce the same report three times, but with three different headers (eg 'Customer Copy', 'Shop Copy' etc).

Inserting the same report as sub reports a couple of times is a bit messy, also difficult to maintain as these reports are complex and prone to change.

I can't just call the report three times (with the changing text as a parameter) as they like having it appear in a window, and 3 windows wouldn't be acceptable as it means going through the print process three times.

I also can't see how to use the 'repeater' table method on this which I have sucessfully applied on various label reports.

Any suggestions on how to achieve this please?

Using Crystal 8.5

Thanks
Marc

 

[IdoMillet]

If you use the Repeater approach (as described in my FAQ: faq149-3226) all you need to do is restrict to 3 and group on (with page break before GH1) the Which_One column.

Create a formula that, based on the Which one value, returns a different GH1 title.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[uczmeg]

Thanks Ido.

But I have a problem with this.

I add the repeater table, and remove any links.

The go into select expert and add the following to my selection criteria:

3 >= {Repeater.How_Many}

I then refresh my report and I get:

ODBC Error: [Microsoft][ODBC Microsoft Access Druver] too few parameters. Expected 1

When I click OK, I get:

Error detected by database DLL

And then when I click OK crystal crashes!

Any ideas what I'm doing wrong?

 

[IdoMillet]

What is the data source for the main report? Same Access mdb?

Do you get the same error message if you remove the
{Repeater.How_Many} < = 3
from the record selection criterion?

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[uczmeg]

The repeater table is in the same mdb and it is using the same ODBC datasource.

If I just have the table added to the report, but no links or selection criteria to it then it just works as before.

There is another selection criteria where I match a field to a parameter.

Cheers
Marc

 

[uczmeg]

If I remove that parameter field I still get the same error.

 

[IdoMillet]

Since all tabbles are in the same mdb, you can easily create a query that uses a main report table and the repeater table. Then, use the query in your report.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[uczmeg]

Good idea.

Have botched it a little for now. Added an extra field to the header table which is in effect the number of copies. Set it to 3 and just link that to the repeater table.

Works fine.

Thanks for your time and help.

Cheers
Marc