Configure report server so that it does not attempt to detect a local SSL certificate by setting the SecureConnectionLevel to 0 in the RSReportServer.config file.

Thank u ,

I want to do the things by using asp.net and Sql Reporting services APIS.

I need to develop a webpage where the users can integrate multiple reports in to...

For begginers it is very very good article

Thanks a lot for ur answers

Hi ,

Thanks for ur reply iam creating the temporary tables by using select into (no indexes) the entire thing in one query itself.

Thanks  for your reply!!i will work on that and i will get back to u

For this Question:

Does Exec(@query) work in the same fashion as Execute SP_executesql @query?

May be u know,ifor this  SP_executesql @query the paramter must be nvarchar.Nvarchar size is 4000.

Hi sharma,

I will say the exact requirement.

In a particular excel a macro is there ,it will run whenver excel opens.

In that excel file data(columns and rows are blank).

I want to...

one more doubt

select @command = 'master..xp_cmdshell ''bcp "SELECT ''''COL1'''', ''''COL2'''' union all select cast(eno as varchar(10)), ename  from pubs.dbo.emp where eno = '+@I+'" queryout c:\EMP_'+@I+'.xls -c -S(local) -E'''

exec (@command

when...

Thanks a lot sharma,

Its working fine ,but again small requirement after exporting to excel formatting became problem.

I will explain

in col2 ename characters are 20 but it is displaying only...

Hi rsharma,

Thanks for ur quick replies.

select @command = 'master..xp_cmdshell ''bcp "SELECT *  from pubs.dbo.emp where eno = '+@I+'" queryout c:\EMP_'+@I+'.csv -n -S(local) -E'''

The above statement is not inserting the data...

Thank u for ur replies,

I will let u know after executing the things,but i have one doubt

The following stament will return more than 1 records:

select @command = 'master..xp_cmdshell ''bcp "SELECT...

Hi,

Thanks for replies...

I given a small example in my first question  but i want to insert a lot of records .

1)From DTS by using global variables we can insert only...

THAT ARTICLE WILL BE USEFUL  ONLY FOR ONE EXCEL FILE BUT I WANT TO CREATE MULTIPLE EXCEL FILE.

thank u guys for all ur reply i done like this its working now:

i created a tmptable with exactly the out put tof the @sqlquery

insert into #tmptable exec sp_executesql...