Report Refresh Problem

Hi,
I had a report wherein it was taking a single parameter value and outputting
the data. In addition I pass other parameters to this report. Now the
functionality is that it can take multiple values in addition to the existing
params. The multiple value list is not passed into the report but the way I
have implemented this is:
1. Load all the values into a listbox and then load it into a table.
2. The stored procedure looks for the entries in the table and builds the
sql statement and outputs the data.
What's happening is this for the first time when the report runs it is fine
and I get the data that I want. When I add another value into the report or
remove the data, the report doesn't get refreshed unless I chnage one of the
parameters(dropdown or date).
Any clue why this is happeing.. I really appreciate your inputs.
Thanks
Suresh
Whn i first select the report to runThe dataset for those parameters is already created for the first set of
parameters. Changing the parameters is how you change the data.
--
| Thread-Topic: Report Refresh Problem
| thread-index: AcWCTExfmZtzyhPaRcKY0HoFtDt+Rw==| X-WBNR-Posting-Host: 161.88.255.139
| From: =?Utf-8?B?U3VyZXNo?= <Suresh@.discussions.microsoft.com>
| Subject: Report Refresh Problem
| Date: Wed, 6 Jul 2005 10:01:06 -0700
| Lines: 23
| Message-ID: <65901F85-6FE9-497F-A0D5-0D9DD1C7BAC9@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:47502
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
|
| I had a report wherein it was taking a single parameter value and
outputting
| the data. In addition I pass other parameters to this report. Now the
| functionality is that it can take multiple values in addition to the
existing
| params. The multiple value list is not passed into the report but the way
I
| have implemented this is:
|
| 1. Load all the values into a listbox and then load it into a table.
| 2. The stored procedure looks for the entries in the table and builds the
| sql statement and outputs the data.
|
| What's happening is this for the first time when the report runs it is
fine
| and I get the data that I want. When I add another value into the report
or
| remove the data, the report doesn't get refreshed unless I chnage one of
the
| parameters(dropdown or date).
|
| Any clue why this is happeing.. I really appreciate your inputs.
|
| Thanks
| Suresh
|
| Whn i first select the report to run
|