Search results for query: *

When I export to Excel 2008 from SSRS 2005 the background color LightSteelBlue is lost and shows up grey. This is not the only color that does this. Many others show up grey as well. I've even tried putting in #B0C4DE (LightSteelBlue) for the color. The color always shows up correctly in...

Anyone know if it's possible to to an advanced filter on a dimension according to the 2nd or 3rd digit of the label? For example, on the following label (601NNZ) I want to filter out anything with the 3rd from left digit containing a 1 Any suggestions?

I have a similar situation and thought it would be perfect to add to this thread. I have set up a multi-value parameter which passes a string to dataset. The dataset data type is numeric. The multi-value parameter is non-queried. It's simply asking clients if they want to select 1, 2, 3, 4...

Actually, I am using Sql Server Reporting Services, a major part of Sql Server 2005. You're probably thinking that because of the ". In the expression builders for Reporting Services you can use iif, ", etc.

Does anyone know how to display a hyperlink with an expression. I am trying to display a hyperlink in the detail section of a report. Each line of my report is different so I need a different hyperlink for each row of data. I've been trying to do something like this in the expression builder...

How do you set the Sch-M lock? I tried using this to no avail: @LockMode = 'Sch-M' I get the following message: Procedure or function 'sp_getapplock' expects parameter '@LockMode', which was not supplied.

I am having the same problem as jaz. I'm linked to a View I created in SQL Server. Every time I do a left join with those Views in Access I will miss records from any column that can have nulls (like text fields) Any suggestions? Thanks, Doug

I dropped my linked server and that didn't work. I followed LNBruno's link to the MDX fix for MSOLAP and selected "Allow inprocess" to no avail with the following types of queries: openrowset and openquery. I searched MSDN, MS Help and Support and all over Google with every possible search...

LNBruno - I'm trying to use openrowset as well as run off of a new linked server. gmmastros - I know we recently installed SP2 so here is the result of that query: 9.00.3050.00 SP2

I'm not able to create and insert into this table with SSIS b/c we do not have a USQL license for SSIS yet. I have reviewed the MSDASQL provider options like LBRuno provided in his post. So far that looks promising or at least I'll learn a little about the different types of connections. I...

LNBruno may be on the right track. I checked our linked server provider MSDASQL and our IT dept had it set up with the "Allow inprocess." Anyone understand what that does? SqlDenis has a good point so I'll try and use SSIS right now.

No. No MDX and no Anaylsis server. This is a simple import to SQL Server from our Company software. The two servers are connected directly to each other, nothing in-between.

no comma's in the file, just listed them for illustration purposes. I know decimal and numeric are the same. So you all know this value (353223500185.92) is not a correct value. It will change once a sales order has been updated. It's actually a sales discount column that s/b...

decimal, numeric, nothing works!!! this is so frustrating.

I'm not sure what you mean. I'm not worried about the problem with viewing this column in Access. I just want to fix the problem in SQL Server. Both Access and SQL Server are pulling the data from the same source(our company software program which is basically a flat file). Any ideas on how...

That is a great soution for the Access side of viewing this data. But I need to get it in SQL Server from the same OLE DB source that Access would be reading from. Any idea what needs done on the SQL Server side of things? I only showed the Access side to further explain the weirdness of...

I can't get it to go in any format type or size, whether it be varchar(max), numeric(38,2) etc. I don't think the problem is getting it to fit because I've tried every possible field size and type.

...but I'm pretty sure that wouldn't work b/c it's a data overflow issue. I get the same error even if I do a insert with case when <=9999 else '0' *********************************************************** What I see with a generic link to this table through Access instead of SQl Server...

Is this possible? I have an index on the table, but it's not the way I would typically want to view the table if I SELECT * I just want the table to be consistent for generic viewing purposes. Any ideas would be appreciated. Thank you.

Three times a day I need to drop a table (say, TABLE1) and rename another freshly imported, prepped and indexed table (say, TABLE1_TEMP). They are the exact same table, one just has more current MTD info. I keep getting locked out from dropping TABLE1 as people are running selects and views...