Report Layout... TextBox Issue

I have two TextBoxes, they are next to each other and they touch.
According to their properties they are the same height, they are also the
same distance from the top.
Preview: they line up perfectly
After Deployment: one appears as though it is a slightly different height
Export To PDF: suddenly they're the same again
Why is this happening and how can I fix it?There are various properties on the text box you can set to specify where
it is located. If they have the same properties, that means they actually
want to be located in the same space. But the HTML viewer will position
them differently because it does not support overlay.
<Height></Height>
<Width></Width>
<Top></Top>
<Left></Left>
--
| Thread-Topic: Report Layout... TextBox Issue
| thread-index: AcS6nZhfn6F0qzGsTYehI9XjssWUhg==| X-WBNR-Posting-Host: 64.86.141.134
| From: "=?Utf-8?B?TUVSNzg=?=" <MER78@.discussions.microsoft.com>
| Subject: Report Layout... TextBox Issue
| Date: Mon, 25 Oct 2004 07:19:10 -0700
| Lines: 10
| Message-ID: <4592BB8A-993A-4A7A-98F1-2690E2E5658E@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33048
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have two TextBoxes, they are next to each other and they touch.
|
| According to their properties they are the same height, they are also the
| same distance from the top.
|
| Preview: they line up perfectly
| After Deployment: one appears as though it is a slightly different height
| Export To PDF: suddenly they're the same again
|
| Why is this happening and how can I fix it?
||||I think I mis-worded my question... I've had endless problems with text boxes
that touch... at least according to their properties they don't overlap... it
looks ok in one format... in another boxes get pushed onto other lines etc...
especially in excel...
I've started using a table for text boxes that touch whenever I can...
though it took me awhile to notice that you can use a table without having it
connected to a data source... if you put all of your stuff in header rows.
""Brad Syputa - MS"" wrote:
> There are various properties on the text box you can set to specify where
> it is located. If they have the same properties, that means they actually
> want to be located in the same space. But the HTML viewer will position
> them differently because it does not support overlay.
> <Height></Height>
> <Width></Width>
> <Top></Top>
> <Left></Left>

Report History in SQL Reporting Service

Hi,

I am using SQL Server 2005 Reporting service. I am working on a report. I have made several subscriptions for it. Report runs according to subscription. SQL Server Reporting service also offers functionality to save report histories. Now how can I configure it so that whenever report runs according to its subscription, a history should be automatically saved?

If in case it is not possible by some automatic process then is there any way to set multiple schedules for history of the single report like multiple subscriptions can be set for single report.

Waiting for your response. Thanks in advance.

Regards,
Sulman.

Under the History Properties of the report, you need to select the option to:
Store all report execution snapshots in history.

There are also other options to indicate how many snapshots you want to keep, as well as creating snapshots on a regular schedule.|||Thanx, J Quick

Yes there is an option in Hisotry properties "Store all report execution snapshots in history". But let me clear how it works.

On the Execution property page there are two option.
1. "Render this report with the most recent data"
This option means that whenever the report will be executed, it will get fresh data from database by making query on it.
2. "Render this report from an execution snapshot"
This option means that an execution snapshot of report will be saved either once when the Apply button is pressed or it will keep on updating depending upon schedule. But at one time there will be only one execution snapsho. And whenever the report will be executed, it will be rendered from that execution snapshot and not from the fresh data of database.

Now i come to History property mentioned above to "Store all report execution snapshots in history". It will work only when the execution property of report is set to "Render this report from an execution snapshot". And if execution snapshot is scheduled to be updated then each time the execution snapshot will update it will also be saved in history as history snapshot. So for this history property to work, we have to sacrifice the updated and fresh data. But in my case, i have to get fresh data every time and also i want to save the history of that executed report. Try to think on this line.

Anyhow i appreciate your effort. Thanx again.

Sulman.
|||

>> "It will work only when the execution property of report is set to "Render this report from an execution snapshot".

I don't think the statement above is correct, but I could be wrong since it has been some time since I tried it.

As I recall, the options to "Render this report with the most recent data" and "Store all report execution snapshots in history" are on different property pages and aren't mutually exclusive.