Hello Guys,
I have a project in visual studio 2003 with crystal Report 11. I have this Query in my Crystal Report.
select
distinct propad01.Papel,propad01.FechaP,propad01.Rollo,propad01.Maquina,
TEADMProm+TEADCProm as [TEADM+DC],JumboDelMes,Fecha
from
propad01
inner join
caljum02
on propad01.FechaP = caljum02.FechaP and propad01.Rollo = caljum02.Rollo and
propad01.Papel = caljum02.Papel and propad01.Maquina = caljum02.Maquina
inner join
catpap01
on catpap01.Id_Papel = propad01.Papel and (catpap01.Familia like 'EXTENSA' or catpap01.Familia like 'SACO')
where
propad01.FechaP = '20121225'
When I run my report this does not show nothing but If I remove the WHERE sentece the report show all information very well.
distinct propad01.Papel,propad01.FechaP,propad01.Rollo,propad01.Maquina,
TEADMProm+TEADCProm as [TEADM+DC],JumboDelMes,Fecha
from
propad01
inner join
caljum02
on propad01.FechaP = caljum02.FechaP and propad01.Rollo = caljum02.Rollo and
propad01.Papel = caljum02.Papel and propad01.Maquina = caljum02.Maquina
inner join
catpap01
on catpap01.Id_Papel = propad01.Papel and (catpap01.Familia like 'EXTENSA' or catpap01.Familia like 'SACO')
I have run my query in SQL SERVER with WHERE sentence and does work very well.
What's the problem?