How to suppress the group footer (@the time of suing SubR)

[rajrev]

Hi,
We are trying to hide the group footer1 (which contains a subreport) at the time of suppress the detial section of the subreport.
For example,
we are using a subreport for education detail (school,major,yearfinished) for each condidate and placed in a group footer1. Now some of the condidates are not yet clear the course, which we don't want to show that in education info.in the report. So we are using some codition and suppress the detial in the subreport(its working good).

Problem:
We want to hide the particular group footer1 in the Main report (which contains that education subreport).
Note:
At present it gives a small gap (blank) in the main report.

Please let me know if you need more information.

Thanks,
MK

 

[LinPro]

Is any of the information from the subreport in the main? What are you using for the join? Is the status of the candidate being used in the subreport as well as the main? If it is you can use if to suppress the grouping of the candidate.

Lin

Otherwise, supply more details.

 

[rajrev]

Thanks for your reply.
Try to expline clear then the previous post with ex.

Group by Empid
group header1 suppressed
detail supressed
Output of the report is

Name : xxxx
Age : xx
Location : yyy (upto this Group footer1a)
Education
School year
xxxx 2000
cccc 1999 (Group footer1b(subreport))
Language
ssss,agfda,weerw (Group footer1c)

now if there is no education detail in the database then the result we need is

Name : xxxx
Age : xx
Location : yyy (upto this Group footer1a)
Language
ssss,agfda,weerw (Group footer1c)


but now it shows like

Name : xxxx
Age : xx
Location : yyy (upto this Group footer1a)


Language
ssss,agfda,weerw (Group footer1c)

thats the blank spcace for group footer1b.

we just copy the parameter called {?Empid} from the main report and past it in the subreport and link the parameter with the Mastertable empid (by right click on the subreport which was placed in the main report and from the drop down select the "change subreport link..&quot
the mastertable is only added in the main report not in the sub report.
its a little complicated for me to expline the problem clearly.
any way if u need any clarification pl. let me know.
Thanks
Mk

 

[Madawc]

You seem to want to use a subreport to conditionally suppress the section that the subreport is in. That's not possible in Crystal 8.5, where the decision to print or suppress is taken before the subreport is run.

There is a work-round: see thread782-477236

Madawc Williams
East Anglia, Great Britain

 

[rajrev]

Thanks for your replay. the given thread is informative to me.
Thanks
MK

 

[lbass]

You could do the following:

Go to format->section->group footer_1a (Location)->underlay following section->x+2 and enter:

isnull({education.school}) //or use an ID field--whatever field recurs with each record in the education subreport

This will cause the subreport to retract under the group footer_1a whenever it is blank. This will leave no space if the number of lines in group footer_1b is the same as the number of lines in group footer_1a. In your example, you show 3 lines in 1a and 4 in 1b. You could decide to create a line space before the first field in 1a so that the numbers of lines are equal, although I suppose the number of schools in the education report could vary, so this approach might only get you partly to your desired result.

-LB