Custom reports wont load in SSMS?

  • Hi,

    I have created a custom report which I want to load into SQL Server (by right clicking on the server name and adding the custom report). When I try to do this I get the following error:

    [highlight=#ffff11]------------------------------

    An error occurred during local report processing. (Microsoft.ReportViewer.WinForms)

    ------------------------------

    ADDITIONAL INFORMATION:

    The definition of the report 'Main Report' is invalid. (Microsoft.ReportViewer.Common)

    ------------------------------

    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. (Microsoft.ReportViewer.Common)------------------------------[/highlight]

    The report was built using BIDS 2008 and the report is run in SQL Server 2008.

    I have no idea what this means or how to resolve it. Can someone please help explain to me what this means and how I can resolve it thereby loading the custom report into SSMS?

    Many thanks,

    Richard

  • This was removed by the editor as SPAM

  • Thank you stewartc-708166.

    I am unable to verify that this was installed since I did not install the software. Is there anyway that I can check? Please note that I am not the administrator of the system.

    Many thanks for your quick response,

    Rbecl

  • This was removed by the editor as SPAM

  • I also experience this issue, and have yet to find a way to load an .RDL as a custom report under Database Snapshots in SSMS. Receiving the error "The definition of the report 'Main Report' is invalid. (Microsoft.ReportViewer.Common)"

    I can, however, load it in SSRS under 'Add Existing Item.'

    The report was built in ReportBuilder 2.0.

  • I have encountered the problem and See that MS will not take care of this issue because architectural considerations ...

    There is a way to create custom reports using VS 2008 and have them show up in SSMS. It took some digging and a lot of luck but there was a backup file that was created immediately after initial creation of the report.

    If I named the report 'MyReport', the file 'MyReport.rdl' exists in the solution directory but there is also a 'MyReport - Backup.rdl' which is created along with it. That RDL works.

    To make modifications, you need to know a lot of XML because any changes you would like in the report, need to be edited using and XML editor. (i.e. width of fields)

    I could not get any of the widgets to work ever but I only played with it for a few hours and I need to move on to more tasks.

    so:

    1) Add a new report

    2) select your data source

    3) Add your query

    4) select the report type

    5) Add the fields into (page,group, details)

    6) Choose your table style

    7) name the report

    8) click on finish

    now look in the directory where the rdl is saved and you will see the backup file.

    This is good for single select custom reports.

    Hope it helps.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply