Realtime/streaming data

Is there a way to update data on a reporting services report without having
the user click the refresh button? I am wanting to show realtime stock
quotes in a reporting services report and update stock quotes as they come in
without having to call the refrsh method in the report viewer or having the
user have to click the refrsh button. I am using the report viewer component
in a C# winforms app.
Thanks in advance!!!Use the timer object in the C# winform and refresh the control. You could
have it refresh every minute or 30 sec - but anything more 'real time' than
that - Reporting Services is probably not a real good solution.
"David" <David@.discussions.microsoft.com> wrote in message
news:A05DA637-32B3-48CE-8972-14135DE7888B@.microsoft.com...
> Is there a way to update data on a reporting services report without
> having
> the user click the refresh button? I am wanting to show realtime stock
> quotes in a reporting services report and update stock quotes as they come
> in
> without having to call the refrsh method in the report viewer or having
> the
> user have to click the refrsh button. I am using the report viewer
> component
> in a C# winforms app.
> Thanks in advance!!!|||If you're using RS 2005 you can set the "Autorefresh" for the report
property to the desired refresh interval. It worked in VS preview and
in the the web browser. So I wouild think if you are using the report
viewer control the autorefresh would work there to.
On Sat, 13 May 2006 15:50:01 -0700, David
<David@.discussions.microsoft.com> wrote:
>Is there a way to update data on a reporting services report without having
>the user click the refresh button? I am wanting to show realtime stock
>quotes in a reporting services report and update stock quotes as they come in
>without having to call the refrsh method in the report viewer or having the
>user have to click the refrsh button. I am using the report viewer component
>in a C# winforms app.
>Thanks in advance!!!|||Thanks for trying guys. As I said in my initial email I want to update
values on the report without the report refreshing as a refresh is annoying
to the user and takes you back to the beginning of a report given you are in
backend pages of the report...
"Mark" wrote:
> If you're using RS 2005 you can set the "Autorefresh" for the report
> property to the desired refresh interval. It worked in VS preview and
> in the the web browser. So I wouild think if you are using the report
> viewer control the autorefresh would work there to.
> On Sat, 13 May 2006 15:50:01 -0700, David
> <David@.discussions.microsoft.com> wrote:
> >Is there a way to update data on a reporting services report without having
> >the user click the refresh button? I am wanting to show realtime stock
> >quotes in a reporting services report and update stock quotes as they come in
> >without having to call the refrsh method in the report viewer or having the
> >user have to click the refrsh button. I am using the report viewer component
> >in a C# winforms app.
> >Thanks in advance!!!
>

Realtime record count for table...

Here's a little sql 2005 script I wrote:

1. Start by running this script....

declare @.x int

select @.x = 1

while ( @.x < 75000)
begin
insert into myTesttable values (@.x)
Select @.x = @.x + 1
end

2. While the script is still running, I want to know how many records are in the table. From the same query window as the script, I have run both of the following statements.

select count(*) from mytesttable
witn (nolock)

select count(*) from mytesttable
witn (tablock)

Instead of getting the answer immediately, they run only after the original script has completed. They seem to be "blocked". How can I get a near realtime count of the number of records in this table while the script populates the table?

Thanks,

Barkingdog

Barkingdog, just open another query window and run your "select count(*) from mytesttable". You'll get the row count while the other script is running.|||

If you use GridView it only displayed after the batch execution completed.

You can use different window or change the GridView to TextView to get the result immd.

|||

Yes, opening a new window did enable to the "select count(*) ...." to run but why is this the case? (After all, I couldn't run the "Select count(*) .." from the window that invoked the original script. Seems like the orignal script "blocks" the conneciton so I need to open a new conneciton (window). But why?

TIA,

barkingdog

|||

barkingdog wrote:

Yes, opening a new window did enable to the "select count(*) ...." to run but why is this the case? (After all, I couldn't run the "Select count(*) .." from the window that invoked the original script. Seems like the orignal script "blocks" the conneciton so I need to open a new conneciton (window). But why?

TIA,

barkingdog

The query window runs the statements sequentially and does not run the next statement until the prior one has finished, thus your select count(*)... will not run until the statements in the while loop complete. It's not "blocking" the connection, it just has not completed the prior statements...

If one of the replies solved your problem, please mark them as answered...