For future reference, the site below has it all!!

http://www.connectionstrings.com

select

right('0' + cast(datepart(month,a.datehired) as char(2)), 2)

+ '/'

+ right('0' + cast(datepart(day,a.datehired) as char(2)), 2)

...

Here is a revised version that works much more efficiently, and addresses various issues with the original version.

---------------------------------------------------------------------------------------------------

USE [ReportServer]

GO

/****** Object: StoredProcedure [dbo].[js_data_driven_subscription] Script Date: 09/29/2006 18:10:40...

If you can post the code tomorrow, it will be much easier to look into. But you knew that 🙂

~I just posted this reply so that I would get an...

Give your textbox this value ...

="Page " & Globals!PageNumber & " of " & Globals!TotalPages

What about

, SUM( CASE r.packagetransmethodid WHEN 9 THEN ShipmentQty ELSE 0 END) as "Others"

Also, if you need appostrophies in your query, you'll need to replace then with ' + char(39) + '

Use a parameter to hold the Database name and Use EXEC sp_executesql ...

Make your data source as follows....

DECLARE @strSQL nvarchar(1000)

SELECT @strSQL = 'select * from ' + @dataSource + '.dbo.yourQuery...

Can you post the query you've written?

You can not refer to fields in the Header and Footer, however a work around is to use a textbox or field in a table/matrix to hold the value for...

That's what I thought, but I had to ask.....

I'll go hide in my corner now.....

This is only a work around, but you could create a "dummy" parameter that isn't used in any of your queries and don't give it a default value.

I haven't tried...

Thanks Andy. I guess I hadn't thought of that as I developed this to solve an in house need and that wasn't somethingI have to deal with. but that is...

I've been meaning to post this for quite a while, but here's an updated procedure that works much better....

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[data_driven_subscription]') and OBJECTPROPERTY(id, N'IsProcedure')...