http://www.idautomation.com/reporting_services/barcode_cri/UserManual.html

visit the above link

N does user have sufficient right now to perform the operation?

Hey Try This!

select * from

(

SELECT EntityID, Property, MAX(CASE WHEN fromDeleted = 1 THEN Value END) AS OldValue,

...

And to pass the parameter

select the parameters tab there and pass the department value there.

Make sure ur subreport query contains a parameter otherwise parameter will not pop up...

helo DP

its as simple as that

On the text box properties of your(Department field)

go to "navigation" part

-->select jump to report

-->select the particular subreport in the dropdown u want to navigate to.

Thats...

So u already knew it...:hehe:

neeraj is quitre right there about passing parameter in sub report.

Also to enable the drilldown u can toggle the visibility of subreport upon the textbox which contains ur dept. info.

Hope...

Hey Try This One Instead:

create table #t (num int)

declare @STRvarchar(500)

select @STR = '4,2,7,7834,45,24,45,77'

declare @sql varchar(8000)

select @sql = 'insert into #t select '+

replace(@str,',',' union all select ')

exec...

Try This:

select b.sum1,sum(a.sum1) as cum_sum

from temp a,temp b

where a.id <= b.id

group by b.id,b.sum1

--where cum_sum will be your cumulative sum