RDLC / RDL report - How to determine last row in Tablix/Table

we need to use Count() and RowNumber() functions to check the last row

 Count() function returns total number of given dataset. 

 RowNumber() function returns current row number

 Finally, 

 = iif (COUNT(Fields!EntityID.Value,"DatasetName") = RowNumber("DatasetName"), "Solid","Default")

 Click the cell in the table row and select the bottom expression



Bottom expression

Result: first column is showing bottom line with each cell but second column is only showing column with the last cell.












Comments

Asif Iqbal said…
Hi Faraz,

The article was nice. However, is there any way to dtermine the last row in a page, rather than the last row in the entire result?

Thanks in advance,
Asif
3 November 2012 at 15:50
Ali Faraz said…
Hi, I think its not straight forward to know the last row of the page but you can use different workaround like custom paging. Display 10/20/25 rows per page so you will know which is the last row.
5 November 2012 at 08:38
Asif Iqbal said…
Thanks for the reply. Actually my problem is that I want to force a border on the table at the end of each page, even if that is not the end of the group. I don't want to show borders on each row, only at the end of a group. However, when a groupspans multiple pages, the bottom of the table in the first page remains open, which looks ugly. That's why I was trying to locate the last row on a page and set an expression for the bottom border or something like that. Do you have any idea for that ?
5 November 2012 at 15:15
Ali Faraz said…
I have not come across anything like this before. I can recommend you one thing (I can't check it at the moment as I am extremely busy). I remember that we can give subtotals at the end of each page. Check that how can we give subtotal at the end of each page. And what you can do is show the subtotal line with empty values and give border style to that subtotal line.
5 November 2012 at 15:27
Ali Faraz said…
Right. drop a tablix. right click on the Textbox and then 'Add total' > below. reduce the height of the row. give top border. i hope it will be helpful.
5 November 2012 at 15:51
Asif Iqbal said…
Thanks Faraz, that worked like a charm !!
5 November 2012 at 17:32
Ali Faraz said…
Brilliant. I am glad it worked.
5 November 2012 at 17:38
Post a Comment

Popular posts from this blog

GOOGLE privacy policy New Rule 1 March 2012 (How to turn the settings off to stop sharing your personal information)

Image
Google has implemented new privacy policy from 1st March 2012. The change means private data collected by one Google service can be shared with its other platforms including YouTube, Gmail and Blogger.   Take following steps to limit Google's ability to track and record your every move online. What this mean is that while Google will continue gathering and storing information about web history it will make all data anonymous. Google will not associate your web history information with your online account. Follow the following steps 1. Go to the Google homepage and sign into your account. 2. Click the drop-down menu next to your name in the upper-right hand corner of your screen. 3. Click accounts settings 4. Find the "Services section" 5. Under "Services" there is a sub-section that reads "View, enable, disable web history." Click the link next to it that reads: "Go to Web History."  (Note: When you click "Go to We...
Read more

Specializing Your Skills: Postgraduate Studies to Enhance Career Prospects

Image
Specializing Your Skills: Postgraduate Studies to Enhance Career Prospects In today's competitive job market, having specialized skills can greatly enhance your career prospects. One way to acquire these skills is through postgraduate studies in fields such as Business Management & Tourism. Obtaining a postgraduate degree in Business Management & Tourism can open up a world of opportunities for you. It not only deepens your knowledge and understanding of the industry but also equips you with the necessary tools and expertise to excel in your chosen career path. With a specialized degree, you become more attractive to potential employers who are seeking candidates with advanced knowledge and skills in the field. This can give you a competitive edge over other job applicants and increase your chances of securing high-level positions with greater responsibilities and higher salaries. Moreover, postgraduate studies provide you with ample networking opportunities, allowing you t...
Read more