Figure out how many rows display on each page of the report, then make a parameter for your query to do a top X to return the right number of...

Exactly what I would do

SELECT DATEDIFF(dd,GetDate(),'12/25/11') AS DaysTillChristmas

Nah....I'll take Acapulco. 😀

Do you want 2011 to appear above each column, so that you 2011 is part of the title of the column? Or, do you simply want 2011 centered above...

Thirty-first anniversary

What is the data source for the agencyID? Can you show the code you are using to populate the parameter? Also please show the code where you are...

Then I suggest you get/create some kind of mirroring or replication process to keep a complete copy on a local server and then do your ETL from there.

Never trust anyone that always answers a question with a question.

What I do is push all the Type 2 change records into a staging table rather than directly to the destination. Then using an execute SQL task to take...

I would try to only pull the data you need in an incremental load rather than move the whole table.

Create it as an image, then embed it.

The NoRowsMessage only works when the report is run. If you have cascading parameters, or any required parameters for that matter, you will have to supply values for all...

still stuffed

Thanks...