Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Reporting Services by Paul Turley, Todd Bryant, James Counihan, Dave DuVarney; ISBN: 9780764584978
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old January 11th, 2007, 04:38 PM
Registered User
 
Join Date: Jan 2007
Location: San Juan Capistrano, CA, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 13 - Registering a Custom Data Extension

I am having a horrible time registering the custom DataExtension described in the book. I downloaded the sample and built the project. I've added pre-build and post-build steps to copy the DLL (I'm using the C# project only).

Within VS.NET BIDS, the DataSource is registered by the name in the config files (not the DataSetConnection.LocalizedName which shows up when everything is truly installed and registered properly). However, when I close DataSource dialogs I get an error suggesting I look at the RSReportDesigner.config - it looks fine.

When I use IE7 and the ReportManger URL, the DataSource list does not contain any sign that our DataExtension is registered.

I am a bit baffled by the registry entries. They basically fall into two categories; types and URLs.

According to the instructions in the book, the "RsReport*.config" have type entries that take the form "<[u]Namespace.Extension.Connection</u>>,<[u]Namespace.Extension</u>>". Simple enough, except this is the one the designer complains about. These entries would be the same for either the C# or VB solution. Interestingly, the C# project's default namespace "DataSetDataExtensionCS" is not used anywhere in the project (which uses "[u]Wrox.ReportingServices.DataSetDataExtension</u>").

According to the instructions in the book, the "*Policy.config" contain URLs that look like a normal path, but end in the namespace-dot-dll - which doesn't look like a normal URL (eg "...\[u]Wrox.ReportingServices.DatSetDataExtension.dll</u>"). Also, it doesn't match the DLL name which actually ends in "CS" or "VB" depending on the project. I'm a little baffled by just what these entries are supposed to be - URLs or namespaces or what.

If anyone can help me straighten this out, I would appreciate it. Is the same configuration supposed to work with either the C# or VB versions? Is their some log file somewhere that I can be looking at to see what is wrong? Is their some way to cause these files to be loaded manually (trying to open ReportServer.asmx in VS.NET was interesting).

Thanks.
Reply With Quote
  #2 (permalink)  
Old January 15th, 2007, 03:30 PM
Registered User
 
Join Date: Jan 2007
Location: San Juan Capistrano, CA, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I found a work around. I changed the assembly name to "Wrox.ReportingServices.CustomDataExtension" so that it looks like the path. I still don't know what it is supposed to be, but it doesn't matter since both assembly and namespace now look the same.
Reply With Quote
  #3 (permalink)  
Old January 10th, 2008, 11:49 AM
Registered User
 
Join Date: Jan 2008
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Oh, yes yes yes.

Thank-you, thank-you, thank-you :-)

I've been working on this for the past two days, and it now works. Now for the next stage

Regards

&lt;&lt;&lt;Bryan Avery&gt;&gt;&gt;
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do the SSRS - Custom Delivery Extension pnviv Reporting Services 1 March 18th, 2008 12:55 AM
How to debug a SSRS 2005 Custom Data Extension MBryga BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 1 January 10th, 2008 11:33 AM
How to debug a SSRS 2005 Custom Data Extension MBryga Reporting Services 0 January 16th, 2007 01:57 PM
Chapter 13 - Custom Control does not show up Technobob BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 0 November 23rd, 2004 01:01 PM
Chapter 13 - Creating Your Own Custom Controls msjolin BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 2 February 16th, 2004 09:01 PM



All times are GMT -4. The time now is 05:28 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.