Question Crystal Report - Create Report???

[mac-duff]

Hi,

I am trying to create as I think an easy report.

I use two tables:

Equipos
-IdEquipo
-Equipo

CambioTurno
-IdEquipo
-FechaHora
-Dia

Now I would like to to place on each site in the page header the time and the name but it every time just display the name once, its like a function that suppresses it.

FechaHora            	IdEquipo	Dia
05/03/2010 18:21:50	1	05/03/2010
05/03/2010 18:23:49	1	05/03/2010
05/03/2010 18:24:16	1	05/03/2010
05/03/2010 18:25:54	1	05/03/2010
05/03/2010 18:26:01	3	05/03/2010
08/03/2010 13:31:45	2	08/03/2010
11/03/2010 12:47:30	1	11/03/2010
24/03/2010 11:46:57	2	24/03/2010
24/03/2010 11:47:31	3	24/03/2010
24/03/2010 11:48:06	2	24/03/2010
24/03/2010 11:57:40	2	24/03/2010
24/03/2010 16:49:34	3	24/03/2010
24/03/2010 21:53:29	1	24/03/2010
24/03/2010 21:58:54	1	24/03/2010

E.g. when I want now to see just the values on the 5th I get this output:

05/03/2010 18:21:50	1	05/03/2010
05/03/2010 18:26:01	3	05/03/2010

In the Database Expert -> Links I have connected those both tables with a '>' => Equipos.IdEquipo --> CambioTurno.IdEquipo.

I am using Crystal Reports 2007 which came with VB 2008. About a good easy reading manaul I would be very gladful

Thanks

 

[mac-duff]

ok, I solved this by setting in the selection expert : "new page before"

but now I am stumbling over another one.
This two tables are now connected with a third one which I also want to display on the same page.


Dia and IDEquipo are connected with another table which can look like this

IdEquipo	Dia	NumMoldes      Ok
1	2010-03-05 00:00:00	4        1
1	2010-03-05 00:00:00	4        1
1	2010-03-05 00:00:00	4        1

Right now I get for this date in the detail section:
05/03/2010 18:21:50 User1
which is ok, but now I want to add the NumMoldesSum which would be in the example 12, but every time I enter this I get 8000 pages becasue it is using the complete table. Here is my code:

If {Produccion.FechaTurno}={CambioTurno.Dia}
then
If {Produccion.OK} = 1 Then
(
 Sum({Produccion.NumMoldes})
)