Print Captions in RDLC Report

navuser1navuser1 Member Posts: 1,329
edited 2012-09-18 in NAV Three Tier
Dear Sir,

How to print Proper Caption into a Table footer when first.fields( name ) and Last.fields( name ) unable to do the same ??

Note : NAV 2009 R2 IN Version

Thanks!
Now or Never

Comments

  • clauslclausl Member Posts: 455
    If possible I would change the dataset so I would get them in the last row and then just use Last(Field!XXXXX.Value). This might be the easiest.

    If this is not possible you will need to create 2 groups in the table, and then on the second group filter out all the blank rows in current scope.
    This way you now only have lines which you need in your footer. And you can use First(Field!XXXXX.Value) or Last(Field!XXXXX.Value), result will be the same in your example, so just forget about First and Last and provide the Field!XXXXX.Value.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • navuser1navuser1 Member Posts: 1,329
    Actually this report( Preprinted Format ) is made for Classic Client as well as RTC and the Blank spaces (at bellow) are programmatically created for the Layout adjustment.
    I want to print all the data which are in the "About this report" to maintain proper Printout and I do these thing with a single Table in the RDLC Layout.
    I am using MAX function to handle my current query.
    I think if I'll take more than one table it would be easier to handle.

    BTW, thank for your reply and waiting for more promising and optimizing reply on my current scenario from your Side.
    Now or Never
Sign In or Register to comment.