Hi every one,
I am new to crystal reports, I have a question regarding a summary report,
I am doing a Crosstab Report.
where i have filter or group records…where the data comes from three tables… in which one table has desc field and the look up values for that field are present in the third table which are related by a field in the middle table…
Now I have to look up certain values which are to be filtered or grouped by: only open files, and which particular code and all the open files which are till date(SYSDATE).
Here in this report I could pull the data using filers or group…But the report shows the summary according to the dates but my requirement is just summary count…
Present Report
type aa bb cc
date 5/6 5/7 5/8 5/6 5/7 5/8 5/7 5/8
abc 5 5 3 4 4 4 4 4
def 4 2 4 6 3 3 3 3
ghi 3 2 4 3 3 3 2 2
Required format…
type aa bb cc
abc 5 5 3
def 4 2 4
ghi 3 2 4
Any help is appreciated…
Thanks in advance
cristal (BOB member since 2010-05-08)