locked
can I use the yield of reporting service in the vs RRS feed

  • Question

  • User-9833593 posted

    Hi everyone,

    I know the usage of reporting and its importance and I know how to work with report viewer and such like but I do not know the usage of sql server reporting services and i want to know if I can only using it in sql server as a final project or after making report with sql sever should I use the yield of sql server reporting in visual studio?My main purpose is using reporting made by reporting service in visual studio not anywhere else so is learning sql server reporting service accord with the purpose that I explained and useful for me under this condition?

    Thursday, April 28, 2011 10:10 AM

Answers

  • User1471008070 posted

    Hi,

    From your information, I get that you want to display the report deployed on the report server via reportviewer control in remote module, Visual Studio comes with freely redistributable Report Viewer controls for embedding Reporting Services functionality into custom applications.

    Firstly, you should design your report in BIDS, then deploy the report on the report server, you might have already done this from your information. What you should do is To add the Report Viewer control to the Web page:

    1. Drag and drop the Report Viewer icon onto the WebForm design surface. The SmartTags panel for the control is automatically displayed.
    2. In the ReportViewer Tasks smart tags panel, in Choose Report, select Server Report.
    3. In the Report Server text box, type the report server URL. The default URL syntax is http://localhost/reportserver. The actual URL that is used in your installation might be different depending on how the report server virtual directory settings are configured.
    4. In the Report Path text box, type the fully qualified path of a published report. When referencing a report on a report server in native mode, the report path starts with a forward slash ( / ); For example: /Adventureworks 2008 Sample Reports/Company Sales 2008

    Brouswer the report via IE, you will see the report deployed on the report server.

    Reference:

    Configuring ReportViewer for Remote Processing http://msdn.microsoft.com/en-us/library/ms252075.aspx

    Using the ReportViewer Tasks Smart Tags Panel http://msdn.microsoft.com/en-us/library/ms252072(VS.80).aspx

    Regards,
    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, April 29, 2011 4:06 AM
  • User1471008070 posted

    Hi,

    BIDS is SQL Server Business Intelligence Development Studio, which is used to develop Business Intelligence project, then deploy the RDL report to Report server, then you could use these report in Visual studio.

    Thanks,
    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, May 8, 2011 9:32 PM

All replies

  • User1471008070 posted

    Hi,

    From your information, I get that you want to display the report deployed on the report server via reportviewer control in remote module, Visual Studio comes with freely redistributable Report Viewer controls for embedding Reporting Services functionality into custom applications.

    Firstly, you should design your report in BIDS, then deploy the report on the report server, you might have already done this from your information. What you should do is To add the Report Viewer control to the Web page:

    1. Drag and drop the Report Viewer icon onto the WebForm design surface. The SmartTags panel for the control is automatically displayed.
    2. In the ReportViewer Tasks smart tags panel, in Choose Report, select Server Report.
    3. In the Report Server text box, type the report server URL. The default URL syntax is http://localhost/reportserver. The actual URL that is used in your installation might be different depending on how the report server virtual directory settings are configured.
    4. In the Report Path text box, type the fully qualified path of a published report. When referencing a report on a report server in native mode, the report path starts with a forward slash ( / ); For example: /Adventureworks 2008 Sample Reports/Company Sales 2008

    Brouswer the report via IE, you will see the report deployed on the report server.

    Reference:

    Configuring ReportViewer for Remote Processing http://msdn.microsoft.com/en-us/library/ms252075.aspx

    Using the ReportViewer Tasks Smart Tags Panel http://msdn.microsoft.com/en-us/library/ms252072(VS.80).aspx

    Regards,
    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, April 29, 2011 4:06 AM
  • User-9833593 posted

    Hi my friend ,

    you know what I have done  till here is to make dataset and use report viewer so I used client side reporting and I did not make it with sql server

    then my question here is that 1- what do you mean by BIDS?

                                            2-if I want to use my report in the world of internet not interanet can I use reporting service? 

    Friday, April 29, 2011 8:32 AM
  • User-9833593 posted

    nobody can help?

    Saturday, April 30, 2011 11:13 PM
  • User-9833593 posted

    I am so frustrated,please help me?????????

    Saturday, May 7, 2011 10:20 AM
  • User1471008070 posted

    Hi,

    BIDS is SQL Server Business Intelligence Development Studio, which is used to develop Business Intelligence project, then deploy the RDL report to Report server, then you could use these report in Visual studio.

    Thanks,
    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, May 8, 2011 9:32 PM