Answer Questions

• eldiener toogle "point labels"

  I have a line chart that i want to have point lables on but i want to give the user the option of having the point lables or not. Basically because if there is alot of data it is ugly. Can this done through code A report paramerater If you set the data point label position to "Auto", the chart will position the labels so that there is no overlapping. If there are too many data point labels, it will remove labels to make room. Alternatively, you would also look into a conditional expression for the data point label string. E.g. you could only show labels if the data point value exceeds a certain threshold: =iif(Sum(Fields!A.Value) > 100, Sum(Fields!A.Value), " ") -- Robe ...Show All

• Eric-NZ Mobile merge simple question

  So when a mobile device pulls down information, say a typical order entry scenario, then continues to edit/add orders and merges those changes back to the server, when/how are those records ever purged from the device once they are no longer needed Let me rephrase this question I have. If you wanted the device to only contain the "working" data for that user and the subscription was partitioned to sync "open" orders, what happens to the orders on the device once the user changes them to "closed" If they are never removed, wouldn't your device DB continue to grow with data that is no longer relevant Thanks     My question is then how do you ever ...Show All

• Rob Ainscough Parameter Selection via checkbox?

  Good afternoon Dudes and Dudettes, I have a report which requires three boolean parameters (actaully they're strings acting as boolean - for some reason the boolean parameter labels wouldn't behave properly after they were deployed to the report server, but that's another story) to be satisfied before the report is run. Currently the Yes, No options are selected from a dropdown list for each parameter - is there a way to change this to a checkbox instead   Y'know, if box is checked then parameter is True, if blank then false Thanks very much y'all, Chris   Guess not ...Show All

• BlueMikey SSAS: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))

  Hi, Iam getting Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) error, when Iam trying to browse a cube in the SQL Management Studio or the Business Intelligence Development Studio. Please let me know how to resolve this asap. Iam able to query on the cubes using mdx, but to see the pivot table view or browse tab, iam getting the above error. Iam using SQL Server 2005 and Visual Studio 2005. Regards, Varma. I am getting the same error. I am seeing a lot of people reporting this error, on other forums, but no one has an answer. WORKED FOR ME!!! http://www.microsoft.com/downloads/details.aspx FamilyID=7287252c-402e-4f72-97a5-e0fd290d4b76&D ...Show All

• Bravo2007 Export import dataset/ stored procedureS?

  Hello. I am making an application that works towards SQL Express database. These Stored procedures are saved in database. I need to use these SP in another database that I have. Is it possible of exporting these and importing to my new database I found out that I could just copy the SP one by one. I have not found any expost import function in SQL2005express og SQL2005 but luckily I did not have that many SP's to copy Hi Njofra, I have the same question but I don't see an answer - basically "How". Did you ever get an answer to your original question I have both SQL Server 2000 and SQL Server 2005 Express. I built a bunch of new stored procedu ...Show All

• mirolslaw Error message returned when executing package via C# app on Citrix

  Hi, I'm at a loss as to why i am getting the following error: Retrieving the COM class factory for component CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E}failed due to the following error: 80040154 I am calling the package from a C# application which i have installed within a citrix environment. The application works without any trouble on my development machine but as soon as i run the code that executes the SSIS pacakge i get the error. Can anyone enlighten me as to what is causing this Many thanks in advance, Grant Hi Sven, Thanks for you're reply. I had wondered about this. I have referenced the SQL DTS dll's for when i call the SSIS package. I have however included these files in the deployment pack ...Show All

• mbaird Table/Index Monitoring

  Is there a way to track tables/indexes/stored procedures that are being used I know that the Profiler can do this but I am looking for a way to query a system table to get this information. Oracle has a way to turn on/off monitorint for tables and indexes so I was wondering if this info is avaialble and if so if something needs to be done to activate the collection of the info. Thanks Thanks, but I think you misunderstood. I am trying to determine tables/indexes and stored procedures in the database that can be safely removed. Therefore, I would like to see if there is a way to audit whether or not a table is being used. ...Show All

• Paulo Reichert SSIS Crashes while validating Data Flows

  Hi all, I'm stuck here when I try to open an existing package which contains several data flows, SSIS tries to validate each data flow and after a while a Visual Studio error message pops up and I can't do anything.  The error message says : "Unable to cast COM object of type 'System._ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject90'. This operation failed because the QueryInterface call on Com component for the interface with IID '...GUID...' failed due to the following error : The application called an interface that was marshalled for a different thread. (Exception from HResult: RPC_E_WRONG_THREAD)" Did anyone has seen this error message Any help will be appreciated. Sebastien ...Show All

• lance p SQL Express -How much RAM per instance?

  How is memory, (RAM) used per instance in SQL Express 2005 I am aware that SQL Express will use only 1 GB of RAM, but is that as a whole, or per instance thanks. hi, per instance... regards ...Show All

• Luis Esteban Valencia Muñoz Anonymous Access from Pivot Table to OLAP 2005

  My asp-net web application connect to Analysis Services 2005 through Pivot Table client. To use anonymous access with AS2000 i used to add this property to the connection string of the pivot: "SSPI=anonymous". Which property give me the same thing with AS2005 Thanks! Hi, The SSPI connection property is still there, so it should work the same. Are you getting an error David Botzenhart Thanks, it's working. But, if i set "Impersonation Level" property to Anonymous Is this the same of SSPI=anonymous Hey David - good to hear from you ! Yes, you could still use SSPI=anonymous, but I really recommend in AS2005 to use standar ...Show All

• JacobRonnie escape characters

  Hi, I need to insert this command into a table, but I can't because. insert XXX set column1 = isnull ( Title , '' ) + case when ( case when title is null then 1 else 0 end ) = 1 then '' else ' ' end + isnull ( Last_name , '' ) + case when ( case when First_name is null then 1 else 0 end ) = 1 then '' else ' ' end + isnull ( First_name , '' ) + case when ( case when Middle_initial is null then 1 else 0 end )= 1 then '' else ' ' + isnull ( Middle_initial , '' ) END I don't know how to use escape sequence, I need insert just once thanks hi i really dont understnd your problem. does thi ...Show All

• turnbui (Item Lookup Error! hr=80040e21, hrDesc=Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if av

  Hi, I am using ATL COM library application. It is using sql data base for fetching the records. Some times, i get the following error. could you please let me know, why this happens This is not reproduceble every time. (Error! hr=80040e21, hrDesc=Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work Here is the code to connect to database which i am using. CDataSource db; CDBPropSet dbinit(DBPROPSET_DBINIT); dbinit.AddProperty(DBPROP_AUTH_INTEGRATED, OLESTR("SSPI")); dbinit.AddProperty(DBPROP_INIT_CATALOG, (const char *)bDatabase); dbinit.AddProperty(DBPROP_INIT_DATASOURCE, (const char *)bServer); dbinit.AddProperty(DBPROP_INIT_LCID, (long)1033); dbinit.AddPropert ...Show All

• DVD_SH default values in SQL Server 2005

  I'm running the September CTP of SQL Server 2005 and I noticed that the way default values are scripted and displayed in the tools has changed. In SQL Server 2000, if I create a table with an INT field with a default value of 0, it gets scripted as FIELDNAME INT DEFAULT (0) Enterprise Manager also shows (0). If you type in 0 for the default (no parentheses) and save, it converts it to (0) in the UI, and it will be scripted with one set of parentheses. In SQL Server 2005 it seems to add an additional set of parentheses. Hence, if you type in 0 for the default in Management Studio, it changes it to ((0)) Furthermore, if you script the table you get FIELDNAME INT DEFAULT ((0)) Is this change intended I couldnt find any references in BOL. ...Show All

• thedo Calculate difference between two rows

  Hi, i have a matrix, and in that matrix i need to have one column which calculates the percentage change between a value on the current row and the same value on the previous row. Is this possible The RunningValue() function isn't of help as it can't help me calculate the change between two rows, and Previous() doesn't work in a matrix (why !!!!!). Also calculating this as part of the query isn't possible as there is a single row group on the matrix, and the query is MDX.* Thanks, sluggy *for those who are curious, the matrix is showing data an a per week basis, the row group is snapshot date, i am trying to measure the change in sales at each snapshot. Hi Everyone, I ...Show All

• Anthony Borton Encryption - Protect from attacks by programmers?

  I can encrypt columns in sql 2005 but where do I store the key to decrypt the columns I can store the key in the database (or server on which the database resides) but I think that offers little security. I could store the key on another server that the sql server accesses only upon startup (though I don't know exactly how to do that). Or I could store the key on a removable drive that is read (and only needed) when the sql server starts up. What are your ideas on this matter TIA, barkingdog Hi, I have a different type of problem. Lets say I have created a Symetric key (without using a password) and i authorize that key to a user called ASP_NET_My_Appln. This user is used by my UI(A ...Show All