Click here to Skip to main content
15,888,610 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
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?
Posted
Updated 29-Mar-13 5:07am
v2
Comments
RedDk 30-Mar-13 14:16pm    
Post sample of data ... possibly tabled ...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900