sub report

[swetham]

I have two tables employees,data
employees contain,

Emp_name Emp_initial

Data contain

Initial Duration Date


I have a main report where i have two parameters startdate and enddate and i wrote a formula in select expert->record as
Date in startdate to enddate.

Now i want a subreport which also should be filtered according to the selection formula in main report and the report should be like,

Name Total
abc 67
frt 89
ert 56
opi 0

Name should display all the employees list and total should should be zero if they wont work from startdate to enddate.

Can anyone help?

 

[Madawc]

You should be able to do it with a crosstab. QUicker than a subreport since it reshuffled the data the report has already collected, whereas a subreport does its own data collection.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[swetham]

Thank you, I have done it using crosstab