Search results for query: *

=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...

because reports are displayed on a browser you might lose some of the pagination feature when viewing the report. The default view in Visual Studio when you're designing reports is also browser like. however another option you have is to see the reports in print view and from there (depending...

Hi if you have created the report properly just run and refresh the data and all should work just fine there is no other code to write its one of the basic functions of RS -Mo

you could do in your SQL script, if you give some more info I could have look -Mo

I have noticed that when you export to excel if you have header, footers and/or group slightly offline it will create merged cells which are a pain to work with. it could be that what causes the error lays in the way the report is formatted. When I create a report that has to be exported to...

hi rogerzebra, the way I use multi values is this: @MultiParam string Multivalue option checked. Value could be from select statement or you add the values manually. @MultiParamList string hidden value: =Join(Parameters!MultiParam.Value,", ") default value: non quered =...