Displaying sub report even when it has no data

Hi,

I have a main report with a sub report in it. Sub Report contains 1 table and some labels. I am passing 1 parameter from the main report to sub report on the basis of which sub report is generated with in the main report. In case if there comes some records in the sub report than the table as well as the other labels of the sub report are coming properly. But if no records are there in the sub report than it doesn't display the complete sub report i.e. no table and no labels which are with in the sub report. I want to make sure that labels should come even if there is no data in the sub report.

I had this same problem. The solution I came up with was to modify my stored procedure to always returnsome value.

SELECT @.Count =Count(*)FROM TableWHERE parameter1 = @.parameter1AND parameter2 = @.parameter2IF @.Count > 0BEGINSELECT Field1, Field2, Field3,DummyValue = -1FROM TableWHERE parameter1 = @.parameter1AND parameter2 = @.parameter2ORDER BY Field1DESC, Field2DESC, Field3ENDELSEBEGINSELECT DummyValue = @.CountEND

I don't know if this is best solution, but it definitely works. Hope this helps.

Display just report

I have a very basic html page I am using for test. It has
a few text boxes on it and I am passing the values in a
URL to the RS report. It's working fine.
What I was wondering is when the reporting services report
is displayed, the very top of the report shows the 2
required parameters, and text boxes containing the values,
as well as the "View Report" button.
Is there any way I can make that disappear? I know you
can click on the arrow all the way to the right and it
collapses it, but I don't want it there at all. I need to
take it completely off the page.
Thanks,
Mark HackenbergYou can go into the Report Manager UI and uncheck the "Prompt User" checkbox
to hide the parameters for relevant report(s). Note that parameters can
still be passed via URL access.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Hackenberg" <mark@.marathondata.com> wrote in message
news:2129301c45ae0$30e318a0$a601280a@.phx.gbl...
> I have a very basic html page I am using for test. It has
> a few text boxes on it and I am passing the values in a
> URL to the RS report. It's working fine.
> What I was wondering is when the reporting services report
> is displayed, the very top of the report shows the 2
> required parameters, and text boxes containing the values,
> as well as the "View Report" button.
> Is there any way I can make that disappear? I know you
> can click on the arrow all the way to the right and it
> collapses it, but I don't want it there at all. I need to
> take it completely off the page.
> Thanks,
> Mark Hackenberg|||I did that, but when I ran it I got the following error:
The report parameter 'CompanyID' is read-only and cannot
be modified. (rsReadOnlyReportParameter)
I don't know if this has anything to do with it, but this
value cannot be null. Is there anything I am missing?
>--Original Message--
>You can go into the Report Manager UI and uncheck
the "Prompt User" checkbox
>to hide the parameters for relevant report(s). Note that
parameters can
>still be passed via URL access.
>--
>Ravi Mumulla (Microsoft)
>SQL Server Reporting Services
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Mark Hackenberg" <mark@.marathondata.com> wrote in message
>news:2129301c45ae0$30e318a0$a601280a@.phx.gbl...
>> I have a very basic html page I am using for test. It
has
>> a few text boxes on it and I am passing the values in a
>> URL to the RS report. It's working fine.
>> What I was wondering is when the reporting services
report
>> is displayed, the very top of the report shows the 2
>> required parameters, and text boxes containing the
values,
>> as well as the "View Report" button.
>> Is there any way I can make that disappear? I know you
>> can click on the arrow all the way to the right and it
>> collapses it, but I don't want it there at all. I need
to
>> take it completely off the page.
>> Thanks,
>> Mark Hackenberg
>
>.
>|||Call the URL with "Parameters=False&Toolbar=False" parameter.
Regards,
Cem
"Mark Hackenberg" <mark@.marathondata.com> wrote in message
news:2129301c45ae0$30e318a0$a601280a@.phx.gbl...
> I have a very basic html page I am using for test. It has
> a few text boxes on it and I am passing the values in a
> URL to the RS report. It's working fine.
> What I was wondering is when the reporting services report
> is displayed, the very top of the report shows the 2
> required parameters, and text boxes containing the values,
> as well as the "View Report" button.
> Is there any way I can make that disappear? I know you
> can click on the arrow all the way to the right and it
> collapses it, but I don't want it there at all. I need to
> take it completely off the page.
> Thanks,
> Mark Hackenberg