Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Custom reports wont load in SSMS? Expand / Collapse
Author
Message
Posted Tuesday, June 21, 2011 3:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 24, 2011 5:14 AM
Points: 6, Visits: 25
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

Post #1128851
Posted Tuesday, June 21, 2011 4:26 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:28 AM
Points: 4,050, Visits: 5,365
Have the CRI components been installed on the report authoring server and the report server?
http://msdn.microsoft.com/en-us/library/cc645969.aspx
http://msdn.microsoft.com/en-us/library/ms345253.aspx


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1128863
Posted Tuesday, June 21, 2011 4:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 24, 2011 5:14 AM
Points: 6, Visits: 25
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
Post #1128870
Posted Tuesday, June 21, 2011 4:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 24, 2011 5:14 AM
Points: 6, Visits: 25
Please note, I also found the below link:

http://connect.microsoft.com/SQLServer/feedback/details/585398/reports-built-in-bids2008r2-dont-work-as-custom-reports-in-ssms2008r2
Post #1128872
Posted Tuesday, June 21, 2011 5:17 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:28 AM
Points: 4,050, Visits: 5,365
rbecl (6/21/2011)
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.


You will have to request the administrators to confirm if this has indeed been deployed.
the only way to really tell is if there is a CRI item in the toolbox


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1128890
Posted Saturday, June 30, 2012 12:21 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, August 17, 2013 7:45 PM
Points: 65, Visits: 228
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.
Post #1323474
Posted Tuesday, April 1, 2014 4:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 11:43 AM
Points: 12, Visits: 8
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.

Post #1557270
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse