Help with creating a subreport

[chandrika]

Hi ,
I am very new to crystal reports .

I need some help in creating a kind of subreport that shows the total handicapped persons attended in that month.
My main report prompts for the starting date and ending date. It also looks into the database and runs a formula '@Handicapped' which checks if the handicapped field in the table is 1 , if 1 then 'y' is displayed.

So the subreport should now show the count of all the y's in the mainreport, for each month , depending on the start date and the enddate . Please help me as to how and where should i position the subreport and how could i do this.

The subreport should look something like
Jul | AUG
_____________________
Handicapp| 12 | 15

 

[synapsevampire]

You shouldn't need a subreport, which slows reports significantly.

Try inserting a cross-tab into the report footer and select whatever the field "Handicapp" is for the row, the date for the column (hit group options and format as month name if you'd like), and place whatever field it is you wish to count into the summarized fields.

If you require additional help please supply environment data (crystal and database type and version, example data) and your expected output.

This should get you there though.

-k

 

[chandrika]

Thanks for the suggestion.

But can u use formulas as summarized fields inside a crosstab.

what I need to do is , the main report looks like this

grouped by | Income | Handicapped |
| ( Low) | |
customer name | | |
___________________________________________
smith X
Jessica X X
Mike X

so the formulas @low and @handicapped display 'X' if they meet the requirements.


JuL
------
Income | 2
(low) |
__________________
Handicapped | 2


How can i do a count of these X's , can i use running totals ? , and how do I get the specific format below?
can i use these running total fields inside a crosstab ?
please advise