Problem removing group header

Using SS2000, RS2000, VS2003
I have a report that displays group totals and grand totals but no detail
lines. There is nothing in the group header. I made the height of the group
header as small as possible but there is still too much room between the rows
when the report is run.
I tried removing the group header and that works as far as the space between
rows. However, after removing the group header and running the report, I
noticed that nothing in the report footer was showing up.
Any ideas? Thanks,
--
Dan D.Have you tried setting Group Header's visibility to False?
"Dan D." wrote:
> Using SS2000, RS2000, VS2003
> I have a report that displays group totals and grand totals but no detail
> lines. There is nothing in the group header. I made the height of the group
> header as small as possible but there is still too much room between the rows
> when the report is run.
> I tried removing the group header and that works as far as the space between
> rows. However, after removing the group header and running the report, I
> noticed that nothing in the report footer was showing up.
> Any ideas? Thanks,
> --
> Dan D.|||I tried that and it made the group footer data disappear. Apparently, the
visibility is for the group as a whole and there is no way to make just the
header hidden.
Thanks,
--
Dan D.
"isaak" wrote:
> Have you tried setting Group Header's visibility to False?
> "Dan D." wrote:
> > Using SS2000, RS2000, VS2003
> > I have a report that displays group totals and grand totals but no detail
> > lines. There is nothing in the group header. I made the height of the group
> > header as small as possible but there is still too much room between the rows
> > when the report is run.
> >
> > I tried removing the group header and that works as far as the space between
> > rows. However, after removing the group header and running the report, I
> > noticed that nothing in the report footer was showing up.
> >
> > Any ideas? Thanks,
> > --
> > Dan D.|||Of course you can do this but not from the Edit Group >> Visibility tab. As
you discovered, changing the visibility here affects the whole group.
Make sure the properties window is visible in report designer (menu: View >>
Properties Window) and then select the group header row you want to hide. Now
find the Visibility property in the properties window, expand it and set
Hidden = True.
"Dan D." wrote:
> I tried that and it made the group footer data disappear. Apparently, the
> visibility is for the group as a whole and there is no way to make just the
> header hidden.
> Thanks,
> --
> Dan D.
>
> "isaak" wrote:
> > Have you tried setting Group Header's visibility to False?
> >
> > "Dan D." wrote:
> >
> > > Using SS2000, RS2000, VS2003
> > > I have a report that displays group totals and grand totals but no detail
> > > lines. There is nothing in the group header. I made the height of the group
> > > header as small as possible but there is still too much room between the rows
> > > when the report is run.
> > >
> > > I tried removing the group header and that works as far as the space between
> > > rows. However, after removing the group header and running the report, I
> > > noticed that nothing in the report footer was showing up.
> > >
> > > Any ideas? Thanks,
> > > --
> > > Dan D.|||That did it Jim. Thanks.
--
Dan D.
"Jim" wrote:
> Of course you can do this but not from the Edit Group >> Visibility tab. As
> you discovered, changing the visibility here affects the whole group.
> Make sure the properties window is visible in report designer (menu: View >>
> Properties Window) and then select the group header row you want to hide. Now
> find the Visibility property in the properties window, expand it and set
> Hidden = True.
> "Dan D." wrote:
> > I tried that and it made the group footer data disappear. Apparently, the
> > visibility is for the group as a whole and there is no way to make just the
> > header hidden.
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "isaak" wrote:
> >
> > > Have you tried setting Group Header's visibility to False?
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003
> > > > I have a report that displays group totals and grand totals but no detail
> > > > lines. There is nothing in the group header. I made the height of the group
> > > > header as small as possible but there is still too much room between the rows
> > > > when the report is run.
> > > >
> > > > I tried removing the group header and that works as far as the space between
> > > > rows. However, after removing the group header and running the report, I
> > > > noticed that nothing in the report footer was showing up.
> > > >
> > > > Any ideas? Thanks,
> > > > --
> > > > Dan D.|||Well, this is weird. I just noticed that when I change the visibility on the
group header to false, the report header and footer both disappear, like
they've also been changed to false. I don't see a visibility setting for the
report header and footer under properties, though. Do you have any idea what
happened? If I change the visibility of the group header back to true, the
report header and footer both appear again.
--
Dan D.
"Jim" wrote:
> Of course you can do this but not from the Edit Group >> Visibility tab. As
> you discovered, changing the visibility here affects the whole group.
> Make sure the properties window is visible in report designer (menu: View >>
> Properties Window) and then select the group header row you want to hide. Now
> find the Visibility property in the properties window, expand it and set
> Hidden = True.
> "Dan D." wrote:
> > I tried that and it made the group footer data disappear. Apparently, the
> > visibility is for the group as a whole and there is no way to make just the
> > header hidden.
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "isaak" wrote:
> >
> > > Have you tried setting Group Header's visibility to False?
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003
> > > > I have a report that displays group totals and grand totals but no detail
> > > > lines. There is nothing in the group header. I made the height of the group
> > > > header as small as possible but there is still too much room between the rows
> > > > when the report is run.
> > > >
> > > > I tried removing the group header and that works as far as the space between
> > > > rows. However, after removing the group header and running the report, I
> > > > noticed that nothing in the report footer was showing up.
> > > >
> > > > Any ideas? Thanks,
> > > > --
> > > > Dan D.sql