Question about Data Extension

Hi all,
i created a data processing extension which connects to a web service to get
data.
Everything works fine so far. But when i look in my DebugView, i see that
the RS calls my web service 3 times for one report. is this a normal
behaviour or do i have to inquire the connection state?
DebugView text:
---
[3900] DocumentConnection.Open()
[3900] DocumentConnection.CreateCommand()
[3900]
DocumentCommand.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior)
[3900] Accessing WebService
[3900] DocumentConnection.Open()
[3900] DocumentConnection.CreateCommand()
[3900]
DocumentCommand.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior)
[3900] Accessing WebService
[3900] DocumentConnection.Open()
[3900] DocumentConnection.CreateCommand()
[3900]
DocumentCommand.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior)
[3900] Accessing WebService
[3900] DocumentConnection.Close()
[3900] DocumentConnection.Close()
[3900] DocumentConnection.Close()
---
regards
PatrickAre you using subreports or grouping or page breaking?
Depending on the ways you implement your report layout, your extension
could get loaded on each new page, sub reports and groups.
Siew Fai.
Patrick Ruhnow wrote:
> Hi all,
> i created a data processing extension which connects to a web service to get
> data.
> Everything works fine so far. But when i look in my DebugView, i see that
> the RS calls my web service 3 times for one report. is this a normal
> behaviour or do i have to inquire the connection state?
> DebugView text:
> ---
> [3900] DocumentConnection.Open()
> [3900] DocumentConnection.CreateCommand()
> [3900]
> DocumentCommand.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior)
> [3900] Accessing WebService
> [3900] DocumentConnection.Open()
> [3900] DocumentConnection.CreateCommand()
> [3900]
> DocumentCommand.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior)
> [3900] Accessing WebService
> [3900] DocumentConnection.Open()
> [3900] DocumentConnection.CreateCommand()
> [3900]
> DocumentCommand.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior)
> [3900] Accessing WebService
> [3900] DocumentConnection.Close()
> [3900] DocumentConnection.Close()
> [3900] DocumentConnection.Close()
> ---
> regards
> Patrick|||No.
It's a simple testreport with only a few fields of one command on it.
I have 3 Commands in my report. Perhaps the RS makes for each
command an connection request although only 1 command is used on the report?
"Siew Fai" wrote:
> Are you using subreports or grouping or page breaking?
> Depending on the ways you implement your report layout, your extension
> could get loaded on each new page, sub reports and groups.
> Siew Fai.
> Patrick Ruhnow wrote:
> > Hi all,
> >
> > i created a data processing extension which connects to a web service to get
> > data.
> > Everything works fine so far. But when i look in my DebugView, i see that
> > the RS calls my web service 3 times for one report. is this a normal
> > behaviour or do i have to inquire the connection state?
> >
> > DebugView text:
> > ---
> > [3900] DocumentConnection.Open()
> > [3900] DocumentConnection.CreateCommand()
> > [3900]
> > DocumentCommand.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior)
> > [3900] Accessing WebService
> > [3900] DocumentConnection.Open()
> > [3900] DocumentConnection.CreateCommand()
> > [3900]
> > DocumentCommand.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior)
> > [3900] Accessing WebService
> > [3900] DocumentConnection.Open()
> > [3900] DocumentConnection.CreateCommand()
> > [3900]
> > DocumentCommand.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior)
> > [3900] Accessing WebService
> > [3900] DocumentConnection.Close()
> > [3900] DocumentConnection.Close()
> > [3900] DocumentConnection.Close()
> > ---
> >
> > regards
> > Patrick
>