Solved

Textbox containing a date expression changes in snapshots ?

Posted on 2008-06-20
1
433 Views
Last Modified: 2013-11-05
Hello,

My report contains a TextBox with an expression "=Now()" in the Page Header
in order to display the date and time the report was generated.

Now, when I open a snapshot of the report the value in the TextBox changes
to the current date and time, instead of preserving the value that was there
at the time the snapshot was generated.

I thought snapshots were static.

1. What exactly remains static for snapshots ?

2. Can or do parameters also change ? The reason I am asking is because I am
also displaying the paraemter values in the Page Header and I don't want
those values to change.

3. Is there a workaround ? I would like to preserve the date and time and I
don't want it to change every time someone generates the report from the
snapshot.

4. I also have two other textboxes on the Page Header which are VB.NET code expression which calculate dates. Will these change ?

Thank you for your help !
0
Comment
Question by:LiorRon
1 Comment
 
LVL 13

Accepted Solution

by:
rickchild earned 250 total points
ID: 21844805
1.  The following is stored as part of a snapshot:

- Data result set
- Report Definition (the code in the .rdl)
- Parameter Values
- Embedded objects such as images

2. Regarding parameters see the quote below from this link, but it looks like the parameters do not change.

http://technet.microsoft.com/en-us/library/aa274411(SQL.80).aspx

You can create a snapshot for a report using one set of parameter values.
If a parameterized report supports multiple values for a single parameter (for example, an EmployeeID parameter that takes an employee-specific value), only one of those values is stored with the snapshot.
If a user requests the report using a different parameter value, the value is ignored.
The snapshot that the user sees is based on the parameter value that is stored with the snapshot.

3. You could try using this instead of =Now()

=Globals!ExecutionTime

Also if that doesn't work the date and time of snapshot is stored with the snapshot in the database, as you can see the "When Run" in report manager next to the report.  Not sure exactly where this is stored, but a workaround may involve running a trace, opening that page to see which Stored Procedure is used by the server to pull this date, and using it in the report as a data source.

4. Unsure sorry, may need to test.
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Average Calculation - SAP Lumira 1 140
If Then Else Query in Cognos 10.0 4 105
SSRS keeping tablix together 13 283
Crystal Reports "Failed to open a rowset" 16 100
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
How to increase the row limit in Jasper Server.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question