Recent content by MisterMo

=iif(Fields!db_bud_desc_line1.Value = NOTHING ,Fields!a_account_desc.Value,Fields!db_bud_desc_line1.Value) SSRS way to read null value fields -Mo If you don't stand for something, you'll fall for anything

just nest the query into another select statement eg: select sum(case when col1 in 'acc10','Acc11' then col2+col3+col4 else 0 end) as Gr1, sum(case when col1 in 'acc11','Acc12' then col2+col3+col4 else 0 end) as Gr2, sum(case when col1 = 'acc30' then col2+col3+col4 else 0 end) as Gr3 from...

i think that the problem should fix itself as soon as you deploy the report. any attempt to work with dates on the developement platform almost always fail, I am still forced to test data by entering 1/1/2008 or 3/3/2008 so that when the month and day swap places(american format) it does not...

try something like this declare @DateType varchar(20), @Flag int, @StartDate datetime, @EndDate datetime set @DateType = 'DueDatess' set @StartDate = '2001/01/01' set @EndDate = '2002/02/02' if @DateType = 'DueDate' set @Flag = 1 else set @Flag = 2 select PurchaseOrderID...

just an idea, What about sending the report to a single email and them have a policy set on that email to forward the report to whoever you wish to.... as I said Just an Idea -Mo If you don't stand for something, you'll fall for anything

because yoy set the no count on the last teransaction only will be returned by the stored procedure which is an update, you might be able to see stuff in SQL but reporting needs a dataset to work with, add a select statement as the last statement of the stored proc to return whatever data it is...

I am not 100% sure that this would work because you have declared t1,t2,t3 and then keep on referencing t2 and t3 and redeclaring t1 and every statement. I would also wrap the statement in a view or stored procedure because is a heck of a statement with more than 60 queries to pass in RS. it...

sorry but your logic is quite confusing 1) your function should return a string but you want to return an array 2) you have a return inside the loop without exit function and that will break the code 3) I can only assume that you want to read the array, remove commas(,), (:) and (.). And then...

if that's the case you can remove those keys from RS Manager -Mo If you don't stand for something, you'll fall for anything

Sorry but what exactly do you mean with array? How do you want the data to be displyed? could you be more specific? -Mo If you don't stand for something, you'll fall for anything

or replace(replace("0100000, 0201T00, 0301T00, 0401T00"," ",""),",", vbCRLF) -Mo

replace("0100000, 0201T00, 0301T00, 0401T00", ",", vbCRLF) -Mo

As I said before if you have set the report properties right it will do exactly what you want. Body Properties: Columns = 2 0r 3 depending on how much space you have ColumnSpacing = .5 space between columns if this is right you will see your table on one column and the other column/s will be...

try and log from SQL server and see if you get the same problem -Mo

Visual Studio and RS are two different things they might connect to the same database but that's it. if the services is running check that a domain Admin user is actually running such service. another thing worth checking is if IIS is still working properly, sometime stop and re-start...