Question

Locked

Crystal report no data displayed at the run time

By naveenaraj ·
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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums