Repeating a textbox on every page of the report

Hi,
I have something like this in the report body
>> TEXTBOX1 = Fields ! MyFieldName.Value <<
>> the table definition here <<
My problem is that I want to repeat TEXTBOX1 on all the pages if the table
has more than one page,
Right now only appear in the first page.
I tried to set TEXTBOX1.RepeatWith = TABLE1 but it has no effect.
In case it helps the value will not change of value in the report. I'm open
to use any other mean like a parameter, etcyou have to put this information in the table header himself
and setup this table header row to be repeated on each page.
"Ignacio Machin" <Ignacio Machin@.discussions.microsoft.com> wrote in message
news:DA36576E-D1C4-4112-B1C8-C7A0B20631EE@.microsoft.com...
> Hi,
> I have something like this in the report body
> >> TEXTBOX1 = Fields ! MyFieldName.Value <<
>> the table definition here <<
> My problem is that I want to repeat TEXTBOX1 on all the pages if the table
> has more than one page,
> Right now only appear in the first page.
> I tried to set TEXTBOX1.RepeatWith = TABLE1 but it has no effect.
> In case it helps the value will not change of value in the report. I'm
> open
> to use any other mean like a parameter, etc

Reorder the table definition of a SQL 2005 table

Hi,

Is it possible to reorder the table definition in a SQL 2005 table?

Example : i want to put to table definition in alphabetical order.

Thanks in advance

I dont understand. do you mean re-ordering of columns in the table?

|||

When i look at my table, i see that the columns are in this order :

CatId
SubCatId
ImageId
PhoneNumber
Adress
Fax
Cell

But if i want to have this order (alphabetical order) :

Adress
CatId
Cell
Fax
ImageId
PhoneNumber
SubCatId

How can i do that?

|||

The order of columns in a table does not matter. So does order of rows in a table.

You can always write your SELECT statement to return the rows in the column order you want.

SELECT Adress, CatId, Cell, Fax, ImageId, PhoneNumber, SubCatId

FROM YoutYable

|||

Ok but if i want to arrange the order of columns when i open the table with SQL Server Management Studio to see them in alphabetical order...

Can i do that?

|||

The bigger question is why? It is just a GUI thing.

|||

I know that!

It's just that i like my things to be ordered ;-)

So?

|||

Right click on the table --> Design view, you can drag the columns up or down.

|||

Ok Thanks!