ExecutionLog Fields

Is there a document that details what the fields in the ExecutionLog
represent. For example, what is the RowCount based on? Or how are the
TimeDataRetrieval, TimeProcessing & TimeRendering fields calculated?You may want to check this related thread for an explanation of execution
log times:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=599418b6-d837-446b-b02b-26394c4a8a7b&sloc=en-us
The RowCount column shows the total number of rows read in _all_ datasets
during the report execution. This includes also dataset rows read for
query-based report parameters.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Propwash" <scott.tyree@.crossmark.com> wrote in message
news:1115137030.760735.158180@.o13g2000cwo.googlegroups.com...
> Is there a document that details what the fields in the ExecutionLog
> represent. For example, what is the RowCount based on? Or how are the
> TimeDataRetrieval, TimeProcessing & TimeRendering fields calculated?
>|||Ok, just to make sure I am fully understanding. If I have a SP that
joins three tables (A,B,C), then my RowCound will be the sum of tables
A, B & C plus the resulting recordset. Is this correct?|||No. The RowCount represents only the number of rows in the resulting record
set. If you join multiple table into one dataset inside the stored
procedure, it will not influence the RowCount.
However, if you use the record set in a report parameter and in the report,
you may say a higher count than if you only use it in the report.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Propwash" <scott.tyree@.crossmark.com> wrote in message
news:1115209799.601180.4530@.g14g2000cwa.googlegroups.com...
> Ok, just to make sure I am fully understanding. If I have a SP that
> joins three tables (A,B,C), then my RowCound will be the sum of tables
> A, B & C plus the resulting recordset. Is this correct?
>