Report won;t run with new paramters

I have a report that works just fine and has for some time. I had to make a
change and added a new parameter to the stored procedure. I updated the
report and republished it. It sees the parameter but doesn't seem to be
using it. I even ran SQL Profiler and it definitely is not calling the
stored procedure with the new parameter. I checked the RDL and it does know
about the parameter. I am just confused.
Stacey LevineTry deleting the report from the report server and redeploying it.
Andy Potter|||That did not work.. but..here is what I had to do to fix it. I had to go to
the data tab in visual studio and run the data set (stored procedure) and
enter the new parameters. Then I rebuilt and redeployed and it started
working. Not sure why.. but this did it.
Thanks.
Stacey
"Potter" <drewpotter@.gmail.com> wrote in message
news:1136925208.341658.254200@.g44g2000cwa.googlegroups.com...
> Try deleting the report from the report server and redeploying it.
> Andy Potter
>|||If you add a parameter to a database object, you must either refresh or
execute the dataset in order for the MSRS to know about the new
parameter. This forces RS to execute its GetParameters() method for
the command. This parameter will then be listed on the Parameters tab
of the dataset (and similarly, in the RDL). The GetParameters() is not
called when you Preview the report.
The alternative is to manually enter the new parameter on the Parameter
tab of the dataset.
Andy Potter

Report Refresh - Bug or Feature

I've noticed that for automatically refreshing reports when you run the
report (and the page refreshes) the data is not updated. Only when you click
the refresh button in the toolbar does the data start changing. Is this a
bug or a feature? The reason why I ask is I want to know if I can depend on
this behaviour in the future or will it change when something is "fixed"?
Thanks in advance,
James SnapeYou can rely on this behavior. Refresh the page and refresh for data for
the report are two different things. Refreshing the data for the report
requires a lot more work on the server while refreshing the page is none.
| From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
| Subject: Report Refresh - Bug or Feature
| Date: Tue, 7 Jun 2005 14:22:13 +0100
| Lines: 10
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| Message-ID: <e7kmsP2aFHA.2884@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: exony-ltd-02.altohiway.com 213.83.66.226
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45428
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I've noticed that for automatically refreshing reports when you run the
| report (and the page refreshes) the data is not updated. Only when you
click
| the refresh button in the toolbar does the data start changing. Is this a
| bug or a feature? The reason why I ask is I want to know if I can depend
on
| this behaviour in the future or will it change when something is "fixed"?
|
| Thanks in advance,
| James Snape
|
|
||||so how to refresh tha data on the report i mean whats that LOT MORE
WORK TO B DONE ON SERVER SIDE to refresh tha data