Subreport is not showing when main Report does not have records
Another way is to switch between main report and subreport. Make your
current subreport the main report, and embed your main report in the
subreport's header.
Quote:
> Since the 2nd parameter is constant, redesign the stored proc used in
> subreport to use 1 parameter rather than 2. Thus, you only link to the
> parameter passed in to the main report.
> > Hi Everybody,
> > I have a problem with crystal Reports 8.0. I have have a report
> > which has one parameter and gets data from a stored procedure. I also
> > added a SubReport which has two parameters and gets data from a
> > seperate stored procdure. These two parameters are linked with main
> > report. One Parameter is linked with Main Reports parameter and the
> > other is linked with main reports formula field(which has constant
> > value). This sub report is added on Main reports Report Footer
> > section.
> > Now the problem is When main report does not have any data Sub report
> > also not showing. I always wanted to show sub report even main report
> > does not have records. Subreports SP always returns data even if Main
> > reports SP does not have data.
> > So how can show the sub report always
> > Thanks
> > NRao
