Answer Questions

• 87jerome report viewer and reporting services security

  i have a web application in studio 2005 using the report viewer control. i have my own security model implemented on my web pages for clients [1..n] each of the [1..n] clients should be able to view reports of their order history. i have the report viewer set up in url mode. the question is that when i have drill downs in my final reports, a user with some tech knowledge, would be able to obtain the url to my sql server running reporting services. the sql server will not be given a port 80 acess. how do i go about displaying reports without any savvy user being able to locate the server locations/credentials i donot want to create windows account for each [1..n] clients as this is ever growing ...Show All

• Avy32 Set the option "Use as Windows credentials when connecting to the data source" in Report Designer

  For reasons that I am yet to figure out, the only way to make data source work with our configuration is to use "Credentials stored securely in the report server" with option "Use as Windows credentials when connecting to the data source" checked. This can be done with report manager, but I do not know how this can be done with Report Designer in Vsisual Studio. Could anyone offer some tips Thanks, ...Show All

• Thomas82 Two Newbie Reports Questions

  Hi, I have a report with 3 parameters. One of which is Company name. To get the available list for this I use a query: select distinct name from companies, etc. However, I also want the user to be able to select "All" or an equivalent to get all the companies. I tried putting * and % in the default values (non-query), but the drop down list displays "<select a value>". Also I've enabled drill-down, is there a way to auto-expand the results Thanks, Dan Just worked it out, by clicking on the row, edit group, then setting the display setting to initially visible rather than hidden. Thats brilliant, thanks. Does anybody know how to auto-enabl ...Show All

• gavin beard How to do multiple rows insert?

  I want to do bulk insert of data into table. I need to do it using System.Data.SqlServerCe namespace; Already tryed 2 methods. 1) SqlCeCommand command = Connection.CreateCommand(); command.CommandText = "Insert INTO [Table] (col1, col2) Values (val1, val2); Insert INTO [Table] (col1, col2) Values(val11, val22)"; if (Connection.State != System.Data.ConnectionState.Closed) {   Connection.Close(); } Connection.Open(); command.ExecuteNonQuery(); Connection.Close(); Doesn't work because of parsing error. Appearantly semicolon isn't understood in commandText, although if commandText is executed in SQL Management Studio it executes flawlessly. 2) SqlCeCommand command = Connection.CreateCommand(); command.CommandText = "INSER ...Show All

• JeevesIndia Can't find PInvoke sqlceme30.dll

  I am using an O2 XDA II mini running Windows Mobile 2003 SE. Tried creating a Windows Mobile 5.0 Pocket PC project but during deployment, I get this error. Can't find PInvoke sqlceme30.dll I have searched thru the forums and found something similar. I tried all their recommendations but no luck. Is there anything I am doing wrong I copied the DLL files in the device's \Windows directory (sqlceme30.dll, sql*.dll...around 5 DLLs) I would appreciate any assistance Hi Ilya, I was just testing it out. Not really for production. I just want to make sure I am doing things right. How do you install the CAB files in the device Yes, you have to install NETCF first. If NETCF it not detected by SQL Mobile CAB, it won't i ...Show All

• s26f84 Error adding existing SSIS Package to new Project

  Hi, All: I am relatively new to SQL Server 2005 SSIS. I encountered the below error while trying to add an existing package to a newly created Project: Failed to save package file <path_filename> with error 0x80029C4A "Error loading type library/DLL.". If someone has encountered this error, please reply with a solution or suggestions. Thanks. Actually, all of the SQL components are installed; however, there are no Service Packs installed. The OS is 32-bit. Thanks for your reply. I have resolved this issue. Thanks everyone. Looks like installation error. What SQL components and Service Packs have you i ...Show All

• JWhite Limit rows to 25 in the body

  Im trying to limit the body of the report to 25 rows before page break. Any help would be appreciated. Hi, Erik, Look for the Page Breaks section in this topic: http://msdn2.microsoft.com/en-us/library/ms157328.aspx --------------------------------------------------------------------------- Download the latest Books Online update: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• tackett ViewReport event

  Hello, I have in an aspx page a reportViewer. I wander if there's any option to catch the user's pressing on the 'ViewReport' button. this is because i have two forms, the report is in the left one, in the beginning this frame is big - to anable the user to see all the parameters, and after he choose the 'ViewReport' I want to reduce the width of the whole frame before the report will be shown. thanks, Talia. ...Show All

• byronfromwesleyan Return value for "NOT EXISTS"

  Hi I frequently use the "If NOT EXISTS (Select ...) Insert ..." statement and would like to display a message to the user after the execution of the statement to say whether the Insert was or wasn't executed. Is there a way to get SQL to return a value that will tell me if the Insert was carried out or not If not, perhaps you know of some other efficient way of handling this situation. Regards Neil @@ROWCOUNT (Transact-SQL) Send Feedback Visual Basic (Declaration) C# C++ J# JScript Returns the number of rows affected by the last statement. Syntax @@ROWCOUNT Return Types int ...Show All

• zion99 Multiple selects on PArameter drop down

  I have a parameter dropdown as USERID. I want a functionality that the user can selct multiple userid's to show more than one record as output for comparison purpose. How can i achieve this multiple select (i.e cntrl+click) within parameter dropdown. Thanks, Kiran. Did this work for you Sorry, I had assumed that you were running RS 2005. In Reporting Services 2000, a report parameter can only be defined to allow the user to enter a single value. Jarret Hmmm... You could try changing the parameter type to string and make your data query use 'IN', then have the user type a comma delimited list. I haven't tried it, but ...Show All

• Dottj Can't uninstall previous version of AdventureWorks database

  I want to install the new (February 2007) sample databases. The readme says any previous version must be removed by dropping the database., then running Remove from Add or Remove Programs. I've detached the database, but when I try to uninstall it I get the following message: "Error 1309.Error reading from file: pathandfilename.mdf. Verify that the file exists and that you can access it." What should I do. Barry Deleting the two database files (after detaching of course!), then running the Uninstall from Add/Remove programs worked! It sounds like the uninstall is expecting the file to exisit and you much have deleted it If you run a repair first it s ...Show All

• Billr17 SQL SERVER 2005 Backup

  I am new to sql server 2005.I am trying to set up databse backup using databse management.but some how it is not working and i am getting error after all settings done. Can any one have experience on this. plz i am in desperate trouble. I am thanksful to you in advance. Thanks, Bharat. hi, SQL Server Agent is "the" scheduler for SQL Server, as it is builtin the system... but is not provided by SQLExpress... you can use "alternate scheduler" to perform all maintenance required tasks, but not Maintenance Plans.. you can define your own "scripts" to be scheduled by AT/SCHTASKS OS based scheduler, or write your own or buy a commercial one.. personally I ...Show All

• mario.muja putting data into table B from table A without using a cursor

  on SQL Server 2005, no SP. Currently using a cursor in a stored procedure to retrieve data from one table and to put it into another table. like so: declare @HTR money declare @Uniqueid varchar(15) declare cur_HTR cursor for select uniqueid, sum(hours_to_resolve) as thtr from com_trail_helpdesk_module group by uniqueid open cur_htr fetch next from cur_HTR into @Uniqueid, @HTR while @@fetch_status = 0 begin update com_hpd_helpdesk_history set total_hours_to_resolve = @HTR where case_id_ = @Uniqueid and dateasat = @dateasat fetch next from cur_HTR into @Uniqueid, @HTR end close cur_htr deallocate cur_htr ... This is taking about 45 minutes each time to do 21k records. Is there a faster, better way to do this ...Show All

• darknessangel SQL Server 2K client do not connect to DB server with IP addresses added to same NIC

  I am setting up a lab on a Windows server 2003 Standard Edition that works as a Database Server. Some clients connct to this database server; clients are on different subnet. Routing is ruled with Windows server 2003 RRAS. The differents subnets are created adding IP addresses to the network interface (I mean: TCP/IP Properties - General - Advanced - IP Settings - IP Addresses - Add) Clients ping without problem with server, I access to folders. Then I connected the first client SQL using SQL Server Client, I run registration, Everything works. I can see SQLServer, I managed everything as usual. In this case IP client is 192.168.1.50 and IP for server is 192.168.1.1 (his IP is in the "general" page of TCP/IP Proper ...Show All

• 0xDEADBEEF SQL Server 2005 SELECT MAX function for multiple columns on the same record

  Hello, I am trying to figure out how to use the select maximum command in SQL Server 2005. I have already created a database and I have it populate it with multiple fields and multiple records. I Would like to create a new column or field which contains the maximum value from four of the fields. I have already created a column and I am trying to figure out how to use a command or SQL statement which is entered into the computed equation or formula in the properties for this field/column. Any help you can provide will be greatly appreciated! Thank you, Nathan thread will be moved to the appropriate subform when the forum is fully running again this function bel ...Show All