Recent content by webuser

Does anyone know if there is a way to make the drop-downs for parameters in Reporting Services Auto-Expand? Right now, when I select a letter, it does go down to that letter in the list but it does not work beyond the first letter. I am used to drop-downs in Access etc. that allow this...

Thanks. So there is no way around this? It's just pretty annoying, especially for automated deployment purposes... I'm just curious though, when you upload the RDL for the first time, are you saying that the parameter and datasource info is stored somewhere other than the RDL on the server? Do...

If I have an existing report on a Report Server, and I modify the report in Visual Studio, then deploy it, only some of the information gets updated on the server. For example, I changed a report parameter from type string to Date/Time and that got updated on the server, but when I added a...

Perfect!

That's great. Thanks! But this returns 2 fields - one for value, one for data. What is the best way to set the value column to a variable? I tried a select from... but it didn't work...

I need to get the name of the Domain that my SQL Server is in using Transact SQL. Is there a function that does this? Like Select GetDomainNameOfMySQLServer() Thanks in advance!

Ok, I guess I can live without the requirement of opening up the URL directly. I can just download the file first, then open it locally from SQL Server. Which brings me to the next part of the question though - can you provide code that will open an xml file (locally), and then parse it and...

I was looking for something that I can do directly from a Stored Procedure. For example, I have gotten this code to work: INSERT INTO T(XmlCol) SELECT * FROM OPENROWSET( BULK 'c:\myfile\MyXML.xml', SINGLE_BLOB) AS x What I would like to improve here is the ability to get the file directly...

What is the best way to do the following: I have a URL that contains an XML file. I need to easily take that XML file and put it in to a table in SQL Server. I will know in advance the fields in the XML file and in the table. I have seen some code using OpenXML, OpenRowset etc. but I have not...

Thanks. That's a good suggestion. I will try it.

In my example, I mentioned a clustered index on Lastname then Firstname. If I tell you that the application has many many WHERE clauses and/or joins on the first name column, I want to know if an additional index on the First Name column would be helpful or if the clustered index (on Last Name...

What if the index is on two columns, for example, a last name and then a first name. So on disk, the table would be sorted with all the last names first, and than the first names. Now, what if I had many queries that needed to find the First name for some reason, wouldn't an additional index on...

I want to know if there is a "Best Pracice" to what I am doing. I have a table with several fields and I know that 2 of the fields should ideally be sorted for best performance, so I added a cluster index that uses both of those fields. What I'd like to know is, do I need to add additional...

Is there any way to embed a Word Document, Excel Document etc. using OLE or some other means directly into a Reporting Services report the way it can be done in for example Microsoft Access? If so, how? And if not, what is the easiest way to accomplish what I am trying to do, and that is - to...

Thanks unclerico! The key was http://servername. I had it under Trusted Sites - when I moved it to Local Intranet, that fixed it!