Page Borders

We're creating a text report (i.e. not tabular, etc.) that will run several
pages. We would like to have a border around each page, including the page
header and page footer. We've set a body border, but that doesn't draw
horizontal lines at the top an bottom of each page.
We've tried putting our controls in a rectange and expanding the rectange to
be encompass a page both vertically and horizontally, but the page header is
excluded from this border (plus we suspect we'll have additional problems if
our individual controls causes a page break). Also, though we have the
rectange control's height set to 9 inches, it shrinks such that it ends
after the last control in the region.
Any suggestions for defining a border on each page, the first page excluded
(it's a cover page)?
We're using MS Reporting Services 2005.
Thanks,
ChrisNot sure if this does exactly what you're looking for, but in addition
to the body border, have you tried putting horizontal lines in the page
header & page footer?
Eva Pierce Monsen|||Thanks for Eva's informative inputs,
Hi Chris.
As Eva has mentioned, you can explicitly customize the SSRS report's header
and footer sections in the VS 2005's report designer. Just right click on
the report designer's empty area and you'll find the "Page Header" and
"Page Footer" option in the context menu, select either one to edit the
template.
#Adding a Page Header and Footer to a Report
http://msdn2.microsoft.com/en-us/library/ms159677.aspx
BTW, as for the body's border setting, based on my local test, it also
works (display both horizental and vertical lines). I simply set the border
width and border style (solid) and the runtime report displays both
horizental and vertical border lines for the report body. I think the
problem you met is possibly specific to report body's size.
Hope this helps.
Regards,
Steven Cheng
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Steven,
The horizonal body borders appear when we first render the report. However,
when we export the report to PDF, the horizontal lines at the top & bottom
of the body do not appear. Also, the border does not encompass the header
and footer, so even if the horizontal lines did appear, it isn't quite what
we're looking for. The prototype I'm working off of is a MS Word document
that has a page border that does encompass the header & footer.
Any other suggestions?
Thanks,
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:NasHAxdjGHA.4528@.TK2MSFTNGXA01.phx.gbl...
> Thanks for Eva's informative inputs,
> Hi Chris.
> As Eva has mentioned, you can explicitly customize the SSRS report's
> header
> and footer sections in the VS 2005's report designer. Just right click on
> the report designer's empty area and you'll find the "Page Header" and
> "Page Footer" option in the context menu, select either one to edit the
> template.
> #Adding a Page Header and Footer to a Report
> http://msdn2.microsoft.com/en-us/library/ms159677.aspx
> BTW, as for the body's border setting, based on my local test, it also
> works (display both horizental and vertical lines). I simply set the
> border
> width and border style (solid) and the runtime report displays both
> horizental and vertical border lines for the report body. I think the
> problem you met is possibly specific to report body's size.
> Hope this helps.
> Regards,
> Steven Cheng
> 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.
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hi Chris,
Thanks for your response.
Yes, the body border solution has its natural limitation since it does not
include the Header and Footer sections. Have you tried Eva's suggestion on
customizing the UI through the Header and Footer template in the report
designer? As I've also mentioned in the previous message, you can right
click on the report designer's empty area and you'll find the "Page Header"
and "Page Footer" option in the context menu, select either one to edit the
template. Thus, you can put some report item(such as Line ) into the header
or footer section to simulate a border line. How do you think of this?
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hey Chris,
How are you doing on this issue, does the further suggestion help you some?
If there is still anything we can help, please feel free to post here.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Page (1:14440325), slot 6 for text, ntext,or image node does not e

Hello,
This is the second time in less than 2 weeks this has happened to my db
server.
Page (1:14440325), slot 6 for text, ntext, or image node does not exist..
I have performed a dbcc checktable and UPDATE STATISTICS ��TBLNAME�� WITH
FULLSCAN after obtaining the table info. from the following
dbcc traceon(3604)
dbcc page(dbname,1, 14440325)
dbcc traceoFF(3604)
Do not know why it is happening��
TIA,
Manoj Kumar
DBCC is of limited use when dealing with BLOB data types. Generally when
you have repeated allocation mismatches, there is an underlying hardware
problem. I would check the system and application event logs for a disk
subsystem fault.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Manoj Kumar" <ManojKumar@.discussions.microsoft.com> wrote in message
news:C1AE4DDE-F52A-4151-A634-01BB3F3E3063@.microsoft.com...
> Hello,
> This is the second time in less than 2 weeks this has happened to my db
> server.
>
> Page (1:14440325), slot 6 for text, ntext, or image node does not exist..
> I have performed a dbcc checktable and UPDATE STATISTICS ��TBLNAME�� WITH
> FULLSCAN after obtaining the table info. from the following
> dbcc traceon(3604)
> dbcc page(dbname,1, 14440325)
> dbcc traceoFF(3604)
> Do not know why it is happening��
>
> TIA,
> --
> Manoj Kumar
|||Thanks Geoff.
I do not see any issues in the evt log which are related with physical disk
subsystem or RAM although the dbcc page(DBName,1, 19440325,2) does indicate a
data corruption!!
Manoj Kumar
"Geoff N. Hiten" wrote:

> DBCC is of limited use when dealing with BLOB data types. Generally when
> you have repeated allocation mismatches, there is an underlying hardware
> problem. I would check the system and application event logs for a disk
> subsystem fault.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Manoj Kumar" <ManojKumar@.discussions.microsoft.com> wrote in message
> news:C1AE4DDE-F52A-4151-A634-01BB3F3E3063@.microsoft.com...
>

Package Validation Error

I have a package which takes a text file and imports data into a SQL table. It returns the Package Validation Error:

Error at Data Flow Task [SQL Server Destination [1430]]: Failure inserting into the read-only column "ZipCode".

The column ZipCode in the sql table is a varchar(50) column. I do not understand why it thinks the column is a read only column; if someone could shed some light on this I would greatly appreciate it.

Thanks!

GN

Take a closer look at the table, perhaps it is a calculated column. What is the CREATE TABLE statement for that table?|||

It's not a calculated column. It is just a standard varchar column. The create table script generated by SQL is:

CREATETABLE [dbo].[ZipToState](

[ZipCode] [varchar](50)COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL,

[StateAbbr] [varchar](2)COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL,

[City] [varchar](50)COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL,

[PreferredCityName] [varchar](50)COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL,

[ID] [int] IDENTITY(1,1)NOTNULL

)ON [PRIMARY]

Actually I'm starting to think that it may actually be a permissions issue.

Thanks!

GN

|||

Okay I've confirmed that it is a permission error.

When I use my login, which has sysadmin privleges, for the database connection there is no problem inserting into the table fields. When I use another login that does not have sysadmin privleges then the package errors out stating the field is read-only. I've the login the bulkadmin server role but I get the same error. I've also given the login the explicit server permission Administer bulk operations but I keep getting the same error. Additionally the login has insert, delete, and select permissions for the table. So does anyone know what permissions are needed for the login to be able to perform the bulk insert via the package?

Thanks!

Package Validation Error

I have a package which takes a text file and imports data into a SQL table. It returns the Package Validation Error:

Error at Data Flow Task [SQL Server Destination [1430]]: Failure inserting into the read-only column "ZipCode".

The column ZipCode in the sql table is a varchar(50) column. I do not understand why it thinks the column is a read only column; if someone could shed some light on this I would greatly appreciate it.

Thanks!

GN

Take a closer look at the table, perhaps it is a calculated column. What is the CREATE TABLE statement for that table?|||

It's not a calculated column. It is just a standard varchar column. The create table script generated by SQL is:

CREATE TABLE [dbo].[ZipToState](

[ZipCode] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[StateAbbr] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[City] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[PreferredCityName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[ID] [int] IDENTITY(1,1) NOT NULL

) ON [PRIMARY]

Actually I'm starting to think that it may actually be a permissions issue.

Thanks!

GN

|||

Okay I've confirmed that it is a permission error.

When I use my login, which has sysadmin privleges, for the database connection there is no problem inserting into the table fields. When I use another login that does not have sysadmin privleges then the package errors out stating the field is read-only. I've the login the bulkadmin server role but I get the same error. I've also given the login the explicit server permission Administer bulk operations but I keep getting the same error. Additionally the login has insert, delete, and select permissions for the table. So does anyone know what permissions are needed for the login to be able to perform the bulk insert via the package?

Thanks!

Package is getting Parent variables too late?...

Hi,

I am sending variables from package to package by configuration parent packages in each package...
I usually set logging to text files in a certain path that should be received from the parent variable... the strange thing is that if i let the variable in the child package with an incorrect path, my package just through an error even if i am passing the variable from the parent with a correct value...

So... my question is... does my package starts execution without any synch over the parent packages? When are they set? How can i be sure to start my logging with the right parent variable settings?

You can try for example to create a package... add a new variable like "A" and "B" set its value to a default string like "I DONT WANT THIS", add an Execute SQL Task that will record the values of "A" variable to a temporary table...

Then use dtexecui.exe to execute the package and set variable "A" to "THIS IS WHAT I NEED" you will see that in the table will appear one record with the "I DONT WANT THIS" value...

I can't understand this...

Also... if i have 100 variables configured to get values from the parent... is the execution synch or asynch?

Best Regards,

Parent variable configuration is applied to child package at runtime after all other package configuration types are applied and loggers initialized. This is a design decision we have made. To workaround this, you have to use other form of package configuration like XML, SQL Server, etc.|||

So, tell me... even if thats the case... why my parent variables are not set when a certain Execute SQL Task gets actually executed, inserting incorrect values into the table? This is not a very good procedure... How can we make sure to be using the right values in the child package, based on the parent values?

Regards,

|||This should have work. Did you see any error/warning messages about package failed to apply any parent variable configuration?|||

Nop, no errors and no warnings... This is defenitly odd..

Regards

|||

I have had problems with this as well...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2045623&SiteID=1

Package is getting Parent variables too late?...

Hi,

I am sending variables from package to package by configuration parent packages in each package...
I usually set logging to text files in a certain path that should be received from the parent variable... the strange thing is that if i let the variable in the child package with an incorrect path, my package just through an error even if i am passing the variable from the parent with a correct value...

So... my question is... does my package starts execution without any synch over the parent packages? When are they set? How can i be sure to start my logging with the right parent variable settings?

You can try for example to create a package... add a new variable like "A" and "B" set its value to a default string like "I DONT WANT THIS", add an Execute SQL Task that will record the values of "A" variable to a temporary table...

Then use dtexecui.exe to execute the package and set variable "A" to "THIS IS WHAT I NEED" you will see that in the table will appear one record with the "I DONT WANT THIS" value...

I can't understand this...

Also... if i have 100 variables configured to get values from the parent... is the execution synch or asynch?

Best Regards,

Parent variable configuration is applied to child package at runtime after all other package configuration types are applied and loggers initialized. This is a design decision we have made. To workaround this, you have to use other form of package configuration like XML, SQL Server, etc.|||

So, tell me... even if thats the case... why my parent variables are not set when a certain Execute SQL Task gets actually executed, inserting incorrect values into the table? This is not a very good procedure... How can we make sure to be using the right values in the child package, based on the parent values?

Regards,

|||This should have work. Did you see any error/warning messages about package failed to apply any parent variable configuration?|||

Nop, no errors and no warnings... This is defenitly odd..

Regards

|||

I have had problems with this as well...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2045623&SiteID=1

sql

Package Fail connections on moving to server

I am working with the ssis packages.I am working in the development enviroment.Once i place them on the server all my connection to text files fails.I dont want to sit and Keep changing with respect to server again and again.

What is the best way to set connection like for example:in my development it can be on e:\data folder

But on server F:\Data

With me changing again and again, can this be set within the package in the development environment.

Please le me know.

Use a package configuration to populate a variable with the location of the files. Then use an expression on the connection manager to combine the file location variable with the hard-coded filenames.
|||

Would you please explain in little more details

Thanks in advance

|||If you aren't familiar with Package Configurations, you should read the topic in Books Online. You can use them to set the connection string on your flat file connection managers, as Jay suggests.

Overwriting text control

Hello,
Is it possible to overwrite a text control in reporting services, so
that I can add two additional properties to it? If possible, do you
have any links/point to resources?
Thanks
/Peterdo you talk about a parameter related textbox?
yes you can... if you develop your own report access interface or if you use
the reportviewer control.
directly in reportserver, you can't
from where you want to add properties in the textbox?
do you want to open a report with some parameters predefined and send in the
URL?
"Peter" <ptrlsn@.gmail.com> wrote in message
news:1178650584.307210.221870@.p77g2000hsh.googlegroups.com...
> Hello,
> Is it possible to overwrite a text control in reporting services, so
> that I can add two additional properties to it? If possible, do you
> have any links/point to resources?
>
> Thanks
> /Peter
>|||On 9 Maj, 04:44, "Jeje" <willg...@.hotmail.com> wrote:
> do you talk about a parameter related textbox?
> yes you can... if you develop your own report access interface or if you use
> the reportviewer control.
> directly in reportserver, you can't
> from where you want to add properties in the textbox?
> do you want to open a report with some parameters predefined and send in the
> URL?
Thanks for the reply
The text in the text box should be retrieved from an external
application based on a property-value that it will pass to said
external application. It will connect to the external app through a
COM connector.
Is this possible programmatically? For example by overwriting the text
control and give it one or two extra properties?
/Peter

Overlay of textboxes are not rendering properly

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?

I do not believe that you can overlap two textboxes. One will push the next one down to the next line. Can't you make one text box only long enough to allow the text that you need, then Format that text box ittself to align Format-Center in Form-Horizonally. Create the second text box, only as large as you need to hold that text that you are displaying. Then put that text box all the way to the right of your page and align the text in it to right.

|||Yes, that sounds like that would work, but how do you format-center in the form-horizonally?|||Create the first text box and make it only large enough to display the text that you need it to display. Click on the text box itsself to select it, go up to the menu bar and click format, slide down to center in form, select horizontally. This will center that text box in the middle of your page. Then you could actually choose text align in your properties and middle align the text within the text box itsself if you needed to do that. Hope this helps.|||

Kim,

Thanks for trying, but that won't work for me because of a couple reasons: 1) The text is dynamic, so I have no idea on how wide to make my textbox. 2) Even if my text is static and I shorten them up and center the one text box, they still overlap.