Web Archive, In Email, Not Rendering Properly.

Feb 1, 2008

Hi all,

I have a report that gets sent to an email alias every morning at 8:00. The subscription is set to send it as a web archive. The report contains a nice wide table, roughly 12". I have the interactive size on the report set to 0,0 and the report renders fine on the website, but in the email the table is only about 1/3rd the width that it ought to be.

This makes the report look like *** in the email. I have other reports that don't seem to have this problem. I have tried setting the interactive width to 12" and this did not help.

Any ideas on what is going on here?

Thanks,

Allen

View 10 Replies


ADVERTISEMENT

Overlay Of Textboxes Are Not Rendering Properly

Sep 12, 2006

In the page header I have a rectangle that has 2 textboxes on the same line and both are the full length of the page. One textbox has text centered and the other has text right justified. When I render report in Studio or print it, the text appears on the same line and justified like I want, but when the report is rendered when I call the report by URL, the textboxes wrap, like it's taking the width of each textbox in account. Has anyone seen this? Any suggestions on how to overlay text on the same line and the text keep their own individual characteristics?

View 5 Replies View Related

Table Border Lines Not Rendering Properly

Oct 5, 2007



Hello all,



I have been unable to get the black vertical lines in a table to render properly, based on the following....



I'm developing a report that requires the following:



1. One group with the group header section having a BackgroundColor of "LightGrey". (any color other than "Transparent")



2. The details section of the report has a Bottom border with the same color as step #1.



3. The table should have black vertical borderlines that seperate some of the columns. The lines should run the length of the table.



The black lines look like they're being overlapped by both the GroupHeader BackgroundColor and the details section bottom border.



Has anyone been able to implement a similar report successfully?



Thanks for your help!

View 3 Replies View Related

Exporting Email Archive From SQL 2005

Oct 26, 2007

Total SQL newbie here. Hope I'm posting in the correct forum.

I have a Exchange 2003 server that archives all email to a large(55GB) SQL database. I have a situation where I have to export several emails from that database. However at this point I am clueless on how to accomplish this.

View 1 Replies View Related

Subscription Email Rendering Badly

Apr 3, 2007

I have created a very simple report that includes a single table with three cells per row.



When I view the report in Visual Studio, on the Report Server, in any format, it looks fine. However, the version that gets emailed as a subscription looks awful. The width of my table cells is not preserved, so they shrink to be as narrow as possible with all the words wrapping.



Basically, the table gets smooshed so that it's much narrower than it should be. All the words wrap when they shouldn't.



CanShrink is set to False. I have tried CanGrow on both False and True and it didn't make any difference.



Remember, the problem is only with the emailed version of the report.





Any idea if there's a solution for this?



Thanks,

Dan

View 4 Replies View Related

Either Rendering Tiff Images In SRS Report Viewer Or Converting Tiff To Jpg Or Gif And Then Rendering

Jun 19, 2007

First of all, this is not in reference to using SRS (SQL Reporting Services) to render a report and then use one of the extensions to render the complete report as a pdf, tiff, excel etc. We have an opportunity to render a list of claims and then embed the supporting docs for each of the claims within the report. We don't have an issue referencing jpg and gif images via URLs and then rendering them within the report after the grid information. We do have an issue rendering tiff images within the report.



You can insert an image object into SRS at design time and have it render and you can convert a complete report to a tiff image but I cannot find a way to be able to render a tiff image when running the report. All you get is the red "x".



My question is has anyone encountered the same issue and, if so, what did you do to resolve the issue?



Thank you,



J Z

View 3 Replies View Related

Reporting Services :: Data Driven Email Subscription With Different Email Per Report Page

Jul 6, 2015

I have a report that gets sends out through a subscription and sometimes the report has multiple pages and all those pages appear within one email.Is it possible to set the subscription in such a way that an email is sent per page when the subscription executes.

View 2 Replies View Related

Dbmail Doesn't Rely On IIS SMTP, How To Set Bounced Email Redirect Email Etc.? Thanks

May 4, 2007

Under IIS SMTP I can set bounced email redirect etc. how to do that with dbmail, the idea is I can get the list of bounced emails somewhere so I can create a report.



Any idea?



thanks

View 2 Replies View Related

Help Split List Of Email Add Comma For Evry Email

May 12, 2008

need help
split list of email add comma for evry email
i have tabe "tblLogin" and in this table i have field emall
like this

emall
-----------------------------------------
aaa@hhhh.mm
nnn@hhhh.mm
mmm@hhhh.mm

need to do ilke this



Code Snippet
@list_email = (SELECT emall FROM tblLogin)

--------------------------i get this
-----------------------@list_email=aaa@hhhh.mm ; nnn@hhhh.mm ; mmm@hhhh.mm

@recipients = @list_email










Code Snippet

IF EXISTS( SELECT * FROM [db_all].[dbo].[taliB] )



BEGIN

DECLARE @xml NVARCHAR(MAX)DECLARE @body NVARCHAR(MAX)

SET @xml =CAST(( SELECT

FirstName AS 'td','',

LastName AS 'td','' ,

Date_born AS 'td','' ,

Age AS 'td','' ,

BirthdayToday AS 'td','' ,

BirthdayThisWeek AS 'td'

FROM [Bakra_all].[dbo].[taliB] ORDER BY LastName FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX))

SET @body ='<html><H1 align=center>aaaaaaaaaaaaaaaaaaaaaa</H1><body ><table border = 1 align=center dir=rtl>

<tr>

<td>name</td>

<td>fname</td>

<td>date</td>

<td>age</td>

<td>aaaaaaaaa</td>

<td>bbbbbbbbbbbbbbb</td>

</tr>'

SET @body = @body + @xml +'</table></body></html>'

EXEC msdb.dbo.sp_send_dbmail

@recipients =N'rrr@iec.co.il',

@copy_recipients='rrrrr@iec.co.il',

@body = @body,

@body_format ='HTML',

@subject ='ggggggggggggggggggggg',

@profile_name ='ilan'

END

ELSE

print 'no email today'

View 1 Replies View Related

SQL Server Archive

Oct 22, 2002

I am wondering if it is possible to archive records out of a SQL Server Database. The records would then be removed from the original database. This process should be able to be run multiple times (with user interface).

View 2 Replies View Related

Archive Database

Jan 18, 2005

Hi Everybody,
I'm working on a new database of 25GB in size with an expected 25% growth per year and an estimated 1000 TPS. Since I need to retain the old data for atleast 7 years. I would like to know whether I should Archive the database or is there any other means of storing the data, which will be used just to generate reports. Also pl. do let me know the advantages/disadvantages.

Thanks
Kishore

View 1 Replies View Related

Archive Database

Jan 18, 2005

Hi Everybody,
I'm working on a new database of 25GB in size with an expected 25% growth per year and an estimated 1000 TPS. Since I need to retain the old data for atleast 7 years. I would like to know whether I should Archive the database or is there any other means of storing the data, which will be used just to generate reports. Also pl. do let me know the advantages/disadvantages.

Thanks
Kishore

View 4 Replies View Related

Sql Archive Script

Oct 31, 2006

hi,
I need a script to deletes records from my DB older than 30 days.
is their anywhere a script that can help me ?
how should i write ?
using some quesy tool ?
thanks
idan

View 5 Replies View Related

Archive Off Old Data

Mar 25, 2012

Project assigned to me called ''Archive off old data''.As SQL DBA the best way to archive large table is data Partitioning. But one table does not enough in terms of size to do partition and plus table has 32 other tables,view,sps dependencies.The data from that table needs to archive off every week to different database on different server. My question are

1) what is the best way to archive data ?
2) what are steps I need to follow ? Do I need to remove dependencies first and then take out data?.

View 2 Replies View Related

Data Archive

Feb 4, 2004

Hello, everyone:

What does "data archive" mean in SQL Server? Is it same thing as archiving in Oracle?

Thanks.

ZYT

View 1 Replies View Related

Archive And Purge

Dec 13, 2007

A client of mine just asked about Archiving and Purging their data (based on different time constraints). For isntance, certain data would get archived after 3 years over to a different database, others purged all together. My thoughts off the bat are store procedures run on a job schedule.

Any other thoughts or ideas?

View 3 Replies View Related

How To Archive Databases

Nov 2, 2007


Is there a way to archive my databases which are not in use so that i can reduce my disk space and i should be able to use them sometime in future?

let me know

thanks

View 3 Replies View Related

Archive Stored Procedure

Feb 7, 2007

My SP looks like this that originally populates the record set.
 CREATE PROCEDURE dbo.sp_insert_file
@KBID int,@rev  int,@filename nvarchar(50),@moddate datetime,@owner nvarchar(50),@author nvarchar(50)
As
INSERT INTO KBFile                      (KBID, rev, filename, moddate, owner, author)VALUES     (@KBID,@rev,@filename,@moddate,@owner, @author)GO
I need to have a stored procedure that will select a recordset based on KBID(PK) and archive the entire record set to another table. I then need to be able to UPDATE the individual records for this record set in the KBFile table. 
Can someone point me in the right direction?

View 1 Replies View Related

NOT Replicate Data Archive

Jun 5, 2002

Hi Folks,

We have transactional replication setup to replicate data from production across to a reporting server.

We want to ARCHIVE production, but don't want the ARCHIVE duplicated on the reporting server.

Does anyone know of a way that the reporting server can be stopped from replicating these changes, and continue to hold the FULL history of the database?

Cheers,

David

View 2 Replies View Related

NOT Replicate Data Archive

Jun 5, 2002

Hi Folks,

We have transactional replication setup to replicate data from production across to a reporting server.

We want to ARCHIVE production, but don't want the ARCHIVE duplicated on the reporting server.

Does anyone know of a way that the reporting server can be stopped from replicating these changes, and continue to hold the FULL history of the database?

Cheers,

David

View 2 Replies View Related

Archive Of DB Project Plan

Jul 8, 2004

Does anybody have a project plan template I can use for an archive of a datatbase?

View 3 Replies View Related

Replicating To An Archive Database.

Nov 27, 2005

I want to replicate to an archive database. This means that the subscriber will have data that has been removed from the publisher. In my reading, I haven't seen any discussion of this specific scenario.

Here's what I imagine the solution might be:

EXEC sp_addpublication_snapshot
@publication = N'My_Publication',
@frequency_type = 1 -- only create the snapshot once
GO

...

EXEC sp_addarticle
@publication = N'My_Publication',
@article = N'My_Table',
@source_owner = N'dbo',
@source_object = N'My_Table',
@del_cmd = 'NONE',
GO

I set the publication snapshot to only execute once, that would be during the maintenance window when it is initially installed. Then, on the tables that will contain archived data, I specify that deletes aren't replicated.

Here's my concern: aren't there times when you need to resync?

If you could push a new snapshot that dropped the tables on the subscriber and built the thing up from scratch, then things would sync-up just fine. But in this scenario if you drop the subscriber tables then you've just lost your archive.

What's the best way to handle this?

Thanks,

-=michael=-

View 6 Replies View Related

Help_Creating Archive Table

Mar 26, 2004

I have a table called customers that store information about the particular customer. I would like to have a table called Archive so that when I delete a Customer that have not been active for a specific time then the deleted information will be automatically be inserted into the Archive table. Do I need to create the archive table with the same numbers of columns as exactly as the customer table?

I need some basic idea about how this should be implemented.

Any input will be appreciated.
Thanks in advance

View 4 Replies View Related

Turning DB To NON-ARCHIVE Mode

Jan 25, 2008

Hi all,

I am pretty new MS SQL server,
I am actaully working as an SAP BASIS ADMIN and 1 of our client is on MS SQL 2005 with SP1 as the DB and Win 2003 as the server.

I just wanted to know

1) How can we login to the dbase from the command prompt?

2) How to alter the database to NON-ARCHIVE mode and back to ARCHIVE MODE ?

I just wanted to execute few SAP activities for which i dont want the database to generate the archive logs, so i need some assistance.

Hoping to START GOOD here in this forum...
Thanks a million in advance to all

Waiting to hear from all the SQL gurus.

Regards
Hunky

View 5 Replies View Related

How Long Should We Keep Archive Files?

Mar 11, 2008

Hi all,

Is there any regulation or law specify how long to keep archived data? 5 years?
or where can i find those info? Thank you

cheers

View 10 Replies View Related

Archive Data Suggestion

Jul 20, 2005

I have a table contains huge rows of data. Performance issue raised. I amthinking archive some data so that the table will not be that big. The mostconvience way is move it to another table. The problem is: will this solvemy performance problem? or I need to move it to another database to reducethe database size?Regards,TrueNo

View 2 Replies View Related

Archive Stored Procedure

Feb 7, 2007

My SP looks like this that originally populates the record set.

CREATE PROCEDURE dbo.sp_insert_file


@KBID int,
@rev int,
@filename nvarchar(50),
@moddate datetime,
@owner nvarchar(50),
@author nvarchar(50)


As

INSERT INTO KBFile
(KBID, rev, filename, moddate, owner, author)
VALUES (@KBID,@rev,@filename,@moddate,@owner, @author)
GO

I need to have a stored procedure that will select a recordset based on KBID(PK) and archive the entire record set to another table. I then need to be able to UPDATE the individual records for this record set in the KBFile table.

I am trying to create an 'audit' trail while maintaining previous records.

Can someone point me in the right direction?

View 4 Replies View Related

Under 6.5, Best Way To Archive Data Out Of Large Table?

Oct 31, 1999

Hello:

The purchased-application mssql 6.5, sp 4 that I am working on has one large table has 13m illion. It the largest table considering thenextlatgest table is only1.75 million rows.

Thew vnedor has made a change to this largest table in recommending changing a data type -- char to varchar. To make this change easier to do,
I want to "archive" older data not necessary for the current year or current processing to another table.

What is the best way to do this archiving?

Any information you can provide will be greatly appreciated. Thanks.


David Spaisman

View 4 Replies View Related

How To Archive Current Sql Server Logs

Nov 28, 2005

Hi Guru's,

It takes me a long time to view in EM under Mangement/SQL Server Logs/current file. Is there a way I can shorten that file so it won't take so long to view the current file?

Thanks in advance. :eek:

View 2 Replies View Related

Archive Files Using Winzip In Ssis

May 8, 2008

I would like to create a command line tools in SSIS which can be used to archive files.

I have 6 files in a dir and i like to zip them up and them move them to an archive dir.

The 6 files all have the same name but the extension is different.

View 4 Replies View Related

Remove And Archive Records Into Another Table

Mar 5, 2008

Hi,

I currently have one table that lists all projects and tasks within the organisation. One of the table fields is the task status, open or closed. I would like to be able to have a process by which the tasks that are completed are removed from the table and placed into another (archive) table. The same records then being removed from the original table. which then only contains the incomplete tasks. This process could be run at given times during the day or at the point when the status of a task is changed from open to closed, either way each time the process is run it would need to append the rows removed into the archive table. Anyone any ideas on the best way to do this?.

Thanks

View 3 Replies View Related

To Archive Content Of A Table Frequently

May 7, 2007

Hi,

In a project with SQL Servcer 2005 the customer is interested to save (archive) content of a table frequently. They want to have possibility to restore the table content as before. I have suggested to export the table every day to a text file and save the file in Visual source safe. If they need there will be possibility to import the text file later. Now I wonder, is there any other way to do archiving of the table content in SQL Server 2005?

Best regards

View 4 Replies View Related

Remove Page Breaks From Web Archive

Jul 13, 2007

I searched the forum, but I was unable to find an answer to this. What I want to do is remove the page breaks (horizontal lines) from the web archive, but I've been unable to find anything on the internet about it.

Does anyone have any advice/suggestions? Thanks in advance.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved