Try this one,

http://server/ReportServer_SQL2008/ReportService2005.asmx

Regards,

Chirag

It is very easy to move it up and down with up and down buttons available on Report Parameter Dialog box.

Regards,

Chirag Prajapati

It looks like Microsoft.ReportingServices.ExcelRendering.dll

is taking care of exporting the data to excel.

I was not able to find any config file if it takes any name from that.

At this point of...

Hi,

A simple way it to add it on Page Header and Keep that part visible only on the First Page with the help of Visibility property.

and you can apply the...

I m agree with the above solution it will be easier to handle at the ASP.Net Page itself rather than calling it for different page.

And this is common requirement which...

you can use it in the below fashion.

RowNumber("Group1") =1

RowNumber("Group1").RowNumber("Group2")= 1.1

RowNumber("Group1").RowNumber("Group2").RowNumber("Group3")=1.1.1

This will Iterate through all rows and provide you the hierarchical numbers.

Hi,

Can you elaborate the issue ?

what are the steps you are following or the sample RDL File which is exported as Excel ?

Thanks

Easy and simplest way is make you user as Administrator on that machine.

and other way is use impersonation.

That is login with Administrator and assign your user Content Manager rights...

Hi,

Excellent Script.

I m not sure whether you have updated it or not.

But it gives error in some cases where datatype is used as DbStamp of in case of Datetime.

Thanks,

Chirag.

There are two alternates

1) To combine the selected columns of both table in to single row

Create StoredProcedure sp_MultipleDataSets

as

begin

SELECT EMP.EMPID, EMP.ENAME, EMP.JOB, EMP.SAL,

Coleasce(EMP.DEPTID,DEPT.DEPTID),

DEPT.DNAME, DEPT.LOC FROM EMP

full outer join DEPT...