Hi

i tried this exprestion =Not Globals!RenderFormat.IsInteractive in ssrs 2008 version its not working in ssrs 2008 version. is there any other way.plz tell me...

IN THIS QUERES OUT PUT RESULT NOT COME .

i developed report with 2data sets

1st dataset i write query like select top 2 sal,* from tablename

2nd dataset i write query like select top 10 sal,* from tablename

after that...

hi why here we use XML PATH('')),1,0,''

plese tell me some explnation to use of xml path

iam not given any security permission to this package

just we add else statement here

case when MaxSalary is not null then 'Yes' else 'no' end MaxSalary,

case when MinSalary is...

k i got it

thanks its working fine. in this query i want modify when max salary then display yes and remaing sal column display no and when min salary then display yes...

while i load multiple xlsx files that time show errore like

Error: The Assertions OleDbSchemaGuid is not a supported schema by the 'Microsoft.ACE.OLEDB.12.0' provider.

that time what we do

hi small doubt to loading xls and xlsz files format

actual whil loading xls file extendent propertis=excel 8.0 and

...

sql server 2008

no ffriend i search google.but exactely i what ever ii need that data iam not getting.

plz tell me how to solve this issue

its load data different table

data typeslike id int,name varchar(50),sal int

hi try this logic but in sal columns null values not retriveing

select *

from aaaa

where RTRIM(ISNULL(id, '')) = '' or

RTRIM(ISNULL(name, '')) = '' OR RTRIM(ISNULL(sal, '')) =...