Skip to Content
0
Former Member
May 14, 2008 at 03:12 PM

Report behaving badly ... Can anyone help?

62 Views

Post Author: OzyatHome

CA Forum: Crystal Reports

I am relatively new to Crystal Reporting, but have been using it more and more over the past 3-4 months. I have just encountered a problem that I simply cannot resolve - any help would be greatly appreciated ... I have basically written a report with 3 groups; Year, Activity, Program where all group headings and footers are hidden apart from the group footer for group 3 - Program. It worked well reporting all Programs in the database for the selected Years and Activity types. The database structure behind this report was straight forward as all details being reported at Program level came from just 2 tables (Activity and Program). An Activity table entry holding the Year for each activity and a link to the 1 or more Programs that make up each activity. The reported consists of one line per Program, all details reported being sourced from either the Program table entry or its Activity parent table entry. I was then asked to also report the Tutor Name for each Program. All Tutor Names being held on a Staff table linked to each program by the Tutors Reference "once allocated", BUT until Tutors are allocated to a Program there is no Tutor Reference on the Program table to link from the Program table entry to the Staff table. I therefore added a 4th group, that being Tutor Names for which I suppressed everything, simply adding a new summary to my single detail line at Program level, namely a distinct count of Tutor Names which I then intended to check to see if a Tutor existed or not before setting a formula field to the Staff table's Tutor Name for reporting. I didn't however get that far as the results after simply adding the new summary count were not as I expected. Whereas before the change all programs to which no Tutors had yet to be assigned were being reported OK, post the above change only Programs reporting a distinct count of Tutor Names greater than zero were reported! I cannot see why this should be? Any pointers or help would be greatly appreciated. Many thanks .. Kev