@thom-2 A Actually it is. I was trying to post in correct section to Forum. I still haven't solved Page break issue yet.

@david-2, I will try...

I was unable to use Pagebreak (in rectangle, I use "Page break before"). That rectangle is in footer. I've applied but it is not showing the break so it can't...

Thank you. How about date time datatype? What are we supposed to give the as datatype when adding empty rows?

ALTER PROCEDURE [dbo].[uspInvoiceLines]

(

--@InInvoiceNbr int

@InLinesPerPageint

)

AS

DECLARE @TotalRows int

DECLARE @Remainder int

DECLARE @NumPages int

DECLARE @NextPageRows int

set @TotalRows= 0

SELECT

ROW_NUMBER() OVER( ORDER BY InvProduct)as InvoiceRow,

CoID,

InvNo,

InvProduct,

InvDesc,

InvQuantity,

InvUOM,

InvUnitPrice,

...

Hi This is my DDL

CREATE TABLE [dbo].[Invoice_Products](

[CoID] [int] NULL,

[InvNo] [int] NULL,

[InvProduct] [nvarchar](255) NULL,

[InvDesc] [nvarchar](255) NULL,

[InvQuantity] [int] NULL,

[InvUOM] [nvarchar](50) NULL,

[InvUnitPrice] [decimal](4, 2) NULL,

[InvAmt] [decimal](5, 2) NULL,

) ON [PRIMARY]

And Here is my...

I mean I can't start up the service.

John, Why you think it will perform badly? Can you elaborate more for your script. I need to loop because I have to add blank rows to those with no...

Yup, I realised it is the only way to make a new dataset with formatted values , and call it from there. After that wrapped inside an empty table,setting...

But, I couldn't limit the number of columns yet.

Row number limiting is not working in matrix, moreover ?

I want to have total 7 columns (including the header column). If it...

I am getting it finally.

I have to remove Group in Row, after that it display nicely for displaying subtotals.

But, I couldn't able to limit the number of columns. Any...

My Table details are a little different what the above post.

CREATE TABLE [dbo].[Details](

[CategoryID] [nvarchar](20) NULL,

[Quantity] [int] NULL,

[Vol] [decimal](6, 3) NULL

) ON [PRIMARY]

GO

Where I am using Vol as subtotals( instead of...

Thank you. But how can I do without touching my dataset?

Alright Thanks for the info as well as the reminder. ThomA~. It is quite risky. I choose not to do it without network admin ,rather , I will try to...

Thanks for letting me know where to start for this case. Unfortunately, I have no access to Router setting and Network person was no where to be found in my...

Have already enabled Window Authentication and SQL Server and Window Authentication mode. I’ve resolved it. the problem is PDB file failure. After refreshing the file, it starts loading properly.