http://reddymsbitools.blogspot.com

Saturday, 26 February 2011

Fixing Number Of rows while rendering the report into excel Report

Def:- After rendering the report into excel you want to show 100 records in each and every sheet
Create the dataset
SELECT ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, ProductModelID, SellStartDate, SellEndDate, DiscontinuedDate, rowguid, ModifiedDate
FROM Production.Product
Create the group
on group exression =ceiling(rownumber(nothing)/100)

No comments:

Post a Comment