Caching Set Up Problem

Hi Expert,

 Am I doing it right? Can you give me any suggestions please? Thank you!!
I followed the way for setting up the sql cache dependency fromhttp://quickstarts.asp.net/QuickStartv20/aspnet/doc/caching/SQLInvalidation.aspx.
However, I still have the following error:

When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance.

IssueSummary.aspx
<%@.PageLanguage="VB"MasterPageFile="~/MasterPage.master"AutoEventWireup="true"CodeFile="IssueSummary.aspx.vb"Inherits="IssueSummary"title="Issue Summary" %>
<%@.RegisterAssembly="AtlasControlToolkit"Namespace="AtlasControlToolkit"TagPrefix="cc2" %>
<%@.RegisterAssembly="Microsoft.Web.Atlas"Namespace="Microsoft.Web.UI"TagPrefix="cc1" %>
<%@.OutputCacheDuration="999999"VaryByParam="None"SqlDependency="CommandNotification" %>

Global.asax
Sub Application_Start(ByVal senderAsObject,ByVal eAs EventArgs)
Dim connectionStringAsString = ConfigurationManager.ConnectionStrings("ICTConnectionString").ConnectionString
Dim needToInstallAsBoolean =True
Try
Dim tables()AsString
tables = SqlCacheDependencyAdmin.GetTablesEnabledForNotifications(connectionString)
If (Not tablesIsNothing)Then
Dim tblAsString
ForEach tblIn tables
If (tbl.ToLower().Equals("IssueDetails"))Then
needToInstall =False
EndIf
Next
EndIf
Catch exAs Exception
needToInstall =True
EndTry
If (needToInstall)Then
SqlCacheDependencyAdmin.EnableNotifications(connectionString)
SqlCacheDependencyAdmin.EnableTableForNotifications(connectionString,"IssueDetails")
EndIf
EndSub

Web.config
<connectionStrings>
<addname="ICTConnectionString"connectionString="Data Source=jamesle-3;Initial Catalog=IssueCommunicationTool;Integrated Security=True"providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<caching>
<sqlCacheDependencyenabled="true"pollTime="1000" >
<databases>
<addname="ICTDB"connectionStringName="ICTConnectionString" />
</databases>
</sqlCacheDependency>
</caching>

SQL Server 2005 - Database - IssueCommunicationTool
SELECT is_broker_enabledFROMsys.databasesWHEREname='IssueCommunicationTool'

Return = 1, it means the broker service is enabled. Also, the database has created the table ASPNET_SQLCacheTableForChangeNotification,
the trigger in IssueDetails table, and some other store procedures.

To use that the notification service nees to be enable, does not look like it is in your configuration.|||

Just thought that if loading them dynamicly you may want just to add the user control in the code behind

Cache["Myusercontrol"] = usercontrolname;

grab them

if ( Cache["Myusercontrol"] != null )

{

usercontrolname = (UserControl) Cache["Myusercontrol"];

}

|||

You are messing the both ways for SQL caching - polling and notifications. Polling is for both 2000 and 2005 version, whether notifications is only for 2005, because of the Service Broker.

In your case you have been usingSqlDependency="CommandNotification" in the outputcache directive. This means that you are using notification based invalidation. In such case you should call SqlDependency.Start(connectionString) in the Application_OnStart method (Global.asax file). In such case you did not need any settings in the web.config file. You need then only if you use polling based invalidation. This is all written down on the page that you point. Just read it more carefully.

Caching results of Stored Procedure

I was wondering if there is anyway to cache the results of a stored procedure in order to gain speed ?

Or do I need to do something else clever ?

Here is my SQL

procedure spGetProcedureParams(v_procname in varchar2,
v_packagename in varchar2,
CurRef out typeRefCur,
v_errcode out integer,
v_errmesg out varchar2)

is
begin
v_errcode :=0;
open CurRef for
select argument_name,
data_type,
NVL(pls_type,'REF'),
in_out
from user_arguments
where upper(object_name) = upper(v_procname)
and upper(package_name) = upper(v_packagename)
order by sequence;
exception
when others then
v_errcode :=SQLCODE;
v_errmesg :=SQLERRM;
end spGetProcedureParams;

end pkgUtils;
/I'm not really sure what you are looking for. You could fetch the data into a collection like an index-by table. Whether this will improve performance depends on what you are going to do with it next.

caching questions

I am new to Reporting Services and would like to know if it can do the
following:
1. If I cache a report with timed expiration such as 48 hours, can I
programatically expire a specific report before it would have expired
normally?
2. When a report is generated from cache, is it possible for it to get any
"superficial" customizations at render time, such as colors or a gif?
Thanks for any help!Hi,
> 1. If I cache a report with timed expiration such as 48 hours, can I
> programatically expire a specific report before it would have expired
> normally?
We do not have straightforward method available. To do so, you could use
SetCacheOptions Method set the CacheReport false and then reset the
expiration time.
> 2. When a report is generated from cache, is it possible for it to get
any
> "superficial" customizations at render time, such as colors or a gif?
No, it's not possible
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Caching Question

Question for all Cache Gurus

I have a page in my website that pulls content for anewsletter from a SQL Server 2000 database using a SqlDataSource and aFormView. I add a new newsletter every week. Other than that weekly addition,no changes are really ever needed or made to the data. Scott Gu says everyapplication can and should make use of caching and I would like to add somekind of caching to improve the performance of this page. I have read about SqlCacheDependency with SQL2000, but if I understand it correctly, it will poll the database for changesevery x seconds, an expensive operation that I just don't need; the data onlychanges once a week. I've seen some code examples using DataSets and the CacheAPI but I'm really just looking for a simple, mostly declarative solution using theSqlDataSource. Theoretically, I wouldlike the data cached forever until I insert a new item. I have set thefollowing cache-related properties on my SqlDataSource as follows:

EnableCaching = True
DataSourceMode = DataSet
CacheDuration = Infinite
CacheExpirationPolicy = Absolute

Setting these properties seems to work great for caching thedata but how do I programmatically invalidate the cache when a new item isinserted? I have a separate admin page with a FormView that I use to insert thenewsletter each week. Is there some kind of code that I could put in theItemInserted event that would invalidate the cache so that the new item will bedisplayed and then cached? I don't have any experience with caching; where am I going wrong? Are my expectations unrealistic? Thank you in advance to anyone who can shed somelight on this issue.

The best way to do this is by using filebased cache dependency. So when ever any change happens to the file cache gets invalidated. check out the below link.

http://www.eggheadcafe.com/articles/20030716.asp

In this Peter used SQL trigger to update the file, but for your requirment I would suggest, as soon as upload a new news letter through admin portal, make change to this dependency file, thats it cache gets invalidated and any new requests gets the new data.

Caching Application Block and SQL 2005 SQL Dependency

I am building a web app using VS2005 and SQL 2005 I would like to use the Caching Application Block to cache objects from my BLL. I was wondering if there is a way of utilizing the build in SQLDependency in SQL 2005 with the Caching Application Block? Does anybody have tried this, are there any samples on the web?

Thanks,

Newbie

You can take a look at

http://msdn2.microsoft.com/en-us/library/a52dhwx7.aspx

http://msdn2.microsoft.com/en-us/library/t9x04ed2.aspx

Caching < 1 Minute

Is it possible expire a report cache after less than one minute? I'm looking for a way to only have a report hit the database once every 10 seconds, no matter how many people are hitting it. Thanks.

This is not possible, the granularity for cache expiration is 1 minute for both scheduling and Timed Expiration. This restriction is set at the API level.

CacheType in Lookup for Oracle OLEDB connection

Hi,

1. If I have millions of rows to be compared, then which cache type is prefereed for lookup, Partial or no caching?

2. If I have lookup connected to Oracle Oledb, cache type as partial and SqlCommandParam as following

select * from (SELECT ORDER_ID, OPER_KEY, STEP_KEY, SUM(OCCUR_COUNT) AS OCCUR_COUNT FROM SFWID_OPER_DESC_EXPLD GROUP BY ORDER_ID, OPER_KEY, STEP_KEY) refTable where refTable.ORDER_ID = ? and refTable.OPER_KEY = ? and refTable.STEP_KEY = ?

then it doesn't allow me to add the parameters from Advance tab of Lookup transformation edition, and raises following error

"Provider cannot derive parameter information and SetParametInfo has not been called"

what am I missing?

1. Depends on the amount of memory available and the size of the data set to be cached. A million of rows should not be a big deal; but you do the math; find the size of the row(using just the required columns) and multiply by the number of rows. You should provide a query instead selecting the table from the drop down list.

2. In SSIS mapping parameters in a half-way complex query is some times impossible. So try re-writing the query in a simpler way (perhaps creating a view). BTW, if you parametrize the query; then only partial cache will be used; meaning the query will be executed for every row in the pipeline, affecting negatively the performance of the package

|||

Rafael,

Is it possible that we dont define parameterized query for partial cache?

I had done following things:

For the partial caching, I have checked Enable memory restriction and Enable caching and has set the cache size. I have not checked "Modify sql statement" option. But, "SqlCommandParam" in advanced editor shows the query as follows:

select * from
(SELECT ORDER_ID, OPER_KEY, STEP_KEY, SUM(OCCUR_COUNT) AS OCCUR_COUNT FROM SFWID_OPER_DESC_EXPLD GROUP BY ORDER_ID, OPER_KEY, STEP_KEY) as refTable where [refTable].[ORDER_ID] = ? and [refTable].[OPER_KEY] = ? and [refTable].[STEP_KEY] = ?

But as this is not the perfect syntax for oracle, it showed the error. Thats why I have changed this query to following

select * from (SELECT ORDER_ID, OPER_KEY, STEP_KEY, SUM(OCCUR_COUNT) AS OCCUR_COUNT FROM SFWID_OPER_DESC_EXPLD GROUP BY ORDER_ID, OPER_KEY, STEP_KEY) refTable where refTable.ORDER_ID = ? and refTable.OPER_KEY = ? and refTable.STEP_KEY = ?

Now after the change, running the package throws the following error at this lookup

Error: An OLE DB error has occurred. Error code: 0x80040E5D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E5D Description: "Parameter name is unrecognized.".

So, I went to advanced tab and checked "Modify sql statement" option but it doesnt allow me to add the parameter and throws the error as said in my earlier post.

|||

Is there any special reason for using partial cache? for performance reasons I would not recommned it; but in some cases it is necessary.

*I think* when you use partial cache the lookup uses a query w/parameters; so I don't think you have control over that. I know SSIS parameter mapping and Oracle are not very easy to get working; and I don't know how easy or possible is that in a Lookup transformtion. Search this forum for 'Oracle parameters' to see if you can find somthing helpful.

|||

I searched but couldn't find anything useful. Is it so that Lookup caching doesn't support Oracle parameters ?

Thanks,

Pratibha

|||

Hi Pratibha:

Did you find anything on using parameters in lookups for Oracle OLEDB. Please let me know if you have any workaround. I am also stuck in the same problem.

Any help will be greatly appreciated.

Thanks,

Vipul

Cache-ing problem

I have a report that renders ok.
When I chenge the executuion settings to "Cache a temporary copy of the
report. Expire copy of report on the following schedule:"
I can render the report once, when I than ask for the report (and should get
the cached verision) I get an error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Index was outside the bounds of the array.
Any suggestions?Apparently, this has somthing to do with the fact that I used the global
parameter UserID.
Once I left that out of the report it works fine.
Why? Beats me.
I even have other reports that chache fine with the UserID-parameter...
Can you immagine how long it took me to find that
"Antoon" wrote:
> I have a report that renders ok.
> When I chenge the executuion settings to "Cache a temporary copy of the
> report. Expire copy of report on the following schedule:"
> I can render the report once, when I than ask for the report (and should get
> the cached verision) I get an error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Index was outside the bounds of the array.
> Any suggestions?

Cached Reports

Is it possible to cache a version of a report, meaning say I pass a parameter "CacheReport" which is a boolean. Can I only cache this report when this variable is set to true?I don't believe that's currently a settable option. You can set them to
cache with the first user, on a schedule or have it pull from a snapshot
each time.
"comet61" <comet61@.discussions.microsoft.com> wrote in message
news:C6DEDF65-C480-430B-A94C-968107D1AC6C@.microsoft.com...
> Is it possible to cache a version of a report, meaning say I pass a
> parameter "CacheReport" which is a boolean. Can I only cache this report
> when this variable is set to true?

Cache: rsInvalidDataSourceCredentialSetting

Error-Message:
"The current action cannot be completed because the user data source
credentials that are required to execute this report are not stored in the
report server database. (rsInvalidDataSource-CredentialSetting) (Report
Services SOAP Proxy Source)".
Our previous action:
In SQL-Server Management Studio, Connect to Reporting Services, Home,
myReports, someReportName.
Right-Click on this report, Properties.
Here on the left side: Execution
Right Side: Cache the Report, OK
Now happens the Error cited above.
Logged on as Local Adminsitrator, as usual, no Domain configured, standalone
Server in Workgroup.
The whole ReportServer was installed and configured from scratch with all
possible patience:
All the following programs in english:
Win Enterprise 2003 R2, SQL Server 2005 completely, SQL-Server SP1, Post SP1
hotfixes and ALL recommended Security Updates/Fixes by Windows Update.Hi Henry,
Thank you for using MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You can not
configure the Report Cache and you get the following error message:
"The current action cannot be completed because the user data source
credentials that are required to execute this report are not stored in the
report server database. (rsInvalidDataSource-CredentialSetting) (Report
Services SOAP Proxy Source)".
If I misunderstood your concern, please feel free to let me know.
Since the report cache need a credential to connect to the datasource to
render the report, it will need the credential stored in the report server
database.
To store the credential, please do the following:
1. Open the Management Studio, connect to Reporting Services, go to the
report you want to configure.
2. Expand the left panel, and click the Data Sources, right-click your data
source name and click Properties.
3. Check the Credentials stored securely on the report server and specify a
Login Name and password.
4. Click Ok and try to configure the report cache.
Hope this will be helpful, thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights|||Hi Wei,
thanks to your advice we finally achieved to configure caching.
It follows here:
- our initial security-config
- the way we solved the problem by temporarily changing this config
- ONE Question
All Reports use a shared datasource.
This shared datasource is configured to connect using Windows integrated
security.
Our security-config is as following:
- SQL-Server is configured for "SQL Server and Windows Authentication mode"
- The reportserver machine is in a workgroup, not in a Domain
- Anonymous access to the ReportServer website is allowed via the
IUSR_machine User
- we created a local Server windows-group "Report-Reader" in Computer
Management
- we added the IUSR_machine Account to this group
- we added this windows-group as a "System User" (not System Administrator)
to Report Services
- we gave this windows-group the Browser-Role
- we gave this windows-group the datareader role with explicit rights to
select and execute on the target databases
We achieved enabling caching only after configuring this shared datasource
temporarily with:
- Connection: Credentials stored securely on the report server
- sa, password
standard config before and after: Windows integrated security (= the
IUSR_machine account) did not work
Question:
Me, the SQL Server Admin, with all possible rights, I want to configure the
caching behaviour.
Why does there need to be configured differently any shared datasource
rights to do this?
What has the config of the datasource to do with ME wanting to change a
behaviour?
Muchas Gracias, yours Henry|||Hello Henry,
Thank you for your update and glad to hear the information is helpful.
I would liket to explain that why we need to store the Credential.
Since the Report Cache is an automatical process to render the report, it
will need the credential to connect to the datasource to get the data. If
you use the Windows integrated security, it will be fine if an user try to
access the report. But the Cache can not connect to the datasource because
it does not know which credential it should use to connect to the
datasource. Thus, you need to store the credential in the database.
Don't worry about the security because the database use a symetic key to
encrypt the credential.
Here is an article for your reference:
Specifying Credential and Connection Information
http://msdn2.microsoft.com/en-us/library/ms160330(d=ide).aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Henry,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
OK, resolved.
But one big question:
If I give e.g. the sa-credentials to be stored securely in the data-source,
and if any one user achieves to send some "= 1; drop someDB; --" Code to our
Stored Procedures that sometimes use dynamic SQL, then we're fried.
Seems to be necessary to configure a SQL-Server account with less privileges.
Or let caching out.
Saludos, Henry|||Hi Henry,
Thank you for the update.
The SQL injection is really a big problem. I recommend you to configure a
SQL account which only have select permission on the database since the
reporting service only need to get the data from datasource.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Henry,
How are you doing on this thread? As Wei has been OOF due to some urgent
issues, I'm helping him contact you to see whether you still have any
problems on this. For the security threaten you mentioned earlier, Wei and
I have discussed this with our product team's engineers and their
suggestion is that we recommend the reporting service datasource always use
a readonly permission identity to access database server since reporting
service report only need readonly access. As always, if you have any
further issues, please feel free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
thank you very much for your invested time.
We are happy, that SSRS-caching could finally be switched on in our
dev-/test-environment.
We'll investigate it further, when our product is live and running and we
need to optimize it.
Have a nice day, greetings from Peru
Yours Henry

Cache Warming

Hi,

I have a cube, which is having a lot of calculated measures.

There are some MDX queries which fetches data from the cube, and aggregates data through a parent -child hierarchy.

It is taking considerable amonut of time.

So , for improving the performance i have written a c# program which executes all the possible MDX queries just after the daily refresh of the cube. As expected it was really giving noticable performnace improvement.

But the problem started when i deployed the cube and the cache warmer into another server, where the cache warmer is executed by Sql Agent, with the service account which is a local admin on that box. The warmer program executed fine, but i am no longer able to find the performance improvement. I understand that , the global cache will be shared across the users only if the users are having same security role in the cube.

So i added the sqlagent service account to the role whiich execute the MDX in the application. But still it is not helping me

Please help me.

Also i would like to know, whether clearing the cache everyday would help in any way in this scenario.

Regards,

Jiju

Somebody please tell me whether I am doing any blunder stuff here, at least

Regards,

Jiju

Cache vs Snapshot

I am new to reporting services and have created a few reports. I have
noticed that I can cache or create a snapshot of the reports.
I currently use a Crystal Command line tool to run crystal reports around
4:00 am, and I would like to do the same for some of my reports.
What is the difference and which peroforms faster?
Thanks for your help.I figured it out and thought I would put it here for someone else to learn
from.
A cache is only created when the report is first run, then it can expire
when you want it to. A snapshot runs on your schedule, and stays in history.
I would like a mix, the ability to load the report the first time from the
snapshot, but give the users the ability to run it again with date ranges.
Oh well :)
"John_g" wrote:
> I am new to reporting services and have created a few reports. I have
> noticed that I can cache or create a snapshot of the reports.
> I currently use a Crystal Command line tool to run crystal reports around
> 4:00 am, and I would like to do the same for some of my reports.
> What is the difference and which peroforms faster?
> Thanks for your help.
>|||You could implement this with a report filter. You filter the data after
it's returned, not in the query. If you want to have a cache preloaded, you
can set up a process to call the report with a NULL rendering extension.
That will execute the query without returning the results.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"John_g" <John_g@.discussions.microsoft.com> wrote in message
news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>I figured it out and thought I would put it here for someone else to learn
> from.
> A cache is only created when the report is first run, then it can expire
> when you want it to. A snapshot runs on your schedule, and stays in
> history.
> I would like a mix, the ability to load the report the first time from the
> snapshot, but give the users the ability to run it again with date ranges.
> Oh well :)
> "John_g" wrote:
>> I am new to reporting services and have created a few reports. I have
>> noticed that I can cache or create a snapshot of the reports.
>> I currently use a Crystal Command line tool to run crystal reports around
>> 4:00 am, and I would like to do the same for some of my reports.
>> What is the difference and which peroforms faster?
>> Thanks for your help.|||Thanks. That sounds like a little more than I currently know how to do.
You are basically saying that I can query the data with a larger date range,
or none at all, cache it, then when the user queries the information, they
are querying the info from the cache?
If so, it this easy, or am I going to have to do some aspx programming?
Thanks for your reply.
"Jeff A. Stucker" wrote:
> You could implement this with a report filter. You filter the data after
> it's returned, not in the query. If you want to have a cache preloaded, you
> can set up a process to call the report with a NULL rendering extension.
> That will execute the query without returning the results.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "John_g" <John_g@.discussions.microsoft.com> wrote in message
> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
> >I figured it out and thought I would put it here for someone else to learn
> > from.
> >
> > A cache is only created when the report is first run, then it can expire
> > when you want it to. A snapshot runs on your schedule, and stays in
> > history.
> >
> > I would like a mix, the ability to load the report the first time from the
> > snapshot, but give the users the ability to run it again with date ranges.
> >
> > Oh well :)
> >
> > "John_g" wrote:
> >
> >> I am new to reporting services and have created a few reports. I have
> >> noticed that I can cache or create a snapshot of the reports.
> >>
> >> I currently use a Crystal Command line tool to run crystal reports around
> >> 4:00 am, and I would like to do the same for some of my reports.
> >>
> >> What is the difference and which peroforms faster?
> >>
> >> Thanks for your help.
> >>
>
>|||Probably not aspx programming. The report filter is just part of the report
design; you can filter groups (check the properties of your List, Table,
Matrix, etc.). To kick off the null report, you may be able to simply
launch a URL using the Windows scheduler. I think the syntax is this:
&rs:Format=NULL
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"John_g" <Johng@.discussions.microsoft.com> wrote in message
news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
> Thanks. That sounds like a little more than I currently know how to do.
> You are basically saying that I can query the data with a larger date
> range,
> or none at all, cache it, then when the user queries the information, they
> are querying the info from the cache?
> If so, it this easy, or am I going to have to do some aspx programming?
> Thanks for your reply.
>
> "Jeff A. Stucker" wrote:
>> You could implement this with a report filter. You filter the data after
>> it's returned, not in the query. If you want to have a cache preloaded,
>> you
>> can set up a process to call the report with a NULL rendering extension.
>> That will execute the query without returning the results.
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "John_g" <John_g@.discussions.microsoft.com> wrote in message
>> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>> >I figured it out and thought I would put it here for someone else to
>> >learn
>> > from.
>> >
>> > A cache is only created when the report is first run, then it can
>> > expire
>> > when you want it to. A snapshot runs on your schedule, and stays in
>> > history.
>> >
>> > I would like a mix, the ability to load the report the first time from
>> > the
>> > snapshot, but give the users the ability to run it again with date
>> > ranges.
>> >
>> > Oh well :)
>> >
>> > "John_g" wrote:
>> >
>> >> I am new to reporting services and have created a few reports. I have
>> >> noticed that I can cache or create a snapshot of the reports.
>> >>
>> >> I currently use a Crystal Command line tool to run crystal reports
>> >> around
>> >> 4:00 am, and I would like to do the same for some of my reports.
>> >>
>> >> What is the difference and which peroforms faster?
>> >>
>> >> Thanks for your help.
>> >>
>>|||To be more specfiic, launch this programmatically:
http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> Probably not aspx programming. The report filter is just part of the
> report design; you can filter groups (check the properties of your List,
> Table, Matrix, etc.). To kick off the null report, you may be able to
> simply launch a URL using the Windows scheduler. I think the syntax is
> this:
> &rs:Format=NULL
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "John_g" <Johng@.discussions.microsoft.com> wrote in message
> news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
>> Thanks. That sounds like a little more than I currently know how to do.
>> You are basically saying that I can query the data with a larger date
>> range,
>> or none at all, cache it, then when the user queries the information,
>> they
>> are querying the info from the cache?
>> If so, it this easy, or am I going to have to do some aspx programming?
>> Thanks for your reply.
>>
>> "Jeff A. Stucker" wrote:
>> You could implement this with a report filter. You filter the data
>> after
>> it's returned, not in the query. If you want to have a cache preloaded,
>> you
>> can set up a process to call the report with a NULL rendering extension.
>> That will execute the query without returning the results.
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "John_g" <John_g@.discussions.microsoft.com> wrote in message
>> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>> >I figured it out and thought I would put it here for someone else to
>> >learn
>> > from.
>> >
>> > A cache is only created when the report is first run, then it can
>> > expire
>> > when you want it to. A snapshot runs on your schedule, and stays in
>> > history.
>> >
>> > I would like a mix, the ability to load the report the first time from
>> > the
>> > snapshot, but give the users the ability to run it again with date
>> > ranges.
>> >
>> > Oh well :)
>> >
>> > "John_g" wrote:
>> >
>> >> I am new to reporting services and have created a few reports. I
>> >> have
>> >> noticed that I can cache or create a snapshot of the reports.
>> >>
>> >> I currently use a Crystal Command line tool to run crystal reports
>> >> around
>> >> 4:00 am, and I would like to do the same for some of my reports.
>> >>
>> >> What is the difference and which peroforms faster?
>> >>
>> >> Thanks for your help.
>> >>
>>
>|||When I run this, what data ranges does it use? My variables are StartDate
and EndDate.
I am just wandering since I am not giving it dates, does it run for all dates?
That could be time consuming.
THanks.
"Jeff A. Stucker" wrote:
> To be more specfiic, launch this programmatically:
> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> > Probably not aspx programming. The report filter is just part of the
> > report design; you can filter groups (check the properties of your List,
> > Table, Matrix, etc.). To kick off the null report, you may be able to
> > simply launch a URL using the Windows scheduler. I think the syntax is
> > this:
> >
> > &rs:Format=NULL
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
> >> Thanks. That sounds like a little more than I currently know how to do.
> >>
> >> You are basically saying that I can query the data with a larger date
> >> range,
> >> or none at all, cache it, then when the user queries the information,
> >> they
> >> are querying the info from the cache?
> >>
> >> If so, it this easy, or am I going to have to do some aspx programming?
> >>
> >> Thanks for your reply.
> >>
> >>
> >> "Jeff A. Stucker" wrote:
> >>
> >> You could implement this with a report filter. You filter the data
> >> after
> >> it's returned, not in the query. If you want to have a cache preloaded,
> >> you
> >> can set up a process to call the report with a NULL rendering extension.
> >> That will execute the query without returning the results.
> >>
> >> --
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
> >> >I figured it out and thought I would put it here for someone else to
> >> >learn
> >> > from.
> >> >
> >> > A cache is only created when the report is first run, then it can
> >> > expire
> >> > when you want it to. A snapshot runs on your schedule, and stays in
> >> > history.
> >> >
> >> > I would like a mix, the ability to load the report the first time from
> >> > the
> >> > snapshot, but give the users the ability to run it again with date
> >> > ranges.
> >> >
> >> > Oh well :)
> >> >
> >> > "John_g" wrote:
> >> >
> >> >> I am new to reporting services and have created a few reports. I
> >> >> have
> >> >> noticed that I can cache or create a snapshot of the reports.
> >> >>
> >> >> I currently use a Crystal Command line tool to run crystal reports
> >> >> around
> >> >> 4:00 am, and I would like to do the same for some of my reports.
> >> >>
> >> >> What is the difference and which peroforms faster?
> >> >>
> >> >> Thanks for your help.
> >> >>
> >>
> >>
> >>
> >
> >
>
>|||It runs for whatever the default dates are specified.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"John_g" <Johng@.discussions.microsoft.com> wrote in message
news:26547C04-1BEA-4438-A37D-FFFE6886979C@.microsoft.com...
> When I run this, what data ranges does it use? My variables are StartDate
> and EndDate.
> I am just wandering since I am not giving it dates, does it run for all
> dates?
> That could be time consuming.
> THanks.
>
> "Jeff A. Stucker" wrote:
>> To be more specfiic, launch this programmatically:
>> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> > Probably not aspx programming. The report filter is just part of the
>> > report design; you can filter groups (check the properties of your
>> > List,
>> > Table, Matrix, etc.). To kick off the null report, you may be able to
>> > simply launch a URL using the Windows scheduler. I think the syntax is
>> > this:
>> >
>> > &rs:Format=NULL
>> >
>> > --
>> > Cheers,
>> >
>> > '(' Jeff A. Stucker
>> > \
>> >
>> > Business Intelligence
>> > www.criadvantage.com
>> > ---
>> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
>> >> Thanks. That sounds like a little more than I currently know how to
>> >> do.
>> >>
>> >> You are basically saying that I can query the data with a larger date
>> >> range,
>> >> or none at all, cache it, then when the user queries the information,
>> >> they
>> >> are querying the info from the cache?
>> >>
>> >> If so, it this easy, or am I going to have to do some aspx
>> >> programming?
>> >>
>> >> Thanks for your reply.
>> >>
>> >>
>> >> "Jeff A. Stucker" wrote:
>> >>
>> >> You could implement this with a report filter. You filter the data
>> >> after
>> >> it's returned, not in the query. If you want to have a cache
>> >> preloaded,
>> >> you
>> >> can set up a process to call the report with a NULL rendering
>> >> extension.
>> >> That will execute the query without returning the results.
>> >>
>> >> --
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
>> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>> >> >I figured it out and thought I would put it here for someone else to
>> >> >learn
>> >> > from.
>> >> >
>> >> > A cache is only created when the report is first run, then it can
>> >> > expire
>> >> > when you want it to. A snapshot runs on your schedule, and stays
>> >> > in
>> >> > history.
>> >> >
>> >> > I would like a mix, the ability to load the report the first time
>> >> > from
>> >> > the
>> >> > snapshot, but give the users the ability to run it again with date
>> >> > ranges.
>> >> >
>> >> > Oh well :)
>> >> >
>> >> > "John_g" wrote:
>> >> >
>> >> >> I am new to reporting services and have created a few reports. I
>> >> >> have
>> >> >> noticed that I can cache or create a snapshot of the reports.
>> >> >>
>> >> >> I currently use a Crystal Command line tool to run crystal reports
>> >> >> around
>> >> >> 4:00 am, and I would like to do the same for some of my reports.
>> >> >>
>> >> >> What is the difference and which peroforms faster?
>> >> >>
>> >> >> Thanks for your help.
>> >> >>
>> >>
>> >>
>> >>
>> >
>> >
>>|||Thanks for your patience. I think I am finally catching on.
I can run the report and leave my variables off of the query, just get the
whole mess. Then I can use parameters and they can be entered by the user at
run-time.
So the cache will simply sit on the server, and when the user hits the query
and passes parms, the report will be run off of the cache, and not directly
hit the SQL Server.
Am I close?
"Jeff A. Stucker" wrote:
> It runs for whatever the default dates are specified.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "John_g" <Johng@.discussions.microsoft.com> wrote in message
> news:26547C04-1BEA-4438-A37D-FFFE6886979C@.microsoft.com...
> > When I run this, what data ranges does it use? My variables are StartDate
> > and EndDate.
> >
> > I am just wandering since I am not giving it dates, does it run for all
> > dates?
> > That could be time consuming.
> >
> > THanks.
> >
> >
> > "Jeff A. Stucker" wrote:
> >
> >> To be more specfiic, launch this programmatically:
> >>
> >> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> >> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> >> > Probably not aspx programming. The report filter is just part of the
> >> > report design; you can filter groups (check the properties of your
> >> > List,
> >> > Table, Matrix, etc.). To kick off the null report, you may be able to
> >> > simply launch a URL using the Windows scheduler. I think the syntax is
> >> > this:
> >> >
> >> > &rs:Format=NULL
> >> >
> >> > --
> >> > Cheers,
> >> >
> >> > '(' Jeff A. Stucker
> >> > \
> >> >
> >> > Business Intelligence
> >> > www.criadvantage.com
> >> > ---
> >> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
> >> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
> >> >> Thanks. That sounds like a little more than I currently know how to
> >> >> do.
> >> >>
> >> >> You are basically saying that I can query the data with a larger date
> >> >> range,
> >> >> or none at all, cache it, then when the user queries the information,
> >> >> they
> >> >> are querying the info from the cache?
> >> >>
> >> >> If so, it this easy, or am I going to have to do some aspx
> >> >> programming?
> >> >>
> >> >> Thanks for your reply.
> >> >>
> >> >>
> >> >> "Jeff A. Stucker" wrote:
> >> >>
> >> >> You could implement this with a report filter. You filter the data
> >> >> after
> >> >> it's returned, not in the query. If you want to have a cache
> >> >> preloaded,
> >> >> you
> >> >> can set up a process to call the report with a NULL rendering
> >> >> extension.
> >> >> That will execute the query without returning the results.
> >> >>
> >> >> --
> >> >> '(' Jeff A. Stucker
> >> >> \
> >> >>
> >> >> Business Intelligence
> >> >> www.criadvantage.com
> >> >> ---
> >> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
> >> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
> >> >> >I figured it out and thought I would put it here for someone else to
> >> >> >learn
> >> >> > from.
> >> >> >
> >> >> > A cache is only created when the report is first run, then it can
> >> >> > expire
> >> >> > when you want it to. A snapshot runs on your schedule, and stays
> >> >> > in
> >> >> > history.
> >> >> >
> >> >> > I would like a mix, the ability to load the report the first time
> >> >> > from
> >> >> > the
> >> >> > snapshot, but give the users the ability to run it again with date
> >> >> > ranges.
> >> >> >
> >> >> > Oh well :)
> >> >> >
> >> >> > "John_g" wrote:
> >> >> >
> >> >> >> I am new to reporting services and have created a few reports. I
> >> >> >> have
> >> >> >> noticed that I can cache or create a snapshot of the reports.
> >> >> >>
> >> >> >> I currently use a Crystal Command line tool to run crystal reports
> >> >> >> around
> >> >> >> 4:00 am, and I would like to do the same for some of my reports.
> >> >> >>
> >> >> >> What is the difference and which peroforms faster?
> >> >> >>
> >> >> >> Thanks for your help.
> >> >> >>
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >>
>
>|||That's it! Perfect summary.
Since you're running off the cache, and filtering that, then at rendering
time it puts more load on the reporting engine, but zero load on the
back-end database. And that's perfectly fine if the back-end query was
where the thing was bogging down to begin with. So your cache will have a
superset of all the various data your end-users will see on the same report.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"John_g" <Johng@.discussions.microsoft.com> wrote in message
news:0E1D42DA-702A-41F9-8277-0F5C42B26A5F@.microsoft.com...
> Thanks for your patience. I think I am finally catching on.
> I can run the report and leave my variables off of the query, just get the
> whole mess. Then I can use parameters and they can be entered by the user
> at
> run-time.
> So the cache will simply sit on the server, and when the user hits the
> query
> and passes parms, the report will be run off of the cache, and not
> directly
> hit the SQL Server.
> Am I close?
> "Jeff A. Stucker" wrote:
>> It runs for whatever the default dates are specified.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> news:26547C04-1BEA-4438-A37D-FFFE6886979C@.microsoft.com...
>> > When I run this, what data ranges does it use? My variables are
>> > StartDate
>> > and EndDate.
>> >
>> > I am just wandering since I am not giving it dates, does it run for all
>> > dates?
>> > That could be time consuming.
>> >
>> > THanks.
>> >
>> >
>> > "Jeff A. Stucker" wrote:
>> >
>> >> To be more specfiic, launch this programmatically:
>> >>
>> >> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
>> >>
>> >> --
>> >> Cheers,
>> >>
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> >> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> >> > Probably not aspx programming. The report filter is just part of
>> >> > the
>> >> > report design; you can filter groups (check the properties of your
>> >> > List,
>> >> > Table, Matrix, etc.). To kick off the null report, you may be able
>> >> > to
>> >> > simply launch a URL using the Windows scheduler. I think the syntax
>> >> > is
>> >> > this:
>> >> >
>> >> > &rs:Format=NULL
>> >> >
>> >> > --
>> >> > Cheers,
>> >> >
>> >> > '(' Jeff A. Stucker
>> >> > \
>> >> >
>> >> > Business Intelligence
>> >> > www.criadvantage.com
>> >> > ---
>> >> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> >> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
>> >> >> Thanks. That sounds like a little more than I currently know how
>> >> >> to
>> >> >> do.
>> >> >>
>> >> >> You are basically saying that I can query the data with a larger
>> >> >> date
>> >> >> range,
>> >> >> or none at all, cache it, then when the user queries the
>> >> >> information,
>> >> >> they
>> >> >> are querying the info from the cache?
>> >> >>
>> >> >> If so, it this easy, or am I going to have to do some aspx
>> >> >> programming?
>> >> >>
>> >> >> Thanks for your reply.
>> >> >>
>> >> >>
>> >> >> "Jeff A. Stucker" wrote:
>> >> >>
>> >> >> You could implement this with a report filter. You filter the
>> >> >> data
>> >> >> after
>> >> >> it's returned, not in the query. If you want to have a cache
>> >> >> preloaded,
>> >> >> you
>> >> >> can set up a process to call the report with a NULL rendering
>> >> >> extension.
>> >> >> That will execute the query without returning the results.
>> >> >>
>> >> >> --
>> >> >> '(' Jeff A. Stucker
>> >> >> \
>> >> >>
>> >> >> Business Intelligence
>> >> >> www.criadvantage.com
>> >> >> ---
>> >> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
>> >> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>> >> >> >I figured it out and thought I would put it here for someone else
>> >> >> >to
>> >> >> >learn
>> >> >> > from.
>> >> >> >
>> >> >> > A cache is only created when the report is first run, then it
>> >> >> > can
>> >> >> > expire
>> >> >> > when you want it to. A snapshot runs on your schedule, and
>> >> >> > stays
>> >> >> > in
>> >> >> > history.
>> >> >> >
>> >> >> > I would like a mix, the ability to load the report the first
>> >> >> > time
>> >> >> > from
>> >> >> > the
>> >> >> > snapshot, but give the users the ability to run it again with
>> >> >> > date
>> >> >> > ranges.
>> >> >> >
>> >> >> > Oh well :)
>> >> >> >
>> >> >> > "John_g" wrote:
>> >> >> >
>> >> >> >> I am new to reporting services and have created a few reports.
>> >> >> >> I
>> >> >> >> have
>> >> >> >> noticed that I can cache or create a snapshot of the reports.
>> >> >> >>
>> >> >> >> I currently use a Crystal Command line tool to run crystal
>> >> >> >> reports
>> >> >> >> around
>> >> >> >> 4:00 am, and I would like to do the same for some of my
>> >> >> >> reports.
>> >> >> >>
>> >> >> >> What is the difference and which peroforms faster?
>> >> >> >>
>> >> >> >> Thanks for your help.
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||Thanks Jeff! I truly appreciate your help.
One last question... I did as you said, but I cannot get my date to
filter. The date field is datetime, but when I try '10/1/2004' or without
the quotes, or even add time, it says that the data is not comparable.
Also, I have been having a hard time scheduling the null report, but I have
not given up yet.
Thanks again
"Jeff A. Stucker" wrote:
> That's it! Perfect summary.
> Since you're running off the cache, and filtering that, then at rendering
> time it puts more load on the reporting engine, but zero load on the
> back-end database. And that's perfectly fine if the back-end query was
> where the thing was bogging down to begin with. So your cache will have a
> superset of all the various data your end-users will see on the same report.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "John_g" <Johng@.discussions.microsoft.com> wrote in message
> news:0E1D42DA-702A-41F9-8277-0F5C42B26A5F@.microsoft.com...
> > Thanks for your patience. I think I am finally catching on.
> >
> > I can run the report and leave my variables off of the query, just get the
> > whole mess. Then I can use parameters and they can be entered by the user
> > at
> > run-time.
> >
> > So the cache will simply sit on the server, and when the user hits the
> > query
> > and passes parms, the report will be run off of the cache, and not
> > directly
> > hit the SQL Server.
> >
> > Am I close?
> >
> > "Jeff A. Stucker" wrote:
> >
> >> It runs for whatever the default dates are specified.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "John_g" <Johng@.discussions.microsoft.com> wrote in message
> >> news:26547C04-1BEA-4438-A37D-FFFE6886979C@.microsoft.com...
> >> > When I run this, what data ranges does it use? My variables are
> >> > StartDate
> >> > and EndDate.
> >> >
> >> > I am just wandering since I am not giving it dates, does it run for all
> >> > dates?
> >> > That could be time consuming.
> >> >
> >> > THanks.
> >> >
> >> >
> >> > "Jeff A. Stucker" wrote:
> >> >
> >> >> To be more specfiic, launch this programmatically:
> >> >>
> >> >> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
> >> >>
> >> >> --
> >> >> Cheers,
> >> >>
> >> >> '(' Jeff A. Stucker
> >> >> \
> >> >>
> >> >> Business Intelligence
> >> >> www.criadvantage.com
> >> >> ---
> >> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> >> >> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> >> >> > Probably not aspx programming. The report filter is just part of
> >> >> > the
> >> >> > report design; you can filter groups (check the properties of your
> >> >> > List,
> >> >> > Table, Matrix, etc.). To kick off the null report, you may be able
> >> >> > to
> >> >> > simply launch a URL using the Windows scheduler. I think the syntax
> >> >> > is
> >> >> > this:
> >> >> >
> >> >> > &rs:Format=NULL
> >> >> >
> >> >> > --
> >> >> > Cheers,
> >> >> >
> >> >> > '(' Jeff A. Stucker
> >> >> > \
> >> >> >
> >> >> > Business Intelligence
> >> >> > www.criadvantage.com
> >> >> > ---
> >> >> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
> >> >> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
> >> >> >> Thanks. That sounds like a little more than I currently know how
> >> >> >> to
> >> >> >> do.
> >> >> >>
> >> >> >> You are basically saying that I can query the data with a larger
> >> >> >> date
> >> >> >> range,
> >> >> >> or none at all, cache it, then when the user queries the
> >> >> >> information,
> >> >> >> they
> >> >> >> are querying the info from the cache?
> >> >> >>
> >> >> >> If so, it this easy, or am I going to have to do some aspx
> >> >> >> programming?
> >> >> >>
> >> >> >> Thanks for your reply.
> >> >> >>
> >> >> >>
> >> >> >> "Jeff A. Stucker" wrote:
> >> >> >>
> >> >> >> You could implement this with a report filter. You filter the
> >> >> >> data
> >> >> >> after
> >> >> >> it's returned, not in the query. If you want to have a cache
> >> >> >> preloaded,
> >> >> >> you
> >> >> >> can set up a process to call the report with a NULL rendering
> >> >> >> extension.
> >> >> >> That will execute the query without returning the results.
> >> >> >>
> >> >> >> --
> >> >> >> '(' Jeff A. Stucker
> >> >> >> \
> >> >> >>
> >> >> >> Business Intelligence
> >> >> >> www.criadvantage.com
> >> >> >> ---
> >> >> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
> >> >> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
> >> >> >> >I figured it out and thought I would put it here for someone else
> >> >> >> >to
> >> >> >> >learn
> >> >> >> > from.
> >> >> >> >
> >> >> >> > A cache is only created when the report is first run, then it
> >> >> >> > can
> >> >> >> > expire
> >> >> >> > when you want it to. A snapshot runs on your schedule, and
> >> >> >> > stays
> >> >> >> > in
> >> >> >> > history.
> >> >> >> >
> >> >> >> > I would like a mix, the ability to load the report the first
> >> >> >> > time
> >> >> >> > from
> >> >> >> > the
> >> >> >> > snapshot, but give the users the ability to run it again with
> >> >> >> > date
> >> >> >> > ranges.
> >> >> >> >
> >> >> >> > Oh well :)
> >> >> >> >
> >> >> >> > "John_g" wrote:
> >> >> >> >
> >> >> >> >> I am new to reporting services and have created a few reports.
> >> >> >> >> I
> >> >> >> >> have
> >> >> >> >> noticed that I can cache or create a snapshot of the reports.
> >> >> >> >>
> >> >> >> >> I currently use a Crystal Command line tool to run crystal
> >> >> >> >> reports
> >> >> >> >> around
> >> >> >> >> 4:00 am, and I would like to do the same for some of my
> >> >> >> >> reports.
> >> >> >> >>
> >> >> >> >> What is the difference and which peroforms faster?
> >> >> >> >>
> >> >> >> >> Thanks for your help.
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Where is your filter set up and what's it look like where the date is
bombing?
Have you verified that the null report works by calling the URL directly
from a browser? I'm not an expert on scheduling, so perhaps someone else
can help you with that.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"John_g" <Johng@.discussions.microsoft.com> wrote in message
news:CA494272-DC24-49CD-9FB7-70852295EDD8@.microsoft.com...
> Thanks Jeff! I truly appreciate your help.
> One last question... I did as you said, but I cannot get my date to
> filter. The date field is datetime, but when I try '10/1/2004' or without
> the quotes, or even add time, it says that the data is not comparable.
> Also, I have been having a hard time scheduling the null report, but I
> have
> not given up yet.
> Thanks again
> "Jeff A. Stucker" wrote:
>> That's it! Perfect summary.
>> Since you're running off the cache, and filtering that, then at rendering
>> time it puts more load on the reporting engine, but zero load on the
>> back-end database. And that's perfectly fine if the back-end query was
>> where the thing was bogging down to begin with. So your cache will have
>> a
>> superset of all the various data your end-users will see on the same
>> report.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> news:0E1D42DA-702A-41F9-8277-0F5C42B26A5F@.microsoft.com...
>> > Thanks for your patience. I think I am finally catching on.
>> >
>> > I can run the report and leave my variables off of the query, just get
>> > the
>> > whole mess. Then I can use parameters and they can be entered by the
>> > user
>> > at
>> > run-time.
>> >
>> > So the cache will simply sit on the server, and when the user hits the
>> > query
>> > and passes parms, the report will be run off of the cache, and not
>> > directly
>> > hit the SQL Server.
>> >
>> > Am I close?
>> >
>> > "Jeff A. Stucker" wrote:
>> >
>> >> It runs for whatever the default dates are specified.
>> >>
>> >> --
>> >> Cheers,
>> >>
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> >> news:26547C04-1BEA-4438-A37D-FFFE6886979C@.microsoft.com...
>> >> > When I run this, what data ranges does it use? My variables are
>> >> > StartDate
>> >> > and EndDate.
>> >> >
>> >> > I am just wandering since I am not giving it dates, does it run for
>> >> > all
>> >> > dates?
>> >> > That could be time consuming.
>> >> >
>> >> > THanks.
>> >> >
>> >> >
>> >> > "Jeff A. Stucker" wrote:
>> >> >
>> >> >> To be more specfiic, launch this programmatically:
>> >> >>
>> >> >> http://RSSRV/ReportServer?/Path/Report&rs:Format=NULL
>> >> >>
>> >> >> --
>> >> >> Cheers,
>> >> >>
>> >> >> '(' Jeff A. Stucker
>> >> >> \
>> >> >>
>> >> >> Business Intelligence
>> >> >> www.criadvantage.com
>> >> >> ---
>> >> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> >> >> news:enleZEI3EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> >> >> > Probably not aspx programming. The report filter is just part of
>> >> >> > the
>> >> >> > report design; you can filter groups (check the properties of
>> >> >> > your
>> >> >> > List,
>> >> >> > Table, Matrix, etc.). To kick off the null report, you may be
>> >> >> > able
>> >> >> > to
>> >> >> > simply launch a URL using the Windows scheduler. I think the
>> >> >> > syntax
>> >> >> > is
>> >> >> > this:
>> >> >> >
>> >> >> > &rs:Format=NULL
>> >> >> >
>> >> >> > --
>> >> >> > Cheers,
>> >> >> >
>> >> >> > '(' Jeff A. Stucker
>> >> >> > \
>> >> >> >
>> >> >> > Business Intelligence
>> >> >> > www.criadvantage.com
>> >> >> > ---
>> >> >> > "John_g" <Johng@.discussions.microsoft.com> wrote in message
>> >> >> > news:FD00DCEA-369A-4B2B-844E-C8BB1C3D509A@.microsoft.com...
>> >> >> >> Thanks. That sounds like a little more than I currently know
>> >> >> >> how
>> >> >> >> to
>> >> >> >> do.
>> >> >> >>
>> >> >> >> You are basically saying that I can query the data with a larger
>> >> >> >> date
>> >> >> >> range,
>> >> >> >> or none at all, cache it, then when the user queries the
>> >> >> >> information,
>> >> >> >> they
>> >> >> >> are querying the info from the cache?
>> >> >> >>
>> >> >> >> If so, it this easy, or am I going to have to do some aspx
>> >> >> >> programming?
>> >> >> >>
>> >> >> >> Thanks for your reply.
>> >> >> >>
>> >> >> >>
>> >> >> >> "Jeff A. Stucker" wrote:
>> >> >> >>
>> >> >> >> You could implement this with a report filter. You filter the
>> >> >> >> data
>> >> >> >> after
>> >> >> >> it's returned, not in the query. If you want to have a cache
>> >> >> >> preloaded,
>> >> >> >> you
>> >> >> >> can set up a process to call the report with a NULL rendering
>> >> >> >> extension.
>> >> >> >> That will execute the query without returning the results.
>> >> >> >>
>> >> >> >> --
>> >> >> >> '(' Jeff A. Stucker
>> >> >> >> \
>> >> >> >>
>> >> >> >> Business Intelligence
>> >> >> >> www.criadvantage.com
>> >> >> >> ---
>> >> >> >> "John_g" <John_g@.discussions.microsoft.com> wrote in message
>> >> >> >> news:71D9E727-49EA-447B-A55B-21A26592EA2F@.microsoft.com...
>> >> >> >> >I figured it out and thought I would put it here for someone
>> >> >> >> >else
>> >> >> >> >to
>> >> >> >> >learn
>> >> >> >> > from.
>> >> >> >> >
>> >> >> >> > A cache is only created when the report is first run, then it
>> >> >> >> > can
>> >> >> >> > expire
>> >> >> >> > when you want it to. A snapshot runs on your schedule, and
>> >> >> >> > stays
>> >> >> >> > in
>> >> >> >> > history.
>> >> >> >> >
>> >> >> >> > I would like a mix, the ability to load the report the first
>> >> >> >> > time
>> >> >> >> > from
>> >> >> >> > the
>> >> >> >> > snapshot, but give the users the ability to run it again with
>> >> >> >> > date
>> >> >> >> > ranges.
>> >> >> >> >
>> >> >> >> > Oh well :)
>> >> >> >> >
>> >> >> >> > "John_g" wrote:
>> >> >> >> >
>> >> >> >> >> I am new to reporting services and have created a few
>> >> >> >> >> reports.
>> >> >> >> >> I
>> >> >> >> >> have
>> >> >> >> >> noticed that I can cache or create a snapshot of the
>> >> >> >> >> reports.
>> >> >> >> >>
>> >> >> >> >> I currently use a Crystal Command line tool to run crystal
>> >> >> >> >> reports
>> >> >> >> >> around
>> >> >> >> >> 4:00 am, and I would like to do the same for some of my
>> >> >> >> >> reports.
>> >> >> >> >>
>> >> >> >> >> What is the difference and which peroforms faster?
>> >> >> >> >>
>> >> >> >> >> Thanks for your help.
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

Cache size lookup transformation

Hi,

I have to perform a lookup in a table based on a query like:

"... where ? = [RefTable].fieldID and ? between [RefTable].AnotherFieldValue and [RefTable].AThirdFieldValue"

So, SSIS has put the CacheType to none. As I really need to speed up the job I want to set the CacheType to partial (full isn't an option due to the custom query I use here).

But here it comes: when using partial CacheType, one has to set the cache size manually - and I really don't know what value I should assign to it - is there a guideline on this topic?

I work on a Win2003 server platform with sql server 2005 - 2 processors - 2Gb Ram - enough disc space

Thanks in advance,
Tom

Tom De Cort wrote:

Hi,

I have to perform a lookup in a table based on a query like:

"... where ? = [RefTable].fieldID and ? between [RefTable].AnotherFieldValue and [RefTable].AThirdFieldValue"

So, SSIS has put the CacheType to none. As I really need to speed up the job I want to set the CacheType to partial (full isn't an option due to the custom query I use here).

But here it comes: when using partial CacheType, one has to set the cache size manually - and I really don't know what value I should assign to it - is there a guideline on this topic?

I work on a Win2003 server platform with sql server 2005 - 2 processors - 2Gb Ram - enough disc space

Thanks in advance,
Tom

Tom,

The only person that can answer this question for sure is yourself. Test and measure, test and measure, test and measure...

Differrent scenarios call for different settings so I doubt there are guidelines anywhere.

-Jamie

|||

ok, I will

Thanks Jamie

Cache problem in Report Services

Hi All,
We are using RS for our application to show report. We are calling URL
for all report from ASP with some parameters, like on click of a button
with some filters we are using report link as
http://localhost/reportserver?/rptParameter/rdlTestParameter&rs:Command=Render&rc:Parameters=false&CID=2067
When we click on button, report gets fired, but it shows old data and
when we press refresh button of RS it shows updated data. We changed
the data and fired the above url again, it doesnt show updated data and
when we press refresh button it will shows updated data. May be this is
due to cache but in Report Manager i have checked the Do not cache
reports.., but problem still persist, can anybody please tell me how to
solve this problem.
Thanks
Regards
RajeshHi,
when calling your report, you can add the following parameter:
http://localhost/reportserver?/rptParameter/rdlTestParameter&rs:Command=Render&rc:Parameters=false&rs:ClearSession=true&CID=2067
Laurent
"Raj" <kapse_rajesh@.rediffmail.com> a écrit dans le message de news:
1141463990.435176.137140@.i40g2000cwc.googlegroups.com...
> Hi All,
> We are using RS for our application to show report. We are calling URL
> for all report from ASP with some parameters, like on click of a button
> with some filters we are using report link as
> http://localhost/reportserver?/rptParameter/rdlTestParameter&rs:Command=Render&rc:Parameters=false&CID=2067
> When we click on button, report gets fired, but it shows old data and
> when we press refresh button of RS it shows updated data. We changed
> the data and fired the above url again, it doesnt show updated data and
> when we press refresh button it will shows updated data. May be this is
> due to cache but in Report Manager i have checked the Do not cache
> reports.., but problem still persist, can anybody please tell me how to
> solve this problem.
>
> Thanks
> Regards
> Rajesh
>|||Thanks Laurent, this solved my problem.
Thanks
Rajesh

Cache problem in Report Services

Hi All,
We developed 40 reports using Reporting services, all reports having
parameters, data source for all reports are views. I am facing problem
of may be cache. I am using url method to show reports, i wrote a ASP
page on link of report i am using report server url to show like -
http://servername/reportserver/fold...arOrderNo=2067,
but when i click on the link, it shows old data in report and when i
press refresh button given with RS it will refresh and shows the
updated data, every time to get updated data i have to press refresh
button. Can anyone suggest me how to show updated data on report
whenever it gets fired? Please my project submission data is too short,
suggest me asap
Thank You
Regards
Rajeshhi Raj,
I had the same problem (I'm not a developer) but managed to find the cause
and got my developer to fix it.
I don't have the solution to hand now, but if you don't get the solution by
the time I get to work and find the solution, I'll post it by tomorrow
morning.
Immy
p.s. You should try to post this message in the reporting services
newsgroup.
"Raj" <kapse_rajesh@.rediffmail.com> wrote in message
news:1141463255.332391.287870@.z34g2000cwc.googlegroups.com...
> Hi All,
> We developed 40 reports using Reporting services, all reports having
> parameters, data source for all reports are views. I am facing problem
> of may be cache. I am using url method to show reports, i wrote a ASP
> page on link of report i am using report server url to show like -
> http://servername/reportserver/fold...arOrderNo=2067,
> but when i click on the link, it shows old data in report and when i
> press refresh button given with RS it will refresh and shows the
> updated data, every time to get updated data i have to press refresh
> button. Can anyone suggest me how to show updated data on report
> whenever it gets fired? Please my project submission data is too short,
> suggest me asap
>
> Thank You
> Regards
> Rajesh
>|||sorry, forgot to say... it has something to do with the fact that you need
to append the command 'ClearSession=true' to the url at some point.
this should get you on your way if it can't wait until later.
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:OAF6lY4PGHA.5856@.TK2MSFTNGP10.phx.gbl...
> hi Raj,
> I had the same problem (I'm not a developer) but managed to find the cause
> and got my developer to fix it.
> I don't have the solution to hand now, but if you don't get the solution
> by the time I get to work and find the solution, I'll post it by tomorrow
> morning.
> Immy
> p.s. You should try to post this message in the reporting services
> newsgroup.
> "Raj" <kapse_rajesh@.rediffmail.com> wrote in message
> news:1141463255.332391.287870@.z34g2000cwc.googlegroups.com...
>

Cache Problem - URGENT HELP !

Dear All,
I have web application (ASP.NET) where I use SQL Server Std Server
engine as backened.
The issue that I have noticed whenever I ran "perfmon" the Total Pages
and Cache Pages alway showss 100 which is topmost.
My WEB application execute many SP that return data to client. In most
of SPs I create Temp Table and drop the same upon completion of SP.
Also I get an alert from SQL Performance monitor tool which is shown
below:
" Not enough physical memory has been left for NT; this will cause
excessive NT paging, resulting in poor performance."
My SQL Server RAM 1 GB. Have configured SQL Server to "to dynamically
confgiure SQL memory"
Do you know what could be the problem of hitting "Total Pages" and
"Cache Pages" 100.
Kindly help and advise..
Many thanks in advance
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!If you only have 1 GB of RAM on the server, and the memory is maxed out, I
would check the counters in Performance Monitor to see if it indicated a
need for more RAM in the box... Are you running IIS and SQL Server on the
same box? Try setting your SQL Server to use a fixed amount of RAM (maybe
800 MB depending on what else you have running on that box?)
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> wrote in message
news:%23q3Gl6tMFHA.3328@.TK2MSFTNGP14.phx.gbl...
> Dear All,
> I have web application (ASP.NET) where I use SQL Server Std Server
> engine as backened.
> The issue that I have noticed whenever I ran "perfmon" the Total Pages
> and Cache Pages alway showss 100 which is topmost.
> My WEB application execute many SP that return data to client. In most
> of SPs I create Temp Table and drop the same upon completion of SP.
> Also I get an alert from SQL Performance monitor tool which is shown
> below:
> " Not enough physical memory has been left for NT; this will cause
> excessive NT paging, resulting in poor performance."
> My SQL Server RAM 1 GB. Have configured SQL Server to "to dynamically
> confgiure SQL memory"
> Do you know what could be the problem of hitting "Total Pages" and
> "Cache Pages" 100.
> Kindly help and advise..
> Many thanks in advance
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Michael,
Thanks for reply.
Yes, I have IIS and SQL on same box. I tried below statment to check
memory used which is return 753 MB used.
Also I checked following counters on "Performance" monitor this AM which
return as follows:
Object: SQL Server: Memory Manager:
--
Counter: Total Server Memory (KB) shows between 75-80
Object: Memory
--
Counter: Cache Bytes shows 100
Object: SQL Server: Cache Manager:
--
Counter: Cache Pages Shows between 50-55
Counter: Cache Object Counts 100
Object: ASP.NET Application
--
Counter: Cache Total hits shows 100
Due to all above, I suspect that my application might have affected it's
performance. I mean, in terms of speed.
How can I resolved this problem ?. Shall I increase the RAM ? What about
the Cache counters ? The pages in the cache, would it increase the
performance or decrease the performance ?
What about if I apply following DBCC commands ?. Will it help ?
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
I would really appreciate your tips or advise to increase the
performance of the application.
Many thanks in advance...
Regards,
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||My first thoughts would be - if at all possible, get IIS on it's own box.
If not possible, I would set SQL Server to have a Fixed Memory size.
Offhand I would say that your memory might be a bottleneck - to find out for
sure, you might want to check other counters. Here's a page that lists some
other counters you might want to check to verify that it is a memory
problem:
[url]http://www.sql-server-performance.com/performance_monitor_counters_memory.asp.[/ur
l]
If you determine it is a memory problem, your best bet might be to add some
memory to the box...
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> wrote in message
news:OBd7ZE2MFHA.3328@.TK2MSFTNGP14.phx.gbl...
> Michael,
> Thanks for reply.
> Yes, I have IIS and SQL on same box. I tried below statment to check
> memory used which is return 753 MB used.
>
> Also I checked following counters on "Performance" monitor this AM which
> return as follows:
> Object: SQL Server: Memory Manager:
> --
> Counter: Total Server Memory (KB) shows between 75-80
> Object: Memory
> --
> Counter: Cache Bytes shows 100
> Object: SQL Server: Cache Manager:
> --
> Counter: Cache Pages Shows between 50-55
> Counter: Cache Object Counts 100
> Object: ASP.NET Application
> --
> Counter: Cache Total hits shows 100
> Due to all above, I suspect that my application might have affected it's
> performance. I mean, in terms of speed.
> How can I resolved this problem ?. Shall I increase the RAM ? What about
> the Cache counters ? The pages in the cache, would it increase the
> performance or decrease the performance ?
> What about if I apply following DBCC commands ?. Will it help ?
> DBCC FREEPROCCACHE
> DBCC DROPCLEANBUFFERS
> I would really appreciate your tips or advise to increase the
> performance of the application.
> Many thanks in advance...
> Regards,
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

Cache Problem

I am using Reporting Services with SQL Server 2000. The report is called in IE and rendered in PDF and displays correctly. However, the problem I have occurs when, during the same IE session, first I call the report, then change the values in the database, and call the report again with the same parameters. The second time, the values in the report remain the same as the first one.

Somehow, the second time I call the report, it is not generating a new one but using the one in Cache. If I close IE, reopen it and call the report then the new values are displayed.

In the Report Manager Properties/Execution, I chose to execute the report with the most recent data and not to put a temporary copy in chache.

Is there a way to force the report to ALWAYS get fresh copies?

Thanks a lot

Bob

There are two levels of caching. One is "execution caching" and you can configure this via the execution options tab in Report Manager. The other is "output caching." Output caching is when we cache the actual rendered output. You are hitting the "output cache" in this case, which is not configurable. Try hitting using "ctrl-f5" to force a refresh. It should cause us to clear your current session and you should see the new data the next time you request the report.

|||

Thanks for the info. It is true, as u wrote, that I am hitting the "output Cache"... But the problem is that the report will not be generated by me, but by the users of the Intranet I am developping.

Is there a way I can simulate the "ctrl-F5", or force a refresh, in the program?

|||

Have you tried passing in the name/value pair

rs:ClearSession=true

with your report URL? That should force a new query every time the report is viewed.

|||CTRL-F5 (through IE) and rs:ClearSession=true should give you identical results.|||

Also, the different users will get the data as it existed when they first rendered the report. The way to think about it is that when their session is created and the report is rendered, the data that generated that report is bound to their session. Subsequent "exports" of the different formats should contain the same data since it is for the same session. We will not reuse the output cache across sessions since they will each have their own snapshot (because you have the report set to execute live).

|||

John Gallardo - MSFT wrote:

CTRL-F5 (through IE) and rs:ClearSession=true should give you identical results.

Well, the OP wondered if he could "force" a refresh. rs:ClearSession will work here; although they are identical CTRL-F5 does not seem like a valid solution.

Side note - I've seen some MVP postings in Google Group results that contradict IE's refresh will work for this. I had a similar problem I had to search for help on. Example:

"Either close IE and reopen it or try clicking on the Report Manager refresh
button (IE refresh does not work). Rolling out a new version of a report is
a special case.

Closing IE and reopening it always works.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services "

Original thread:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/acd8e041dd06dd86/8b17af12fee5b901?lnk=st&q=sql+reporting+services+session+caching&rnum=1&hl=en#8b17af12fee5b901

Just FYI. What, for my edification, is the difference in the thread's scenario and the OP?

|||Thx a lot, this was the solution!|||

Hello guys,

I have a problem with cashe.

When I get rport at the first time, it's OK

At the second - I get report without right part of header (it's truncated.)

Part of footer located at the same X position of footer isn't truncated.

All solutions mentioned above isn't useful.

What might it be?

Thanks

Cache Problem

I am using Reporting Services with SQL Server 2000. The report is called in IE and rendered in PDF and displays correctly. However, the problem I have occurs when, during the same IE session, first I call the report, then change the values in the database, and call the report again with the same parameters. The second time, the values in the report remain the same as the first one.

Somehow, the second time I call the report, it is not generating a new one but using the one in Cache. If I close IE, reopen it and call the report then the new values are displayed.

In the Report Manager Properties/Execution, I chose to execute the report with the most recent data and not to put a temporary copy in chache.

Is there a way to force the report to ALWAYS get fresh copies?

Thanks a lot

Bob

There are two levels of caching. One is "execution caching" and you can configure this via the execution options tab in Report Manager. The other is "output caching." Output caching is when we cache the actual rendered output. You are hitting the "output cache" in this case, which is not configurable. Try hitting using "ctrl-f5" to force a refresh. It should cause us to clear your current session and you should see the new data the next time you request the report.

|||

Thanks for the info. It is true, as u wrote, that I am hitting the "output Cache"... But the problem is that the report will not be generated by me, but by the users of the Intranet I am developping.

Is there a way I can simulate the "ctrl-F5", or force a refresh, in the program?

|||

Have you tried passing in the name/value pair

rs:ClearSession=true

with your report URL? That should force a new query every time the report is viewed.

|||CTRL-F5 (through IE) and rs:ClearSession=true should give you identical results.|||

Also, the different users will get the data as it existed when they first rendered the report. The way to think about it is that when their session is created and the report is rendered, the data that generated that report is bound to their session. Subsequent "exports" of the different formats should contain the same data since it is for the same session. We will not reuse the output cache across sessions since they will each have their own snapshot (because you have the report set to execute live).

|||

John Gallardo - MSFT wrote:

CTRL-F5 (through IE) and rs:ClearSession=true should give you identical results.

Well, the OP wondered if he could "force" a refresh. rs:ClearSession will work here; although they are identical CTRL-F5 does not seem like a valid solution.

Side note - I've seen some MVP postings in Google Group results that contradict IE's refresh will work for this. I had a similar problem I had to search for help on. Example:

"Either close IE and reopen it or try clicking on the Report Manager refresh
button (IE refresh does not work). Rolling out a new version of a report is
a special case.

Closing IE and reopening it always works.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services "

Original thread:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/acd8e041dd06dd86/8b17af12fee5b901?lnk=st&q=sql+reporting+services+session+caching&rnum=1&hl=en#8b17af12fee5b901

Just FYI. What, for my edification, is the difference in the thread's scenario and the OP?

|||Thx a lot, this was the solution!|||

Hello guys,

I have a problem with cashe.

When I get rport at the first time, it's OK

At the second - I get report without right part of header (it's truncated.)

Part of footer located at the same X position of footer isn't truncated.

All solutions mentioned above isn't useful.

What might it be?

Thanks