thanks Grant, I agree great software which removes so much hassle for me!

actually i did make a mistake 🙂

i had assigned the parameter in the report as @param instead of using |P1|

now works a treat jason , brilliant article!

thanks

mal

no probs Jason, i was being optimistic!

have double checked, and everything matches up, ill just have to do a bit more playing about with it !

thanks

mal

what i pass to the sp

exec data_driven_subscription

@scheduleID ='DD1C75F3-2CD5-43A7-97B5-C01DAB758EEB',

@emailTO = 'm22222@zzzzzzzz.com',

@emailCC = 'm22222@zzzzzzzz.com',

@emailBCC = 'm22222@zzzzzzzz.com',

@emailReplyTO = 'm22222@zzzzzzzz.com',

@emailBODY = 'hello...

TOOK IT BACK TO MY QUERY AND JUST REMOVED THE DATA I DIDNT WANT TO SEE!

Thanks Steve, will look into this next week, no need to apologise I appreciate the always great advice i get on here!

yea i think ssis is where i need to go

i can dump the reports into a directory, and pickup them up from there and deliver to specifc email address's hopefully

BY USING

EXEC msdb.dbo.sp_start_job

i can execute the report at will

i just need to work out how to pass the haulier parameter!

yea, but if i have 100 suppliers then i need 100 subscriptions?

iv managed to send the report using a script, so i think if i can pass the email address...

hi John

yea i have used subscriptions

i need this to run automatically on the 1 report (dont want to create a report per supplier), and have relevant supplier parameters passed to...

hi John

i only want each supplier to get their own data, can i execute an ssrs report within a stored procedure and email it one report at a time? say...

hi folks,

after i do some index rebuilds is till have a high frag level eg 75%

i am guessing this is down to low page count? is there an option...

brilliant tool, thanks for bringing to my attention! 😀

thank you grant, i will get a good review of this, seems to be just what i need!

think thats it wayne!

no more tabs

THANKS FOR HELP FOLKS