Showing posts with label retrieve. Show all posts
Showing posts with label retrieve. Show all posts

Friday, March 30, 2012

Report works fine on VS.NET 2003, get error when uploaded

Hello,

I created a report and use stored procedure to retrieve data. The report works perfect on VS.NET 2003 IDE. But when I upload the .rdl file to the report server, it doesn't work. The error msg I got is:

Reporting Services Error

An error has occurred during report processing. (rsProcessingAborted)Get Online HelpQuery execution failed for data set 'dsTransTime'. (rsErrorExecutingCommand)Get Online HelpProcedure 'usp_RPT_Procedure_Name' expects parameter '@.Parameter1', which was not supplied.
Anyone know the problem?
Thanks,Finally, I make it works. But I still don't know how I made it.
I cannot find a similiar errors from google. So everything I did is based on guess. Becasuse the error msg shows the report cannot take the parameter, I removed the parameter and re-created it again. Also, I use refresh button on the Data view to refresh the dataset.

Sometime I feel waired about Reporting services.

Wednesday, March 7, 2012

Report Server Execution Log (Retrieve, Process, Render

The online help states under ther Report Server Execution Log the following
description for the Retrieve, Process, Render counters:
"Percentage of time spent retrieving the data, processing the report, and
rendering the report."
Shouldn't the three numbers added together match to 100%? What units are
these values depicted in?
In order to calculate duration in seconds I have taken the datediff in
seconds between starttime and endtime. I would assume there is a way to
calculate percent of time for retrieval, processing and rendering from this
value. Is this correct?
--
Thanks in Advance,
John KThis is a bug in the documentation. Thanks for pointing this out.
The values represent milli seconds and not percentage.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"John K" <JohnK@.discussions.microsoft.com> wrote in message
news:2CF19C95-BCCA-454D-BF31-F624215B4A6D@.microsoft.com...
> The online help states under ther Report Server Execution Log the
> following
> description for the Retrieve, Process, Render counters:
> "Percentage of time spent retrieving the data, processing the report, and
> rendering the report."
> Shouldn't the three numbers added together match to 100%? What units are
> these values depicted in?
> In order to calculate duration in seconds I have taken the datediff in
> seconds between starttime and endtime. I would assume there is a way to
> calculate percent of time for retrieval, processing and rendering from
> this
> value. Is this correct?
>
> --
> Thanks in Advance,
> John K