PAY ATTEN....I SAY PAY ATTENTION SON 😛

ruthless

Subscriptions also make entries in to several system tables in the MSDB database, so simply restoring the data to the table in the reporting services database may not get you...

You could still probably delete folder A, the rebuild A and A1-A50 manually than you could script this without running the risk of destroying your reporting services database.

Well, if you wait a week or so, this heat wave in the central and eastern US may make its way over to you.:cool:

You can make a separate "navigation" report that simply has links to the separate sub reports, and perhaps a link to the report with all sub reports showing.

bopeavy (7/21/2011)

---

Brandie Tarvin (7/20/2011)

---

I'm curious. How many people subscribe to a job service (or keep in touch with job sites / recruiters) because they're currently looking?

Or do you...

Why would you want to repeat data that is in the report in the footer? That seems unnecessarily redundant.

Turning column values into an array is not something SQL does...

In your dataset query parameter values are you using a JOIN?

Does any of your data have commas in the values?

Have you looked at some of the issues, directly feeding your...

In a data driven subscription, you write a query to supply the report with parameter values. Each row returned by the query will generate a separate report. You...

I still prefer this to getting up at 5:00 AM to snowblow a foot...

Something to think about: although the primary focus is SQL, do we (or should we) touch on other topics as well? As I said yesterday, although I still work...

One of the great advantages of SSIS is the ability to add robust error handling to sql server jobs. I would suggest adding some error handling, or at least...

Interesting article, I wish them luck.

For your proposal, great idea. I will give it .35 cents of effort.....Ok I'm done.:-D

Of the roses