how to refresh a report?

newbie to this. pls bear with me.
background: sql2k and report server standard edition, on a w2k3 box.
all sameple reports work great so far. I created a report my own, it
went fine too. but when i changed the sorting order in report designer
(in vs .net 2003), the preview looks fine, but when i deployed it, the
report on report server still display the old sorting order. i deleted
it from report server, re-deployed it, but still got the old sorting
order?
why' how to refresh any changes after a report was deployed?
thank youIS it possible you are getting cached pages from IE... To check
In IE Tools ->internet Options ->General-> Settings
It is possible to have reports cached in RS as well, but by default they are
not...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"lins" <steve.lin@.powells.com> wrote in message
news:1106931232.984721.63720@.c13g2000cwb.googlegroups.com...
> newbie to this. pls bear with me.
> background: sql2k and report server standard edition, on a w2k3 box.
> all sameple reports work great so far. I created a report my own, it
> went fine too. but when i changed the sorting order in report designer
> (in vs .net 2003), the preview looks fine, but when i deployed it, the
> report on report server still display the old sorting order. i deleted
> it from report server, re-deployed it, but still got the old sorting
> order?
> why' how to refresh any changes after a report was deployed?
> thank you
>sql

how to read database connection data from a properties file?

Hi guys,
I am very new to Reporting Services, so please bear with me here. I am
curious about how we can configure the database server, database name, and
login data using data from a properties file so that when Reporting Services
and the Report Server start up, they have all the data they need to connect
to the appropriate database. Has anyone tried this yet? If so how would it
be possible?
Thanks a bunch,
Carolyn
cvoREMOVE_ALL_CAPS@.REMOVE_ALL_CAPSacornsys.comWhen you design reports you have the option of using shared data sources for
running the report. Or each report can use its own data source. I always use
the shared datasources. The shared data source is referred to when you
design the report. When you deploy the default is that the shared datasource
does not get written over. What this means is you can configure the shared
datasource on the server and it can be different than what the developers
are using. For the credentials for the shared datasource I use a specific
username. The db username I use is one I have setup for reporting that has
only read access to the database. An advantage of this is it allows
connection pooling since all the connections for reporting will use the
exact same connection string (a necessity for connection pooling).
Note that what I am talking about here is getting to the database which has
the data for the report. RS also has a database which is used for caching of
the reporting objects. This can be the same or different database from which
you are reporting on.
Bruce L-C
"Carolyn Vo" <cvoREMOVE_ALL_CAPS@.REMOVE_ALL_CAPSacornsys.com> wrote in
message news:O3lMQ9BhEHA.556@.tk2msftngp13.phx.gbl...
> Hi guys,
> I am very new to Reporting Services, so please bear with me here. I am
> curious about how we can configure the database server, database name, and
> login data using data from a properties file so that when Reporting
Services
> and the Report Server start up, they have all the data they need to
connect
> to the appropriate database. Has anyone tried this yet? If so how would
it
> be possible?
> Thanks a bunch,
> Carolyn
> cvoREMOVE_ALL_CAPS@.REMOVE_ALL_CAPSacornsys.com
>