* sorry I mean embedded coding( custom coding)

Hello tindong,

Thanks for your response, but I am getting error when running,

COUNTROWS is not declared . It may be due to its protection level.

By the way can...

helloo?:(

Thank you guys for trying to help me out. But I would like to ask more, how about not changing any data in SQL level , and only dealing with...

😀 Thanks for highlighting.

It is when I try to export to PDF.

Hi

I am getting error when trying to run your script.

Help pls.

So far I have managed to have the groupings correct (without SQL edit, done in report level only) , but I have no idea how to add blank lines to...

Thanks. Nice Information obtained.:-)

Hope this time it is working.

CREATE Table Data_Details(

HallNo INT,

ItemCode nvarchar(255),

ItemName nvarchar(255),

Location nvarchar(255),

LotNumber nvarchar(255),

Zone nvarchar(50),

Quantity INT,

Remark nvarchar(255),

GrossWeight decimal(6,3),

Zone_Abbr nvarchar(50)

);

INSERT into Data_Details VALUES (8520376,'7BRUSUP15X-1E','MonaLisa','#OU','1302150016','002/1','1','Auction',0.756,'S');

INSERT into Data_Details VALUES (8520376,'7BRUSUP1XX-1E','The Night Watch','#OU','1302150015','002/1','1','Auction',0.504,'S');

INSERT into Data_Details VALUES (8520376,'7BRUSUP1XX-1E','The Night Watch','#OU','1302150015','001/1','1','Auction',0.504,'S');

INSERT into...

Thank you.

I am aware that I should be providing the data in correct way, if I want to be helped.

I am trying using the links inside the page. Still...

You can't have make custom page without SQL when you have more than one group. Cannot use row limit or whatsoever, as far as I have researched. Easily can limit/or...