Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Sub reports help

Answered Sub reports help

  • Tuesday, January 29, 2013 1:31 AM
     
     
    Sign In to Vote
    0

    Hi all i have two reports report1 and report2 that i created and they are saved under c:\used\thinkingeye\documents. Now i have to create a subreport (report2) under report 1. Both the reports have the same parameter, I'm using report builder 3.0. and in REPORT1 i clicked on the INSERT tab and clicked on the subreport. This is where i have two problems.

    Problem 1 is i cannot make enough space under report1 to insert the subreport.

    Problem 2 is when i inserted the SUBREPORT icon and clicked on the subreport properties , it gave me an option to browse to a  location , but the browse location is defaulted to a folder "Recent Report and Servers". Now can anyone please guide me as how to get to the location? or should i deploy these two reports before creating a sub report? Please need help.

    Thanks

     

All Replies

  • Tuesday, January 29, 2013 6:34 AM
     
     
    Sign In to Vote
    0

    Hi,

    1. In Design view, click Subreportin the Toolbox.
    2. On the design surface, click a location on the report and then drag a box to the desired size of the subreport. Alternatively, double-click the design surface to create a subreport of fixed size.

    Note:

    If the subreport is in the project, you can drag the report from Solution Explorer onto the design surface to create a subreport.

    1. Right-click the subreport, and then click Subreport Properties.
    2. In the Subreport Propertiesdialog box, type a name in the Nametext box or accept the default.
    3. In the Use this report as a subreport list box, type the name of the report. The name of the report can be specified in the following ways:
      • For a report in this project, select the name of the report from the drop-down list.
      • For a report published to a report server configured for native mode, use a full or relative path to the report, without the file name extension. If the report is in the same folder as the current report, use the name of the report only. If the report is in a different folder, use a relative path to the report (for example, ../Reports/DetailReport).
      • For a report published to a report server configured in SharePoint integrated mode, use the name of the report including the file name extension (for example, DetailReport.rdl). The subreport must be in the same folder as the main report. Relative paths are not supported.
    4. Click OK.

    To specify parameters to pass to a subreport

    1. In Design view, right-click the subreport and then click Subreport Properties.
    2. In the Subreport Propertiesdialog box, click Parameters.
    3. Click Add. A new row is added to the parameter grid.
    4. In the Nametext box, type the name of a parameter in the subreport. This name must match a report parameter in the subreport. If the subreport is in the project, you can choose the parameter from the drop-down list. If the subreport is on the report server, run the report in Report Manager, and on the Propertiestab, click Parameters.

    Note:

    The parameter name must match the name of a report parameter, not a query parameter.

    1. In the Value list box, type or select a value to pass to the subreport. This value can be static text or an expression pointing to a field or other object in the main report.
    2. Repeat steps 3-4 to specify a value for each subreport parameter.

    Note:

    All parameters that are required by the subreport must be included in the Parameterslist. If a required parameter is missing, the subreport is not displayed correctly in the main report.

    The above steps are documented on MSDN, for more information (include 2008/2005), you can refer to:

    http://msdn.microsoft.com/en-us/library/ms160348.aspx

    This is datawarehousing Forum ...

    Request you to post the reporting services related queries in SSRS forum for faster replies

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads

    Best Regards,
    Silna
    Please feel free to ask if you have any doubts and remember to mark the correct replies as answers.

     
  • Wednesday, January 30, 2013 12:36 AM
     
     
    Sign In to Vote
    0

    Thanks Silna, but nothing helped, wheni cliecked on the SUBREPORT PROPERTIES, it open the subreport properties and it has a "Browse" button on it and when i click on it, it takes me to a window where it says Look in "recent sites and servers folder" and there is no way to get to any other folder. In the name i tried all options but no luck please need help.

     
  • Wednesday, January 30, 2013 10:40 AM
     
     
    Sign In to Vote
    0

    Hi,

    Hope this link is helpful for you to configure (External Items)

    http://msdn.microsoft.com/en-us/library/dd220423.aspx

    Best Regards,
    Silna
    Please feel free to ask if you have any doubts and remember to mark the correct replies as answers.

     
  • Wednesday, January 30, 2013 10:58 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    please try this

    You can type in a fully qualified URL in the NAME field in the properties of the subreport

    or

    http://blogs.msdn.com/b/sqlforum/archive/2010/12/21/sql-preview-a-subreport-which-is-in-another-ssrs-project.aspx

    Best Regards,
    Silna
    Please feel free to ask if you have any doubts and remember to mark the correct replies as answers.