In addition to reading the article provided by Steve you should also read the BOL section on server-side tracing. This sounds like something you want to have running all...

Duplicate post, please respond here.

Here is a link to a Connect item requesting functionality similar to this. You should go and vote for this item. Microsoft definitely takes Connect entries seriously.

Currently the ReportOBjectModel does not expose these properties. I have submitted a Connect Item requesting this functionality. You can validate and vote for this item here

That is correct. Unfortunately in SSRS sub-reports inherit the page orientation of the parent report.

A staging table is basically a copy of your source table except in SQL Server. So if I am migrating a persons table (last_name, first_name, birth_date, national_id_number) I would...

I've gotta agree with Gus on this one. Excel is a great tool, the problem is that it gets used in ways it shouldn't. Workbooks with lookups to...

Try setting the visibility of all the objects on the sub report to hidden if there are no rows in the dataset.

Do you mean that you do not want the subreport to display or you do not want the subreport to print when the report is printed?

I don't think that there...

I'd probably use SSIS and execute the package in job.

What format do you want it in? Do you want to include relationships (Foreign Keys)?

You can query most of the data yourself using T-SQL using the INFORMATION_SCHEMA views. ...

ashu (4/30/2009)

---

It is ordered based on the id first and then the id2

ID ID2 Num1

1 1 5.00

1...

You are welcome, but I am still concerned about how you are guaranteeing order.

How are you enforcing the order of the numbers? SQL Server only guarantees order if you have an explicit order by.

Here's a solution that works on your example data,...

I would think you could do this. What is your reporting solution going to be? If I was using SSRS I would decrypt in the report, as you...