SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Custom reports wont load in SSMS?


Custom reports wont load in SSMS?

Author
Message
rbecl
rbecl
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 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
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17071 Visits: 7415
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”
rbecl
rbecl
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 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
rbecl
rbecl
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 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
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17071 Visits: 7415
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”
dj1202
dj1202
Old Hand
Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)

Group: General Forum Members
Points: 361 Visits: 231
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.
mrady
mrady
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search