Exporting to Excel with more than or equal to 60000 records makes it very slow since one sheet can hold only max of 60000 records.Hence it is advisable...

Hi ,

If it s neccessary to use two dataset,then Use the concept of Subreports

Place a subreport in the table of ur First report

Create...

Hei,

Reporting server supports conditional statement 'iif' only...not if..

iif(Condition,value if true,vlaue if false)

Hi,

If u want to trim all the zero's,ie if the value of feild is 1.23450000,select in the properties>> FORMAT as Number.

then this will return values with out zero..zz...ie 1.2345

Hi,

what is your dataset for the table? Member...ya..Shared..??