KDC Problem: February 2012

Friday, February 24, 2012

Keep Table Group on Same Page

I have a report that consists of a table containing invoices grouped by
Customer. I'd like to keep all invoices for any given customer on the same
page, but without needing a page break after each customer (each page can fit
about 12 or so groups on it).
Does anyone know how to do this?
I found a thread dated 5/20/2005 called "Control Page Breaking in Detail
(Keep Together)". I think some of the people on that thread are also trying
to do what I want to do.
I tried the method suggested by Matt Temple at the end of the thread, but
this did not have the desired effect. This method resulted in keeping each
group on the same page BUT meant that only the first invoice for each
customer was displayed.
Any ideas?
Thanks,
RobRight, I had another go at Matt's suggestion (included below for convenience)
from the other thread. I was doing step 7 wrong. I've now redone it and am
getting closer, but still without the effect I need.
The instructions ensure that all the detail elements within a group are kept
on the same page, but sometimes the group header is shown at the bottom of
the previous page instead of with the detail elements.
My next step was to edit the Grouping and Sorting Properties of the group to
add a check next to "Repeat group header". This ensures that when a block of
detail elements are kept together by taking them to the next page, the group
header is repeated with them. However, I'm still left with a copy of the
group header at the bottom of the previous page.
I can't be the only person who's wanted to do this. Can anyone help?
______________________________________
Instructions to keep group elements together:
1) Right-click border of table containing the elements
2) Select "Properties"
3) Go to the "General" tab, if not already displayed
4) Place a check in the "Fit table on one page if possible" checkbox
5) Go to the "Groups" tab
6) Click on the "Details grouping..." button
7) Select the elements which comprise of the detail group you want to keep
together
8) Click "OK"
9) Click "OK" again
10) Test the modified design
"Rob Nelder" wrote:
> I have a report that consists of a table containing invoices grouped by
> Customer. I'd like to keep all invoices for any given customer on the same
> page, but without needing a page break after each customer (each page can fit
> about 12 or so groups on it).
> Does anyone know how to do this?
> I found a thread dated 5/20/2005 called "Control Page Breaking in Detail
> (Keep Together)". I think some of the people on that thread are also trying
> to do what I want to do.
> I tried the method suggested by Matt Temple at the end of the thread, but
> this did not have the desired effect. This method resulted in keeping each
> group on the same page BUT meant that only the first invoice for each
> customer was displayed.
> Any ideas?
> Thanks,
> Rob

Keep table as it is..

Hi
I have a publication with about 30 tables. For one of the tables
'tabA', I only want to publish 4 of the 6 colums, so i uncheck them in
"publish columns". None of them are keys of any kind.
Each subscriber does have a complete 'tabA' at startup and i only want
to transfer changes made to the first 4 coulmns after it is added as a
subscriber.
Now, the prolem is
1. When the snapshot is created i get a end of file reached,
terminator missing of field data incomplete for the .bcp.
2. I get an error since it tried to copy over records that are already
there.
So, is there a way to NOT copy any data for this table during the
snapshot, and only send changes for the first 4 columns in the future
after the snapshot?
You may want to post this in the replication newsgroup. Hilary should be
able to answer that one real quick.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<jostein.solstad@.gmail.com> wrote in message
news:1185459329.169314.161210@.r34g2000hsd.googlegr oups.com...
Hi
I have a publication with about 30 tables. For one of the tables
'tabA', I only want to publish 4 of the 6 colums, so i uncheck them in
"publish columns". None of them are keys of any kind.
Each subscriber does have a complete 'tabA' at startup and i only want
to transfer changes made to the first 4 coulmns after it is added as a
subscriber.
Now, the prolem is
1. When the snapshot is created i get a end of file reached,
terminator missing of field data incomplete for the .bcp.
2. I get an error since it tried to copy over records that are already
there.
So, is there a way to NOT copy any data for this table during the
snapshot, and only send changes for the first 4 columns in the future
after the snapshot?

Keep table as it is..

Hi
I have a publication with about 30 tables. For one of the tables
'tabA', I only want to publish 4 of the 6 colums, so i uncheck them in
"publish columns". None of them are keys of any kind.
Each subscriber does have a complete 'tabA' at startup and i only want
to transfer changes made to the first 4 coulmns after it is added as a
subscriber.
Now, the prolem is
1. When the snapshot is created i get a end of file reached,
terminator missing of field data incomplete for the .bcp.
2. I get an error since it tried to copy over records that are already
there.
So, is there a way to NOT copy any data for this table during the
snapshot, and only send changes for the first 4 columns in the future
after the snapshot?You may want to post this in the replication newsgroup. Hilary should be
able to answer that one real quick.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<jostein.solstad@.gmail.com> wrote in message
news:1185459329.169314.161210@.r34g2000hsd.googlegroups.com...
Hi
I have a publication with about 30 tables. For one of the tables
'tabA', I only want to publish 4 of the 6 colums, so i uncheck them in
"publish columns". None of them are keys of any kind.
Each subscriber does have a complete 'tabA' at startup and i only want
to transfer changes made to the first 4 coulmns after it is added as a
subscriber.
Now, the prolem is
1. When the snapshot is created i get a end of file reached,
terminator missing of field data incomplete for the .bcp.
2. I get an error since it tried to copy over records that are already
there.
So, is there a way to NOT copy any data for this table during the
snapshot, and only send changes for the first 4 columns in the future
after the snapshot?

Keep table as it is..

Hi
I have a publication with about 30 tables. For one of the tables
'tabA', I only want to publish 4 of the 6 colums, so i uncheck them in
"publish columns". None of them are keys of any kind.
Each subscriber does have a complete 'tabA' at startup and i only want
to transfer changes made to the first 4 coulmns after it is added as a
subscriber.
Now, the prolem is
1. When the snapshot is created i get a end of file reached,
terminator missing of field data incomplete for the .bcp.
2. I get an error since it tried to copy over records that are already
there.
So, is there a way to NOT copy any data for this table during the
snapshot, and only send changes for the first 4 columns in the future
after the snapshot?You may want to post this in the replication newsgroup. Hilary should be
able to answer that one real quick.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<jostein.solstad@.gmail.com> wrote in message
news:1185459329.169314.161210@.r34g2000hsd.googlegroups.com...
Hi
I have a publication with about 30 tables. For one of the tables
'tabA', I only want to publish 4 of the 6 colums, so i uncheck them in
"publish columns". None of them are keys of any kind.
Each subscriber does have a complete 'tabA' at startup and i only want
to transfer changes made to the first 4 coulmns after it is added as a
subscriber.
Now, the prolem is
1. When the snapshot is created i get a end of file reached,
terminator missing of field data incomplete for the .bcp.
2. I get an error since it tried to copy over records that are already
there.
So, is there a way to NOT copy any data for this table during the
snapshot, and only send changes for the first 4 columns in the future
after the snapshot?

keep SQL Express while testing SQL Server 2005 trial?

Can I keep using my SQL Server Express on the same system while installing
SQL Server 2005 trial?
Should be able to becuase the new install will be a new instance. I belive
you can install it as default instance or named instance. Haven't had need
to have both on same computer yet. But don't expect issues. Thanks!
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Dabbler" wrote:

> Can I keep using my SQL Server Express on the same system while installing
> SQL Server 2005 trial?
|||On Jul 5, 1:28 pm, Dabbler <Dabb...@.discussions.microsoft.com> wrote:
> Can I keep using my SQL Server Express on the same system while installing
> SQL Server 2005 trial?
You won't have any problems with this, as I believe the default
installation of SQL Express is utilizing the <computername>/SQLEXPRESS
instance name. When you install SQL 2005, you can choose to install
it with the default instance <computername> or utilizing a named
instance <computername>/<namedinstance>. You should not run into any
issues.
Aaron

keep SQL Express while testing SQL Server 2005 trial?

Can I keep using my SQL Server Express on the same system while installing
SQL Server 2005 trial?Should be able to becuase the new install will be a new instance. I belive
you can install it as default instance or named instance. Haven't had need
to have both on same computer yet. But don't expect issues. Thanks!
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Dabbler" wrote:

> Can I keep using my SQL Server Express on the same system while installing
> SQL Server 2005 trial?|||On Jul 5, 1:28 pm, Dabbler <Dabb...@.discussions.microsoft.com> wrote:
> Can I keep using my SQL Server Express on the same system while installing
> SQL Server 2005 trial?
You won't have any problems with this, as I believe the default
installation of SQL Express is utilizing the <computername>/SQLEXPRESS
instance name. When you install SQL 2005, you can choose to install
it with the default instance <computername> or utilizing a named
instance <computername>/<namedinstance>. You should not run into any
issues.
Aaron

keep SQL Express while testing SQL Server 2005 trial?

Can I keep using my SQL Server Express on the same system while installing
SQL Server 2005 trial?Should be able to becuase the new install will be a new instance. I belive
you can install it as default instance or named instance. Haven't had need
to have both on same computer yet. But don't expect issues. Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Dabbler" wrote:
> Can I keep using my SQL Server Express on the same system while installing
> SQL Server 2005 trial?|||On Jul 5, 1:28 pm, Dabbler <Dabb...@.discussions.microsoft.com> wrote:
> Can I keep using my SQL Server Express on the same system while installing
> SQL Server 2005 trial?
You won't have any problems with this, as I believe the default
installation of SQL Express is utilizing the <computername>/SQLEXPRESS
instance name. When you install SQL 2005, you can choose to install
it with the default instance <computername> or utilizing a named
instance <computername>/<namedinstance>. You should not run into any
issues.
Aaron

Keep speed

Hi...

I'm inserting and deleting about 30 000 records into 2 tables each day - import them from a text file using DTS.

The users add about 1000 records a day using Access and Windows .NET frontends...

Which TSQL commands should I run frequently to keep the database up to speed ?

I'm doing the following ... do you know of anything else?

Backup LOG MyDataBase WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE (MyDataBase , 40)
GO

Backup LOG tempdb WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE (tempdb, 70)
GO

THANKS!!!!!!!!!!!!!!!

Dave

There are a lot of different things you can do to keep the speed of your database up, such as:

Set the database to Simple Recovery and enable Auto Shrink, this will perform the same function you are doing with your DBCC Shrink commands. There are quite a few debates as to whether or not Simple Recovery and Auto Shrink impact performance but I have not seen any negative impacts myself.

Partition your database across multiple physical drives, this can dramatically improve performance

If you are using SAN disk, properly align the sector boundaries of your disk, here is a rather large document on the subject but it's a good one

http://www.hertenberger.co.za/resources/diskpar.pdf#search='how%20to%20use%20diskpar'

Delete any data older than "x" days from your tables, which it sounds like you may already be doing

Dedicate "x" amount of RAM to your instance

Dedicate "x" number of CPU's to your instance

The list goes on but that is a few examples.

|||Simple recovery model will not impact performance. However, the autoshrink certainly will. If the autoshrink kicks off when you are trying to process other queries, it will definitely slow everything down.|||

Hi Dave,

What comes to mind immediatly is that there will be a potentially large amount of fragmentation of tables/indexes in your db. This is because: a) you are performing a large amount of deletes and inserts often and b) shrinkdatabase introduces logical fragmentation.

So, I would recommend you run dbcc showcontig on your main tables, then perform rebuilds as needed with either DBCC DBREINDEX or DBCC INDEXDEFRAG. As an aside, if there has been a large amount of fragmentation on several tables, make sure your statistics are up to date, and run sp_recompile on the tables in question so that any stored procs you have can make use of the new stats immediatly.

Cheers
Rob

|||

Hi, Lesego.

If you're going to be doing queries agianst these tables that you're adding and removing data from, it's probably a good idea to update the statistics on the table. UPDATE STATISTICS is the command to use, and you'll want to run it against any statistics the table has -- you can find those most easily by exploring in the object browser in managemnet studio, but you'll have one for each index on the table, plus any that you've created yourself, plus any that the server has created automatically.

UPDATE STATISTICS might not be too important if you're selecting data directly from the table. But it will be very important if you are using the table that's the target of your insert/delete batch job in any JOINs with other tables. The query optimizer makes many decisions about how to best execute a statement based on information it can gather from the statistics on the table.

Hope that helps, and do let us know if you have more follow-up questions.

.B ekiM

Keep sp in cache

hi, I wonder if anyone knows if it is possible to specify that a specific
stored procedure always should stay in cache or for example set that i
specific sp has "high cache priority"?
Regards
JuaninhoNo. You can be sneaky about it though and have a default parameter that is
used as a flag to return immediately. Then you can set up a sql agent job
to fire every so often (minutes/hours') with that flag set, which will keep
the plan in cache. This could lead to poor query plans if the OTHER
parameters for the sproc (if any) are not typical.
TheSQLGuru
President
Indicium Resources, Inc.
"Juaninho" <Juaninho@.discussions.microsoft.com> wrote in message
news:29BC33AD-8DC2-462A-89F0-B984366895B7@.microsoft.com...
> hi, I wonder if anyone knows if it is possible to specify that a specific
> stored procedure always should stay in cache or for example set that i
> specific sp has "high cache priority"?
> Regards
> Juaninho|||On Apr 24, 2:00 am, Juaninho <Juani...@.discussions.microsoft.com>
wrote:
> hi, I wonder if anyone knows if it is possible to specify that a specific
> stored procedure always should stay in cache or for example set that i
> specific sp has "high cache priority"?
> Regards
> Juaninho
If you've not read the BOL yet, here is what it says. After attending
Kalen Delaney's presentation last week I was reading about it more. I
have not seen any way or technique to keep the stored proc in the
cache. What I understand is even the execution plan is eligible for
deallocation sql server does not deallocate it till the resources is
needed. But make sure you have a lot of memory and that sql server
can use all of it.
After an execution plan is generated, it stays in the procedure cache.
SQL Server 2000 ages old, unused plans out of the cache only when
space is needed. Each query plan and execution context has an
associated cost factor that indicates how expensive the structure is
to compile. These data structures also have an age field. Each time
the object is referenced by a connection, the age field is incremented
by the compilation cost factor. For example, if a query plan has a
cost factor of 8 and is referenced twice, its age becomes 16. The
lazywriter process periodically scans the list of objects in the
procedure cache. The lazywriter decrements the age field of each
object by 1 on each scan. The age of our sample query plan is
decremented to 0 after 16 scans of the procedure cache, unless another
user references the plan. The lazywriter process deallocates an object
if these conditions are met:
The memory manager requires memory and all available memory is
currently in use.
The age field for the object is 0.
The object is not currently referenced by a connection.
Because the age field is incremented each time an object is
referenced, frequently referenced objects do not have their age fields
decremented to 0 and are not aged from the cache. Objects infrequently
referenced are soon eligible for deallocation, but are not actually
deallocated unless memory is required for other objects.
Good day,
Bulent|||On Apr 24, 5:41 pm, "TheSQLGuru" <kgbo...@.earthlink.net> wrote:
> No. You can be sneaky about it though and have a default parameter that i
s
> used as a flag to return immediately. Then you can set up a sql agent job
> to fire every so often (minutes/hours') with that flag set, which will ke
ep
> the plan in cache. This could lead to poor query plans if the OTHER
> parameters for the sproc (if any) are not typical.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Juaninho" <Juani...@.discussions.microsoft.com> wrote in message
> news:29BC33AD-8DC2-462A-89F0-B984366895B7@.microsoft.com...
>
>
>
> - Show quoted text -
If you are using SQL Server 2005 Look at USE PLAN, KEEPFIXED PLAN in
BOL
Regards
Amish Shah
http://shahamishm.tripod.com

Keep section of report the same size

I need to keep a section of a report the same size. I have now a table with a detail and group section. The table header must print on every page and the table footer must print on every page. The detail section can only be 16 rows. When I have more than 16 rows the report page breaks perfectly and puts the remaining rows on the next page along with repeating the header and footer. The problem is when there are fewer than 16 rows the table does not take up the full page and looks horrible. All my displayed data is in the data set. I have looked at padding the dataset with bogus rows that would show up at the end and just not display but would rather take care of this on the report end. Any ideas?

Thanks, Chad

Hve you tried placing the table in a rectangle control and setting it's size? I believe it can grow if it needs to and uses the defined size as it's minimum.

Keep Same Virtual Name

Hello,
We have a 2 node Sql 2000 cluster running on Legato Cluster. We are
planning to move it to MSCS 2 node Active/Passive Cluster. I am trying
to migrate to have less downtime which allows me to backout if any
problems.
Questions:
1. Can we keep same Virtual Server Name when we move to MSCS ...
2. Using DNS Alias is that recommended and is their any performance
issues?
3. Can we Change Virtual IP address of MSCS cluster node to the old IP
that the legato cluster used...
In order:
1) Only if you do an in-place upgrade. No bailout without an uninstall and
a reinstall.
2) No performance issues with DNS alias. DNs is very efficient and client
cached.
3) You can use any IP address on the same subnet as long as it is not
already in use.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<imsajil@.gmail.com> wrote in message
news:1165249946.641878.318150@.f1g2000cwa.googlegro ups.com...
> Hello,
> We have a 2 node Sql 2000 cluster running on Legato Cluster. We are
> planning to move it to MSCS 2 node Active/Passive Cluster. I am trying
> to migrate to have less downtime which allows me to backout if any
> problems.
> Questions:
> 1. Can we keep same Virtual Server Name when we move to MSCS ...
> 2. Using DNS Alias is that recommended and is their any performance
> issues?
> 3. Can we Change Virtual IP address of MSCS cluster node to the old IP
> that the legato cluster used...
>

Keep running out of memory?

There is a server configuration called 'Open Objects' that
you will need to modify.
Run this to determine current count (look for open objects
in results)
USE master
EXEC sp_configure 'show advanced option', '1'
--Here is the message:
Configuration option 'show advanced options' changed from
0 to 1.
Run the RECONFIGURE command to install.
RECONFIGURE
EXEC sp_configure
If you need to increase it, just use this command
USE master
EXEC sp_configure 'OPEN OBJECTS', '#of objects'

>--Original Message--
>Does anyone know how-to fix this error?
>17424 :
>Warning: OPEN OBJECTS parameter may be too low.
>
>.
>The values defaults to 0, which means auto-config. SQL Server will use the m
emory as it needs for open
objects. This error message often indicates that one need more memory in the
machine, quite simply.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"sbauer" <anonymous@.discussions.microsoft.com> wrote in message news:e4c701c411d9$b3bcd950$
a001280a@.phx.gbl...
> There is a server configuration called 'Open Objects' that
> you will need to modify.
> Run this to determine current count (look for open objects
> in results)
> USE master
> EXEC sp_configure 'show advanced option', '1'
> --Here is the message:
> Configuration option 'show advanced options' changed from
> 0 to 1.
> Run the RECONFIGURE command to install.
> RECONFIGURE
> EXEC sp_configure
> If you need to increase it, just use this command
> USE master
> EXEC sp_configure 'OPEN OBJECTS', '#of objects'
>|||I have 4 Gig of memory in this server and a pretty small database (50 meg).
Do you still think it is a memory problem?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23G2vf0dEEHA.3080@.TK2MSFTNGP10.phx.gbl...
> The values defaults to 0, which means auto-config. SQL Server will use the
memory as it needs for open
> objects. This error message often indicates that one need more memory in
the machine, quite simply.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "sbauer" <anonymous@.discussions.microsoft.com> wrote in message
news:e4c701c411d9$b3bcd950$a001280a@.phx.gbl...
>|||What are your settings (sp_configure) for max server memory and open objects
?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dan Marth" <danmarth@.earthlink.net> wrote in message news:uA4ZB5eEEHA.3016@.TK2MSFTNGP11.ph
x.gbl...
> I have 4 Gig of memory in this server and a pretty small database (50 meg)
.
> Do you still think it is a memory problem?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23G2vf0dEEHA.3080@.TK2MSFTNGP10.phx.gbl...
> memory as it needs for open
> the machine, quite simply.
> news:e4c701c411d9$b3bcd950$a001280a@.phx.gbl...
>|||when I ran the USE master EXEC sp_configure 'show advanced option', '1' I
was already set to 1. So I changed it back to '0' and hopefully auto config
should work better. What do you think? Below are those settings you ask
for:
Server Memory
Minimum 4
Maximum: 2147483647
Config_value: 2147483647
Run_value: 2147483647
Open Objects
Minimum 0
Maximum 2147483647
Config_value 1000
Run_value 1000
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23GEyj7eEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> What are your settings (sp_configure) for max server memory and open
objects?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
news:uA4ZB5eEEHA.3016@.TK2MSFTNGP11.phx.gbl...
meg).
in
the
in
>|||Show advanced options does not control auto-config for the other options. It
does only that the option name
implies.
Someone has configured open objects to 1000, way way too low for a productio
n environment. I recommend you set
it back to auto, 0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dan Marth" <danmarth@.earthlink.net> wrote in message news:uMtja6nEEHA.1272@.TK2MSFTNGP12.ph
x.gbl...
> when I ran the USE master EXEC sp_configure 'show advanced option', '1' I
> was already set to 1. So I changed it back to '0' and hopefully auto conf
ig
> should work better. What do you think? Below are those settings you ask
> for:
> Server Memory
> Minimum 4
> Maximum: 2147483647
> Config_value: 2147483647
> Run_value: 2147483647
> Open Objects
> Minimum 0
> Maximum 2147483647
> Config_value 1000
> Run_value 1000
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23GEyj7eEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> objects?
> news:uA4ZB5eEEHA.3016@.TK2MSFTNGP11.phx.gbl...
> meg).
> in
> the
> in
>|||How do you set it back to auto? Is the below values correct for auto?
open objects
Minimum: 0
Maximum: 2147483647
Config_Value: 0
Run_Value: 1000
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eZwjB%23nEEHA.3856@.TK2MSFTNGP12.phx.gbl...
> Show advanced options does not control auto-config for the other options.
It does only that the option name
> implies.
> Someone has configured open objects to 1000, way way too low for a
production environment. I recommend you set
> it back to auto, 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
news:uMtja6nEEHA.1272@.TK2MSFTNGP12.phx.gbl...
I
config
ask
in
(50
wrote
use
memory
>|||All parameters for sp_configure are documented in Books Online. For Open Obj
ects, 0 is auto config. After
setting this, you need to execute RECONFIGURE and for some parameters, you a
lso need to restart SQL Server
(check BOL if this is one of these). It seems you have already set it to 0,
but that value if not in effect
yes (run_value is 1000) so you either need to do RECONFIGURE or restart SQL
Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dan Marth" <danmarth@.earthlink.net> wrote in message news:OTI17xzEEHA.3976@.TK2MSFTNGP12.ph
x.gbl...
> How do you set it back to auto? Is the below values correct for auto?
> open objects
> Minimum: 0
> Maximum: 2147483647
> Config_Value: 0
> Run_Value: 1000
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:eZwjB%23nEEHA.3856@.TK2MSFTNGP12.phx.gbl...
> It does only that the option name
> production environment. I recommend you set
> news:uMtja6nEEHA.1272@.TK2MSFTNGP12.phx.gbl...
> I
> config
> ask
> in
> (50
> wrote
> use
> memory
>|||Thanks for all the help! A reboot fixed it, all is working fine now!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23Lks540EEHA.3344@.tk2msftngp13.phx.gbl...
> All parameters for sp_configure are documented in Books Online. For Open
Objects, 0 is auto config. After
> setting this, you need to execute RECONFIGURE and for some parameters, you
also need to restart SQL Server
> (check BOL if this is one of these). It seems you have already set it to
0, but that value if not in effect
> yes (run_value is 1000) so you either need to do RECONFIGURE or restart
SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
news:OTI17xzEEHA.3976@.TK2MSFTNGP12.phx.gbl...
in
options.
'1'
auto
you
wrote
open
database
<tibor_please.no.email_karaszi@.hotmail.nomail.com>
will
message
>

Keep RS awake.

Any ideas as to how to keep Reporting Services awake? I have tried setting
up a simple report that gets the current time and then created a
subscription that runs ever 5 minutes, but it often still takes time to open
the home page.Here is a response from another poster:
"If you are running Windows 2003 server for your IIS reportserver, then this
is a simple issue - I'll explain what happens:The report service engine,
once it is idle for more than the default 20 minutes, the worker process is
shutdown.This is controlled by IIS.Open up the Internet Information Services
(IIS) Manager
Expand the server node then the application pools.On my IIS machine, I
created an application pool dedicated to the reportserver & reportmanager
virtual webs.
But anyways, for the application pool that the reportserver is pointing to
if you left everything to their defaults will be the DefaultAppPool.
Right click the default app pool and select properties.
There are two things that are checked by default - On the recycling tab
there is a checkbox for recycling worker processes - it is currently set to
1740 minutes (29 hours). Leave it.
The other one is on the performance tab - which is the one you are
interested in changing...
See the "Idle Timeout" section and increase the number of minutes to be 8
hours a typical working day - 8*60 = 480 minutes.
Next, to be sure the "morning person" that runs the first report doesn't get
the delay, set up a schedule for either a dummy or adhoc report to fire off
like at 6am so that the report component worker processes get loaded.
I hope this helps you.
There is no need to have a report fire off every minute to keep things
alive - it is just that the report service was "unloaded" and needed to load
back up.
=-Chris"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shawn" <shawn.camner@.ccci.org> wrote in message
news:e2WCz9ahHHA.392@.TK2MSFTNGP06.phx.gbl...
> Any ideas as to how to keep Reporting Services awake? I have tried setting
> up a simple report that gets the current time and then created a
> subscription that runs ever 5 minutes, but it often still takes time to
> open the home page.
>|||Thanks, I will give it a whirl...
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23GYWyNbhHHA.3960@.TK2MSFTNGP02.phx.gbl...
> Here is a response from another poster:
> "If you are running Windows 2003 server for your IIS reportserver, then
> this is a simple issue - I'll explain what happens:The report service
> engine, once it is idle for more than the default 20 minutes, the worker
> process is shutdown.This is controlled by IIS.Open up the Internet
> Information Services (IIS) Manager
> Expand the server node then the application pools.On my IIS machine, I
> created an application pool dedicated to the reportserver & reportmanager
> virtual webs.
> But anyways, for the application pool that the reportserver is pointing to
> if you left everything to their defaults will be the DefaultAppPool.
> Right click the default app pool and select properties.
> There are two things that are checked by default - On the recycling tab
> there is a checkbox for recycling worker processes - it is currently set
> to 1740 minutes (29 hours). Leave it.
> The other one is on the performance tab - which is the one you are
> interested in changing...
> See the "Idle Timeout" section and increase the number of minutes to be 8
> hours a typical working day - 8*60 = 480 minutes.
> Next, to be sure the "morning person" that runs the first report doesn't
> get the delay, set up a schedule for either a dummy or adhoc report to
> fire off like at 6am so that the report component worker processes get
> loaded.
> I hope this helps you.
> There is no need to have a report fire off every minute to keep things
> alive - it is just that the report service was "unloaded" and needed to
> load back up.
> =-Chris"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shawn" <shawn.camner@.ccci.org> wrote in message
> news:e2WCz9ahHHA.392@.TK2MSFTNGP06.phx.gbl...
>> Any ideas as to how to keep Reporting Services awake? I have tried
>> setting up a simple report that gets the current time and then created a
>> subscription that runs ever 5 minutes, but it often still takes time to
>> open the home page.
>

Keep remote SQL data tables updated

Hello, I need some guidance in the best method to accomplish this task. I have a network with a SBS 2003 server and a SQL 2000 member server in the SBS domain. I have a remotely hosted website at discountasp.net with a SQL 2000 database. The website will host a modified e-commerce kit where corporate clients can order parts. I need to keep the products table on the remotely hosted site as updated as possible. The website orders are placed via email from the commerce kit and the fulfillment department proccesses the order against the SQL server in the SBS domain.

Any ideas on how to keep the data updated on the website?

How updated do you want?|||Within an hour perhaps. I have a remotely hosted sql server at discountasp.net and a sql server in my domain. The hosting provider does not allow dts or replication.|||

I would say create a web service at your hosting provider. Then create a service you can run on your local sql 2000 machine that does the pull/push at intervals. Just make sure that all your important tables have auto-incremented id fields so you know what you are missing since last pull/push.

It sounds like the hosting provider is the master table for orders, and your local sql server is the master for products. Create a trigger on the ISP's order table that records all insert/delete/updates to that table to an auditOrders table that contains an id field (Autoincrement int), a changetype field (char) constrained to 'I','U', or 'D', a ChangeTime field (datetime with default of GetUTCDate()), and a field for every field in Orders. Make a similiar trigger on your local products table going into auditProducts. Then create a webservice at the hosting provider that has 3 methods:

public function GetNewOrders(LastId as integer) As Dataset

public function GetLatestProductChangeID() as integer

public sub SaveProductChanges(ds as dataset)

Make a copy of auditProducts and auditOrders at the other location. To pull changes to orders, select the highest id from your local auditOrders table. Then call GetNewOrders with that id. Take the dataset and record by record (It should be in id order) start a transaction, perform the Insert/Update/Delete on the local table, and then insert the record into the local audit table, and commit the transaction. To push Products, call the GetLatestProductChangeID, then create a dataset containing all the records from the local auditProducts table where the id is larger than the id you got from the webmethod, and call SaveProductChanges with the dataset.

Alternatively from having to do the transaction, and manually record the record into the audit table, you can also copy the triggers from the other side, and it (SHOULD) recreate the record, all except for the ChangeTime which will be different obviously.

|||

Take a look at my Remote SQL data provider, WebSql Data Provider, for secure, efficent access to SQL Server over HTTP, as simple as using the native SQL provider in System.Data.SqlClient namespace.

keep relationships

Hi,
Which type(s) of publications keep the relationships and constraints when
the schema and data is pushed over to the subscriber ?
Ben,
have a look at the article properties form - DRI constraints is an option in
each type of replication. It'll take the FKs if both the PK and the FK
tables are in the same publication.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Keep registered servers in tact

Every time I register servers in Management Studio, the next time I reopen management studio after closing it, they all disappear. Is there a setting somewhere to tell SSMS to keep those settings?Hmmm... That's strange. The data for registered servers is stored in C:\Documents and Settings\%User%\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\RegSrvr.xml take a look at that file between sessions.

Keep records that contain certain attributes

Have a report that I want to keep certain attributes and as long as the report contains this certain attribute, bring all other attributes with it. Better with an example. In this report I am specifically looking for attribute "Alcohol", if I find this attribute I want to include all others that fit with this record's Primary Key which could include, "Drugs","Arson","Vandalism", etc. Problem is when I try to use a paramater or filter I get the "Alcohol" Attribute but not the "Drugs","Arson","Vandalism", etc. Conversely since I dont have any filter/paramater set I get everything even if it does not include "Alcohol"

suggestions?

thansk in advance

Hi km

I am having a bit of trouble understanding what data you are working with.
Once this is clear perhaps I can help.
Does your data-set look like the following?

Primary Key | Problem
-
1 Drugs
1 Alcohol
1 Vandalism
2 Theft
2 Drugs

And you want to display all rows with PrimaryKey = 1 (since it includes alcohol), but not any rows with Primary Key 2?

If that is the case it will definitely be easiest to do this in you query itself, not in the report.
Something like:

Select * From Table WHERE PrimaryKey IN
(SELECT PrimaryKey From Table WHERE Problem = 'Alcohol'

Cheers
Mark
|||

thanks Mark

Yes this is similiar to my data found out that there is a unique key for each atttribute so all is resolved

thanks for your response

Keep records that contain certain attributes

suggestions?

thansk in advance

Hi km

I am having a bit of trouble understanding what data you are working with.
Once this is clear perhaps I can help.
Does your data-set look like the following?

Primary Key | Problem
-
1 Drugs
1 Alcohol
1 Vandalism
2 Theft
2 Drugs

And you want to display all rows with PrimaryKey = 1 (since it includes alcohol), but not any rows with Primary Key 2?

If that is the case it will definitely be easiest to do this in you query itself, not in the report.
Something like:

Select * From Table WHERE PrimaryKey IN
(SELECT PrimaryKey From Table WHERE Problem = 'Alcohol'

Cheers
Mark
|||

thanks Mark

Yes this is similiar to my data found out that there is a unique key for each atttribute so all is resolved

thanks for your response

Keep prior select results in the Results pane

I run query A in SQL server (Management Studio). I slightly change the query and want to run it again. How do I keep the results of the prior run in the Results pane so that I can compare them.

Thanks,

Skender

You can open mulitple query Windows to do that, or just copy the results out to another window.

Buck Woody

|||

Oracle had a code you put in and saves the results in the same window (spool on). I was hoping SQL server has the same thing.

Keep package alive forever

Hi there,

Does anyone know how i can keep an ssis package used for real time reporting alive no matter the amount of errors it gets? So for instance the server im streaming to is shutdown for maintenance, and the connection dies, its needs to just keep re-trying. In other words the maximum error count is infinite. i dont just want to set max err count high, i want it out of the picture all together.

Thanks

are you talking about a SSIS packages which do stuff inside a infinite loop?

|||yup thats the plan. i want the package to stay alive rather than calling it from a job over and over because of the validation time incurred in having the package start and end all the time|||

ssis might not be the one you need.

how about replication

|||We currently replicate. but due to performance issues starting to rear their heads, we have changed our structures on our ODS to include only data marts - therefore we need to transform all that gets replicated to our ODS|||

replication should be able to catch up with that change. anyway. just stay for more suggestions.

how about scheduling the package to run regularly using a Sql jobs or windows task scheduler

|||Thanks for the reply. Yup gonna go with scheduling it. slower than i initially wanted but will prob be the only way

Keep only X # of backups when appending to BU file

Using SQL Server 2005 STD, is there a way to create a maintance plan to
backup the database, appending to a file, but only keeping the last X number
of backups?
I would like to keep 4 full backups at a time. When the 5th backup occurs, I
would like the first to be deleted.
I've seen options like this in 3rd party backup tools, but is there a way to
do this natively w/ SQL Server?
Have a look at the expire parameter of the backup command. From
http://msdn2.microsoft.com/en-us/library/ms187510.aspx
a.. To have the backup set expire after a specific number of days, click
After (the default option), and enter the number of days after set creation
that the set will expire. This value can be from 0 to 99999 days; a value of
0 days means that the backup set will never expire.
The default value is set in the Default backup media retention (in days)
option of the Server Properties dialog box (Database Settings Page). To
access this, right-click the server name in Object Explorer and select
properties; then select the Database Settings page.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:DEA2E6D1-DB67-42F7-8406-E37EB553AEA9@.microsoft.com...
> Using SQL Server 2005 STD, is there a way to create a maintance plan to
> backup the database, appending to a file, but only keeping the last X
> number
> of backups?
> I would like to keep 4 full backups at a time. When the 5th backup occurs,
> I
> would like the first to be deleted.
> I've seen options like this in 3rd party backup tools, but is there a way
> to
> do this natively w/ SQL Server?
|||If every backup goes to the same file, then the answer is no. There
is no way for SQL Server to drop old backups from the front of the
file. The solution is for each backup to go to an individual file.
Roy Harvey
Beacon Falls, CT
On Tue, 19 Sep 2006 18:34:01 -0700, Dan
<Dan@.discussions.microsoft.com> wrote:

>Using SQL Server 2005 STD, is there a way to create a maintance plan to
>backup the database, appending to a file, but only keeping the last X number
>of backups?
>I would like to keep 4 full backups at a time. When the 5th backup occurs, I
>would like the first to be deleted.
>I've seen options like this in 3rd party backup tools, but is there a way to
>do this natively w/ SQL Server?

Keep only X # of backups when appending to BU file

Using SQL Server 2005 STD, is there a way to create a maintance plan to
backup the database, appending to a file, but only keeping the last X number
of backups?
I would like to keep 4 full backups at a time. When the 5th backup occurs, I
would like the first to be deleted.
I've seen options like this in 3rd party backup tools, but is there a way to
do this natively w/ SQL Server?Have a look at the expire parameter of the backup command. From
http://msdn2.microsoft.com/en-us/library/ms187510.aspx
a.. To have the backup set expire after a specific number of days, click
After (the default option), and enter the number of days after set creation
that the set will expire. This value can be from 0 to 99999 days; a value of
0 days means that the backup set will never expire.
The default value is set in the Default backup media retention (in days)
option of the Server Properties dialog box (Database Settings Page). To
access this, right-click the server name in Object Explorer and select
properties; then select the Database Settings page.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:DEA2E6D1-DB67-42F7-8406-E37EB553AEA9@.microsoft.com...
> Using SQL Server 2005 STD, is there a way to create a maintance plan to
> backup the database, appending to a file, but only keeping the last X
> number
> of backups?
> I would like to keep 4 full backups at a time. When the 5th backup occurs,
> I
> would like the first to be deleted.
> I've seen options like this in 3rd party backup tools, but is there a way
> to
> do this natively w/ SQL Server?|||If every backup goes to the same file, then the answer is no. There
is no way for SQL Server to drop old backups from the front of the
file. The solution is for each backup to go to an individual file.
Roy Harvey
Beacon Falls, CT
On Tue, 19 Sep 2006 18:34:01 -0700, Dan
<Dan@.discussions.microsoft.com> wrote:

>Using SQL Server 2005 STD, is there a way to create a maintance plan to
>backup the database, appending to a file, but only keeping the last X numbe
r
>of backups?
>I would like to keep 4 full backups at a time. When the 5th backup occurs,
I
>would like the first to be deleted.
>I've seen options like this in 3rd party backup tools, but is there a way t
o
>do this natively w/ SQL Server?

Keep only X # of backups when appending to BU file

Using SQL Server 2005 STD, is there a way to create a maintance plan to
backup the database, appending to a file, but only keeping the last X number
of backups?
I would like to keep 4 full backups at a time. When the 5th backup occurs, I
would like the first to be deleted.
I've seen options like this in 3rd party backup tools, but is there a way to
do this natively w/ SQL Server?Have a look at the expire parameter of the backup command. From
http://msdn2.microsoft.com/en-us/library/ms187510.aspx
a.. To have the backup set expire after a specific number of days, click
After (the default option), and enter the number of days after set creation
that the set will expire. This value can be from 0 to 99999 days; a value of
0 days means that the backup set will never expire.
The default value is set in the Default backup media retention (in days)
option of the Server Properties dialog box (Database Settings Page). To
access this, right-click the server name in Object Explorer and select
properties; then select the Database Settings page.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:DEA2E6D1-DB67-42F7-8406-E37EB553AEA9@.microsoft.com...
> Using SQL Server 2005 STD, is there a way to create a maintance plan to
> backup the database, appending to a file, but only keeping the last X
> number
> of backups?
> I would like to keep 4 full backups at a time. When the 5th backup occurs,
> I
> would like the first to be deleted.
> I've seen options like this in 3rd party backup tools, but is there a way
> to
> do this natively w/ SQL Server?|||If every backup goes to the same file, then the answer is no. There
is no way for SQL Server to drop old backups from the front of the
file. The solution is for each backup to go to an individual file.
Roy Harvey
Beacon Falls, CT
On Tue, 19 Sep 2006 18:34:01 -0700, Dan
<Dan@.discussions.microsoft.com> wrote:
>Using SQL Server 2005 STD, is there a way to create a maintance plan to
>backup the database, appending to a file, but only keeping the last X number
>of backups?
>I would like to keep 4 full backups at a time. When the 5th backup occurs, I
>would like the first to be deleted.
>I've seen options like this in 3rd party backup tools, but is there a way to
>do this natively w/ SQL Server?

Keep one connection open for log

I am using SQL 7. If I open one connection for long, I notice that as I keep
running more SQL statement my I/O and CPU Usage keep growing. Even though I
am done with the connection not running any statement I still see those
resouces being used.
Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
Please help.
Hi
Look up 'Connection Pooling' in BOL.
The MDAC driver keeps the connection open by default 120 seconds, and if
another query, to the same saver, using the same credentials comes along on
the same client machine., it just re-uses the existing connection.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:64E68C08-BACE-44A0-9301-2476AA954CD3@.microsoft.com...
> I am using SQL 7. If I open one connection for long, I notice that as I
keep
> running more SQL statement my I/O and CPU Usage keep growing. Even though
I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.
|||I do not agree with you at all. For SQL 7 it is not true. I saw connections
stays there as long as I do not discoonect.
You have not answered any thing of my question. My bad luck is no body else
going to answer this question.
"Astros" wrote:

> I am using SQL 7. If I open one connection for long, I notice that as I keep
> running more SQL statement my I/O and CPU Usage keep growing. Even though I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.
|||Hi
Well, then give us more information. Give us outputs of sp_who2 over
intervals and run profiler at the same time to see what is being submitted
to SQL Server. You might find that there are requests being submitted. There
is no known bug where counters increase themselves for no reason.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> I do not agree with you at all. For SQL 7 it is not true. I saw
connections
> stays there as long as I do not discoonect.
> You have not answered any thing of my question. My bad luck is no body
else[vbcol=seagreen]
> going to answer this question.
> "Astros" wrote:
keep[vbcol=seagreen]
though I[vbcol=seagreen]
|||Hi Mike,
I don't mean to be rude the other day. My application using one connection
and doing same kind of activities again and again. Several hundred time doing
same insert for a different record. It is not cursor as far as SQL server
concern. From within the application it is repeating.
Another situation is: I open query analyser and start using it for different
type of select or updat etc. Using same connection. I see that counter for
I/O and CPU keep increasing. Not necessarily I am using more resouce
consuming SQL but I never see those resouceses being released. Unless I killl
the connection.
Aziz
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Well, then give us more information. Give us outputs of sp_who2 over
> intervals and run profiler at the same time to see what is being submitted
> to SQL Server. You might find that there are requests being submitted. There
> is no known bug where counters increase themselves for no reason.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> connections
> else
> keep
> though I
>
>

Keep one connection open for log

I am using SQL 7. If I open one connection for long, I notice that as I keep
running more SQL statement my I/O and CPU Usage keep growing. Even though I
am done with the connection not running any statement I still see those
resouces being used.
Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
Please help.Hi
Look up 'Connection Pooling' in BOL.
The MDAC driver keeps the connection open by default 120 seconds, and if
another query, to the same saver, using the same credentials comes along on
the same client machine., it just re-uses the existing connection.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:64E68C08-BACE-44A0-9301-2476AA954CD3@.microsoft.com...
> I am using SQL 7. If I open one connection for long, I notice that as I
keep
> running more SQL statement my I/O and CPU Usage keep growing. Even though
I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.|||I do not agree with you at all. For SQL 7 it is not true. I saw connections
stays there as long as I do not discoonect.
You have not answered any thing of my question. My bad luck is no body else
going to answer this question.
"Astros" wrote:
> I am using SQL 7. If I open one connection for long, I notice that as I keep
> running more SQL statement my I/O and CPU Usage keep growing. Even though I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.|||Hi
Well, then give us more information. Give us outputs of sp_who2 over
intervals and run profiler at the same time to see what is being submitted
to SQL Server. You might find that there are requests being submitted. There
is no known bug where counters increase themselves for no reason.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> I do not agree with you at all. For SQL 7 it is not true. I saw
connections
> stays there as long as I do not discoonect.
> You have not answered any thing of my question. My bad luck is no body
else
> going to answer this question.
> "Astros" wrote:
> > I am using SQL 7. If I open one connection for long, I notice that as I
keep
> > running more SQL statement my I/O and CPU Usage keep growing. Even
though I
> > am done with the connection not running any statement I still see those
> > resouces being used.
> >
> > Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> >
> > Please help.|||Hi Mike,
I don't mean to be rude the other day. My application using one connection
and doing same kind of activities again and again. Several hundred time doing
same insert for a different record. It is not cursor as far as SQL server
concern. From within the application it is repeating.
Another situation is: I open query analyser and start using it for different
type of select or updat etc. Using same connection. I see that counter for
I/O and CPU keep increasing. Not necessarily I am using more resouce
consuming SQL but I never see those resouceses being released. Unless I killl
the connection.
Aziz
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Well, then give us more information. Give us outputs of sp_who2 over
> intervals and run profiler at the same time to see what is being submitted
> to SQL Server. You might find that there are requests being submitted. There
> is no known bug where counters increase themselves for no reason.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> > I do not agree with you at all. For SQL 7 it is not true. I saw
> connections
> > stays there as long as I do not discoonect.
> >
> > You have not answered any thing of my question. My bad luck is no body
> else
> > going to answer this question.
> >
> > "Astros" wrote:
> >
> > > I am using SQL 7. If I open one connection for long, I notice that as I
> keep
> > > running more SQL statement my I/O and CPU Usage keep growing. Even
> though I
> > > am done with the connection not running any statement I still see those
> > > resouces being used.
> > >
> > > Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> > >
> > > Please help.
>
>

Keep one connection open for log

I am using SQL 7. If I open one connection for long, I notice that as I keep
running more SQL statement my I/O and CPU Usage keep growing. Even though I
am done with the connection not running any statement I still see those
resouces being used.
Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
Please help.Hi
Look up 'Connection Pooling' in BOL.
The MDAC driver keeps the connection open by default 120 seconds, and if
another query, to the same saver, using the same credentials comes along on
the same client machine., it just re-uses the existing connection.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:64E68C08-BACE-44A0-9301-2476AA954CD3@.microsoft.com...
> I am using SQL 7. If I open one connection for long, I notice that as I
keep
> running more SQL statement my I/O and CPU Usage keep growing. Even though
I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.|||I do not agree with you at all. For SQL 7 it is not true. I saw connections
stays there as long as I do not discoonect.
You have not answered any thing of my question. My bad luck is no body else
going to answer this question.
"Astros" wrote:

> I am using SQL 7. If I open one connection for long, I notice that as I ke
ep
> running more SQL statement my I/O and CPU Usage keep growing. Even though
I
> am done with the connection not running any statement I still see those
> resouces being used.
> Is it a bug in SQL 7 or it happens with 2000 also. Is it a memory leak ?
> Please help.|||Hi
Well, then give us more information. Give us outputs of sp_who2 over
intervals and run profiler at the same time to see what is being submitted
to SQL Server. You might find that there are requests being submitted. There
is no known bug where counters increase themselves for no reason.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> I do not agree with you at all. For SQL 7 it is not true. I saw
connections
> stays there as long as I do not discoonect.
> You have not answered any thing of my question. My bad luck is no body
else[vbcol=seagreen]
> going to answer this question.
> "Astros" wrote:
>
keep[vbcol=seagreen]
though I[vbcol=seagreen]|||Hi Mike,
I don't mean to be rude the other day. My application using one connection
and doing same kind of activities again and again. Several hundred time doin
g
same insert for a different record. It is not cursor as far as SQL server
concern. From within the application it is repeating.
Another situation is: I open query analyser and start using it for different
type of select or updat etc. Using same connection. I see that counter for
I/O and CPU keep increasing. Not necessarily I am using more resouce
consuming SQL but I never see those resouceses being released. Unless I kill
l
the connection.
Aziz
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Well, then give us more information. Give us outputs of sp_who2 over
> intervals and run profiler at the same time to see what is being submitted
> to SQL Server. You might find that there are requests being submitted. The
re
> is no known bug where counters increase themselves for no reason.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:52DB2055-CAE1-42CE-A106-C55E1422D918@.microsoft.com...
> connections
> else
> keep
> though I
>
>

Keep object together

when we right click a text object in the report there's a checkbox KeepObjectTogether what is this option for?!!!Did you try looking in the help?
It keeps the object on one page if possible, so I guess it's applicable if your text object can span > 1 line.

Keep Identity

Hi,
Please let me know how to keep identity property retained while copying
empty tables(with identity property set) from one database to another.
One way that I know is Backup\Restore. Suggest some other options.
Thanks in advance...
You can try a simple SSIS package using the Transfer SQL Server Object Task;
look at the Book on line searching for the task and i think you'll be
satisfied.
Gilberto Zampatti
"manu" wrote:

> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...
|||Hi,
Can't you just script out the table and run the script on the other database?
You can script using EM in 2000 and Mgmt Studio in 2005.
Thank you.
Regards,
Karthik
"manu" wrote:

> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...
|||search web for kondredi and get his generate_inserts sproc. WONDERFUL
utility!
TheSQLGuru
President
Indicium Resources, Inc.
"manu" <manu@.discussions.microsoft.com> wrote in message
news:2C6B421A-929F-4FDE-962B-F6000BE1450E@.microsoft.com...
> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...

Keep Identity

Hi,
Please let me know how to keep identity property retained while copying
empty tables(with identity property set) from one database to another.
One way that I know is Backup\Restore. Suggest some other options.
Thanks in advance...You can try a simple SSIS package using the Transfer SQL Server Object Task
;
look at the Book on line searching for the task and i think you'll be
satisfied.
Gilberto Zampatti
"manu" wrote:

> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...|||Hi,
Can't you just script out the table and run the script on the other database
?
You can script using EM in 2000 and Mgmt Studio in 2005.
Thank you.
Regards,
Karthik
"manu" wrote:

> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...|||search web for kondredi and get his generate_inserts sproc. WONDERFUL
utility!
TheSQLGuru
President
Indicium Resources, Inc.
"manu" <manu@.discussions.microsoft.com> wrote in message
news:2C6B421A-929F-4FDE-962B-F6000BE1450E@.microsoft.com...
> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...

Keep Identity

Hi,
Please let me know how to keep identity property retained while copying
empty tables(with identity property set) from one database to another.
One way that I know is Backup\Restore. Suggest some other options.
Thanks in advance...You can try a simple SSIS package using the Transfer SQL Server Object Task;
look at the Book on line searching for the task and i think you'll be
satisfied.
Gilberto Zampatti
"manu" wrote:
> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...|||Hi,
Can't you just script out the table and run the script on the other database?
You can script using EM in 2000 and Mgmt Studio in 2005.
Thank you.
Regards,
Karthik
"manu" wrote:
> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...|||search web for kondredi and get his generate_inserts sproc. WONDERFUL
utility!
--
TheSQLGuru
President
Indicium Resources, Inc.
"manu" <manu@.discussions.microsoft.com> wrote in message
news:2C6B421A-929F-4FDE-962B-F6000BE1450E@.microsoft.com...
> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...

Keep group together

Is there any way to keep a group header and detail rows together so I don't get the header on the bottom of a page and the details orphaned at the top of the next page?

Table Keep Together property only works at the table level (though not sure how that works anyway). And I don't want a page break before each group.

Thanks in advance.

The only solution to this problem as of now is to repeat the group headers on new page.

Shyam

|||Any idea if this is going to be addressed in a future version?|||

Probably yes, but not sure.

Shyam

Keep Group Together

Hi,
we currently have a situation where the column headings for our group is
printed on the bottom of the page and the data starts on the next page. Is
there anyway to ensure the group header prints on the next page instead if
no data can be fitted on the page. Hope this is clear - in Crystal there
was an option Keep group together which did this.
thanks
MattTry putting the items you want to keep together in a rectangle. Sometimes
that keeps them on the same page. If you're working with tables, there are
problems with pagination that probably we'll have to wait for a later
version to fix.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eiyCb601EHA.3392@.TK2MSFTNGP10.phx.gbl...
> Hi,
> we currently have a situation where the column headings for our group is
> printed on the bottom of the page and the data starts on the next page.
> Is
> there anyway to ensure the group header prints on the next page instead if
> no data can be fitted on the page. Hope this is clear - in Crystal there
> was an option Keep group together which did this.
> thanks
> Matt
>|||Thanks for the response Jeff.
Just clarifying:
Are you saying put the whole table in a rectangle?
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:e6dvxV11EHA.4000@.TK2MSFTNGP10.phx.gbl...
> Try putting the items you want to keep together in a rectangle. Sometimes
> that keeps them on the same page. If you're working with tables, there
are
> problems with pagination that probably we'll have to wait for a later
> version to fix.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:eiyCb601EHA.3392@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > we currently have a situation where the column headings for our group is
> > printed on the bottom of the page and the data starts on the next page.
> > Is
> > there anyway to ensure the group header prints on the next page instead
if
> > no data can be fitted on the page. Hope this is clear - in Crystal
there
> > was an option Keep group together which did this.
> >
> > thanks
> >
> > Matt
> >
> >
>|||Yes, and other items as well if preferable. It's not completely
deterministic, but can influence the page breaks.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:%23$AxPFC3EHA.3840@.tk2msftngp13.phx.gbl...
> Thanks for the response Jeff.
> Just clarifying:
> Are you saying put the whole table in a rectangle?
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:e6dvxV11EHA.4000@.TK2MSFTNGP10.phx.gbl...
>> Try putting the items you want to keep together in a rectangle.
>> Sometimes
>> that keeps them on the same page. If you're working with tables, there
> are
>> problems with pagination that probably we'll have to wait for a later
>> version to fix.
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
>> news:eiyCb601EHA.3392@.TK2MSFTNGP10.phx.gbl...
>> > Hi,
>> >
>> > we currently have a situation where the column headings for our group
>> > is
>> > printed on the bottom of the page and the data starts on the next page.
>> > Is
>> > there anyway to ensure the group header prints on the next page instead
> if
>> > no data can be fitted on the page. Hope this is clear - in Crystal
> there
>> > was an option Keep group together which did this.
>> >
>> > thanks
>> >
>> > Matt
>> >
>> >
>>
>|||Ok, will give it a try. Thanks
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:%23CoByFI3EHA.1392@.tk2msftngp13.phx.gbl...
> Yes, and other items as well if preferable. It's not completely
> deterministic, but can influence the page breaks.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:%23$AxPFC3EHA.3840@.tk2msftngp13.phx.gbl...
> > Thanks for the response Jeff.
> >
> > Just clarifying:
> > Are you saying put the whole table in a rectangle?
> >
> > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > news:e6dvxV11EHA.4000@.TK2MSFTNGP10.phx.gbl...
> >> Try putting the items you want to keep together in a rectangle.
> >> Sometimes
> >> that keeps them on the same page. If you're working with tables, there
> > are
> >> problems with pagination that probably we'll have to wait for a later
> >> version to fix.
> >>
> >> --
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> >> news:eiyCb601EHA.3392@.TK2MSFTNGP10.phx.gbl...
> >> > Hi,
> >> >
> >> > we currently have a situation where the column headings for our group
> >> > is
> >> > printed on the bottom of the page and the data starts on the next
page.
> >> > Is
> >> > there anyway to ensure the group header prints on the next page
instead
> > if
> >> > no data can be fitted on the page. Hope this is clear - in Crystal
> > there
> >> > was an option Keep group together which did this.
> >> >
> >> > thanks
> >> >
> >> > Matt
> >> >
> >> >
> >>
> >>
> >
> >
>

Keep group rows together

Hi,

Is it possible to keep a group in a table report on the one page if this group could be fitted into the rest of the page and start new page otherwise?

Thanks,
Igor

This is taken from here http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx

Using Rectangles to Keep Objects Together
Rectangles in Reporting Services can be used either as graphical elements or as containers of objects. As object containers, they keep objects together on a page and control how objects move and push each other.

To keep multiple objects together on a page, put the objects within a rectangle. You can then put a page break before or after the rectangle by using the PageBreakAtStart or PageBreakAtEnd properties for the rectangle.

Using Rectangles to Control Item Growth and Displacement
Items within a rectangle become peers of each other and are governed by the rules of how peer items are positioned on the page as they move or grow. For example:

? Items will push or displace each other within the rectangle.
? Items will not push or displace items outside the rectangle, because they are not their peers.
? If necessary, a rectangle will grow to accommodate the items it contains.

You can use this logic to your advantage when dealing with objects that expand. For example:

? If you want to leave a blank space in your report for a table to expand into, group the blank space and the table in the same rectangle. When the table grows, it will push the blank space.
? If you want to prevent a matrix from pushing items off the right edge of the page, put the matrix within a rectangle with blank space to its right. Now, the matrix is no longer a peer to the other item on the page and will not be able to push it until the matrix can no longer be contained within its rectangle.

Keep Group Data Together

In Access there was a keep together...
How do I make sure data in a group moves to the next page if it will not fit
on the current page?
--
Thank You, LeoHello Leo,
Thank you for your post!
Regarding your question, you can add page break at each group as you want.
For example:
1. Click Layout
2. Click a table, and click table_cateory footer row icon and select the
row, right click group footer handle button
3. Select edit group
4. Select Page break at end box and click OK
Hope this information is helpful.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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.
| Thread-Topic: Keep Group Data Together
| thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==| X-WBNR-Posting-Host: 64.91.16.201
| From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| Subject: Keep Group Data Together
| Date: Tue, 2 Nov 2004 18:09:01 -0800
| Lines: 6
| Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33917
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| In Access there was a keep together...
|
| How do I make sure data in a group moves to the next page if it will not
fit
| on the current page?
| --
| Thank You, Leo
||||Peter,
Thanks for the post. I cant have seperate pages for each group . When the
whole group will not fit on the current page I would like it to be sent to
the next page.
Thanks, Leo
"Peter Yang [MSFT]" wrote:
> Hello Leo,
> Thank you for your post!
> Regarding your question, you can add page break at each group as you want.
> For example:
> 1. Click Layout
> 2. Click a table, and click table_cateory footer row icon and select the
> row, right click group footer handle button
> 3. Select edit group
> 4. Select Page break at end box and click OK
> Hope this information is helpful.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> 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.
>
> --
> | Thread-Topic: Keep Group Data Together
> | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==> | X-WBNR-Posting-Host: 64.91.16.201
> | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | Subject: Keep Group Data Together
> | Date: Tue, 2 Nov 2004 18:09:01 -0800
> | Lines: 6
> | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33917
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | In Access there was a keep together...
> |
> | How do I make sure data in a group moves to the next page if it will not
> fit
> | on the current page?
> | --
> | Thank You, Leo
> |
>|||Hello Leo,
Thank you for your reply. You can also define the page size for a report.
Rendering extensions that support page size create page breaks based on the
page size. Rendering extensions that do not support page size ignore page
size. To change the page size for a report, change the PageHeight and
PageWidth properties of the report.
Hope this helps. Have a great day!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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.
| Thread-Topic: Keep Group Data Together
| thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==| X-WBNR-Posting-Host: 64.91.16.201
| From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
<D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
| Subject: RE: Keep Group Data Together
| Date: Wed, 3 Nov 2004 06:30:02 -0800
| Lines: 75
| Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33956
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Peter,
|
| Thanks for the post. I cant have seperate pages for each group . When
the
| whole group will not fit on the current page I would like it to be sent
to
| the next page.
|
| Thanks, Leo
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Leo,
| >
| > Thank you for your post!
| >
| > Regarding your question, you can add page break at each group as you
want.
| > For example:
| >
| > 1. Click Layout
| > 2. Click a table, and click table_cateory footer row icon and select
the
| > row, right click group footer handle button
| > 3. Select edit group
| > 4. Select Page break at end box and click OK
| >
| > Hope this information is helpful.
| >
| > Best Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================| > 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.
| >
| >
| > --
| > | Thread-Topic: Keep Group Data Together
| > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==| > | X-WBNR-Posting-Host: 64.91.16.201
| > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | Subject: Keep Group Data Together
| > | Date: Tue, 2 Nov 2004 18:09:01 -0800
| > | Lines: 6
| > | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:33917
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | In Access there was a keep together...
| > |
| > | How do I make sure data in a group moves to the next page if it will
not
| > fit
| > | on the current page?
| > | --
| > | Thank You, Leo
| > |
| >
| >
||||"Peter Yang [MSFT]" wrote:
> Hello Leo,
> Thank you for your reply. You can also define the page size for a report.
> Rendering extensions that support page size create page breaks based on the
> page size. Rendering extensions that do not support page size ignore page
> size. To change the page size for a report, change the PageHeight and
> PageWidth properties of the report.
> Hope this helps. Have a great day!
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> 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.
>
> --
> | Thread-Topic: Keep Group Data Together
> | thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==> | X-WBNR-Posting-Host: 64.91.16.201
> | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Keep Group Data Together
> | Date: Wed, 3 Nov 2004 06:30:02 -0800
> | Lines: 75
> | Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33956
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Peter,
> |
> | Thanks for the post. I cant have seperate pages for each group . When
> the
> | whole group will not fit on the current page I would like it to be sent
> to
> | the next page.
> |
> | Thanks, Leo
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Leo,
> | >
> | > Thank you for your post!
> | >
> | > Regarding your question, you can add page break at each group as you
> want.
> | > For example:
> | >
> | > 1. Click Layout
> | > 2. Click a table, and click table_cateory footer row icon and select
> the
> | > row, right click group footer handle button
> | > 3. Select edit group
> | > 4. Select Page break at end box and click OK
> | >
> | > Hope this information is helpful.
> | >
> | > Best Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > Get Secure! - www.microsoft.com/security
> | >
> | > =====================================================> | > 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.
> | >
> | >
> | > --
> | > | Thread-Topic: Keep Group Data Together
> | > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==> | > | X-WBNR-Posting-Host: 64.91.16.201
> | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | > | Subject: Keep Group Data Together
> | > | Date: Tue, 2 Nov 2004 18:09:01 -0800
> | > | Lines: 6
> | > | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:33917
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | In Access there was a keep together...
> | > |
> | > | How do I make sure data in a group moves to the next page if it will
> not
> | > fit
> | > | on the current page?
> | > | --
> | > | Thank You, Leo
> | > |
> | >
> | >
> |
>|||Peter,
How do I know where the pages ends when the data is changeing all the time?
Is there no setting like in access that will keep a group of data together
dynamically?
If I change the page height and width it will not print correctly...
Thanks, Leo
"Peter Yang [MSFT]" wrote:
> Hello Leo,
> Thank you for your reply. You can also define the page size for a report.
> Rendering extensions that support page size create page breaks based on the
> page size. Rendering extensions that do not support page size ignore page
> size. To change the page size for a report, change the PageHeight and
> PageWidth properties of the report.
> Hope this helps. Have a great day!
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> 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.
>
> --
> | Thread-Topic: Keep Group Data Together
> | thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==> | X-WBNR-Posting-Host: 64.91.16.201
> | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Keep Group Data Together
> | Date: Wed, 3 Nov 2004 06:30:02 -0800
> | Lines: 75
> | Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33956
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Peter,
> |
> | Thanks for the post. I cant have seperate pages for each group . When
> the
> | whole group will not fit on the current page I would like it to be sent
> to
> | the next page.
> |
> | Thanks, Leo
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Leo,
> | >
> | > Thank you for your post!
> | >
> | > Regarding your question, you can add page break at each group as you
> want.
> | > For example:
> | >
> | > 1. Click Layout
> | > 2. Click a table, and click table_cateory footer row icon and select
> the
> | > row, right click group footer handle button
> | > 3. Select edit group
> | > 4. Select Page break at end box and click OK
> | >
> | > Hope this information is helpful.
> | >
> | > Best Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > Get Secure! - www.microsoft.com/security
> | >
> | > =====================================================> | > 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.
> | >
> | >
> | > --
> | > | Thread-Topic: Keep Group Data Together
> | > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==> | > | X-WBNR-Posting-Host: 64.91.16.201
> | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | > | Subject: Keep Group Data Together
> | > | Date: Tue, 2 Nov 2004 18:09:01 -0800
> | > | Lines: 6
> | > | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:33917
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | In Access there was a keep together...
> | > |
> | > | How do I make sure data in a group moves to the next page if it will
> not
> | > fit
> | > | on the current page?
> | > | --
> | > | Thank You, Leo
> | > |
> | >
> | >
> |
>|||Hello Leo,
Thank you for your reply.
If you check "Select Page break at end" box as I mentioned, the there shall
be a page break at the end of each group. Also, the group can be in
multiple pages if a group is not fit in one page according to the page size
but the last page may not full because there is a page break at the end of
each group.
Have a great day!
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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.
| Thread-Topic: Keep Group Data Together
| thread-index: AcTCd2yfHR7OlHLpTzeFPn4UYW1JNQ==| X-WBNR-Posting-Host: 64.91.16.201
| From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
<D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
<72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
<CUiSUgjwEHA.764@.cpmsftngxa10.phx.gbl>
| Subject: RE: Keep Group Data Together
| Date: Thu, 4 Nov 2004 06:06:05 -0800
| Lines: 148
| Message-ID: <C7461150-2CC3-4DB7-AC26-E987D1CBBE39@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:34074
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Peter,
|
| How do I know where the pages ends when the data is changeing all the
time?
| Is there no setting like in access that will keep a group of data
together
| dynamically?
| If I change the page height and width it will not print correctly...
|
| Thanks, Leo
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Leo,
| >
| > Thank you for your reply. You can also define the page size for a
report.
| > Rendering extensions that support page size create page breaks based on
the
| > page size. Rendering extensions that do not support page size ignore
page
| > size. To change the page size for a report, change the PageHeight and
| > PageWidth properties of the report.
| >
| > Hope this helps. Have a great day!
| >
| > Best Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================| > 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.
| >
| >
| > --
| > | Thread-Topic: Keep Group Data Together
| > | thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==| > | X-WBNR-Posting-Host: 64.91.16.201
| > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
| > | Subject: RE: Keep Group Data Together
| > | Date: Wed, 3 Nov 2004 06:30:02 -0800
| > | Lines: 75
| > | Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:33956
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | Peter,
| > |
| > | Thanks for the post. I cant have seperate pages for each group .
When
| > the
| > | whole group will not fit on the current page I would like it to be
sent
| > to
| > | the next page.
| > |
| > | Thanks, Leo
| > |
| > | "Peter Yang [MSFT]" wrote:
| > |
| > | > Hello Leo,
| > | >
| > | > Thank you for your post!
| > | >
| > | > Regarding your question, you can add page break at each group as
you
| > want.
| > | > For example:
| > | >
| > | > 1. Click Layout
| > | > 2. Click a table, and click table_cateory footer row icon and
select
| > the
| > | > row, right click group footer handle button
| > | > 3. Select edit group
| > | > 4. Select Page break at end box and click OK
| > | >
| > | > Hope this information is helpful.
| > | >
| > | > Best Regards,
| > | >
| > | > Peter Yang
| > | > MCSE2000/2003, MCSA, MCDBA
| > | > Microsoft Online Partner Support
| > | >
| > | > Get Secure! - www.microsoft.com/security
| > | >
| > | > =====================================================| > | > 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.
| > | >
| > | >
| > | > --
| > | > | Thread-Topic: Keep Group Data Together
| > | > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==| > | > | X-WBNR-Posting-Host: 64.91.16.201
| > | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | > | Subject: Keep Group Data Together
| > | > | Date: Tue, 2 Nov 2004 18:09:01 -0800
| > | > | Lines: 6
| > | > | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > | > | MIME-Version: 1.0
| > | > | Content-Type: text/plain;
| > | > | charset="Utf-8"
| > | > | Content-Transfer-Encoding: 7bit
| > | > | X-Newsreader: Microsoft CDO for Windows 2000
| > | > | Content-Class: urn:content-classes:message
| > | > | Importance: normal
| > | > | Priority: normal
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | > | Xref: cpmsftngxa10.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:33917
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | > |
| > | > | In Access there was a keep together...
| > | > |
| > | > | How do I make sure data in a group moves to the next page if it
will
| > not
| > | > fit
| > | > | on the current page?
| > | > | --
| > | > | Thank You, Leo
| > | > |
| > | >
| > | >
| > |
| >
| >
||||Hello Peter,
I dont think I am communicating what I need very well.
I need the groups to continue unless it splits it in the middle of a group.
The group data is generally small and I do not want the groups to be on new
pages every time.
Thanks, Leo
"Peter Yang [MSFT]" wrote:
> Hello Leo,
> Thank you for your reply.
> If you check "Select Page break at end" box as I mentioned, the there shall
> be a page break at the end of each group. Also, the group can be in
> multiple pages if a group is not fit in one page according to the page size
> but the last page may not full because there is a page break at the end of
> each group.
> Have a great day!
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> 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.
>
> --
> | Thread-Topic: Keep Group Data Together
> | thread-index: AcTCd2yfHR7OlHLpTzeFPn4UYW1JNQ==> | X-WBNR-Posting-Host: 64.91.16.201
> | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
> <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
> <CUiSUgjwEHA.764@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Keep Group Data Together
> | Date: Thu, 4 Nov 2004 06:06:05 -0800
> | Lines: 148
> | Message-ID: <C7461150-2CC3-4DB7-AC26-E987D1CBBE39@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:34074
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Peter,
> |
> | How do I know where the pages ends when the data is changeing all the
> time?
> | Is there no setting like in access that will keep a group of data
> together
> | dynamically?
> | If I change the page height and width it will not print correctly...
> |
> | Thanks, Leo
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Leo,
> | >
> | > Thank you for your reply. You can also define the page size for a
> report.
> | > Rendering extensions that support page size create page breaks based on
> the
> | > page size. Rendering extensions that do not support page size ignore
> page
> | > size. To change the page size for a report, change the PageHeight and
> | > PageWidth properties of the report.
> | >
> | > Hope this helps. Have a great day!
> | >
> | > Best Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > Get Secure! - www.microsoft.com/security
> | >
> | > =====================================================> | > 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.
> | >
> | >
> | > --
> | > | Thread-Topic: Keep Group Data Together
> | > | thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==> | > | X-WBNR-Posting-Host: 64.91.16.201
> | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | > | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> | > <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
> | > | Subject: RE: Keep Group Data Together
> | > | Date: Wed, 3 Nov 2004 06:30:02 -0800
> | > | Lines: 75
> | > | Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:33956
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | Peter,
> | > |
> | > | Thanks for the post. I cant have seperate pages for each group .
> When
> | > the
> | > | whole group will not fit on the current page I would like it to be
> sent
> | > to
> | > | the next page.
> | > |
> | > | Thanks, Leo
> | > |
> | > | "Peter Yang [MSFT]" wrote:
> | > |
> | > | > Hello Leo,
> | > | >
> | > | > Thank you for your post!
> | > | >
> | > | > Regarding your question, you can add page break at each group as
> you
> | > want.
> | > | > For example:
> | > | >
> | > | > 1. Click Layout
> | > | > 2. Click a table, and click table_cateory footer row icon and
> select
> | > the
> | > | > row, right click group footer handle button
> | > | > 3. Select edit group
> | > | > 4. Select Page break at end box and click OK
> | > | >
> | > | > Hope this information is helpful.
> | > | >
> | > | > Best Regards,
> | > | >
> | > | > Peter Yang
> | > | > MCSE2000/2003, MCSA, MCDBA
> | > | > Microsoft Online Partner Support
> | > | >
> | > | > Get Secure! - www.microsoft.com/security
> | > | >
> | > | > =====================================================> | > | > 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.
> | > | >
> | > | >
> | > | > --
> | > | > | Thread-Topic: Keep Group Data Together
> | > | > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==> | > | > | X-WBNR-Posting-Host: 64.91.16.201
> | > | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | > | > | Subject: Keep Group Data Together
> | > | > | Date: Tue, 2 Nov 2004 18:09:01 -0800
> | > | > | Lines: 6
> | > | > | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> | > | > | MIME-Version: 1.0
> | > | > | Content-Type: text/plain;
> | > | > | charset="Utf-8"
> | > | > | Content-Transfer-Encoding: 7bit
> | > | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | > | Content-Class: urn:content-classes:message
> | > | > | Importance: normal
> | > | > | Priority: normal
> | > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | > | Xref: cpmsftngxa10.phx.gbl
> | > microsoft.public.sqlserver.reportingsvcs:33917
> | > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > | > |
> | > | > | In Access there was a keep together...
> | > | > |
> | > | > | How do I make sure data in a group moves to the next page if it
> will
> | > not
> | > | > fit
> | > | > | on the current page?
> | > | > | --
> | > | > | Thank You, Leo
> | > | > |
> | > | >
> | > | >
> | > |
> | >
> | >
> |
>|||Hello Leo,
Thank you for your reply. It seems that you do not want group information
to be split to a new page. Based on my research, there is no method at
present to achieve this goal. I am sorry for the inconvenience. We strive
to capture any product issues or product feedback so as to ensure that we
are continuously developing Microsoft products to meet customer needs. Your
feedback is taken seriously. I will make sure it is routed through the
proper channels and thank you again for your valuable feedback. You can
also post your suggestions to MSWISH: mswish@.microsoft.com.
Also, you may try to use this option to see if can partially meet your
requirement:
1. Click Layout
2. Click a table, and click table_cateory footer row icon and select the
row, right click group footer handle button
3. Select edit group
4. Select "Repeat group header" and "Repeat group footer" and click OK.
Each page shall have group information at this time.
If you have further questions or concerns, please feel free to respond
back.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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.
| Thread-Topic: Keep Group Data Together
| thread-index: AcTDXg9z62ueWoV6Q3e2ObxIX206vg==| X-WBNR-Posting-Host: 64.91.16.201
| From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
<D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
<72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
<CUiSUgjwEHA.764@.cpmsftngxa10.phx.gbl>
<C7461150-2CC3-4DB7-AC26-E987D1CBBE39@.microsoft.com>
<aA7BISwwEHA.768@.cpmsftngxa10.phx.gbl>
| Subject: RE: Keep Group Data Together
| Date: Fri, 5 Nov 2004 09:37:02 -0800
| Lines: 230
| Message-ID: <C4CB5E79-7FB8-4977-8F64-F8BB53109E88@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:34228
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello Peter,
|
| I dont think I am communicating what I need very well.
|
| I need the groups to continue unless it splits it in the middle of a
group.
| The group data is generally small and I do not want the groups to be on
new
| pages every time.
|
| Thanks, Leo
| "Peter Yang [MSFT]" wrote:
|
| > Hello Leo,
| >
| > Thank you for your reply.
| >
| > If you check "Select Page break at end" box as I mentioned, the there
shall
| > be a page break at the end of each group. Also, the group can be in
| > multiple pages if a group is not fit in one page according to the page
size
| > but the last page may not full because there is a page break at the end
of
| > each group.
| >
| > Have a great day!
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================| > 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.
| >
| >
| > --
| > | Thread-Topic: Keep Group Data Together
| > | thread-index: AcTCd2yfHR7OlHLpTzeFPn4UYW1JNQ==| > | X-WBNR-Posting-Host: 64.91.16.201
| > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
| > <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
| > <CUiSUgjwEHA.764@.cpmsftngxa10.phx.gbl>
| > | Subject: RE: Keep Group Data Together
| > | Date: Thu, 4 Nov 2004 06:06:05 -0800
| > | Lines: 148
| > | Message-ID: <C7461150-2CC3-4DB7-AC26-E987D1CBBE39@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:34074
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | Peter,
| > |
| > | How do I know where the pages ends when the data is changeing all the
| > time?
| > | Is there no setting like in access that will keep a group of data
| > together
| > | dynamically?
| > | If I change the page height and width it will not print correctly...
| > |
| > | Thanks, Leo
| > |
| > | "Peter Yang [MSFT]" wrote:
| > |
| > | > Hello Leo,
| > | >
| > | > Thank you for your reply. You can also define the page size for a
| > report.
| > | > Rendering extensions that support page size create page breaks
based on
| > the
| > | > page size. Rendering extensions that do not support page size
ignore
| > page
| > | > size. To change the page size for a report, change the PageHeight
and
| > | > PageWidth properties of the report.
| > | >
| > | > Hope this helps. Have a great day!
| > | >
| > | > Best Regards,
| > | >
| > | > Peter Yang
| > | > MCSE2000/2003, MCSA, MCDBA
| > | > Microsoft Online Partner Support
| > | >
| > | > Get Secure! - www.microsoft.com/security
| > | >
| > | > =====================================================| > | > 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.
| > | >
| > | >
| > | > --
| > | > | Thread-Topic: Keep Group Data Together
| > | > | thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==| > | > | X-WBNR-Posting-Host: 64.91.16.201
| > | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | > | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > | > <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
| > | > | Subject: RE: Keep Group Data Together
| > | > | Date: Wed, 3 Nov 2004 06:30:02 -0800
| > | > | Lines: 75
| > | > | Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
| > | > | MIME-Version: 1.0
| > | > | Content-Type: text/plain;
| > | > | charset="Utf-8"
| > | > | Content-Transfer-Encoding: 7bit
| > | > | X-Newsreader: Microsoft CDO for Windows 2000
| > | > | Content-Class: urn:content-classes:message
| > | > | Importance: normal
| > | > | Priority: normal
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | > | Xref: cpmsftngxa10.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:33956
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | > |
| > | > | Peter,
| > | > |
| > | > | Thanks for the post. I cant have seperate pages for each group .
| > When
| > | > the
| > | > | whole group will not fit on the current page I would like it to
be
| > sent
| > | > to
| > | > | the next page.
| > | > |
| > | > | Thanks, Leo
| > | > |
| > | > | "Peter Yang [MSFT]" wrote:
| > | > |
| > | > | > Hello Leo,
| > | > | >
| > | > | > Thank you for your post!
| > | > | >
| > | > | > Regarding your question, you can add page break at each group
as
| > you
| > | > want.
| > | > | > For example:
| > | > | >
| > | > | > 1. Click Layout
| > | > | > 2. Click a table, and click table_cateory footer row icon and
| > select
| > | > the
| > | > | > row, right click group footer handle button
| > | > | > 3. Select edit group
| > | > | > 4. Select Page break at end box and click OK
| > | > | >
| > | > | > Hope this information is helpful.
| > | > | >
| > | > | > Best Regards,
| > | > | >
| > | > | > Peter Yang
| > | > | > MCSE2000/2003, MCSA, MCDBA
| > | > | > Microsoft Online Partner Support
| > | > | >
| > | > | > Get Secure! - www.microsoft.com/security
| > | > | >
| > | > | > =====================================================| > | > | > 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.
| > | > | >
| > | > | >
| > | > | > --
| > | > | > | Thread-Topic: Keep Group Data Together
| > | > | > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==| > | > | > | X-WBNR-Posting-Host: 64.91.16.201
| > | > | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | > | > | Subject: Keep Group Data Together
| > | > | > | Date: Tue, 2 Nov 2004 18:09:01 -0800
| > | > | > | Lines: 6
| > | > | > | Message-ID:
<B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > | > | > | MIME-Version: 1.0
| > | > | > | Content-Type: text/plain;
| > | > | > | charset="Utf-8"
| > | > | > | Content-Transfer-Encoding: 7bit
| > | > | > | X-Newsreader: Microsoft CDO for Windows 2000
| > | > | > | Content-Class: urn:content-classes:message
| > | > | > | Importance: normal
| > | > | > | Priority: normal
| > | > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | > | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | > | > | Xref: cpmsftngxa10.phx.gbl
| > | > microsoft.public.sqlserver.reportingsvcs:33917
| > | > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | > | > |
| > | > | > | In Access there was a keep together...
| > | > | > |
| > | > | > | How do I make sure data in a group moves to the next page if
it
| > will
| > | > not
| > | > | > fit
| > | > | > | on the current page?
| > | > | > | --
| > | > | > | Thank You, Leo
| > | > | > |
| > | > | >
| > | > | >
| > | > |
| > | >
| > | >
| > |
| >
| >
|

Friday, February 24, 2012

Keep Table Group on Same Page

Keep table as it is..

Keep table as it is..

Keep table as it is..

keep SQL Express while testing SQL Server 2005 trial?

keep SQL Express while testing SQL Server 2005 trial?

keep SQL Express while testing SQL Server 2005 trial?

Keep speed

Keep sp in cache

Keep sp in cache

Keep sp in cache

Keep section of report the same size

Keep Same Virtual Name

Keep running out of memory?

Keep RS awake.

Keep remote SQL data tables updated

keep relationships

Keep registered servers in tact

Keep records that contain certain attributes

Keep records that contain certain attributes

Keep prior select results in the Results pane

Keep package alive forever

Keep only X # of backups when appending to BU file

Keep only X # of backups when appending to BU file

Keep only X # of backups when appending to BU file

Keep one connection open for log

Keep one connection open for log

Keep one connection open for log

Keep object together

Keep Identity

Keep Identity

Keep Identity

Keep group together

Keep Group Together

Keep group rows together

Keep Group Data Together

KDC Problem

Blog Archive

About Me