Month & Date is not printing on Report
Hello Friends
I am selecting dates from a FORM to print my required data on report. My required data is displaying on Screen.. with the selected Dates... but when I print the report Report , it gives me error.... #Name?
This report has of 2 parts..... Part 1 for complete year data and Part 2 is for last 30 days data.... I select dates for last 30 days via a FORM..... & this dates are printed on Report... so far this is being displayed on Screen but not on Paper...
All the process is below:
Form Name: frmOne2
Report Name: SumryGLT4
Report Source: Query6, Query61a Query6b WithTerritoryGLT
Query6,
Expand|Select|Wrap|Line Numbers
SELECT DM.Class, DM.ClassName, DM.Size, DM.SizeName, Format([TDate],"yyyy") AS Period1, Sum(DM.FAS) AS SumOfFAS, Sum(DM.BG) AS SumOfBG, Sum(DM.Demo) AS SumOfDemo, Sum(DM.DTP) AS SumOfDTP, Sum(DM.FM) AS SumOfFM, Sum(DM.HPM) AS SumOfHPM, DM.Division
FROM DM
GROUP BY DM.Class, DM.ClassName, DM.Size, DM.SizeName, Format([TDate],"yyyy"), DM.Division, Format([TDate],"yyyy")
HAVING (((DM.Class)=2))
ORDER BY DM.SizeName;
Query61a,
Expand|Select|Wrap|Line Numbers
SELECT DM.Class, DM.ClassName, DM.Size, DM.SizeName, DM.TDate, Sum(DM.BG) AS SumOfBG, Sum(DM.Demo) AS SumOfDemo, Sum(DM.DTP) AS SumOfDTP, Sum(DM.FAS) AS SumOfFAS, Sum(DM.FM) AS SumOfFM, Sum(DM.HPM) AS SumOfHPM, DM.Division
FROM DM
GROUP BY DM.Class, DM.ClassName, DM.Size, DM.SizeName, DM.TDate, DM.Division
HAVING (((DM.Class)=2) And ((DM.TDate)>=forms!frmOne2!txtStartDate And (DM.TDate)<=forms!frmOne2!txtEndDate))
ORDER BY DM.ClassName, DM.TDate;
Query6b,
Expand|Select|Wrap|Line Numbers
SELECT Query6a1.Class, Query6a1.ClassName, Query6a1.Size, Query6a1.SizeName, Sum(Query6a1.SumOfFAS) AS SumOfSumOfFAS, Sum(Query6a1.SumOfFM) AS SumOfSumOfFM, Sum(Query6a1.SumOfDemo) AS SumOfSumOfDemo, Sum(Query6a1.SumOfHPM) AS SumOfSumOfHPM, Sum(Query6a1.SumOfBG) AS SumOfSumOfBG, Sum(Query6a1.SumOfDTP) AS SumOfSumOfDTP, Query6a1.Division
FROM Query6a1
GROUP BY Query6a1.Class, Query6a1.ClassName, Query6a1.Size, Query6a1.SizeName, Query6a1.Division;
WithTerritoryGLT
Expand|Select|Wrap|Line Numbers
SELECT Query6.ClassName AS CompanyName, Query6.Division, Query6.SizeName AS RegionName, Region.Territories, [Territories]*932 AS FASTarget, Query6.SumOfFAS AS A1, Round([A1]/[FASTarget]*100,2) AS [FAS%], Round([FASTarget]/12,2) AS FASMonth, Query6b.SumOfSumOfFAS AS A2, Round([A2]/[FASMonth]*100,2) AS [FASM%], [Territories]*104 AS FMTarget, Query6.SumOfFM AS B1, Round([B1]/[FMTarget]*100,2) AS [FM%], Round([FMTarget]/12,2) AS FMMonth, Query6b.SumOfSumOfFM AS B2, Round([B2]/[FMMonth]*100,2) AS [FMM%], [Territories]*75 AS DemoTarget, Query6.SumOfDemo AS C1, Round([C1]/[DEMOTarget]*100,2) AS [DEMO%], Round([DemoTarget]/12,2) AS DemoMonth, Query6b.SumOfSumOfDemo AS C2, Round([C2]/[DemoMonth]*100,2) AS [DemoM%], [Territories]*3 AS HPMTarget, Query6.SumOfHPM AS D1, Round([D1]/[HPMTarget]*100,2) AS [HMP%], Round([HPMTarget]/12,2) AS HPMMonth, Query6b.SumOfSumOfHPM AS D2, Round([D2]/[HPMMonth]*100,2) AS [HPM%], [Territories]*3 AS BGTarget, Query6.SumOfBG AS E1, Round([E1]/[BGTarget]*100,2) AS [BG%], Round([BGTarget]/12,2) AS BGMonth, Query6b.SumOfSumOfBG AS E2, Round([E2]/[BGMonth]*100,2) AS [BGM%], [Territories]*3 AS DTPTarget, Query6.SumOfDTP AS F1, Round([F1]/[DTPTarget]*100,2) AS [DTP%], Round([DTPTarget]/12,2) AS DTPMonth, Query6b.SumOfSumOfDTP AS F2, Round([F2]/[DTPMonth]*100,2) AS [DTPM%]
FROM (Query6 INNER JOIN Query6b ON (Query6.Class = Query6b.Class) AND (Query6.ClassName = Query6b.ClassName) AND (Query6.Size = Query6b.Size) AND (Query6.SizeName = Query6b.SizeName)) INNER JOIN Region ON (Query6b.SizeName = Region.RegionName) AND (Query6b.Size = Region.RegionID)
ORDER BY Query6.Division, Query6.SizeName;
Request for all friends for help.
Thanks
irsmalik