Home > Archive > Visual Basic Crystal Reports > March 2006 > Show group header when no details
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Show group header when no details
|
|
| Vinodh 2006-03-28, 7:05 pm |
| Hi there,
I am new to CR, I am using CR 8.5. I have a report where the layout is
as follows:
Group Header 1
Group Header 2
Details
Group Footer 2
Group Footer 1.
My problem is that the groups don't show up in the report when there is
no data in the details. Basically, the DB relationship between the
group data and details data is one-to-many and there is an outer join
in SQL query for them. So, I would expect the group data to be shown
when there are no child data in the details. Also, the 'suppress'
option is not checked for any of the groups. Can anyone please throw
some light on this ?
Cheers,
Vinodh.
| |
| Iain Sharp 2006-03-29, 4:12 am |
| On 28 Mar 2006 08:43:59 -0800, "Vinodh" <vinodh.poyyapakkam@gmail.com>
wrote:
>Hi there,
>
>I am new to CR, I am using CR 8.5. I have a report where the layout is
>as follows:
>Group Header 1
>Group Header 2
>Details
>Group Footer 2
>Group Footer 1.
>
>My problem is that the groups don't show up in the report when there is
>no data in the details. Basically, the DB relationship between the
>group data and details data is one-to-many and there is an outer join
>in SQL query for them. So, I would expect the group data to be shown
>when there are no child data in the details. Also, the 'suppress'
>option is not checked for any of the groups. Can anyone please throw
>some light on this ?
>
>Cheers,
>Vinodh.
1. Are there any other tables linked to the details. If so they must
be outer joins as well.
2. Are any of the details table fields mentioned in the report
selection formula. If so they must be set to (isnull({field}) or
{field} = test). i.e. Where the outer join finds no details the data
will be set to null. You must explicitly test for null and allow it as
valid in the report.
Iain
|
|
|
|
|