This link might be useful.

http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

If it is a problem with the array or anythign then it shouldnt appear in dataset result in RS. But it appears in dataset.

Hi,

i am creating temporarty table and inserting the parameter into that table and then using that table into main query.

create table #TempTable (

slice varchar(8000))

declare...

You can format your text into your report itself. Like find the report below or attached sheets etc. You can pass parameter value into your report expression. So try to...

please refer to the following link about all color changes in RS. U can see lots of innovative stuff from this link.

http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

regards,

vijay

hi,

you can use interactive sort.

Go to column of your table on which u need sorting. Then go to properties of column and you will interactive sort table. give the name...

Thanks krishna...it seems i need to use developer edition of SQL...

Sorry what you mean by this?

you will need to install either SQL2005 express or developer. Enterprise and standard are for server systems only

Sorry i cant see SQL Services under services. There should be something missing and i cant just figure it out.

Sorry which services and where?

Hi Krishna,

I have enterprise edition of SQL Server 2005. I have Windows VISTA Home premiem. Is it problem to install SQL on Vista Home?

thanks,

vijay

Thanks tracey.

I have tried to open surface area configuration and it gives following error.

No SQL Server 2005 components were found on the specified computer. Either no components are installed, or...

You can see that it has been created by DWilliams. But when she created the subscription, one might have her username and password assigned during setup and another will have...

= right(("0" + Cstr(Day(Fields!admdate.Value))),2) + "/" + right(("0" + Cstr(Month(Fields!admdate.Value))),2) + "/" + Cstr(Year(Fields!admdate.Value))

assume your date field name - admdate

I would think that is the main intention to use data driven subscription. I am expecting errors. If you need to send email in some conditions then it will send...