Any way to insert page breaks between tables?

I have about 5 tables on a report.
Is there a way to insert a break between the tables to prevent tables
from being chopped on a page break?
Thank you!Pull up table properties dialog and check "insert page break after this
table" checkbox and also "fit this table on one page if possible" checkbox.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"The Whistler" <sharris@.SLeasynews.com> wrote in message
news:bg48i09pocfef9h7ot6rmklf02uas8dl49@.4ax.com...
> I have about 5 tables on a report.
> Is there a way to insert a break between the tables to prevent tables
> from being chopped on a page break?
> Thank you!
>sql

Any Timeout setting in ConnectionString of web.config

Hi:

I have some query that takes quite a long time to process in the sql server and every time the page seems to time out.

I wondor is there any Timeout setting that I can defined in the database ConnectionString in web.config file so that I can extend the "wait" time?

Many thanks!

I believe there is:

"integrated security=SSPI;SERVER=YOUR_SERVER;DATABASE=YOUR_DB_NAME;Connect Timeout=45;";

|||

Jason,

I recently had a time out issue with an app after some servers where moved to a centralized location. In my case, the use of the sql server name caused my app to time out as apparently the newly located web server wasn't able to resolve the sql server name in the web.config file fast enough against the WINS server. The solution was to use our sql server's IP address in web.congif file instead of it's name. Then the app ran just fine.

Time outs can definitely be network related. Need to look at that as well as any app configuring.

|||

Unfortunately not Jason. The timeout in the connection string only controls the timeout of the connection (How long the connection will wait before giving up), normally it's irrelevant as you'll get a (fairly) quick negative response.

That said, in your pages where the default 30 second command timeout is too short, in your SqlDataSource_Selecting/Inserting events, the e parameter will have a reference to the actualy SqlCommand object that is about to be used. Set it's timeout. Off the top of my head, I believe it is like:

e.SelectCommand.Timeout=90

That is assuming that you are having the issue with a SqlDataSource. SqlCommand objects have their own timeout parameter that you can set if that is what you are using and having an issue with.

|||

Actually, e.Command.CommandTimeout=90

any good links on database design

I dont want to go over thru a 100 page book on the subject.
Id like a quick introductory course on database design with examples and
terminology that i could read thats possibly less than 20 pages.
Is there such a link ?
Database Design: http://www.kudzuworld.com/articles/DBDesign/
SQL:
http://www.dbbm.fiocruz.br/class/Lec...an/sqltut.html
|||On Sun, 17 Sep 2006 14:33:12 -0700, Hassan wrote:

>I dont want to go over thru a 100 page book on the subject.
>Id like a quick introductory course on database design with examples and
>terminology that i could read thats possibly less than 20 pages.
>Is there such a link ?
>
Hi Hassan,
Some googling brought me these twoo VERY short introductions on database
design:
http://www.datamodel.org/NormalizationRules.html
http://www.databasedesign-resource.c...mal-forms.html
However, p-l-e-a-s-e do not make the mistake to think that it's even
possible to become an expert in this subject by reading these pages or
any other "less than 20 pages" publication. In such a short span, only
an introduction or a quick, basic overview is possible. The reason that
most good books on DB design are welll over 100 pages is becuase that
amount of space is NEEDED to cover the subject matter.
Hugo Kornelis, SQL Server MVP
|||Database Modelling in UML
http://www.methodsandtools.com/archive/archive.php?id=9

any good links on database design

I dont want to go over thru a 100 page book on the subject.
Id like a quick introductory course on database design with examples and
terminology that i could read thats possibly less than 20 pages.
Is there such a link ?Database Design: http://www.kudzuworld.com/articles/DBDesign/
SQL:
http://www.dbbm.fiocruz.br/class/Le...man/sqltut.html|||On Sun, 17 Sep 2006 14:33:12 -0700, Hassan wrote:

>I dont want to go over thru a 100 page book on the subject.
>Id like a quick introductory course on database design with examples and
>terminology that i could read thats possibly less than 20 pages.
>Is there such a link ?
>
Hi Hassan,
Some googling brought me these twoo VERY short introductions on database
design:
http://www.datamodel.org/NormalizationRules.html
http://www.databasedesign-resource...rmal-forms.html
However, p-l-e-a-s-e do not make the mistake to think that it's even
possible to become an expert in this subject by reading these pages or
any other "less than 20 pages" publication. In such a short span, only
an introduction or a quick, basic overview is possible. The reason that
most good books on DB design are welll over 100 pages is becuase that
amount of space is NEEDED to cover the subject matter.
Hugo Kornelis, SQL Server MVP|||Database Modelling in UML
http://www.methodsandtools.com/archive/archive.php?id=9

any good links on database design

I dont want to go over thru a 100 page book on the subject.
Id like a quick introductory course on database design with examples and
terminology that i could read thats possibly less than 20 pages.
Is there such a link ?Database Design: http://www.kudzuworld.com/articles/DBDesign/
SQL:
http://www.dbbm.fiocruz.br/class/Lecture/d17/sql/jhoffman/sqltut.html|||On Sun, 17 Sep 2006 14:33:12 -0700, Hassan wrote:
>I dont want to go over thru a 100 page book on the subject.
>Id like a quick introductory course on database design with examples and
>terminology that i could read thats possibly less than 20 pages.
>Is there such a link ?
>
Hi Hassan,
Some googling brought me these twoo VERY short introductions on database
design:
http://www.datamodel.org/NormalizationRules.html
http://www.databasedesign-resource.com/normal-forms.html
However, p-l-e-a-s-e do not make the mistake to think that it's even
possible to become an expert in this subject by reading these pages or
any other "less than 20 pages" publication. In such a short span, only
an introduction or a quick, basic overview is possible. The reason that
most good books on DB design are welll over 100 pages is becuase that
amount of space is NEEDED to cover the subject matter.
--
Hugo Kornelis, SQL Server MVP|||Database Modelling in UML
http://www.methodsandtools.com/archive/archive.php?id=9