CR XI posted a work-around/solution for inserting a row title in a cross tab report by creating a separate "fake" group, overlaying it and copying the cross tab to the fake group's section. It also discussed horizontal pages.
How do you repeat the label on subsequent/multiple pages though?See if you find answer here
http://support.businessobjects.com/
Showing posts with label separate. Show all posts
Showing posts with label separate. Show all posts
Saturday, February 25, 2012
Tuesday, February 14, 2012
Cross instance / server joins
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com
Yes, you can via linked servers. Be prepared for poor performance, however.
Databases that interact with each other frequently should be in the same
instance.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Randy K" <wawork@.hotmail.com> wrote in message
news:431dbdc5.2953031@.msnews.microsoft.com...
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com
Yes, you can via linked servers. Be prepared for poor performance, however.
Databases that interact with each other frequently should be in the same
instance.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Randy K" <wawork@.hotmail.com> wrote in message
news:431dbdc5.2953031@.msnews.microsoft.com...
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com
Labels:
cross,
database,
gis,
implementing,
instance,
instances,
joins,
microsoft,
mysql,
non-gis,
oracle,
possibleto,
production,
separate,
server,
sql,
standardedition
Cross instance / server joins
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.comYes, you can via linked servers. Be prepared for poor performance, however.
Databases that interact with each other frequently should be in the same
instance.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Randy K" <wawork@.hotmail.com> wrote in message
news:431dbdc5.2953031@.msnews.microsoft.com...
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.comYes, you can via linked servers. Be prepared for poor performance, however.
Databases that interact with each other frequently should be in the same
instance.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Randy K" <wawork@.hotmail.com> wrote in message
news:431dbdc5.2953031@.msnews.microsoft.com...
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com
Labels:
cross,
database,
gis,
implementing,
instance,
instances,
joins,
microsoft,
mysql,
non-gis,
oracle,
possibleto,
production,
separate,
server,
sql,
standardedition
Cross instance / server joins
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.comYes, you can via linked servers. Be prepared for poor performance, however.
Databases that interact with each other frequently should be in the same
instance.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Randy K" <wawork@.hotmail.com> wrote in message
news:431dbdc5.2953031@.msnews.microsoft.com...
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.comYes, you can via linked servers. Be prepared for poor performance, however.
Databases that interact with each other frequently should be in the same
instance.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Randy K" <wawork@.hotmail.com> wrote in message
news:431dbdc5.2953031@.msnews.microsoft.com...
We are implementing two production instances of SQL Server standard
edition so we can separate GIS data from non-GIS data. Is it possible
to do joins between instances or even servers? If yes can someone
point me to a document on how to set it up?
Thank you,
Randy
wawork@.hotmail.com
Subscribe to:
Posts (Atom)