Detail Section Limit Records

Hi,

I have limited my detail section output to print 20 records per page, but if have total of 108 records ,First 100 records are printing 5 pages and the 6 thpage prints 8 records .

I want that the 6 th page to print 8 records , plus 12 lines filled with dashes (---).Making the page to appear having 20 lines .

Can anybody help

thanks
ShaliniI had resolved something like that by modifying the data source, I mean, generating the extra lines when writing the output file

Detail information within other detail (different table)

I have a one page report that prints information from several tables. The
report contains a list object slightly smaller than the body size (8X10.5)
and a rectangle object slightly smaller than the list object. The rectangle
object contains 130 plus textboxes for labels and actual fields to be
printed. This is a profile type report used to print all information for a
member (name, address, city, state, and several other fields) and requires
the whole page. There can be further detail linked to this member. In this
case, committees that the member serves on. I can't figure out how to get the
top 5 committees to print with all of the other detail. Does anyone know a
"best method" to accomplish this?
Thanks,
JohnNevermind. Finally used a subreport which solved the problem very nicely.
John
"John Joslin" wrote:
> I have a one page report that prints information from several tables. The
> report contains a list object slightly smaller than the body size (8X10.5)
> and a rectangle object slightly smaller than the list object. The rectangle
> object contains 130 plus textboxes for labels and actual fields to be
> printed. This is a profile type report used to print all information for a
> member (name, address, city, state, and several other fields) and requires
> the whole page. There can be further detail linked to this member. In this
> case, committees that the member serves on. I can't figure out how to get the
> top 5 committees to print with all of the other detail. Does anyone know a
> "best method" to accomplish this?
> Thanks,
> John

Desupport dates

Is the a page online that lists any desupport dates for
the various versions of SQL Server (v7, 2000 etc)http://support.microsoft.com/defaul...en-gb;lifeprods
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:b62101c407bb$afa9b4f0$a401280a@.phx.gbl...
> Is the a page online that lists any desupport dates for
> the various versions of SQL Server (v7, 2000 etc)

Design question related to Grouping

Hello,

I am using SQL 2005 Reporting Services to create a user status report. Each page of the report will contain information about 1 user.

On a single page, there are 4 different views of the data (pulling from different tables). Ideally, I would like to group the data (by user for each page, then by category for each of the 4 views on the page). I grouped by user, and the separate pages came out fine. But attempting to group by category, I found that the grouping applies to all the data...and I only want to group a subset of the data.

Is this possible? Will I need to nest select statements to make it happen? Is there a better way to approach this?

Go easy on me...I'm new to this.

Thanks,
Davidi think what your looking for is an outer join.
select * from table1 1
left outer join table2 2 on 1.column = 2.column

design of a process

I'm going to design a web page for students parking permit application.I'm new to asp.net, I have a process in mind doing it like this:

The form asks student to choose a permit type, then fill in applicant info, like name, grade, vehicle info, student may have 2 vehicles, and payment method, check or credit card,

I plan to create 3 tables like tblPermit, tblapplicant, tblVehicle.

After the students fill in the form, click submit button, I pass the values and call a stored procedure, some thing like this.Dim CmdAsNew Data.SqlClient.SqlCommand(MySQL, MyConn)

Cmd.CommandType = Data.CommandType.StoredProcedure

Then in the stored proceudre, I will do :

Begin

insert into Permit table, then get permitID, by using something like this:

Select @.PermitID=@.@.Identity

Then insert into Student table,then use

Select @.StudentID=@.@.Identity

Then insert into vehicle table.

All the above 3 processes I put it in begin, end--So that they will not messed up with other applicants data.

I think begin...end is one transaction.

SO am I doing correctly this way? Thanks

Begin...End doesn't signify a transaction, it signifies a code block. The idea is basically correct, but use SELECT @.PermitID=SCOPE_IDENTITY() instead. You should also wrap the whole thing in a transaction to be safe.

|||

So shall I use something like this:

AS
Begin

Begin transaction
Set NoCount on
DECLARE @.PermitID INT
Insert table............

Commit Transaction

End

Can I use the begin transaction ...commit transaction in Begin ......end, or no need of begin..end.

Thanks