penninha's Q&A profile

• SQL Server Create User Roles in Reporting Server 2005

  Hi, I would like to create the folders Sales, Orders and Credit under the Home folder. The Sales folder contains a set of reports that should be accessible to a group of users, similarly Orders folder contains a set of reports that should be accessible to a group of users. I do not have facility to create user groups in SQL Reporting Service. I create a user group in my machine (from Control Panel) but Reporting service is not able to view this group. I am able to add individual users to a folder, but I would like to check if I can create a group and then add users to this group. Any help in how to resolve this issue. Cheers, Hi Jarret, Thanks!! The problem was that I have to use ...Show All

• SQL Server Preferred index for a standard history/activity table design

  Imagine the following table: MyTableActivity -------------------- MyTableActivityId (pk, guid) MyTableId (fk, guid) MyUserId (fk, guid) ActivityTypeId (int, guid) ActivityDateTime (datetime) Comment (varchar(max)) This is pretty common, right One way or another, this is kind of an audit log of another table (referenced by MyTableId). My question is in regards to what would be the best index(es) to place on this table. The three fields in question are MyTableId, ActivityTypeId, and ActivityDateTime, as these are (at least in my system) far and away the most frequent search criteria. Users will either typically want: All rows for MyTableId, sorted by ActivityDateTime All rows for MyTableId and ActivityTypeId, sorted by ActivityDateTime The ...Show All

• Visual Studio Express Editions How can i change MonthCalendar's language? (VC#.net2005)

  i used MonthCalendar toolbox but day and month are in Thai language (i'm Thai). So i need to change it to English. How can i do that need help thank Aonz Are you sure Thai is not set as the default language of your browser If I'm not mistaken, you can't set the culture on the calendar itself. However, you can set it either on your whole website, or on a particular page. To set it on the whole site. Set the globalization tag within the system.web tag. Something like this: < globalization culture = "en " uiCulture = "en " /> If you'd rather set it in one single page, you could use the following: protected override void ...Show All

• SQL Server Access project connecting to SQL 2005

  Most of our users are using MS Access project to work with our data in SQL Server 2005. The problem we have is that in order for them to access the tables they need to be given db_datareader and db_datawriter permission on the database. Our goal is not to give access to the tables themselves but to views. Therefore, we've created several views and placed them into a particular schema. Now we want to give access to that schema, but when we assign select, delete, insert, and update to that schema user in ms access project aren't able to view these tables. When we give them db_datareader permission they are able to see the views but in parentencies does not show the correct schema; therefore, when you try to open that view it errors out sayin ...Show All

• Visual Studio Express Editions Manually changing location of a Form in Minimized State / Form.ShowInTaskbar=False

  I need help on a problem as bellow: I have Form1 that the Form1.ShowInTaskbar property set to False , After click on the minimized box when the form is in normal state it goes down and locate in the bottom - Left of my screen (excactly above the windows start button). I Want to change the location of this little title-bar. I have written the code bellow in Form1.move event but it is working just After I click on the maximized button and this will change my form-location at the normal window state: Me.Location = New Point(598, 850) note : I have not any restore button in my form so my form is not sizable Pls F1 me . . . !! Try something like this: Private Sub Form1_Resize(By ...Show All

• Visual C++ Clock

  How would I code a live simple 12 hour format clock that keeps up with my system's clock on my program with "hours, minutes, and seconds" on a status strip on the bottom right http://www.codersource.net/mfc_working_with_timers.html That's an article on using timers. WM_TIMER is probably what you want to type into your search engine for more info, if you need it http://msdn.microsoft.com/library/default.asp url=/library/en-us/vclib/html/_CRT_localtime.asp This MSDN article shows you how to format the system time into a string. You need a slight modification of the code in the second link ( to remove the date part ) to run inside a timer event, and then to assign that string to your status bar. ...Show All

• .NET Development Parameter within WITH-Clause in MDX

  Hi, I need a parameter within the WITH part of an MDX Statement in Reporting Services. I tried several types, but all will bring an error. I will do it like: WITH MEMBER [Measures].[Amount] AS STRTOMEMBER(@MyMeasure) SELECT { [Measures].[Amount] } on columns, ...... The @MyMeasures should be a combobox with the values like Name: Sales Volume (kg) Value: [Measures].[Sales Volume KG] Name: Sales Volume (m2) Value: [Measures].[Sales Volume KG] ... and so on. What's my failure Thanks Hans What is the error you get Please post the exact error text. This should be moved to either the Analysis Services ( http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=83&SiteID=1 ) or Reportin ...Show All

• SQL Server Efficient way than IN statement

  I have two tables JDECurrencyRates and JDE Currency Conversion I want to insert all the records all the records from JDECurrencyRates to JDECurrencyConversion that does not exists in JDECurrencyConversion table. For matching I am to use three keys i.e. FromCurrency, TO Currency and Effdate To achieve this task i wrote the following query INSERT INTO PresentationEurope . dbo . JDECurrencyConversion ( Date , FromCurrency , FromCurrencyDesc , ToCurrency , ToCurrencyDesc , EffDate , FromExchRate , ToExchRate , CreationDatetime , ChangeDatetime ) ( SELECT effdate as date , FromCurrency , FromCurrencyDesc , ToCurrency , ToCurrencyDesc , EffDate , FromExchRate , ToExchRate , GETDATE (), GETDATE () FROM ...Show All

• Windows Forms INI files

  Hey, I searched MSDN for this but I could not find anything on it... How do you have the program recongnize a .ini file I have called it load.ini and this is what it is inside of it: [firstload] firsttime = 1 I am trying to make it so that in the Private Sub Form_Load it will look for the ini file and read it, is firsttime = 1 then it is going to open up a dialog, otherwise it will do nothing, I can do all of that, I just need to know how to have it find the ini file... I placed the ini file in the project's folder... Thanks :) The keywords and phrases. As for broadening my horizons...lol.  I know html, c++ and C#.  I am teaching myself asp .net as well....  not to mention i ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. device create fails

  I tried to run my d3d application on a computer with an on board graphic card - and as a result the create device fails. I tried many to change the DeviceType, but it didn't help. I tried changing the XVertexProcessing options. stiill no good. What am i doing wrong Thanks. Check the capabilities of the device. It could be that you're using an unsupported depth buffer format, multisampling, etc. ...Show All

• Visual Studio Team System Shelveset manipulation

  Hi, Ever since I heard about the guantlet, I have been trying to implement a similar idea for our build/release system. I just hit a few snags. In my implementation, once a shelveset has been submitted, the shelveset must not be modified by the developers. Initially, I thought about just changing the owner -- trivial right! Not really. To do this, I had to create a workspace, unshelve the shelveset, reshelve the shelveset and finally delete the workspace. Is there an easier way to do this without unshelving the whole set Suppose I want to append a PendingChange to a shelveset (either from another shelveset or from the current workspace) assuming of course that there are no conflicts. Would I need to unshelve and then reshelve the ...Show All

• Smart Device Development port VS2005 application to CE5.0 platform

  I have a C# project built with VS2005 and I want port it to CE5.0. In CE's platform builder, I could not find "Compact Framework 2.0" in Catelog so I cannot add it to my OS. I have CF2.0 installed on my PC. How can I config my CE PlatformBuilder to import CF2.0 Without CF2.0 included in my OS and when I try to connect to my hardware target, I run into "ActiveSync" problem. Is it related to CF2.0 Any advices are appreciated! The .NET CF 2.0 and CF 2.0 SP1 updates are still available from the Microsoft Downloads Site. Get the Download named 'Windows CE 5.0 Platform Builder - Cumulative Product Update Rollup Package (through 12/31/2006' ( http://www.microsoft.com/downlo ...Show All

• Windows Live Developer Forums Scale and messages language?

  The default scale is in miles, can I setup the scale in km units The server messages appears in English, can be setup so that they appear in other languages Thanks!! Default scale is miles. You can call this before or right after map initialization: MapControl.Features.ScaleBarKilometers = true; This will set the scalebar in the bottom of the map to kilometers. When you calculate routes, you can specify which unit to use. I don't think the server messages are in other languages. You can translate them yourself by overriding them. ...Show All

• Visual Studio Express Editions LNK1104: cannot open file 'uuid.lib'

  Hi everybody, I wanted to try the rakkarsoft network library and I was following this tutorial. When I add lines of code similar to: rakClientInterface=RakNetworkFactory::GetRakClientInterface(); I get a linker error when compiling: LINK : fatal error LNK1104: cannot open file 'uuid.lib' I don't understand what I have to do. I searched on the web but couldn't find anything. Please help me if you can. PS: as you can imagine I use Visial C++ 2005 Express Edition. I also installed Microsoft Platform SDK (R2) --Actually the problem shouldn't be related to raknet because I got it also when compiling another OpenGL-based project Check your dependancies. The uuid.lib fi ...Show All

• Visual Studio 2008 (Pre-release) TreeView & HierarchicalDataTemplate

  Hi, I am using HierarchicalDataTemplate to bind my TreeView to list a set of directories. In our applicatoin, we have a favorites menu, from which user can navigate directly to a particular node in the tree. I got the logic to get the active item. But I couldn't set it to the SelectedItem or SelectedValue of the TreeView as they are readonly properties. Is there a way to hack this or this is not possible in WPF with HierarchicalDataTemplate. Please help me, this is blocking me to go further. Thanks, -------------------------------- Raghavendra RAV After successfully expand the node and select it, I believe you also wanna bring it into the view, you can do so by using TreeViewItem.BringIntoView(). Sheva ...Show All