Skip to Content
0
Former Member
Mar 29, 2013 at 07:58 PM

Issue with Crystal report 11 ans Visual studio 2003 when I try to use WHERE sentence

22 Views

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.

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')

I have run my query in SQL SERVER with WHERE sentence and does work very well.

What's the problem?