none
ReportViewer control local and remote mode differences RRS feed

  • Question

  •  Questions on reporting (using VS 2008 designer or SSRS):

    1)  If an SSRS engine service  is setup using SQL Server 2008 express on a server:

        a)  Can the data itself reside in a separate SQL 2005 server that exists either on the same machine or a separate machine?  If so, what limitations are there as far as design (e.g. html rendering in textboxes, export to MSFT Word Doc format, etc) and output?  Will the report run against 2005 data in a separate sql server?
        b) Can the report be designed using VS 2008 ide or does it have to be designed using the tools in SSRS? (We use the reportviewer control in a winform to preview/print the report)
        c)  Can the reportviewer control be hosted in a winform and used to produce the report?  Right now I create 'dummy' datasources during design mode and then during production I push the data to the report behind the scenes using the same datasource name that was using during the design process.  As long as the layout and structure is identical, it works.  Will that work with rdl reports as well?
        c) Can I programmatically set the report and add the datasources of the rdl report as I do now (the data exists locally in a list, dataset, or table already pulled from sql server) with local reports (rdlc) in c#? (ex: ReportDataSource odtReportData = new ReportDataSource("CustomerDataSet_CustomerData", odt) where odt is a table and I set the report in code using: reportViewer.LocalReport.ReportPath = "r_empl1.rdlc")
       d) How to allow the customer to use an existing report we created and allow them to modify it or copy it to another report and modify the copy and run it?

    2)  If using local reports and the report is designed in VS2008 (using reportviewer control in local mode) and the report is stored in a separate assembly (what I am doing now), how to:
     
       a) Render html in a textbox on the report (rdlc) from a SQL2005 database
       b) Export to Word Doc format from the reportviewer on a winform
       c) Allow the user to edit the report as in d) above
       d) produce rounded corners on textboxes (instead of using a shape behind the textbox)


    Thanks All!

    tracy
    Thursday, February 26, 2009 5:16 PM

Answers

  • 1a - Yes.  The data used in the report can be from a large number of data sources, including SQL 2005.

    1b - VS 2008 creates RDL using the SQL 2005 schema.  You can publish that 2005 schema to a 2008 report server.

    1c - RDL and RDLC are nearly identical in schema.  RDLC simply doesn't require connection or query information for data sources.  You can use an RDL in local mode.  You can also point the report viewer at a server and view a published RDL.

    1c2 - You can't supply data directly from the application to a report running on the report server.  The report server will execute the queries defined in the RDL.

    1d - RDL is just an XML file.  Users can load it into our report authoring tools to modify it.  Or you can implement a custom tool.

    2a - HTML data in a text box, including formatting, is not available with the 2005 RDL schema.  This feature is in 2008.  An updated viewer capable of reading the 2008 RDL schema in local mode is coming.  http://blogs.msdn.com/brianhartman/archive/2008/12/05/sql-server-2008-and-the-reportviewer-controls.aspx

    2b - This feature in not available in the report viewer in local mode today.  It will be in the next version.  If you view a report on the server, you can export to any format available on the server, including Word (in SQL 2008).

    2c - Same as above.
    • Marked as answer by tcCoder Saturday, February 28, 2009 3:34 PM
    Saturday, February 28, 2009 4:36 AM
    Moderator

All replies

  • 1a - Yes.  The data used in the report can be from a large number of data sources, including SQL 2005.

    1b - VS 2008 creates RDL using the SQL 2005 schema.  You can publish that 2005 schema to a 2008 report server.

    1c - RDL and RDLC are nearly identical in schema.  RDLC simply doesn't require connection or query information for data sources.  You can use an RDL in local mode.  You can also point the report viewer at a server and view a published RDL.

    1c2 - You can't supply data directly from the application to a report running on the report server.  The report server will execute the queries defined in the RDL.

    1d - RDL is just an XML file.  Users can load it into our report authoring tools to modify it.  Or you can implement a custom tool.

    2a - HTML data in a text box, including formatting, is not available with the 2005 RDL schema.  This feature is in 2008.  An updated viewer capable of reading the 2008 RDL schema in local mode is coming.  http://blogs.msdn.com/brianhartman/archive/2008/12/05/sql-server-2008-and-the-reportviewer-controls.aspx

    2b - This feature in not available in the report viewer in local mode today.  It will be in the next version.  If you view a report on the server, you can export to any format available on the server, including Word (in SQL 2008).

    2c - Same as above.
    • Marked as answer by tcCoder Saturday, February 28, 2009 3:34 PM
    Saturday, February 28, 2009 4:36 AM
    Moderator
  • Thank you so much for taking the time to answer each of my questions!  I really appreciate it and it will assist us in making a decision on which route to go with reporting features.
    Saturday, February 28, 2009 3:33 PM
  • Hi Brian,


    We are using VS 2008 and SQL SERVER 2008, is it possible to export report to MS Word in local mode processing?
    Also in your point 2b you said it will be available in next version. could you tell which is that version and when it is expected to release (with the export to MS word in local mode reports will be available).

    Thanks in Advance.





    Tuesday, September 8, 2009 1:20 PM
  • See Robert Bruckner's response here:

    Last response on Saturday, February 28, 2009 9:44 PM:

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c7780d80-0f98-4691-9e50-44366e5c8b1b
    Tuesday, September 8, 2009 1:56 PM
  • 1a - Yes.  The data used in the report can be from a large number of data sources, including SQL 2005.

    1b - VS 2008 creates RDL using the SQL 2005 schema.  You can publish that 2005 schema to a 2008 report server.

    1c - RDL and RDLC are nearly identical in schema.  RDLC simply doesn't require connection or query information for data sources.  You can use an RDL in local mode.  You can also point the report viewer at a server and view a published RDL.

    1c2 - You can't supply data directly from the application to a report running on the report server.  The report server will execute the queries defined in the RDL.

    1d - RDL is just an XML file.  Users can load it into our report authoring tools to modify it.  Or you can implement a custom tool.

    2a - HTML data in a text box, including formatting, is not available with the 2005 RDL schema.  This feature is in 2008.  An updated viewer capable of reading the 2008 RDL schema in local mode is coming.  http://blogs.msdn.com/brianhartman/archive/2008/12/05/sql-server-2008-and-the-reportviewer-controls.aspx

    2b - This feature in not available in the report viewer in local mode today.  It will be in the next version.  If you view a report on the server, you can export to any format available on the server, including Word (in SQL 2008).

    2c - Same as above.

    Hi,

    Are the new features (html rendering and export to Word) in the latest CTP of VS2010?  They were not in the first one.

    Thanks!

    Tracy
    Sunday, January 17, 2010 5:02 PM
  • The first CTP of VS 2010 did not contain any of the new features of the Report Viewer, but the latest CTP does, including Word rendering in local mode.  http://blogs.msdn.com/brianhartman/archive/2009/10/22/visual-studio-2010-beta-2-is-now-available.aspx

    Sunday, January 17, 2010 5:39 PM
    Moderator
  • The first CTP of VS 2010 did not contain any of the new features of the Report Viewer, but the latest CTP does, including Word rendering in local mode.  http://blogs.msdn.com/brianhartman/archive/2009/10/22/visual-studio-2010-beta-2-is-now-available.aspx


    Cool!  Thanks!
    Sunday, January 17, 2010 5:51 PM
  • ...
    1b - VS 2008 creates RDL using the SQL 2005 schema.  You can publish that 2005 schema to a 2008 report server.
    ...


    Would you change this statement now given the time that has passed?  If it's true that it's in 2005 schema then why does the file start off saying xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"?

    That being the case, why does my target reject (Dynamics CRM on SQL Server 2005) the report with the error "The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded"

    Or, if there is a way to make VS2008 save as RDL2005, how does one set that?

    Monday, September 20, 2010 3:36 PM