Share
ReportHi
I want to fix no of rows in Body in Sales Quotation Document. I want only 12 rows to print . If it is more than 12 then on next page and so on.
Thanks
*This post is locked for comments
You’re offline. This is a read only version of the page.
3,027
Hi
I want to fix no of rows in Body in Sales Quotation Document. I want only 12 rows to print . If it is more than 12 then on next page and so on.
Thanks
*This post is locked for comments
Hi Yogesh
Can u little guide how to use integer DataItem. Currently i have Sales Header & Sales Line as DataItem
Thanks
Hi.
You need to write =CEILING(RowNumber(Nothing)/12) where 12 is the number of records to be displayed per page. You can refer below links.
www.mssqltips.com/.../display-a-fixed-number-of-rows-per-page-for-an-ssrs-report
mohana-dynamicsnav.blogspot.in/.../fixed-no-of-lines-in-nav-2013-rtc.html
You can write function on rdlc report layout using code window and control the no of rows to br printed on report
You can make use of the Ceiling and RowNumber as suggested by Suresh Sir.
Or you can make use of Integer Dataitem.
Write a code to maintain a number to display blank lines on layout (12 - no of lines getting printed).
Adjust your code to consider if Sales Lines are more than 12.
In Layout just add another BodyLine to iterate for specific number of blank lines to print on.
-Yogesh Kulkarni
Please verify, if you find answer helpful.
You need to create a group and use Ceiling and RowNumber function, check the below link
www.sqlchick.com/.../displaying-fixed-number-of-rows-per-ssrs-report-page.html
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (