Sql Reporting Services Question

Hot Topic

ODBC connection with stored procedure on iSeries as data source
problem with panda antivirus and olap cubes
sql in C# Select
Out-of-Memory error on Sort Transformation
securing Local System, password expiration, occasionally connected MSDE
SQL Server 2005 - TCP "Keep Alive" problem / not working
modify procedure sys.sp_datatype_info
rounding datetime nnn to whole seconds
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance
error applying initial snapshot

SQL Server

Error message for null at SET or aggregate
Trouble setting-up witness.
Buffer latch error
Restoring a primary log shipping database - will it ship ?
Create New SQL Server Mobile Edition Database
Executing trigger
Kirk: Importing/Exporting with column ErrorCode, ErrorColumns
AJAX and SQL DataAdapter Inserts from Visual Studio 2003
Exporting a Cube into MS Excel
Database restores using Enterprise Manager

Sql Reporting Services Question

Hi,

I use sql reporting services in a C# windows form application.
I made 3 reports which i use in the application.
I tried to use each report several times during the application, i.e. - I filled
in the report with parameters and DB data at first during the running of the application, and created a mhtml file from the report.
when I tried to use the same report in the same running time of the application , but with different data and different parameters, I saw that the report I get is the first report I made, with the old data and old parameters although the data in the DB has changed and the parameters I gave the report have changed.
If I restart the application, the phenomenon returns: the first time I use the report
it's OK, but from that moment nometer what changes I'll made in the parameters and DB data when I'll use this report, I will always see the fist data and parameters I used, untill i'll restart the application.

Is there a way to dill with this issue
Can I maybe clear the report data, or reload it from the application
without restart the application somehow

Thanks


Answer this question

Sql Reporting Services Question

  • JT Snake

    Reporting Services caches the report execution for a specific user. You can manually re-run the report via the 'refresh' button on the report viewer toolbar. Programmatically, you can call the web services API or URL to clear the execution. How you do this depends on whether you are using SQL 2000 RS or SQL 2005.

    Brian Welcker
    SQL Server Reporting Services

  • Amer 570

    The SQL 2000 URL parameter is rs:ClearSession=True, although I don't think it is working in SQL 2005 yet.



  • psique

    Is it possible to refresh the report ex. every 30 minutes
     
    I would like to place a report on a screen and automatically call a full refresh timed on 30-minute intervals


    Leo
     



  • Mike81

    How do you call report on another server For example, how do you reference the namespace

    using GetProperties .ReportingServices;

  • Jim815

    Not sure what you mean. Are you using the Web Services API

    BTW, this would probably be more visibile in the new Reporting Services forum.

  • davherb

    Thanks Brian!

  • Tiadd4

    Can you please elaborate.  I would like to send a "do not cache" or "please refresh" querystring parameter in the url for SQL 2000 Reporting Services.  I guess it wouldn't hurt to also know the parameter for SQL 2005.
    Thanks!
  • Sql Reporting Services Question
Answer this question