Urlik's Q&A profile

• SQL Server SSRS 2005 - SOS - Need top xxx rank as paramenters - SOS

  Hey, I have a requirement to print out sales report which has interactive sort on the Net Sales Column (which is all taken care of)...now, I need to include a new column which displays the ranks dynamically as the user chooses the interactive sort to be Ascending or Descending. The Rank Column will be required to display the ranks as serial numbers and takes into consideration the TOTALS on the summary row and not the detail lines. When I hit RowNumber(Nothing) , I get the row numbered on the details line and not the Summary line (I have enabled drill down as you can tell by now). I presume I cannot use the RANK() OVER function here in the query, because, the ranks cannot be assigned here as the query pulls up all the details a ...Show All

• Visual Studio Team System SMTP - Project Alerts

  I installed a (on a ocal domain) TFS but forgot the smtp settings configuration We do not have any exchange nor anything and I installed SMTP and POP3 for Win2K3 Then I entered all the values that are available in the forums But nope It does not send any project alert Any help would be appreciated Have you tries these troubleshooting steps for SMTP configuration Testing SMTP pipes: http://blogs.msdn.com/psheill/archive/2005/11/22/495863.aspx . Check SMTP configuration in msdn help http://msdn2.microsoft.com/en-US/library/ms400808.aspx Have you also tried other troubleshooting steps under http://blogs.msdn.com/narend/archive/2006/07/27/679571.aspx ...Show All

• Visual Studio What's wrong with MSVS SP1? It does not extract at all...

  The file name is: VS80sp1-KB926601-X86-ENU.exe After quite a few hours(> 4 + ) waiting, it still did about 60% of extraction... and the process seemed dead. I killed it a few times and re-executed it, it didn't work at all. I rebooted my Windows XP several times. Still didn't work. What's wrong I am using MS Visual Studio 2005 Academic version. Thanks Check this blog to see if anything mentioned in there might fit to your symptoms: https://blogs.msdn.com/heaths/archive/2006/12/29/the-visual-studio-2005-service-pack-1-installation-experience.aspx -- SvenC ...Show All

• Windows Live Developer Forums Website development

  Hi there I have been reading up a bit on website development and have been interested in finding out how it works when a site is interactive i.e. asking questions and providing answers to the questions. In particular, and as an example, if I write a simple engineering programme (in for instance visual basic) to calculate the headloss in a pipe, and I offer this programme on the web, how can I obtain input from the person wanting to use the programme (eg the lenght and diameter of the pipe) and then upon receipt of the information, carry out the calculation with the visual basic programme, and giving back the answer to the internet user. Many thanks Cheers Astericks Hi Astericks, You need to ...Show All

• .NET Development How to get notified if finalization is aborted?

  During an application shutdown the finalization can be aborted if all finalizer did take longer than 40s to execute or if one finalizer does take longer than 2s to execute. In these cases no exception is thrown and I have a hard time to find out which one was the bad guy. Is there some tracing built into the CLR to find out which finalizer (call stack would be nice) did cause the abortion of a finalizer during application shutdown Yours, Alois Kraus A trivial solution... You can write an entry in a log, with the first instruction in each Finalize method... The last entry in the log will indicate the class... ...Show All

• Visual Studio Team System Wanted, Web load tester - Cambridge (UK)

  We may need to make use of a web load testing expert for a week or two. The task will includes writing some automatic load tests and telling us how many users our system can cope with etc. The work will have to be done on site in Cambridge (UK), as we expect to learn how to do it ourselves by working with the person. If the person has used lots of different load testing tools so match the better, as they can then help us pick the tools. Can anyone recommend someone Please email me at "inneedofspeed at ringrose dot name" (Anyone that phones me or email me at my normal email address will disqualify them selves from getting the work. If we go ahead I will of course let anyone that looks hopeful know the name of my employer and ...Show All

• Visual Studio Express Editions install problems

  ok i went to intall and it said i needed to download system pack 2 so i did and i restarted my computer but when i went to install it it still said i needed to install system pack 2 Hello Re: install problems I am going to mark this thread as answered since you have not followed up with any further information on your problem - I assume you solved the problem yourself or one of the suggestions in this thread helped you solved the problem. If you have a solution you could post it so others can find it. If you do not have a solution then please submit further details and then mark the thread as unanswered. Thanks Damien ...Show All

• Windows Forms Datagrid Header as Combo box

  Hi, I would like my hearders in my data grid view to be drop down boxes. Every coloum should be drop downs with all the possible values for that coloum. So if there is a coloum called Color, I should be able to click on it and choose the color, and only those will be displayed below. Is this possible This is helpful http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=224323&SiteID=1 ...Show All

• SQL Server Getting the uniqueName and name of members in a Calculated set?

  I'm trying to do this to have a somewhat dynamic parameter value list in Reporting Services 2005. I need to be able to show Customer.Territory or a different type of Territory (this will be determined based on another parameter). When running some initial mdx I get the error: The CURRENT function cannot be invoked in this context because the 'aa' set is not in the scope. I'd prefix aa with Customer, but there are multiple attributes in Customer, and I'd then need to respecify which attribute I'd want to be accessing - this would defeat the purpose of the set. I need the ending name "aa" to always be aa (for Reporting Services), so Customer.Territory.aa or Customer.TerritoryType2.aa would not be static. with set aa ...Show All

• Windows Forms Insert/Delete in Datagrid

  I have a form with a datagrid, which is sourced from a dataset. I would like to add buttons to this for to Insert, Delete and Undo (if possible). I am not sure how to do this using datagrids/dataset functionality. Can someone give me pointers on how this may be done. I do have the update scripts written and they work fine, just wanting to add additional functionality to the form. Thanks in advance Insert is available for detailsView not datagrid. AutogenerateDeleteButton = True AutogenerateUpdateButton = True You'll also have to code a query for each and add the parameters. Adamus ...Show All

• .NET Development How to sort an xml data island by a field

  I have an xml data island like this.. actually a few hundred web pages using a similar form <xml id="xmldataisland"> <table_T> <table_R> <field1>1</field1> <field2>Beer</field1> <field3>Mmm</field3> </table_R> <table_R> <field1>2</field1> <field2>Wine</field1> <field3>kkk</field3> </table_R> </table_T> </xml> that is, root > record > fields I would like to write a javascript function to sort the records within the xml data island by a view. So for example sortmyisland(xmldataisland, "field2"); I haven't got a clue about xsl - if anyone could help me write thi ...Show All

• Visual Studio Team System how to check who is accesing TFS

  Hi , In my team we are having 5 administrators in TFS , all are giving some permissions to users, at some time it goes wrong. so i wan to know is there any way to identify who is accesing and giving permissions to whome in TFS, please help. thanks and regards suresh Thanks for your support, but still i was not able to get the result... any how i shall do some R&D on this.. and if i have doubts i shall come back to you... thanks and regards suresh ...Show All

• Software Development for Windows Vista Returns non-zero value for the handle while using LoadLibrary in vista

  Hi, I tried this code directly from the following link: http://www.devx.com/vb2themax/Tip/18307 It worked fine on my XP machine.But when i tried the following code on my vista machine...even when the Dll did not exist it returned a non-zero value...whilst it shud return null. please help me. Private Declare Function LoadLibrary Lib "kernel32" Alias "LoadLibraryA" (ByVal _ lpLibFileName As String) As Long Private Declare Function GetProcAddress Lib "kernel32" (ByVal hModule As Long, _ ByVal lpProcName As String) As Long Private Declare Function FreeLibrary Lib "kernel32" (ByVal hLibModule As Long) _ As Long Function IsProcedureAvailable(ByVal ProcedureName As String, _ ByVal DllFilename As String ...Show All

• Windows Forms BindingSource question about saving updates.

  I have a very simple table setup in SQL Express 2005. Category - ID int identity PK - Description varchar(100) NOT NULL - SetupDate datetime NOT NULL - ChangeDate datetime NOT NULL SetupDate and ChangeDate have a default value setup in the database. I used the wizard to add a connection to the database. I dragged the fields onto a test form and then ran the app. I tried adding a new record by putting in just the Description and then saving (since ID is auto generated and there are default values for SetupDate and ChangeDate), but it is giving me an error on the BindingSource1.EndEdit() saying Null values are not allowed in the SetupDate field. Which is true, but it should be getting the default value from the database when ...Show All

• Visual C++ Controlling a Monitor Using ACPI

  I am programming an application to turn ON/OFF a monitor using ACPI function calls. Does anyone know the strategy involved or where I can find example code Any direction help would be appreciated. Thanks Hello Re: Controlling a Monitor Using ACPI Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All