Cant allocate space

Novice MS SQL User

Dell PowerEdge 2300
NT 4 server SP4
MS SQL Server 6.5

i'm trying to upload 250,000 records

Error : 1105, Severity: 17, State: 2
Can't allocate space for object 'Syslogs' in database 'clearance_data' because the 'logsegment' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.

what i'm planning to do is to add a new hard drive to the server, but HOW?

please help

see attached files (jpeg zip) for
Disk Administration
SQL Server
Devices
Databases
Available space

Thanks in advance(Couldn't read your attached files), but:

You might consider trying some of the following:

Temporarily set the DB 'clearance_data' to truncate on checkpoint until you have loaded your data.

Add or increase the size of the existing transaction log for DB 'clearance_data'.

I assume you are loading 250,000 records into the the DB 'clearance_data'? (If so, try loading fewer records at any one time e.g., load 10 25,000 record data subsets, instead of all 250,000 at once.)

To clear the error 'logsegment' segment is full try: Dump Log 'clearance_data' with Truncate_Only

Finally, RE: " ...add a new hard drive to the server, but HOW?"
What kind of (hardware?) issues are you having with the new hard drive?|||Thanks for the quick response

Finally, RE: " ...add a new hard drive to the server, but HOW?"
What kind of (hardware?) issues are you having with the new hard drive?

please download again the attached file, I used WinZip 8.0

NT Server Setup

4338MB DISK 0 C: - 1083MB Mirror Set E: - 3240 Stripe Set
4338MB DISK 1 C: - 1083MB Mirror Set E: - 3240 Stripe set
4299MB DISK 2 F: - 4299MB Primary Partition

SQL Server Setup
Database devices Data Size Available
clearance_device 5500MB 1290MB
DATA2
master
MSDBData
MSDBLog
Databases
clearance_data
master
model
msdb
pubs
tempdb

if I add, lets say 18GB HD
this will become

18GB DISK 3

can I still add/expand the clearance_device to 18GB more
is this doable?

Thanks again in adavce|||Q1 please download again the attached file, I used WinZip 8.0
Q2 can I still add/expand the clearance_device to 18GB more
is this doable?
A1 This time the error (with the image zip) was "images.zip: Either multipart or corrupt ZIP archive."

A2 You may not actually be able to use 100% of the new volume's free space, (even implementing raw partion devices), but generally, yes.

Note: It appears likely that you have separate devices for both DB Log and DB Data (if so, a good thing). In your particular situation, (if you must perform a single large operation in one step); you must provide the DB LOG sufficient space to complete the operation. Obviously, there must also be sufficient room for the actual DB data itself, as well; so it is possible you may also need to provide additional free data device space to successfully complete your load operation. The reason for mentioning this (in this manner) is that Sql Server 6.x allowed the co-mingling of Log / Data on the same device (generally not a desirable configuration, for a number of reasons).|||I tried downloading the file... yes it was corrupted
I'll try to attached it again
. +------+
4338MB DISK 0 C: - 1083MB Mirror Set | E: - 3240 Stripe Set
4338MB DISK 1 C: - 1083MB Mirror Set | E: - 3240 Stripe Set
. +------+

on those stripe set resides the clearance_data

A2 You may not actually be able to use 100% of the new volume's free space, (even implementing raw partion devices), but generally, yes.

assuming I have installed a new device

how can I configure MS SQL 6.5 to use the new device for clearance_data for expansion

Thanks again

please try to download the new attached file|||RE: Q1 Assuming I have installed a new device, how can I configure MS SQL 6.5 to use the new device for clearance_data for expansion?
Q2 Please try to download the new attached file.

A1 I'm not sure exactly what you are asking (I had assumed hardware mirroring, are you using Sql Server DB mirroring? If so I believe you must break the mirror before altering the DB, then remirror subsequently if possible.). If not, as I recall, you may do everything necessary from Sql EM once the new drive volume is available (visible) to the OS (unless maybe, you have done some intersting things with segments). You could use tsql in isqlw as well, for example: (not tested)

/* Find out the maximum VDevNo (XX): Then XXX = XX + 1 (where XX is the first digit of low byte column data) */

Use Master
Go

exec sp_HelpDevice
Go
Select * From SysDevices
Go

/* G: = 18GB DISK 3*/
/* The following tsql would use half of G for Log and half G for Data: */

Disk INIT
Name = 'Clearance_Data_DataDevG_001',
PhysName = 'G:\MsSql\Data\Clearance_Data_DataDevG001.dat'
VDevNo = XXX,
Size = 4608000 /* 4608000 x 2KB = 9GB */
Go

Disk INIT
Name = 'Clearance_Data_LogDevG_001',
PhysName = 'G:\MsSql\Data\Clearance_Data_LogDevG001.log'
VDevNo = XXX,
Size = 4608000 /* 4608000 x 2KB = 9GB */
Go

/* The following tsql should then Alter the clearance_data DB to use about half of each of the log and data device files created on G. : */

Alter DataBase clearance_data
On Clearance_Data_DataDevG_001 = 4500,
Log On Clearance_Data_LogDevG_001 = 4500
Go

/* - NOTE - */
/* If the above statement fails, then the Log On clause may not be valid to use with Alter Table. In that case, use the following tsql which should work: */

Alter DataBase clearance_data
On Clearance_Data_DataDevG_001 = 4500,
Clearance_Data_LogDevG_001 = 4500
Exec sp_LogDevice 'clearance_data', 'Clearance_Data_LogDevG_001'
Go

A2 The latest file has a zero byte size (downloaded).

Cant "SELECT" using CREATED_DATE column...help

Ok,
What format is this to where I can't find records (that I know are
there) using this date "2005-09-29 23:58:00".
Here is the SELECT that I use that doesn't work:

SELECT * FROM RMA_HEADER
WHERE CREATED_DATE LIKE '2005-09-29%'

Any help is appreciated.
Thanks,
Trintcreate table MY_RMA_HEADER (CREATED_DATE datetime)

insert into MY_RMA_HEADER values(getdate())
insert into MY_RMA_HEADER values(dateadd(hh, -1, getdate()))
insert into MY_RMA_HEADER values(dateadd(hh, -2, getdate()))
insert into MY_RMA_HEADER values(dateadd(hh, -3, getdate()))
insert into MY_RMA_HEADER values(dateadd(hh, 1, getdate()))
insert into MY_RMA_HEADER values(dateadd(dd, 1, getdate()))

-- it will fetch data for 30th Sept. 2005
-- I have used 103 for formatting, u can use other as well, the idea is
to truncate time part
SELECT convert(datetime, convert(varchar, CREATED_DATE, 103)) FROM
MY_RMA_HEADER
WHERE convert(datetime, convert(varchar, CREATED_DATE, 103)) =
convert(datetime, '20050930' )|||On 30 Sep 2005 04:12:28 -0700, trint wrote:

>Ok,
>What format is this to where I can't find records (that I know are
>there) using this date "2005-09-29 23:58:00".
>Here is the SELECT that I use that doesn't work:
>SELECT * FROM RMA_HEADER
>WHERE CREATED_DATE LIKE '2005-09-29%'
>Any help is appreciated.
>Thanks,
>Trint

Hi Trint,

If the Created_Date is of datetime format, then use

SELECT Col1, Col2, ...-- Don't use SELECT * !!!
FROM RMA_Header
WHERE Created_Date >= '20050929'
AND Created_Date < '20050930'

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||>> created_date LIKE '2005-09-29%' <<

Temporal data types are not strings, so you cannot use string functions
on them.

Cannot use global variables in Table Footer

Hi,
I tried to use the global variables "totalpages" in my table footer to decide whether to hide or show if there are no records from the dataset.
But then I found out that global variables can only be used in page header/footer.
Is there any way i could check whether there's records returned, and hence control the visibility.
Thanks.Good Evening!
Right or wrong - but never mind me using stored procs for everything!

For ALL MS RS reports we use stored procedures - for everything...
So in every stored proc we count records in a lot of various ways - but primarily we use in the first line
Select
Count(1) as Expr1 - Expr1 is our indicator that data has been populated within the SQL Select for all records processed (may have some records or not)
You should never use Count(*) anyway because it does another "scan" of the DB to get the result...
So within MS RS the first thing we do is inspect EXPR1 for a value
No Value
Display "Selection Parameters Found No Information For Your Request" in a text box that was added to the Header of the Report
Else
Display the data within MS RS.
The header text box has an IIF condition and we BOLD in RED so it is visible for the users who do not like to read what they are getting
I don't know how to do if the SQL Select was a "TEXT" string versus a stored procedure! Probaly just as easy - I guess....
We have also in a lot of instances where we use a SQL Stored Proc driver which means and it works really nice if you have SELECTS <= 8000 characters...
We already know the fields to populate the MS RS REport so we just take the parameters passed - look up in a table the SQL for the particulare MS RS report and insert the parameters passed by MS RS so we always get a return value(s) from the SQL Stored Proc driver that performs and EXEC for the SQL select we pull from the table and then declare and insert in the SQL script the values the user passed from MS RS.
So the return value from the EXEC is passed back to use and we cast as EXPR1.
I got to "woordy" here - but nevertheless - I would hope that not only for no data from a Select is captured but also other error situations that might occur as well - so you can pass this information back as well especially if your environment is OLTP versus a warehouse...
Best regards



|||

eeyore21,
CountRows(Scope) where Scope is your dataset. ex: Place=IIF(CountRows("MyDataset") = 0, True, False) as Visibility->Hidden->Expession for your object that you want to hide/show based on record count.

Hope this helps,
Mike

|||

Thanks,
It sure helps alot.

Cannot update some records on Sql server 2005

Hi,
I have a problem on updating some records on sql server 2005.
I can update the records in the table apart from some records.
Records are added to table by a .net application.
When I try to update some records on the table (1-2 records ~1500 records) sql server shows "executing query" message but it cannot execute the update query for these records.
on the other records updating query works fine.
Do you have any idea?Question moved to SQL Server forum .

Cannot Update Records that contain NULL Values!

Hi,

I am trying to use a formView with an update button to update individual records in an sql database. (when i click update it doesnt perform the update and just refreshes the page. ) One of the fields in my records is a NULL - this is also one of the fields that i need to update. When i manually go into the database and enter some data, and then go back to my form, it updates fine, but as soon as i delete the data from the field, it returns to NULL and im back to square one.

Any Ideas on how to get around this problem?

THanks

Then what's wrong? Since you delete the data from the field, it should be set to NULL. What do you expect to get after deleting the data? And what's meaing of "im back to square one"|||Fix your update statement. If you've used the wizard with "Check Original Values", then you are correct, it fails with nulls. You have to manually modify the update to handle nulls.|||

yep.. i got it now... i had to change "compare all values" to "overwrite changes". That makes sense. you cant compare null values to each other.

Thanks

Cannot Truncate due to Fks

i read that i can Truncate a table even if child table has no records so i tries to disable constraints but still can't get it to work

Cannot truncate table 'InventoryPC' because it is being referenced by a FOREIGN KEY constraint.

disabling code on lines 9-13 and enabling codes on 36-40

1ALTER PROCEDURE dbo.RevertDB23/* Reverts Database to original "Clean" State */4AS5SET NOCOUNT OFF6DECLARE @.LogAS varchar(MAX), @.RowsInDBAS int7SET @.Log ='RevertDB Started at ' +CAST(GETDATE()AS varchar(50)) +'\n'89/* *** Disable Constraints *** */10ALTER TABLE BookingNOCHECK CONSTRAINTALL11ALTER TABLE InventoryPCNOCHECK CONSTRAINTALL12ALTER TABLE PCNOCHECK CONSTRAINTALL13ALTER TABLE PlatformNOCHECK CONSTRAINTALL1415/* *** Start Truncates *** */16TRUNCATE TABLE Booking17SET @.Log = @.Log +'Trucate Table Booking - Done' +'\n'18SET @.RowsInDB = (SELECTCOUNT(BookingID)FROM Booking)19SET @.Log = @.Log +'-- Rows Affected: ' + CAST(@.@.ROWCOUNT AS varchar(10)) + ', Rows in Table: ' + CAST(@.RowsInDB AS varchar(10)) + '\n'2021TRUNCATE TABLE InventoryPC22SET @.Log = @.Log + 'TrucateTable InventoryPC - Done' + '\n'23SET @.RowsInDB = (SELECT COUNT(InventoryID) FROM InventoryPC)24SET @.Log = @.Log + '-- Rows Affected: ' + CAST(@.@.ROWCOUNT AS varchar(10)) + ', Rows in Table: ' + CAST(@.RowsInDB AS varchar(10)) + '\n'2526TRUNCATE TABLE PC27SET @.Log = @.Log +'Trucate Table PC - Done' +'\n'28SET @.RowsInDB = (SELECTCOUNT(PCID)FROM PC)29SET @.Log = @.Log +'-- Rows Affected: ' + CAST(@.@.ROWCOUNT AS varchar(10)) + ', Rows in Table: ' + CAST(@.RowsInDB AS varchar(10)) + '\n'3031TRUNCATE TABLE Platform32SET @.Log = @.Log + 'TrucateTable Platform - Done' + '\n'33SET @.RowsInDB = (SELECT COUNT(PlatformID) FROM Platform)34SET @.Log = @.Log + '-- Rows Affected: ' + CAST(@.@.ROWCOUNT AS varchar) + ', Rows in Table: ' + CAST(@.RowsInDB AS varchar(10)) + '\n'3536/* *** Enable Constraints *** */37ALTER TABLE BookingWITH CHECK CHECK CONSTRAINTALL38ALTER TABLE InventoryPCWITH CHECK CHECK CONSTRAINTALL39ALTER TABLE PCWITH CHECK CHECK CONSTRAINTALL40ALTER TABLE PlatformWITH CHECK CHECK CONSTRAINTALL4142SET @.Log = @.Log +'*** End Truncates ***' +'\n'43/* *** End Truncates *** */4445/* *** Start Insert Platform *** */46SET @.Log = @.Log +'Start Insert Platform' +'\n'4748EXEC dbo.InsertPlatform'Windows XP SP2 Professional Edition','Some description for Windows XP SP2 Professional Edition over here …'49EXEC dbo.InsertPlatform'Windows Vista Ultimate','See everything you''re working on more clearly with Windows Aero, and quickly switch between windows or tasks using Windows Flip 3D and Live Thumbnails. You can easily find what you need—when you need it―with Instant Search and live icon previews that display the actual contents of your files. And while you''re at it, give your personal productivity a boost with instant access to the information you care about using Windows Sidebar and Gadgets. Put these easy-to-use and customizable mini-applications on your desktop and reveal the information you''re looking for at a glance.\nWebsite: http://www.microsoft.com/windows/products/windowsvista/seeit/default.mspx'50EXEC dbo.InsertPlatform'Apple Mac OS X Tiger','Some description for Apple Mac OS X Tiger over here …'51EXEC dbo.InsertPlatform'Apple Mac OS X Leopard','Desktop: The new look of Leopard showcases your favorite desktop image and puts new file Stacks at your fingertips for a stunning, clutter-free workspace.\nFinder: Browse your files like you browse your music with Cover Flow.\nTime Machine: See how your system looked on any given day and restore files with a\nWebsite: http://www.apple.com/macosx/leopard/features/'52EXEC dbo.InsertPlatform'Red Hat Linux','Some description for Red Hat Linux over here …'5354SET @.Log = @.Log +'Rows In Platform: ' + (SELECTCOUNT(PlatformID)FROM Platform) +'\n'55/* *** Start Insert PC *** */56SET @.Log = @.Log +'Start Insert PC' +'\n'5758DECLARE @.WinXPint, @.WinVistaint, @.OSXTigerint, @.OSXLeopardint, @.RedHatint59SET @.WinXP = (SELECT PlatformIDFROM PlatformWHERE Title ='Windows XP SP2 Professional Edition')60SET @.WinVista = (SELECT PlatformIDFROM PlatformWHERE Title ='Windows Vista Ultimate')61SET @.OSXTiger = (SELECT PlatformIDFROM PlatformWHERE Title ='Apple Mac OS X Tiger')62SET @.OSXLeopard = (SELECT PlatformIDFROM PlatformWHERE Title ='Apple Mac OS X Leopard')63SET @.RedHat = (SELECT PlatformIDFROM PlatformWHERE Title ='Red Hat Linux')6465EXEC dbo.InsertPC'Fusion PC One','Description here ...','Intel Core2 Duo E6600 2.4 GHz 1066MHz','1GB Dual Channel DDR2 667 SDRAM','120GB SATA2 NCQ HDD','NVIDIA GeForce 8600 256MB GDDR3','22" 3000:1 Wide Screen LCD', @.WinXP66EXEC dbo.InsertPC'Fusion PC Two','Description here ...','Intel Core2 Duo E6850 3 GHz 1333MHz','2GB Dual Channel DDR2 800 SDRAM','240GB SATA2 NCQ HDD','NVIDIA GeForce 8800 Ultra 256MB GDDR3 SLI','24" 3000:1 Wide Screen LCD', @.WinVista67EXEC dbo.InsertPC'Fusion PC Three','Description here ...','AMD Athlon 64 X2 Dual Core 6000+ 3 GHz','2GB Dual Channel DDR2 667 SDRAM','240GB SATA2 NCQ HDD','ATI Radeon Cross Fire 2900 256MB GDDR3','24" 3000:1 Wide Screen LCD', @.WinVista68EXEC dbo.InsertPC'Fusion X1','Description here ...','Intel Core2 Extreme Q6850 3 GHz 1333MHz','6GB Dual Channel DDR2 800 SDRAM','500GB SATA2 NCQ HDD','NVIDIA GeForce 8800 Ultra 256MB GDDR3 SLI','30" 3000:1 Wide Screen LCD', @.OSXLeopard69EXEC dbo.InsertPC'Fusion X2','Description here ...','AMD Athlon 64 FX 74 3 GHz','6GB Dual Channel DDR2 800 SDRAM','500GB SATA2 NCQ HDD','NVIDIA GeForce 8900 Ultra SLI 256MB GDDR3','30" 3000:1 Wide Screen LCD', @.WinVista70EXEC dbo.InsertPC'Fusion Tiger 1','Description here ...','Intel Core2 Duo E6600 2.4 GHz 1066MHz','2GB Dual Channel DDR2 800 SDRAM','120GB SATA2 NCQ HDD','NVIDIA GeForce 8600 256MB GDDR3 SLI','22" 3000:1 Wide Screen LCD', @.OSXTiger71EXEC dbo.InsertPC'Fusion Linux 1','Description here ...','AMD Athlon 64 X2 6000+ 3 GHz','1GB Dual Channel DDR2 800 SDRAM','120GB SATA2 NCQ HDD','NVIDIA GeForce 8600 256MB GDDR3','22" 3000:1 Wide Screen LCD', @.RedHat7273SET @.Log = @.Log +'Rows In PC: ' + (SELECTCOUNT(PCID)FROM PC) +'\n'7475/* *** Start Insert Inventory *** */76SET @.Log = @.Log +'Start Insert Inventory' +'\n'7778DECLARE @.F1int, @.F2int, @.F3int, @.FX1int, @.FX2int, @.FT1int, @.FR1int79SET @.F1 = (SELECT PCIDFROM PCWHERE Title ='Fusion PC One')80SET @.F2 = (SELECT PCIDFROM PCWHERE Title ='Fusion PC Two')81SET @.F3 = (SELECT PCIDFROM PCWHERE Title ='Fusion PC Three')82SET @.FX1 = (SELECT PCIDFROM PCWHERE Title ='Fusion X1')83SET @.FX2 = (SELECT PCIDFROM PCWHERE Title ='Fusion X2')84SET @.FT1 = (SELECT PCIDFROM PCWHERE Title ='Fusion Tiger One')85SET @.FR1 = (SELECT PCIDFROM PCWHERE Title ='Fusion Linux One')8687EXEC dbo.InsertInventory 10, @.F1, 2.5,'iCluster Fusion One'88EXEC dbo.InsertInventory 10, @.F2, 2.5,'iCluster Fusion Two'89EXEC dbo.InsertInventory 10, @.F3, 2.5,'iCluster Fusion Three'90EXEC dbo.InsertInventory 6, @.FX1, 6,'iCluster Fusion X1'91EXEC dbo.InsertInventory 6, @.FX2, 6,'iCluster Fusion X2'92EXEC dbo.InsertInventory 10, @.FT1, 3,'iCluster Fusion Tiger One'93EXEC dbo.InsertInventory 30, @.FR1, 2,'iCluster Fusion Linux One'9495SET @.Log = @.Log +'Rows In Inventory: ' + (SELECTCOUNT(InventoryID)FROM InventoryPC) +'\n'9697RETURN @.Log98

When the Forigen Keys are exist the Truncate statement will not be executed on the master table, even it is disabled.

You have 2 options,

Option 1: Use Delete From <table name> & disabled constraint

Option 2: Drop the FK on the child table, use the truncate statement then recreate the FK on your child table.

Cannot see all records in report

Ok..
On the data tab I can see 6 rows of data returned from a sproc
When I input these same parameters onto the report (preview) I can only see
the first or last record depending on the following:
=First(Fields!Year.Value) - gives me first
=(Fields!Year.Value) - also gives me first (I thought this would give me all
values)
=Last(Fields!Year.Value) - gives me last
I just threw the field on the report inside a rectangle which I have set to
put a page break after.
For simplicity, assume I only have to print the year on each page.. how do I
do that? At the moment, I can only print 1.
Tx
LesYou need to put a list control or a table control. What you are doing will
only show one record.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LesWright" <LesWright@.discussions.microsoft.com> wrote in message
news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> Ok..
> On the data tab I can see 6 rows of data returned from a sproc
> When I input these same parameters onto the report (preview) I can only
> see
> the first or last record depending on the following:
> =First(Fields!Year.Value) - gives me first
> =(Fields!Year.Value) - also gives me first (I thought this would give me
> all
> values)
> =Last(Fields!Year.Value) - gives me last
> I just threw the field on the report inside a rectangle which I have set
> to
> put a page break after.
> For simplicity, assume I only have to print the year on each page.. how do
> I
> do that? At the moment, I can only print 1.
> Tx
> Les|||Thanks Bruce for your reply.
To confirm, you're saying that if I want the information pertaining to one
record to occupy 1 page, I need to add a list or table and design that to
occupy one page, with a page break for the next record?
Tx
Les
"Bruce L-C [MVP]" wrote:
> You need to put a list control or a table control. What you are doing will
> only show one record.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> > Ok..
> > On the data tab I can see 6 rows of data returned from a sproc
> > When I input these same parameters onto the report (preview) I can only
> > see
> > the first or last record depending on the following:
> >
> > =First(Fields!Year.Value) - gives me first
> > =(Fields!Year.Value) - also gives me first (I thought this would give me
> > all
> > values)
> > =Last(Fields!Year.Value) - gives me last
> >
> > I just threw the field on the report inside a rectangle which I have set
> > to
> > put a page break after.
> >
> > For simplicity, assume I only have to print the year on each page.. how do
> > I
> > do that? At the moment, I can only print 1.
> >
> > Tx
> > Les
>
>|||If you want one record per page then you want to have a list, have a group
with a page break to force one record per page.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LesWright" <LesWright@.discussions.microsoft.com> wrote in message
news:96A788F1-337C-4712-8094-2DA68FC192F7@.microsoft.com...
> Thanks Bruce for your reply.
> To confirm, you're saying that if I want the information pertaining to one
> record to occupy 1 page, I need to add a list or table and design that to
> occupy one page, with a page break for the next record?
> Tx
> Les
> "Bruce L-C [MVP]" wrote:
>> You need to put a list control or a table control. What you are doing
>> will
>> only show one record.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
>> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
>> > Ok..
>> > On the data tab I can see 6 rows of data returned from a sproc
>> > When I input these same parameters onto the report (preview) I can only
>> > see
>> > the first or last record depending on the following:
>> >
>> > =First(Fields!Year.Value) - gives me first
>> > =(Fields!Year.Value) - also gives me first (I thought this would give
>> > me
>> > all
>> > values)
>> > =Last(Fields!Year.Value) - gives me last
>> >
>> > I just threw the field on the report inside a rectangle which I have
>> > set
>> > to
>> > put a page break after.
>> >
>> > For simplicity, assume I only have to print the year on each page.. how
>> > do
>> > I
>> > do that? At the moment, I can only print 1.
>> >
>> > Tx
>> > Les
>>|||Thanks Bruce.
Les
"Bruce L-C [MVP]" wrote:
> If you want one record per page then you want to have a list, have a group
> with a page break to force one record per page.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> news:96A788F1-337C-4712-8094-2DA68FC192F7@.microsoft.com...
> > Thanks Bruce for your reply.
> >
> > To confirm, you're saying that if I want the information pertaining to one
> > record to occupy 1 page, I need to add a list or table and design that to
> > occupy one page, with a page break for the next record?
> >
> > Tx
> > Les
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You need to put a list control or a table control. What you are doing
> >> will
> >> only show one record.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> >> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> >> > Ok..
> >> > On the data tab I can see 6 rows of data returned from a sproc
> >> > When I input these same parameters onto the report (preview) I can only
> >> > see
> >> > the first or last record depending on the following:
> >> >
> >> > =First(Fields!Year.Value) - gives me first
> >> > =(Fields!Year.Value) - also gives me first (I thought this would give
> >> > me
> >> > all
> >> > values)
> >> > =Last(Fields!Year.Value) - gives me last
> >> >
> >> > I just threw the field on the report inside a rectangle which I have
> >> > set
> >> > to
> >> > put a page break after.
> >> >
> >> > For simplicity, assume I only have to print the year on each page.. how
> >> > do
> >> > I
> >> > do that? At the moment, I can only print 1.
> >> >
> >> > Tx
> >> > Les
> >>
> >>
> >>
>
>