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

Problem Passing Report Parameters in URL

I'm currently trying to create a report that will take one parameters in the URL to generate a detail report. when i pass parameter as

http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=123

it works fine . But i want to send master report's parameter to detail at run time which is selected in master report, then i got an error

i want to use

http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" &Parameters!p1.Value& "

but an error come i,e

" The path of the item '/UpdatedByClickTest/S,Parameters!p1.Value, "' is not valid. The full path must be less than 260 characters long, must start with slash; other restrictions apply. Check the documentation for complete set of restrictions. (rsInvalidItemPath)"

how can i pass parameter to remove this error?

plz any one help me i shall be thankfull to you

Hello Arshad,

Where are you trying to generate the URL?

If you just want to display a link, this will append your parajmeter to the URL:

="http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" + cStr(Parameters!p1.Value)

Hope this helps.

Jarret

|||

Thanks Jarret its working now i m using

="http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" & Parameters!p1.Value

now i want to use global server name becuase i will have to deploy reports to different servers e,g DEV, QA and Production

i m using code like

=Globals!ReportServerUrl & "?/UpdatedByClickTest/S&rs:Command=Render&P1="&Parameters!p1.Value

but its not working plz send me ur code.

|||

That should work, but not while you are designing the report. I tried what you posted and it worked when I deployed the report. When you deploy it to the server and run it from there, you should see the ReportServerURL showing correctly.

Jarret

Problem passing parameters to sub report

Hi,

I'm hoping this will be an easy one for you gurus:

I have a report with 2 groups and a detail line. I have put a sub report in the group1 footer. Now I can pass the main reports parameters down to the sub-report no problems. The problem I have is that I coded an "All" option into the reps parameter, so that I can report on (for example) all reps sales rather than just one.

Problem is that I need each groups rep ID passed down to the sub report. If I pass the All parameter, the report gives me all reps results in the group footer of each rep. I have tried passing the reportitems!txtrepid.value (the text field holding the repID value in the report) to the sub report, but that doesn't work.

Any ideas?

I also tried using fields!repid.value - I just get "sub report cannot be displayed". If I change it back to use a report parameter, it works - but does not give me what I need.

Any ideas anyone?

|||

Sussed it.

The sub report was looking for a string parameter 3 chars long. The field on the table that I was querying was 15 chars long - therefore it was being padded out with spaces - this made my sub report fail.

I used a LTRIM(RTRIM(S.SlPrsnId)) in my SQL, and low and behold it works!!