No COLLATE definition

Hi,
during the initialization of the subscriber from a mergepublication the
COLLATE definitions were not defined in the created tables of the subscribers.
In the snapshot directory I searched the right schema script and I saw that
the collate definition in the create table command was not defined.
Is this a bug or is it a result of a wrong setting of the publisher or
subscriber ?
How can I solve the problem ?
Best regards
Axel Lanser
On the article properties, snapshot tab there is a checkbox for Collation -
by default it is not taken from the publisher to the subscriber.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi,
my snapshot has more then 200 articles. Is there a way to set the collation
for all articles automaticaly.
Best regards
Axel Lanser
"Paul Ibison" wrote:

> On the article properties, snapshot tab there is a checkbox for Collation -
> by default it is not taken from the publisher to the subscriber.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

newbie: Preview in VS.NET looks great, RS has poor alignment

hi folks
(newbie question) why in VS.NET, my preview'd reports look wonderful (from
imported MS Access report definitions), BUT from the web they look awful...
Am I possibility (most likely) missing something? One would believe that the
preview in VS.NET would be the same rendering mechanism from RS?
column heading misalignment, field misalignment, etc.
Respectfully
Robthat's normal, by grouping elements (that should stay together) in a
rectangle you can greatly improve your control of the web-layout
"RobKaratzas" wrote:
> hi folks
> (newbie question) why in VS.NET, my preview'd reports look wonderful (from
> imported MS Access report definitions), BUT from the web they look awful...
> Am I possibility (most likely) missing something? One would believe that the
> preview in VS.NET would be the same rendering mechanism from RS?
> column heading misalignment, field misalignment, etc.
> Respectfully
> Rob|||Hi Antoon,
I've had this problem as well...what do you mean by 'grouping in a
rectangle'?
My way of solving this problem was to create a table that called a SP
that returned exactly one row and then put what I wanted into the
table. It worked, but I figured there must be a better way...
Peter|||If you want to keep report-elements together (textboxes, rectangles, lines,
immages,...). You draw a (transparent) rectangle first and then draw (ore
move) alle your elements in this rectangle.
The rectangle functions as a container (you move alle the elements by moving
the rectangle. And the elements will not "rearange themselfs" if they are
closly contained
"Peter Nolan" wrote:
> Hi Antoon,
> I've had this problem as well...what do you mean by 'grouping in a
> rectangle'?
> My way of solving this problem was to create a table that called a SP
> that returned exactly one row and then put what I wanted into the
> table. It worked, but I figured there must be a better way...
> Peter
>|||hi
I tried this with just the Page Header (by putting everything in a
rectangle). Can tell I did it right since moving the rectangle moves all of
the texboxes, but this had no effect whatsoever. (Again, the preview in
VS.NET looks wonderful, but the browser 'View Report' is very mangled (with
items getting cut-off, being moved to a new line vs. sized correctly.)
Am I missing something here?
Rob
(I am a newbie, but I use to teach MS Access classes back in 95-97 and was a
cert'd access and developer, so I wouldn't consider myself untrainable.)
"Antoon" wrote:
> If you want to keep report-elements together (textboxes, rectangles, lines,
> immages,...). You draw a (transparent) rectangle first and then draw (ore
> move) alle your elements in this rectangle.
> The rectangle functions as a container (you move alle the elements by moving
> the rectangle. And the elements will not "rearange themselfs" if they are
> closly contained
> "Peter Nolan" wrote:
> > Hi Antoon,
> > I've had this problem as well...what do you mean by 'grouping in a
> > rectangle'?
> >
> > My way of solving this problem was to create a table that called a SP
> > that returned exactly one row and then put what I wanted into the
> > table. It worked, but I figured there must be a better way...
> >
> > Peter
> >
> >|||You might be missing something.
On the menu go to Report > Report Properties and under layout ensure that
the Page width minus left and right margins is >= your report body width.
e.g. Most of my reports are landscape 11" with .5" margins. So when I create
reports I can only stretch the body to 10" or it will give me unexpected
results in the browser or when printed.
HTH.
Cheerios.
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:037C6FCF-0078-4AA2-8C37-AFD0173FCC04@.microsoft.com...
> hi
> I tried this with just the Page Header (by putting everything in a
> rectangle). Can tell I did it right since moving the rectangle moves all
of
> the texboxes, but this had no effect whatsoever. (Again, the preview in
> VS.NET looks wonderful, but the browser 'View Report' is very mangled
(with
> items getting cut-off, being moved to a new line vs. sized correctly.)
> Am I missing something here?
> Rob
> (I am a newbie, but I use to teach MS Access classes back in 95-97 and was
a
> cert'd access and developer, so I wouldn't consider myself untrainable.)
> "Antoon" wrote:
> > If you want to keep report-elements together (textboxes, rectangles,
lines,
> > immages,...). You draw a (transparent) rectangle first and then draw
(ore
> > move) alle your elements in this rectangle.
> > The rectangle functions as a container (you move alle the elements by
moving
> > the rectangle. And the elements will not "rearange themselfs" if they
are
> > closly contained
> >
> > "Peter Nolan" wrote:
> >
> > > Hi Antoon,
> > > I've had this problem as well...what do you mean by 'grouping in a
> > > rectangle'?
> > >
> > > My way of solving this problem was to create a table that called a SP
> > > that returned exactly one row and then put what I wanted into the
> > > table. It worked, but I figured there must be a better way...
> > >
> > > Peter
> > >
> > >|||hi
double-checked what you said and all of my margins as well as width are fine.
(and would be glad to send you screenshots, just to clariy what I'm seeing.
thing that puzzles me is that these are reports that the import has
determined how to best interpret the layout. I'm in the process of migrating
60 of them and will let everyone know if I have any 'breakthroughs')
made no difference (width 10.5, margins 0.0)
but thanks, rob
"Nice_Out" wrote:
> You might be missing something.
> On the menu go to Report > Report Properties and under layout ensure that
> the Page width minus left and right margins is >= your report body width.
> e.g. Most of my reports are landscape 11" with .5" margins. So when I create
> reports I can only stretch the body to 10" or it will give me unexpected
> results in the browser or when printed.
> HTH.
> Cheerios.
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:037C6FCF-0078-4AA2-8C37-AFD0173FCC04@.microsoft.com...
> > hi
> >
> > I tried this with just the Page Header (by putting everything in a
> > rectangle). Can tell I did it right since moving the rectangle moves all
> of
> > the texboxes, but this had no effect whatsoever. (Again, the preview in
> > VS.NET looks wonderful, but the browser 'View Report' is very mangled
> (with
> > items getting cut-off, being moved to a new line vs. sized correctly.)
> >
> > Am I missing something here?
> >
> > Rob
> > (I am a newbie, but I use to teach MS Access classes back in 95-97 and was
> a
> > cert'd access and developer, so I wouldn't consider myself untrainable.)
> >
> > "Antoon" wrote:
> >
> > > If you want to keep report-elements together (textboxes, rectangles,
> lines,
> > > immages,...). You draw a (transparent) rectangle first and then draw
> (ore
> > > move) alle your elements in this rectangle.
> > > The rectangle functions as a container (you move alle the elements by
> moving
> > > the rectangle. And the elements will not "rearange themselfs" if they
> are
> > > closly contained
> > >
> > > "Peter Nolan" wrote:
> > >
> > > > Hi Antoon,
> > > > I've had this problem as well...what do you mean by 'grouping in a
> > > > rectangle'?
> > > >
> > > > My way of solving this problem was to create a table that called a SP
> > > > that returned exactly one row and then put what I wanted into the
> > > > table. It worked, but I figured there must be a better way...
> > > >
> > > > Peter
> > > >
> > > >
>
>|||it actually prints real nice, in terms of layout... (close to how the VS.NET
preview looks).
rob
"RobKaratzas" wrote:
> hi
> double-checked what you said and all of my margins as well as width are fine.
> (and would be glad to send you screenshots, just to clariy what I'm seeing.
> thing that puzzles me is that these are reports that the import has
> determined how to best interpret the layout. I'm in the process of migrating
> 60 of them and will let everyone know if I have any 'breakthroughs')
> made no difference (width 10.5, margins 0.0)
> but thanks, rob
> "Nice_Out" wrote:
> > You might be missing something.
> > On the menu go to Report > Report Properties and under layout ensure that
> > the Page width minus left and right margins is >= your report body width.
> > e.g. Most of my reports are landscape 11" with .5" margins. So when I create
> > reports I can only stretch the body to 10" or it will give me unexpected
> > results in the browser or when printed.
> >
> > HTH.
> > Cheerios.
> >
> > "Rob" <Rob@.discussions.microsoft.com> wrote in message
> > news:037C6FCF-0078-4AA2-8C37-AFD0173FCC04@.microsoft.com...
> > > hi
> > >
> > > I tried this with just the Page Header (by putting everything in a
> > > rectangle). Can tell I did it right since moving the rectangle moves all
> > of
> > > the texboxes, but this had no effect whatsoever. (Again, the preview in
> > > VS.NET looks wonderful, but the browser 'View Report' is very mangled
> > (with
> > > items getting cut-off, being moved to a new line vs. sized correctly.)
> > >
> > > Am I missing something here?
> > >
> > > Rob
> > > (I am a newbie, but I use to teach MS Access classes back in 95-97 and was
> > a
> > > cert'd access and developer, so I wouldn't consider myself untrainable.)
> > >
> > > "Antoon" wrote:
> > >
> > > > If you want to keep report-elements together (textboxes, rectangles,
> > lines,
> > > > immages,...). You draw a (transparent) rectangle first and then draw
> > (ore
> > > > move) alle your elements in this rectangle.
> > > > The rectangle functions as a container (you move alle the elements by
> > moving
> > > > the rectangle. And the elements will not "rearange themselfs" if they
> > are
> > > > closly contained
> > > >
> > > > "Peter Nolan" wrote:
> > > >
> > > > > Hi Antoon,
> > > > > I've had this problem as well...what do you mean by 'grouping in a
> > > > > rectangle'?
> > > > >
> > > > > My way of solving this problem was to create a table that called a SP
> > > > > that returned exactly one row and then put what I wanted into the
> > > > > table. It worked, but I figured there must be a better way...
> > > > >
> > > > > Peter
> > > > >
> > > > >
> >
> >
> >