Please suggest, iam using five queryies in single report , when i run the indival quries i am getting the result in sql, but when i run the Crystal report no data displayed in the output
My five quriers are:1:
SELECT A.REFERENCE_ID, TO_CHAR(A.CLOSED_TIME, ‘MM’), TO_CHAR(A.CLOSED_TIME,’YYYY’), SUM(B.FATAL_NO), SUM(B.SERIOUS_NO), SUM(B.SLIGHT_NO) FROM SITUATION A INNER JOIN SITE_INCIDENT_DATA B ON A.SITUATION_ID = B.SITUATION_ID
WHERE A.REFERENCE_ID=’00’
GROUP BY A.REFERENCE_ID, TO_CHAR(A.CLOSED_TIME, ‘MM’), TO_CHAR(A.CLOSED_TIME, ‘YYYY’)
2:
SELECT A.REFERENCE_ID, TO_CHAR(A.CLOSED_TIME, ‘MM’), TO_CHAR(A.CLOSED_TIME, ‘YYYY’), COUNT(A.SITUATION_ID) FROM
SITUATION A INNER JOIN SITE_VEHICLE_BKDOWN_DATA B ON A.SITUATION_ID = B.SITUATION_ID
–WHERE A.REFERENCE_ID=’00’
GROUP BY A.REFERENCE_ID, TO_CHAR(A.CLOSED_TIME, ‘MM’), TO_CHAR(A.CLOSED_TIME, ‘YYYY’)
3:SELECT A.REFERENCE_ID, TO_CHAR(A.CLOSED_TIME, ‘MM’), TO_CHAR(A.CLOSED_TIME, ‘YYYY’), COUNT(A.SITUATION_ID) FROM
SITUATION A INNER JOIN SITE_MISC_DATA B ON A.SITUATION_ID = B.SITUATION_ID
–WHERE A.REFERENCE_ID=’00’
GROUP BY A.REFERENCE_ID, TO_CHAR(A.CLOSED_TIME, ‘MM’), TO_CHAR(A.CLOSED_TIME, ‘YYYY’)
4:SELECT COUNT(DEVICE_ID) FROM DISCRETE_DATA where device_type in (‘ETS’) group by DEvice_type
and writing the recound selection like these toNumber({command.to_char(A.closed_time,’MM’)})={?MONTH} AND
toNumber({command.to_char(A.closed_time,’YYYY’)})={?YEAR}
please suggest.
Thanks & Regards
Raj
