July 14, 2010 at 11:25 am
Hi ,
Need some quick help . Thanks in advance. I am designing a report (sql server reporting services 2005) wherein i have to change the Border style based on if it is the Last line/rownumber/record on the current page . I am not sure how to programmatically determine the last line. Any help is highly appreciated.
July 15, 2010 at 2:23 am
Hi,
please make ur question more clear.. so that ll try to help u...
i understood that u want to find the last record for the current page in ur report ??? / or u want to find the last record in ur report ???
Regards,
Gayathri 🙂
July 15, 2010 at 3:38 am
Hi,
just give fixed no of rows for a page.. Say for example 25 records per page
=ceiling(RowNumber(nothing)/25), then
in border style property , give the expression
=iif(rownumber(nothing) = 25,"Solid","Dotted").
check your post in msdn... 🙂
Regards,
Gayathri 🙂
July 15, 2010 at 7:26 am
Hi,
Thanks for the response. I need the last record for the current page in the report not the total report.
Hard coding the no of records may not work since the same report should be able to display the invoice for an individual order as well as combined multiple orders.This complicates the choice of the no of records per page as the number of records may be lesser than the specified records per page for an individual order.Even for a combined invoice , ther will be at least one page where the number of records will be lesser than specified.The only way i can guarantee correct behaviour is by determing the last line programmatically.
I did try the additional footer solution which seemed promising but the result was not satisfactory since rectangle/box was being displayed instead of a singl line. Thanks again for your assistance.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply