2. If we put a textbox in header or footer containing "=Globals!TotalPages" (This property is allowed only in header or footer.), the report will display the total number of pages...

Ok Lynn, Here is the sample data

INSERT INTO [dbo].[tblFlashDrive]([Id],[SizeId],[MakeId],[IssuedTo],[IssuedDate],[Issued] VALUES (1,2,1,900,06/17/2010,'1')

INSERT INTO [dbo].[tblFlashDrive]([Id],[SizeId],[MakeId],[IssuedTo],[IssuedDate],[Issued] VALUES (1,2,1,800,06/17/2010,'1')

INSERT INTO [dbo].[tblFlashDrive]([Id],[SizeId],[MakeId],[IssuedTo],[IssuedDate],[Issued] VALUES (1,2,2,700,06/17/2010,'1')

INSERT INTO [dbo].[tblFlashDrive]([Id],[SizeId],[MakeId],[IssuedTo],[IssuedDate],[Issued] VALUES (1,1,2,800,06/17/2010,'1')

INSERT INTO [dbo].[tblFlashDrive]([Id],[SizeId],[MakeId],[IssuedTo],[IssuedDate],[Issued] VALUES (1,1,1,900,06/17/2010,'1')

GO

INSERT INTO [dbo].[tblFlashDriveMake]([MakeId],[Make]) VALUES...

Ok Lynn, Here is the complete picture.

***********************************************

CREATE TABLE [dbo].[tblFlashDrive](

[Id] [int] NULL,

[SizeId] [int] NULL,

[MakeId] [int] NULL,

[IssuedTo] [int] NULL,

[IssuedDate] [datetime] NULL,

...

Lynn, I have replied to your post. I gave you the modified query with a table and two columns. Pls let me know if you need more details.

Thanks.

Any Clues?

Hi Lynn,

I have made the query simple.

I have given the user an option to select 2 sort order and 2 sortby dropdowns. example: User may select as following sortby/sort...

Hi Lynn,

Here is the query in the stored procedure where @sortorder1,@sortby1, @sortorder2 and @sortby2 are the parameters.

SELECT ...