Answer Questions

• Radvis harnessing Reportviewer toolbar buttons

  Hello everyone, Well ive never used Reportviewer before and ive been trying all this week to harness the events in the buttons of the reportviewer toolbar... the thing is that i need to hide the toolbar for UI reasons but i dont know how to make my own buttons to have the functionality of those included in the reportviewers toolbar. i know this is possible.. but can someone pleeeease give me a hand! P.S: and by the way is it possible in both rdl and rdlc or just rdlc Thanks Egli please its urgent!!! can anyone help me ...Show All

• amendez Data Source View of Mining Structure cant be edited?

  Hi, all here, Thank you very much for your kind attention. I got a quite a strange problem with Mining structure for OLAP data source though. The problem is: I am not able to edit the mining structure in the mining structure editor. The whole data source view within the mining structure editor is greyed. Could please anyone here give me any advices for that Thank you very much in advance for any help for that. With best regards, Yours sincerely,   Hi, Jamie, thank you very much for your guidance. Sorry for the bad description of the problem. What I originally meant is that: the mining structure cant be edited within the mining structure editor when its data source is OALP. Why is that Is it the limitati ...Show All

• Shril Pyrrho Problem generating XML version of ListChildren using URL access to ReportServer (XML of Render works fine)

  Folks, I want to programatically obtain the list of reports for a given directory in the reportserver, and I don't want to use either web services or the normal HTML view of reports that is shown. According to the docs , I should be able to use the URL access approach to do this, yet I find that it does not work, specifically calling the ListChildren command this way, as in: http://localhost/ReportServer /test&rs:Command=ListChildren&rs:format=XML It simply always provided an HTML view of the list of reports in that /test directory. Now, as proof that this is not a problem with generating XML in general from RS, I will note that the following will indeed give me an XML version of one of the reports in that very directory: ...Show All

• Thanh Duong regular expressions in transact sql

  hi guys, i need some help tp write code in order to search the string ( regular expressions) in t- sql. e.g. when a user enters [A-Z] it means any alphabet from 'A' to 'Z'... similarly [0-9] means any digit. the problem is: when user enters [0-6] and the string received contains digit 5 it should return true but if it contains 7 it should return false. so how do i read the [A-Z] as a range of characters in t-sql   Yes.. if you want to find the repeated chars you can use the following condtions.... columnname not like '%aaa%' and columnname not like '%bbb%' and columnname not like '%ccc%' and columnname not like '%ddd%' and columnname not like '%eee%' and columnname not like '%fff%' and columnname ...Show All

• hapazlam Unicode characters stored incorrectly in SQL 2005

  I have SQL 2005 installed as back-end for MCMS 2002 , when storing a unicode content like Arabic , and query it direclty from SQL it appears like كيف الحال The english text stored correctly and can be read. Note that same senario with SQL 2000 the unicode data cane be viewed correctly. Regards Does this affect operation of MCMS or not   Could you please list data types for SQL Server 2000 and 2005 in this case Did it change Is it ntext or nvarchar() vs. ntext and varchar()   I’m not familiar with MCMS but they may be choosing to store data HTML encoded ( ) and use single-byte data type as oppos ...Show All

• Sai A Setting a Minimum support threshold for association rule mining

  What is the best practice in setting a minimum support threshold for market basket analysis Is there a formula Does it depend on ROI you predict There isn't a formula. The minimum threshold is there for two reasons. One, to filter out data that is inconsequential, and two, to prevent the algorithm from running out of memory. If you only want to find strong correlations, you can set it high. If you want a wide range of unknown correlations, set it low. It's best to experiment with the results and performance you get from the algorithm to see which settings work best for your particular situation. Thanks Moving to the data mining forum ...Show All

• Allan-Nielsen Reporting Services custom authentication and web reportviewer - familiar question

  This is a subject that has been brought up before but I have not seen a definitive answer/solution. We have implemented a custom authentication extension (forms authentication) for reporting services and it has been working just fine under "normal" conditions; "normal" being users logging in, viewing reports, and then moving on. Recently some reports were created by our report group and they contain Dundas gauge controls for "dashboard" style reports. These reports are meant to be up all day and they post back every few seconds because the data they present is mission critical. This of course exposed the inability of the reportviewer control to stay in the context of Report Manager when it comes to the cookie ...Show All

• Alastair Q Migrate AS2005 Cube to New Version of Source DB

  Is it possible -- and how straightforward is it -- to migrate an existing AS2005 Cube (and/or at least it's dimensions) to an updated version of my source DB (SQL 2005) I had little choice but to establish a "dev-and-test" version of the source DB during enhancements that coincided with production analysis and reporting. Now that I've approved the "dev-and-test" version, I want to make it our production master for OLAP. As a note, I don't believe that any of the fields used in the cube have been modified. We've just added some new calculated fields (and sp's). I have little idea of whether this will be simple, hard or impossible. I'm planning to try, but wanted expert feedback first. ...Show All

• cyberjoe2 HELP! database restore using SQL Express

  I've try to do the database restore in Microsoft SQL Server 2005 Express using sql command as below: RESTORE DATABASE testJG FROM DISK = 'c:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Backup\JGsql.bak' GO But I get this error message. Msg 3102, Level 16, State 1, Line 1 RESTORE cannot process database 'testJG' because it is in use by this session. It is recommended that the master database be used when performing this operation. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Does this means that I need to restore the master database from systems database to the database testJG before I restore the backup database ...Show All

• Neotech How can I get Actual Operation Cost from Actual Execution Plan?

  I have a view in SQLServer 2005. It took 30 sec. to finish. Then I deleted 4500 records from one table that is used in view. It took 90 sec. to finish now. I did a comparison on Actual Execution Plan between before I deleted data and after I deleted data, they are almost same, only different is Actual Number Rows become less after deleted data. So, I wonder why data become less but time become more. When I look closely on the Actual Execution Plan, the ridiculous thing is, there are only Estimated Operation Cost on each step, no Actual Operation Cost. I guess there are something wrong with optimizer because reuse same Execution Plan, but how can I tell which step wrong without Actual Operation Cost. Thanks! Henry ...Show All

• gobby74 SQL Mobile create sdf file from SQL 2005 DB

  Hi, I'm trying to create a SQL Mobile .sdf file from my SQL Server 2005 database and cannot. I read the ms support docs for doing this and have had no luck . I created the respective publication and SQL Subscription for the db and when i run the process (not sure if i'm running the right process - docs don't say) it creates a directory under a "unc" directory with all my table objects (articles) with subscription/replication files for each table such as .cft, .bcp, .dri, .prc, .sch, and .trg. But no .sdf file for my SQL Server 2005 database. All I want is the .sdf file so that i can copy it to my Pocket PC device and then connect my mobile application to it. I want to copy my SQL Server 2005 database to my device so that t ...Show All

• scyle Merge replication between same schema databases but different data

  Hi all. I 'm trying to set up merge replication between two servers that have the same schema databases. The two database have the majority of there data the same but as well as data inserted at a later time independently on the two servers. (The two servers were connected in a merge replication scheme that failed at some later  time and replication was paused, but users continout to insert data indepentedly at the two servers.) I need to get them up and running. I cleaned replication at both servers, I recreated the publication at the puplisher distributor and all is fine. When I create a push subscription to the subscriper I get the error invalid column name ' rowguidcol ' . I so far managed to have merge replicatio ...Show All

• clint 2 How to select the row that has the maximum value in one field

  This has me stumped. I have a table UnitRateItems with the following columns ItemID, Description and  table UnitRates with the following columns ItemID,Year,UnitRate UnitRateItems and UnitRates have a primary-foreign key relationship on ItemID. In UnitRates, there may be several rows with the same value for ItemID but a different value for Year.  What I want to do is pick the row with the largest value of Year for a given ItemID.  I want to do this for ALL the rows in the table (not just for a particular ItemID). In other words, I want to return one row in UnitRates for each row in UnitRateItems. I want that one row to be the one with the highest Year for that ItemID. It sounds simple, but I can't see ...Show All

• arkiboys just downloaded advanced services

  hey all, i just downloaded sqlexpress and advanced services but i don't see how to get to management studio thanks, rodchar hi, have a look at http://www.microsoft.com/downloads/details.aspx familyid=3C856B93-369F-4C6F-9357-C35384179543&displaylang=en regards Management Studio Express is available from the Start menu after you install SQL Express Advanced. If it is not there, you likely did not select it from the feature tree (it's not installed by default) so you'll need to go back into Maintenance mode and select it. That should get you going. Mike ...Show All

• molemenacer TransferDatabase task in SSIS

  Hi I am trying to write a dynamic Transfer Database task in my SSIS package which generates the DestinationDatabaseName and DestinationDatabaseFiles on the fly before each run. I have written a Script task which generates a string in the format("MyDB_data.mdf","C:\Data","";"MyDB_log.ldf","C:\Data","") and stores this in a variable which is then bound to the DestinationDatabaseFiles property using Expressions.  But I keep getting the following error- Package Validation Error (Package Validation Error) =================================== Error at Copy MyDB monthly snapshot database [Transfer Database Task]: The number of source transfer files and the number of destination transfer files must be the same. ...Show All