.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Melody Anderson
Post New Web Links

RFC: I want your FB on "RS Parameters Enhancements" for the next major release

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
Hello,RS product team is looking into doing some substantive work in the next release of Reporting Services, related to enhancing parameters. This could include changes to RDL, design tools like BIDS and RB, SOAP API's, Report Manager and SharePoint UI's, and of course the Report Server internals. Without making any commitments, I'll just lob a few "top of the list" features out there to prime the pump:Prompt localizabilityValidation (value ranges, defining invalid values, extensible validation through assemblies, etc.)Tree view of heirarchical parametersHistory and Execution snapshot parameter controlSelect All configuration -- yes or no, top or bottom, etc.Multivalue usabilityPLZ reply to this thread with your "wish list" for better RS parameters. I'd also very much like to see sample reports that use parameters in creative ways, especially if you had to do extra work to compensate for missing features or unexepected behaviors. I'll take all the FB, filter it through the list we already have, and hopefully come up with a list of features we can pull off in time for the next major release that meets as much of your needs as possible.Thanks for your consideration, and regards.Mike

View Complete Post

More Related Resource Links

Editor's Note: A Large Release Wave is Headed your Way


This month Howard Dierking discusses the coverage of Windows Server 2008, SQL Server 2008, and Visual Studio 2008.

Howard Dierking

MSDN Magazine Launch 2008

Delete major doucument version


Hi All,

I have a document library with versioning activated (0.1,0.2,0.3..). i want to keep only 0.1 version and rest delete. when iam trying to delete it is deleting minor version. Can any one tell me how to do this.

Thanks in advance.

Add Release-Only try-catch to CLR languages

Deploying a software, it's a common practice to encapsulate top-most function calls and/or event handlers with general try-catch blocks to deliver an error description to the user instead of just having him/her see the software exiting unexpectedly when unexpected exceptions occur. Unfortunately, during debugging it is most annoying to reach these log entries or message boxes instead of having Visual Studio halt where the exception occured. At the time of writing it is possible to designate particular exception types to halt the debugger when they are actually thrown. But it becomes a nuisance when there are many exception types to be marked this way. Plus, it becomes contra-productive if there is a scenario when expected exceptions of the marked types occur regularly and "Continue" has to be selected again and again in the debugger. Thus, I'd like to suggest to add a new, Microsoft specific, "try" keyword to all of the CLR languages (plus C++), perhaps something like "__try". This new kind of try should create a try-catch block only when compiling in Release mode. (This behaviour might apply to other configurations as well. I suppose the Configuration Settings dialog to provide an additional checkbox column to provide an option to select whether a particular configuration will create a try-catch block or not.)   See here for

VS2010 Web App does not build Release - Could not load AjaxControlToolkit error

I have a VS2010 Web Application that uses the AjaxControlToolkit. I am able to build the Debug configuration. When I build the release configuration I get the following error message: Error 89 Could not load file or assembly 'file:///S:\My Code\Libraries\ACT\May 2010\AjaxControlToolkit.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515) S:\My Code\EZFishing\EZFishing\EZFishing\SGEN EZFishing The location of the file is correct, and I just downloaded and unzipped there the Ajax CT. I have always built this app correctly before upgrading to VS2010 and ACT May 2010. Any idea of what is going on? Thank you in advance for your help. Mauro  

is the overarchitecting of a solution a major problem in the development world today.

Hello all,I have been on this project for a while and wanted to get your thoughts.I have been working on a Sharepoint solution for a while to create a ASP .Net feature in Visual Studio. Now this is your standard CRUD application that queries data, displays data, updates data etc.As I am proceeding to code in this the original developer has used quite a few patterns MVP, observer, commands, repository and a couple of others. Being that this is Sharepoint developement and integration with Sharepoint is not good at all, I am finding that to much time is spent managing facets of the patterns rather than actually finishing the app. Another point is that debugging a Sharepont app with VS2008 is a pain because I have to redeploy the app everytime to make sure my changes worked.My chief concern is that its taking me going through about5 hours, 8 different objects having to redeploy the app to sharepoint over 10 times to test my code just to populate a couple of grids and comboboxes. It just seems more efficient use of my time program this app just seperating out my data access and business logic layers and calling the them from my code behind in my ASP .Net pages. It just seemed like he used the patterns just to use them without understanding why they are needed or a patterns proper place in an app..What do you guys think?

Release a public program - read me/warranty

Do i need to include a read me or anything like this? ( i copied this...) This program is provided as-is without any warranty, implied or otherwise. By using this program, the end user agrees to take full responsibility regarding its proper and lawful use. The authors/hosts/distributors cannot be held responsible for any damage resulting in the use of this program, nor can they be held accountable for the manner in which it is used. I wouldn't be blamed if something happened to someones computer if i include this, right?

Can't Get .Net to Release Memory From Destroyed Objects

Hey folks, I have a rather large WPF (.net 3.5 sp1) business app.  There are 2 projects within the solution.  One project contains my business objects and all database interaction and business logic.  The other project is the front end ui.  Multiple tabs, many controls on each tab, lots of data, lots of objects bound to controls... All works very well.  My problem is that when I reload the data (which is semi-frequent), the old business objects that held the prior data never gets released by the Garbage Collector, so the size of the app continues to increase. I've tried nearly everything I can think of.  I've ensured nothing held a reference to the objects that were destroyed.  Anything that had a dispose function, I ensured that I called it.  Set everything to null.  I called the gc manually to make sure it wasn't just a delayed call.  Set WPF user controls to null that were bound to my objects.  Even tried moving it to .Net 4.0 to see if it was something resolved with the new version. I'v also researched WPF memory leaks, but I don't think any of the situations apply to me.  Finally I installed .Net Memory Profiler which confirmed that the old instances are still alive and consuming memory, but I can't figure out why (although I'm not an expert at using the .Net Memory Profiler app). One guess I had (but ca

Resuming of workflows from InstanceStore in Workflow 4.0 Release Candidate

Hi,  I am using the WorkflowApplication object to invoke the Workflows. In this type of invokcation, after the workflow persisted,  in case of delay activity, in beta 2 there is no support to autmatic invocation in case of expiry of timers. But in case workflowservicehost the WWF invokes the expired timers workflow instrances automatically.  When I posted the same to forums some time back, I got answer that in the  Release Candidate Mcrosoft will be providing the support of for automatic invocation even the workflows are invoked through the workflow application object.  Now I am using Custom batch job for doing the same. Please let us know about this scenario. If Microsoft provides the support please let me know the process. If there is no automatic invocation support, Can we expect in future?Thanksrajeevkalyan

Debug and Release Buids

I have a solution containing a windows forms application and a class library.  The windows forms application has a reference to the class library project.  When I build the project, it fails to find the class library output.  Looking closer at this, it appears that VS.NET is looking for the debug build, but the class library has been built in release mode.Since I have no idea how to switch between debug and release (used to be a toolbar option) I would have assumed that since I must be in debug mode, VS.NET would have built both in debug mode and no problems.  So why has it built my class library in release mode and attempt to build my forms application in debug mode, then fail because it can't find the debug version of the class library?Help much appreciated.

Non-Release version 603?

I have installed the ebay selling starter kit. It was written within Visual Studio.Net 2005 using Sql Server 2005. I was under the impression that I could work with a Sql 2005 database (ebayTraders.mdf) even though I am using Sql Express 2008. When trying to open the database, I get an error message stating that the db cannot be upgraded with this non-release version of Sql Server (603). I don't want to install sql server 2005. Any suggestions? Thanks. Jeff

"Failed to grant minimum permission requests" when building release mode dll

Hi there,I have started to receive a  release mode build failure for which I  would appreciate some advice. The build works fine in debug but sgen fails in release when a dll that contains a web-reference is linking to a c++\cli dll on the network. The debug build links to the same (release mode) c++\cli dll without this problem.I believe this has started since adding the web-reference. Any idea what the work around is?Many thanks.Duncan4>C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\bin\sgen.exe /assembly:"C:\Projects\Forecaster\Source 2.0\GH.Forecaster.IO\obj\Release\GH.Forecaster.IO.dll" /proxytypes /reference:S:\SoftwareUtils\Release\GH.Common\Release\Latest\GH.Common.Unmanaged.dll /reference:S:\SoftwareUtils\Release\GH.Common\Release\Latest\GH.Common.Util.dll /reference:"C:\Projects\Forecaster\Source 2.0\Release\GH.Forecaster.Data.dll" /reference:"C:\Projects\Forecaster\Source 2.0\Release\GH.Forecaster.Util.dll" /reference:S:\External\log4net-1.2.10\bin\net\2.0\release\log4net.dll /reference:"C:\Program Files\NUnit-Net-2.0 2.2.8\bin\nunit.framework.dll" /reference:C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.dll /reference:C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.dll /reference:C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.EnterpriseServices.dll /reference:C:\WINDOWS\Microsoft.NET\Framework\v2

varbinary (max) release space used after delete?




When -all- records from a table with a varbinary(max) column are deleted (not via truncate), the table properties

still show a dataspace size from before the delete operation.

Inserting new blob records only leads in the growth of the allocated space withouth reusing the empty

already allocated space.


Runnning commands like dbcc updatusage/checkdb/cleantable/reindex or sp_spaceused @updateusage = N'TRUE'

seem to have no effect.


Does anyone know when space allocated by a varbinary col. is released?





running SQL 2005 STD ed SP2. DB is in simple recovery mode.


How can I use the Resolver.FindCompletions method in the R2 SMO release?


I'm working on an application that allows users to author T-Sql in a text editor, and displays an Intellisense like popup as the user types. After discovering the SqlServer 2008 R2 Feature Pack, I downloaded the SMO portion of the release, as it appears that Microsoft made a bunch of APIs public and redistributable that can be used for this purpose. However, after playing with it, I'm looking for help with using the Resolver.FindCompletions method.

Specifically, I'm looking to understand the purpose of its ParseResult and IMetadataDisplayInfoProvider parameters. Is the idea that I parse my SQL query locally and pass the result to FindCompletions(), as opposed to giving it the SQL string directly? And what is expected for IMetadataDisplayInfoProvider? Also, how do I tell FindCompletions what SQL connection to access in order to derive a completions list? Are there examples somewhere that demonstrate how this function is intended to be used?

Thanks very much for any help,


Release mode application throws Break instruction exception - code 80000003 when running in WinDbg


Here is the initial output of my program after running it from WinDbg:

CommandLine: "C:\Documents and Settings\Administrator\My Documents\Work\QMI_Test_Tool\QMI_UT_Source\Release\QMI Validation Tool.exe"
Symbol search path is: SRV*c:\symbols*http://msdl.microsoft.com/download/symbols
Executable search path is: 
ModLoad: 00400000 0048f000  QMI Validation Tool.exe
ModLoad: 7c900000 7c9b2000  ntdll.dll
ModLoad: 79000000 7904a000  C:\WINDOWS\system32\mscoree.dll
ModLoad: 7c800000 7c8f6000  C:\WINDOWS\system32\KERNEL32.dll
ModLoad: 77dd0000 77e6b000  C:\WINDOWS\system32\advapi32.dll
ModLoad: 77e70000 77f03000  C:\WINDOWS\system32\RPCRT4.dll
ModLoad: 77fe0000 77ff1000  C:\WINDOWS\system32\Secur32.dll
ModLoad: 7c420000 7c4a7000  C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989\MSVCP80.dll
ModLoad: 78130000 781cb000  C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989\MSVCR80.dll
ModLoad: 77c10000 77c68000  C:\WINDOWS\system32\msvcrt.dll
ModLoad: 7c9c0000 7d1d7000  C:\WINDOWS\system32\SHELL32.dll
ModLoad: 77f10000 77f59000  C:\WINDOWS\system32\GDI32.dll
ModLoad: 7e410000 7e4a1000  C:\WINDOWS\system32\USER32.dll
ModLoad: 77f60000 77fd6000  C:\WINDOWS\system32\SHLWAPI.dll
ModLoad: 7c4c0000 7c53d000  C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989\m

DisposableCOMProxy doesnt appear to release underlying DLL


Hello All,

I am writing a windows forms application (in C# targetting .NET v2 x86), that instanciates a COM object by its ProgID, calls a few methods on it to check its version , and then disposes it (with the dispose interface that the DisposeableCOMProxy provides). 

Based on the method calls to the COM object, my program will download and run an MSI that updates the dll that contains the COM object (should an update be required).  The MSI is set to remove previous versions, and all this happens automatically.

My problem is that the MSI shuts down my forms application because it claims that it still has a handle on the dll - the below is an excerpt from the msi verbose log:

MSI (s) (40:74) [14:38:06:141]: RESTART MANAGER: Will attempt to shut down and restart applications in no UI modes.
MSI (s) (40:74) [14:38:06:141]: RESTART MANAGER: Detected that application with id 3676, friendly name 'MyApp', of type RmUnknownApp and status 1 holds file[s] in use.

The MSI only contains one file, and thats the dll file that the DisposableCOMProxy used when i instanciated the COM Object with the progid.

Ive tried explicitly calling GC.Collect() and subsequently calling GC.WaitForPendingFinalizers()

None of this works!

How can I remove the "lock" on this file? is it even a lock?

Is this an issue

Deploy in Release Mode


Hi I'm developing a web application in VS2008 (VB.Net).


How do I set configuration to Release mode?

I followed this thead and was able to display configuration DropDownList. But it is disabled.



Thanks for the help!!


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend