troubleshooting Question

Crystal Reports sub report issue

Avatar of Ess Kay
Ess KayFlag for United States of America asked on
Crystal ReportsMicrosoft SQL Server
16 Comments3 Solutions426 ViewsLast Modified:
Dear Experts,


I have a report with a date parameter
screenshot 1
it passes it to the subreport


subreport has a query with a parameter

subreport param
the query is



 select distinct invntryitm_id,serial,itemdesc  from (
SELECT DISTINCT ABCOSPRO_EQTOOL.invntryitm_id, ABCOSPRO_EQTOOL.serial, ABCOSPRO_EQTOOL.itemdesc, ABCO_Inv_batch.date,case when ABCO_Inv_batch.date is null then '' else ABCO_Inv_batch.date end as thedate
FROM         ABCO_Inv_data INNER JOIN
                      ABCO_Inv_batch ON ABCO_Inv_data.batch_rn = ABCO_Inv_batch.batch_rn FULL OUTER JOIN
                      ABCOSPRO_EQTOOL ON ABCO_Inv_data.serial = ABCOSPRO_EQTOOL.serial
WHERE     (ABCOSPRO_EQTOOL.serial LIKE '%') AND (ABCOSPRO_EQTOOL.serial <> ''))x
where thedate not in  ({?Pm-@qdate} )
and serial not in (
SELECT DISTINCT ABCOSPRO_EQTOOL.serial
FROM         ABCO_Inv_data INNER JOIN
                      ABCO_Inv_batch ON ABCO_Inv_data.batch_rn = ABCO_Inv_batch.batch_rn FULL OUTER JOIN
                      ABCOSPRO_EQTOOL ON ABCO_Inv_data.serial = ABCOSPRO_EQTOOL.serial
WHERE     (ABCOSPRO_EQTOOL.serial LIKE '%') AND (ABCOSPRO_EQTOOL.serial <> '') and convert(varchar(50),date) =  ({?Pm-@qdate} ))








-------------
for some reason if I enter the date 3/19/2012 the main report takes it but the subreports sees 04/12/3765 or something


??wtf


someone please help

Thanks in advance
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 16 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros