Viewing 15 posts - 31 through 45 (of 65 total)
why do you need to loop through?
is there a word that always follows "datasource" and "computer"?
if there is, look for those and use CHARINDEX to work it out
it not, you...
January 25, 2010 at 9:50 am
in fact, it was puzzling so much, i had a crack at the script task
' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic
' The ScriptMain...
January 25, 2010 at 9:14 am
ok...my initial thoughts...
not that straight forward as the for..next container doesn't have the functionality to go through worksheets
so, i propose
1) a script task that opens the workbook, loops through the...
January 25, 2010 at 6:43 am
Hendra Eka Putra (9/16/2009)
I don't really understand what you are trying to do, because you had one row in Dec.
you misunderstand, i want a 1 in january as that...
September 17, 2009 at 2:55 am
figured it out!
joy of joys
don't need a subreport
didn't realise i could have two matices in the body
doh
cheers for looking though
April 1, 2009 at 8:49 am
attached
the bit i'm struggling with is the sub total bit
April 1, 2009 at 7:17 am
as a follow up question...
i have
CASE
WHEN ISEMPTY([Measures].[Projected]) THEN null
ELSE
CASE [Measures].[Projected]
WHEN 0 THEN 0
ELSE [Measures].[Projected]/[Measures].[Principal...
March 27, 2009 at 7:42 am
Dan English (2/27/2009)
March 10, 2009 at 12:07 pm
actually...i think i've got it
WHERE
CROSSJOIN
(
[CCY].[CCY].&[GBP]
,
UNION
(
([StartDate].[Start Date].[All],[FromDate].[FromDate].&[2009-02-23T00:00:00])
,
([StartDate].[Start Date].&[2009-02-23T00:00:00],[FromDate].[FromDate].[All])
)
)
February 24, 2009 at 6:16 am
wahey!
got it
even more thanks
i knew that damn thing would be fiddly and out my comfort zone!
😀
February 20, 2009 at 8:02 am
aha
many many thanks, that's solved the empty thing
have got
CASE
WHEN ISEMPTY([Measures].[Projected]) THEN NULL
ELSE (([Measures].[Projected]/[Measures].[Principal Amt])-StrToValue([BENCH].[RATE]))
but it's still returning #VALUE in Excel...
BENCH.RATE is a double, but it's a dimension
February 20, 2009 at 6:32 am
solved it...
i had a variable to SQL thing going on and if i removed the "use databasename" line from the start it worked
strange...but hey ho
February 18, 2009 at 10:13 am
ah, ok
seems strange it would run ok in BIDS though
i'll chop it up and see what happens
many thanks
February 10, 2009 at 7:44 am
hi Tim
thanks for that...but i suspect it isn't blocking as it's the same server from BIDS and deployment (although i'm by no means a blocking expert!)
i can't see anything in...
February 10, 2009 at 7:32 am
thank bob & dave
took me a while to figure out the
use [ReportServer]
bit 🙂
one further question...i'm trying to pull the data out and into a flat file, or anywhere (!) in...
February 10, 2009 at 5:06 am
Viewing 15 posts - 31 through 45 (of 65 total)