Are you doing this as part of a Change Data Capture process for a loading a Data Warehouse? If so this is covered in many books and online articles...

For a...

Thanks Matt...What I've done to prevent an error from occurring is included the following custom function that is called to perform the divide operation. So when it is encountered I...

You've described your scenario...what is your question?

I would change the parameter for the Weekly/Monthly reports to only show those appropriate values rather than letting them choose a specific date and deriving the week/month down stream...

Uma,

I believe the solution proposed regarding having the stored procedure return a readable message be your best solution for this scenario. I played around with another option using an additional...

Ah okay...I am going to play with this a little and see if i can make something a little more general for my use. Generally when I am developing reports...

Great Job!

Is your 'Total' line in the footer section of the table?

Alright so I got this to work but I'm not 100% confident it's the best answer. What I did:

1.) Created separate data set that returns comma delimited string of all...

Ah okay..makes sense...if the settings all show 8.5in x 11in then I would be curios to see what happens when you print them. To the best of my knowledge...

Nice work around...

Wayne,

Just wondering here, why would a user want to print a report without first viewing it? I would think that they would at least want to see what...

Jack,

Nice article...Being more of a front end guy I was wondering your thoughts on taking your query you use to look at the SSIS errors and converting that into a...

Give this page a shot...

http://technet.microsoft.com/en-us/library/ms143506.aspx

Good point Michael,

Another thing to keep in mind would be that if you change the name of the report in the report manager and do not change the actual RDL...

When viewing the report you wish to add a description of to the listing click on the properties tab. Under the General properties page you may edit the name displayed...

Hey Sam,

Can you possibly post the RDL code for the table object you're using in the body of the report?