dwain.c (12/12/2013)

---

Better to use sys.columns or sys.all_columns as information_schema.columns is being deprecated.

All the technical metadata exists in there....

You could try a for each loop that uses the list of sprocs as the item to iterate through and then call bulk copy for each of them

For this to work, you will need to get Kerberos authentication configured. Have a look at http://blogs.technet.com/b/rob/archive/2011/11/23/enabling-kerberos-authentication-for-reporting-services.aspx - it has (I think) sufficient information to get you going.

If you...

Is she running the report from inside Visual Studio or from the reports website ?

I have seen this happen in Visual Studio but when not when run from the reports...

peacesells (12/3/2013)

---

I have stored procedure where I use try and catch block.I call that store procedure from within SSIS (execute sql task) to load data. The problem i...

Full backups and differential backups don't backup data that is in the transaction log. They contains pages that exist in the various .mdf and .ndf files (the data files)...

mario17 (12/2/2013)

---

Hi,

I have simple report but user wants to add some title that kind looks like parent group, is it possible to insert extra line let say after 3rd group...

In the report action, when you use "go to report", the bottom half of the screen allows you to add the parameters you want when calling that report.

wendy elizabeth (12/1/2013)

---

How will the ssrs 2008 r2 report know what server it is running on? Is there a command to check ip addresses and/or server names? If so, what...

All you need to do is create a table to store the location of your PDF, add a...

I normally store this sort of thing in a config table and use a dataset in the report to retrieve the value. The URL used for the action uses...

kenreg (11/20/2013)

---

Version control does more than just tracking changes to your code over time. It also does the following:

* Record the user who made the change (great...

Try using the following expression in textbo34:

=sum(Fields!DaysVoid)

Try using:

target server URL : http://XXXdev002/sites/Reports

target report folder: http://XXXdev002/sites/Reports/myreports

You don't need the "vti_bin" stuff

What schema are the tables in ? Try including the schema name with the drop index/stats statements