New Data for the same report

Hello!
I have a question - i hope some one can help me...
I have a report that gets an id as a parameter and get the data for this ID.
In the same Stored Procedure where i get this data - i also update the data
(change status...).
Now when i do "view report" again on the same ID - i don't see the changes...
Only when i go and put other ID ,press "view report" and then go back to the
first ID - then i see the changes.
It seems that the reporting does not go and bring the data every time i
press on "View Report" unless i change the parameter (which means that i
force the action of going again to the Data Base and bringing data)
Do you know how i make the report go and bring the data every time i press
on "view report" ?
Please HELP!
ThanksThis is definitely true from the development environment. That is a feature
of the IDE (I suppose so you can develop with long running reports without
having it have to run the query over and over again. Have you tried this
with a deployed report?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Penker" <Penker@.discussions.microsoft.com> wrote in message
news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> Hello!
> I have a question - i hope some one can help me...
> I have a report that gets an id as a parameter and get the data for this
> ID.
> In the same Stored Procedure where i get this data - i also update the
> data
> (change status...).
> Now when i do "view report" again on the same ID - i don't see the
> changes...
> Only when i go and put other ID ,press "view report" and then go back to
> the
> first ID - then i see the changes.
> It seems that the reporting does not go and bring the data every time i
> press on "View Report" unless i change the parameter (which means that i
> force the action of going again to the Data Base and bringing data)
> Do you know how i make the report go and bring the data every time i press
> on "view report" ?
> Please HELP!
> Thanks|||Yes - The reports i use (from an application) are all deployed.
I have an application that on a link "click" it open a report from the
Reporting Service
while sending it his parameters. Now when i send the same parameter twice it
returns the same data (even it already changed after the first time)...
Can you help me?
"Bruce L-C [MVP]" wrote:
> This is definitely true from the development environment. That is a feature
> of the IDE (I suppose so you can develop with long running reports without
> having it have to run the query over and over again. Have you tried this
> with a deployed report?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Penker" <Penker@.discussions.microsoft.com> wrote in message
> news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> > Hello!
> > I have a question - i hope some one can help me...
> > I have a report that gets an id as a parameter and get the data for this
> > ID.
> > In the same Stored Procedure where i get this data - i also update the
> > data
> > (change status...).
> > Now when i do "view report" again on the same ID - i don't see the
> > changes...
> > Only when i go and put other ID ,press "view report" and then go back to
> > the
> > first ID - then i see the changes.
> > It seems that the reporting does not go and bring the data every time i
> > press on "View Report" unless i change the parameter (which means that i
> > force the action of going again to the Data Base and bringing data)
> > Do you know how i make the report go and bring the data every time i press
> > on "view report" ?
> > Please HELP!
> > Thanks
>
>|||Caching is set at the server. The default is for it not to be cached. I
think what is happening is you are coming up against your web page doing
caching. One way you can test this is to do the following. Open up your
report using reporting manager.Click on the View Report button. Click on it
a second time, I bet it works the way you want it to.
For the web page you are hosting the report in make sure it is not being
cached. I forget the line you put in the page but there is a html tag you
can put that tell ASP to not cache the web page.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Penker" <Penker@.discussions.microsoft.com> wrote in message
news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
> Yes - The reports i use (from an application) are all deployed.
> I have an application that on a link "click" it open a report from the
> Reporting Service
> while sending it his parameters. Now when i send the same parameter twice
it
> returns the same data (even it already changed after the first time)...
> Can you help me?
> "Bruce L-C [MVP]" wrote:
> > This is definitely true from the development environment. That is a
feature
> > of the IDE (I suppose so you can develop with long running reports
without
> > having it have to run the query over and over again. Have you tried this
> > with a deployed report?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Penker" <Penker@.discussions.microsoft.com> wrote in message
> > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> > > Hello!
> > > I have a question - i hope some one can help me...
> > > I have a report that gets an id as a parameter and get the data for
this
> > > ID.
> > > In the same Stored Procedure where i get this data - i also update
the
> > > data
> > > (change status...).
> > > Now when i do "view report" again on the same ID - i don't see the
> > > changes...
> > > Only when i go and put other ID ,press "view report" and then go back
to
> > > the
> > > first ID - then i see the changes.
> > > It seems that the reporting does not go and bring the data every time
i
> > > press on "View Report" unless i change the parameter (which means that
i
> > > force the action of going again to the Data Base and bringing data)
> > > Do you know how i make the report go and bring the data every time i
press
> > > on "view report" ?
> > > Please HELP!
> > > Thanks
> >
> >
> >|||Hi!
I know that caching is set at the server - been there tried that...
Also tried to open the report using reporting manager and click on the View
Report button - it doesn't work
but - about this Tag you are talking about - is there any way to pass this
tag in the url that 'call' the report?
i use "window.open(...)" in Java Script...
Thanks!!!
"Bruce L-C [MVP]" wrote:
> Caching is set at the server. The default is for it not to be cached. I
> think what is happening is you are coming up against your web page doing
> caching. One way you can test this is to do the following. Open up your
> report using reporting manager.Click on the View Report button. Click on it
> a second time, I bet it works the way you want it to.
> For the web page you are hosting the report in make sure it is not being
> cached. I forget the line you put in the page but there is a html tag you
> can put that tell ASP to not cache the web page.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Penker" <Penker@.discussions.microsoft.com> wrote in message
> news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
> > Yes - The reports i use (from an application) are all deployed.
> > I have an application that on a link "click" it open a report from the
> > Reporting Service
> > while sending it his parameters. Now when i send the same parameter twice
> it
> > returns the same data (even it already changed after the first time)...
> > Can you help me?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > This is definitely true from the development environment. That is a
> feature
> > > of the IDE (I suppose so you can develop with long running reports
> without
> > > having it have to run the query over and over again. Have you tried this
> > > with a deployed report?
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Penker" <Penker@.discussions.microsoft.com> wrote in message
> > > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> > > > Hello!
> > > > I have a question - i hope some one can help me...
> > > > I have a report that gets an id as a parameter and get the data for
> this
> > > > ID.
> > > > In the same Stored Procedure where i get this data - i also update
> the
> > > > data
> > > > (change status...).
> > > > Now when i do "view report" again on the same ID - i don't see the
> > > > changes...
> > > > Only when i go and put other ID ,press "view report" and then go back
> to
> > > > the
> > > > first ID - then i see the changes.
> > > > It seems that the reporting does not go and bring the data every time
> i
> > > > press on "View Report" unless i change the parameter (which means that
> i
> > > > force the action of going again to the Data Base and bringing data)
> > > > Do you know how i make the report go and bring the data every time i
> press
> > > > on "view report" ?
> > > > Please HELP!
> > > > Thanks
> > >
> > >
> > >
>
>|||Are you saying that when you click on the View Report button, it too is not
showing the data? Because if that doesn't work then no need to worry about
anything else until that is resolved. View Report button should always show
the most recent data.
I know of no way to set the html tag on the url.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Penker" <Penker@.discussions.microsoft.com> wrote in message
news:5D7088B9-F337-4C0F-B2B9-073761CC5994@.microsoft.com...
> Hi!
> I know that caching is set at the server - been there tried that...
> Also tried to open the report using reporting manager and click on the
View
> Report button - it doesn't work
> but - about this Tag you are talking about - is there any way to pass this
> tag in the url that 'call' the report?
> i use "window.open(...)" in Java Script...
> Thanks!!!
> "Bruce L-C [MVP]" wrote:
> > Caching is set at the server. The default is for it not to be cached. I
> > think what is happening is you are coming up against your web page doing
> > caching. One way you can test this is to do the following. Open up your
> > report using reporting manager.Click on the View Report button. Click on
it
> > a second time, I bet it works the way you want it to.
> >
> > For the web page you are hosting the report in make sure it is not being
> > cached. I forget the line you put in the page but there is a html tag
you
> > can put that tell ASP to not cache the web page.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Penker" <Penker@.discussions.microsoft.com> wrote in message
> > news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
> > > Yes - The reports i use (from an application) are all deployed.
> > > I have an application that on a link "click" it open a report from
the
> > > Reporting Service
> > > while sending it his parameters. Now when i send the same parameter
twice
> > it
> > > returns the same data (even it already changed after the first
time)...
> > > Can you help me?
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > This is definitely true from the development environment. That is a
> > feature
> > > > of the IDE (I suppose so you can develop with long running reports
> > without
> > > > having it have to run the query over and over again. Have you tried
this
> > > > with a deployed report?
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Penker" <Penker@.discussions.microsoft.com> wrote in message
> > > > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> > > > > Hello!
> > > > > I have a question - i hope some one can help me...
> > > > > I have a report that gets an id as a parameter and get the data
for
> > this
> > > > > ID.
> > > > > In the same Stored Procedure where i get this data - i also
update
> > the
> > > > > data
> > > > > (change status...).
> > > > > Now when i do "view report" again on the same ID - i don't see the
> > > > > changes...
> > > > > Only when i go and put other ID ,press "view report" and then go
back
> > to
> > > > > the
> > > > > first ID - then i see the changes.
> > > > > It seems that the reporting does not go and bring the data every
time
> > i
> > > > > press on "View Report" unless i change the parameter (which means
that
> > i
> > > > > force the action of going again to the Data Base and bringing
data)
> > > > > Do you know how i make the report go and bring the data every time
i
> > press
> > > > > on "view report" ?
> > > > > Please HELP!
> > > > > Thanks
> > > >
> > > >
> > > >
> >
> >
> >|||Ctrl+F5 is the way to force a refresh in IE. What happens then?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Penker" <Penker@.discussions.microsoft.com> wrote in message
news:5D7088B9-F337-4C0F-B2B9-073761CC5994@.microsoft.com...
> Hi!
> I know that caching is set at the server - been there tried that...
> Also tried to open the report using reporting manager and click on the
> View
> Report button - it doesn't work
> but - about this Tag you are talking about - is there any way to pass this
> tag in the url that 'call' the report?
> i use "window.open(...)" in Java Script...
> Thanks!!!
> "Bruce L-C [MVP]" wrote:
>> Caching is set at the server. The default is for it not to be cached. I
>> think what is happening is you are coming up against your web page doing
>> caching. One way you can test this is to do the following. Open up your
>> report using reporting manager.Click on the View Report button. Click on
>> it
>> a second time, I bet it works the way you want it to.
>> For the web page you are hosting the report in make sure it is not being
>> cached. I forget the line you put in the page but there is a html tag you
>> can put that tell ASP to not cache the web page.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Penker" <Penker@.discussions.microsoft.com> wrote in message
>> news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
>> > Yes - The reports i use (from an application) are all deployed.
>> > I have an application that on a link "click" it open a report from
>> > the
>> > Reporting Service
>> > while sending it his parameters. Now when i send the same parameter
>> > twice
>> it
>> > returns the same data (even it already changed after the first
>> > time)...
>> > Can you help me?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> > > This is definitely true from the development environment. That is a
>> feature
>> > > of the IDE (I suppose so you can develop with long running reports
>> without
>> > > having it have to run the query over and over again. Have you tried
>> > > this
>> > > with a deployed report?
>> > >
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > >
>> > > "Penker" <Penker@.discussions.microsoft.com> wrote in message
>> > > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
>> > > > Hello!
>> > > > I have a question - i hope some one can help me...
>> > > > I have a report that gets an id as a parameter and get the data for
>> this
>> > > > ID.
>> > > > In the same Stored Procedure where i get this data - i also update
>> the
>> > > > data
>> > > > (change status...).
>> > > > Now when i do "view report" again on the same ID - i don't see the
>> > > > changes...
>> > > > Only when i go and put other ID ,press "view report" and then go
>> > > > back
>> to
>> > > > the
>> > > > first ID - then i see the changes.
>> > > > It seems that the reporting does not go and bring the data every
>> > > > time
>> i
>> > > > press on "View Report" unless i change the parameter (which means
>> > > > that
>> i
>> > > > force the action of going again to the Data Base and bringing data)
>> > > > Do you know how i make the report go and bring the data every time
>> > > > i
>> press
>> > > > on "view report" ?
>> > > > Please HELP!
>> > > > Thanks
>> > >
>> > >
>> > >
>>|||<meta HTTP-EQUIV="cache-directive" CONTENT="no-cache">
How do I get this into the report HTML page?
Jeff A. Stucker wrote:
> Ctrl+F5 is the way to force a refresh in IE. What happens then?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Penker" <Penker@.discussions.microsoft.com> wrote in message
> news:5D7088B9-F337-4C0F-B2B9-073761CC5994@.microsoft.com...
> > Hi!
> > I know that caching is set at the server - been there tried
that...
> > Also tried to open the report using reporting manager and click on
the
> > View
> > Report button - it doesn't work
> > but - about this Tag you are talking about - is there any way to
pass this
> > tag in the url that 'call' the report?
> > i use "window.open(...)" in Java Script...
> > Thanks!!!
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Caching is set at the server. The default is for it not to be
cached. I
> >> think what is happening is you are coming up against your web page
doing
> >> caching. One way you can test this is to do the following. Open up
your
> >> report using reporting manager.Click on the View Report button.
Click on
> >> it
> >> a second time, I bet it works the way you want it to.
> >>
> >> For the web page you are hosting the report in make sure it is not
being
> >> cached. I forget the line you put in the page but there is a html
tag you
> >> can put that tell ASP to not cache the web page.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Penker" <Penker@.discussions.microsoft.com> wrote in message
> >> news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
> >> > Yes - The reports i use (from an application) are all deployed.
> >> > I have an application that on a link "click" it open a report
from
> >> > the
> >> > Reporting Service
> >> > while sending it his parameters. Now when i send the same
parameter
> >> > twice
> >> it
> >> > returns the same data (even it already changed after the first
> >> > time)...
> >> > Can you help me?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> > > This is definitely true from the development environment. That
is a
> >> feature
> >> > > of the IDE (I suppose so you can develop with long running
reports
> >> without
> >> > > having it have to run the query over and over again. Have you
tried
> >> > > this
> >> > > with a deployed report?
> >> > >
> >> > > --
> >> > > Bruce Loehle-Conger
> >> > > MVP SQL Server Reporting Services
> >> > >
> >> > > "Penker" <Penker@.discussions.microsoft.com> wrote in message
> >> > > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> >> > > > Hello!
> >> > > > I have a question - i hope some one can help me...
> >> > > > I have a report that gets an id as a parameter and get the
data for
> >> this
> >> > > > ID.
> >> > > > In the same Stored Procedure where i get this data - i also
update
> >> the
> >> > > > data
> >> > > > (change status...).
> >> > > > Now when i do "view report" again on the same ID - i don't
see the
> >> > > > changes...
> >> > > > Only when i go and put other ID ,press "view report" and
then go
> >> > > > back
> >> to
> >> > > > the
> >> > > > first ID - then i see the changes.
> >> > > > It seems that the reporting does not go and bring the data
every
> >> > > > time
> >> i
> >> > > > press on "View Report" unless i change the parameter (which
means
> >> > > > that
> >> i
> >> > > > force the action of going again to the Data Base and
bringing data)
> >> > > > Do you know how i make the report go and bring the data
every time
> >> > > > i
> >> press
> >> > > > on "view report" ?
> >> > > > Please HELP!
> >> > > > Thanks
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>|||Try adding this to the report URL:
&rs:ClearSession=true
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Raj" <RajeevRamesh7207@.gmail.com> wrote in message
news:1105129321.910500.285100@.c13g2000cwb.googlegroups.com...
> <meta HTTP-EQUIV="cache-directive" CONTENT="no-cache">
> How do I get this into the report HTML page?
> Jeff A. Stucker wrote:
>> Ctrl+F5 is the way to force a refresh in IE. What happens then?
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Penker" <Penker@.discussions.microsoft.com> wrote in message
>> news:5D7088B9-F337-4C0F-B2B9-073761CC5994@.microsoft.com...
>> > Hi!
>> > I know that caching is set at the server - been there tried
> that...
>> > Also tried to open the report using reporting manager and click on
> the
>> > View
>> > Report button - it doesn't work
>> > but - about this Tag you are talking about - is there any way to
> pass this
>> > tag in the url that 'call' the report?
>> > i use "window.open(...)" in Java Script...
>> > Thanks!!!
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Caching is set at the server. The default is for it not to be
> cached. I
>> >> think what is happening is you are coming up against your web page
> doing
>> >> caching. One way you can test this is to do the following. Open up
> your
>> >> report using reporting manager.Click on the View Report button.
> Click on
>> >> it
>> >> a second time, I bet it works the way you want it to.
>> >>
>> >> For the web page you are hosting the report in make sure it is not
> being
>> >> cached. I forget the line you put in the page but there is a html
> tag you
>> >> can put that tell ASP to not cache the web page.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Penker" <Penker@.discussions.microsoft.com> wrote in message
>> >> news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
>> >> > Yes - The reports i use (from an application) are all deployed.
>> >> > I have an application that on a link "click" it open a report
> from
>> >> > the
>> >> > Reporting Service
>> >> > while sending it his parameters. Now when i send the same
> parameter
>> >> > twice
>> >> it
>> >> > returns the same data (even it already changed after the first
>> >> > time)...
>> >> > Can you help me?
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> > > This is definitely true from the development environment. That
> is a
>> >> feature
>> >> > > of the IDE (I suppose so you can develop with long running
> reports
>> >> without
>> >> > > having it have to run the query over and over again. Have you
> tried
>> >> > > this
>> >> > > with a deployed report?
>> >> > >
>> >> > > --
>> >> > > Bruce Loehle-Conger
>> >> > > MVP SQL Server Reporting Services
>> >> > >
>> >> > > "Penker" <Penker@.discussions.microsoft.com> wrote in message
>> >> > > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
>> >> > > > Hello!
>> >> > > > I have a question - i hope some one can help me...
>> >> > > > I have a report that gets an id as a parameter and get the
> data for
>> >> this
>> >> > > > ID.
>> >> > > > In the same Stored Procedure where i get this data - i also
> update
>> >> the
>> >> > > > data
>> >> > > > (change status...).
>> >> > > > Now when i do "view report" again on the same ID - i don't
> see the
>> >> > > > changes...
>> >> > > > Only when i go and put other ID ,press "view report" and
> then go
>> >> > > > back
>> >> to
>> >> > > > the
>> >> > > > first ID - then i see the changes.
>> >> > > > It seems that the reporting does not go and bring the data
> every
>> >> > > > time
>> >> i
>> >> > > > press on "View Report" unless i change the parameter (which
> means
>> >> > > > that
>> >> i
>> >> > > > force the action of going again to the Data Base and
> bringing data)
>> >> > > > Do you know how i make the report go and bring the data
> every time
>> >> > > > i
>> >> press
>> >> > > > on "view report" ?
>> >> > > > Please HELP!
>> >> > > > Thanks
>> >> > >
>> >> > >
>> >> > >
>> >>
>> >>
>> >>
>