|
|
You're in the
sql server reporting services
group:Subreports on the report server
sql server reporting services:
I havent worked alot with subreports so I have this question pertaining to
subreports showing up on the report server with the regular report. Do they have to be on there and if so can they be hidden. Anything that might help will be greatly appreciated.
Hi,
You would create a sub-report just the way you create any other report. While using it as a sub-report, you can drag a report that's to be used as a sub-report on the parent report (the report in which you want to use the sub-report). Yes, you can hide sub-reports. The table control used in a report would contain a sub-report. If you want to hide a sub-report, you can do so by making the cell inivisible in which the sub-report exists on the parent report. If you've any confusions about this, let me know. thanks, Sunny [quoted text, click to view] Ben Watts wrote:
> I havent worked alot with subreports so I have this question pertaining to > subreports showing up on the report server with the regular report. Do they > have to be on there and if so can they be hidden. Anything that might help > will be greatly appreciated.
Ben,
Yes you can hide the report in the Report Manager: Click the Show Details Button to the right of the screen. Click the Edit icon of the subreport In the General Node, check the Hide Property, and click Apply. Note: this 'hide' only works when the Default View is selected in the Report Manager. If the user clicks 'Show Details' the subreport will be displayed. If your trying to write a Web App that shows the available reports in a dropdown, try something like this: ddlReports.Items.Clear() Dim Report As CatalogItem For Each Report In ReportList If Report.Hidden = False Then If Report.Type = ItemTypeEnum.Report Then Dim MyItem = New ListItem(Report.Description, Report.Name) ddlReports.Items.Add(MyItem) End If End If Next Hope this helps, rwiethorn [quoted text, click to view] "Ben Watts" wrote:
> I may have been very confusing. You know when you display your report on > the report server for other people to use. Well the subreports show up just > like a regular report on the server. So if you deploy your report to the > report server to a blank folder and it has a subreport in it, then that > folder will contain two reports. Your regular report and the subreport. I > want to know if this is necessary and if so can you hide the subreprt. > > Thanks > > "sunny" <sunny.mohan@gmail.com> wrote in message > news:1153917283.064626.313910@75g2000cwc.googlegroups.com... > > Hi, > > > > You would create a sub-report just the way you create any other report. > > While using it as a sub-report, you can drag a report that's to be used > > as a sub-report on the parent report (the report in which you want to > > use the sub-report). > > > > Yes, you can hide sub-reports. The table control used in a report would > > contain a sub-report. If you want to hide a sub-report, you can do so > > by making the cell inivisible in which the sub-report exists on the > > parent report. > > > > If you've any confusions about this, let me know. > > > > thanks, > > Sunny > > > > > > > > Ben Watts wrote: > >> I havent worked alot with subreports so I have this question pertaining > >> to > >> subreports showing up on the report server with the regular report. Do > >> they > >> have to be on there and if so can they be hidden. Anything that might > >> help > >> will be greatly appreciated. > > > >
I may have been very confusing. You know when you display your report on
the report server for other people to use. Well the subreports show up just like a regular report on the server. So if you deploy your report to the report server to a blank folder and it has a subreport in it, then that folder will contain two reports. Your regular report and the subreport. I want to know if this is necessary and if so can you hide the subreprt. Thanks [quoted text, click to view] "sunny" <sunny.mohan@gmail.com> wrote in message news:1153917283.064626.313910@75g2000cwc.googlegroups.com... > Hi, > > You would create a sub-report just the way you create any other report. > While using it as a sub-report, you can drag a report that's to be used > as a sub-report on the parent report (the report in which you want to > use the sub-report). > > Yes, you can hide sub-reports. The table control used in a report would > contain a sub-report. If you want to hide a sub-report, you can do so > by making the cell inivisible in which the sub-report exists on the > parent report. > > If you've any confusions about this, let me know. > > thanks, > Sunny > > > > Ben Watts wrote: >> I havent worked alot with subreports so I have this question pertaining >> to >> subreports showing up on the report server with the regular report. Do >> they >> have to be on there and if so can they be hidden. Anything that might >> help >> will be greatly appreciated. >
Click on the properties for the report and check the box that says hide in
list view. I also do this for my data sources, the user doesn't need to see them. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Ben Watts" <ben.watts@aaronnickellhomes.com> wrote in message news:euy1kOLsGHA.4164@TK2MSFTNGP06.phx.gbl... >I may have been very confusing. You know when you display your report on >the report server for other people to use. Well the subreports show up >just like a regular report on the server. So if you deploy your report to >the report server to a blank folder and it has a subreport in it, then that >folder will contain two reports. Your regular report and the subreport. I >want to know if this is necessary and if so can you hide the subreprt. > > Thanks > > "sunny" <sunny.mohan@gmail.com> wrote in message > news:1153917283.064626.313910@75g2000cwc.googlegroups.com... >> Hi, >> >> You would create a sub-report just the way you create any other report. >> While using it as a sub-report, you can drag a report that's to be used >> as a sub-report on the parent report (the report in which you want to >> use the sub-report). >> >> Yes, you can hide sub-reports. The table control used in a report would >> contain a sub-report. If you want to hide a sub-report, you can do so >> by making the cell inivisible in which the sub-report exists on the >> parent report. >> >> If you've any confusions about this, let me know. >> >> thanks, >> Sunny >> >> >> >> Ben Watts wrote: >>> I havent worked alot with subreports so I have this question pertaining >>> to >>> subreports showing up on the report server with the regular report. Do >>> they >>> have to be on there and if so can they be hidden. Anything that might >>> help >>> will be greatly appreciated. >> > >
Thanks alot Bruce, that has been bugging me for a long time. Thanks for
the help.!! [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:uafUqtLsGHA.4452@TK2MSFTNGP05.phx.gbl... > Click on the properties for the report and check the box that says hide in > list view. I also do this for my data sources, the user doesn't need to > see them. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Ben Watts" <ben.watts@aaronnickellhomes.com> wrote in message > news:euy1kOLsGHA.4164@TK2MSFTNGP06.phx.gbl... >>I may have been very confusing. You know when you display your report on >>the report server for other people to use. Well the subreports show up >>just like a regular report on the server. So if you deploy your report to >>the report server to a blank folder and it has a subreport in it, then >>that folder will contain two reports. Your regular report and the >>subreport. I want to know if this is necessary and if so can you hide the >>subreprt. >> >> Thanks >> >> "sunny" <sunny.mohan@gmail.com> wrote in message >> news:1153917283.064626.313910@75g2000cwc.googlegroups.com... >>> Hi, >>> >>> You would create a sub-report just the way you create any other report. >>> While using it as a sub-report, you can drag a report that's to be used >>> as a sub-report on the parent report (the report in which you want to >>> use the sub-report). >>> >>> Yes, you can hide sub-reports. The table control used in a report would >>> contain a sub-report. If you want to hide a sub-report, you can do so >>> by making the cell inivisible in which the sub-report exists on the >>> parent report. >>> >>> If you've any confusions about this, let me know. >>> >>> thanks, >>> Sunny >>> >>> >>> >>> Ben Watts wrote: >>>> I havent worked alot with subreports so I have this question pertaining >>>> to >>>> subreports showing up on the report server with the regular report. Do >>>> they >>>> have to be on there and if so can they be hidden. Anything that might >>>> help >>>> will be greatly appreciated. >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |