Visual Studio Report Designer question

bknopp
bknopp Member Posts: 37
edited 2014-06-20 in NAV Three Tier
Hi all,

I have a "can I do this, and if so, how do I do it?" question.

I have a customer on NAV 2013 - all the reports are RDLC format. They have a customized Order Confirmation report that eats a lot of paper, due to wasted space. The report has a "bill to" and "ship to" section that the customer wants to print only on the first page, and a totals section that the customer wants printed only on the last page.

So far, I can do all that.

The customer also wants the intermediate pages to print detail lines in the areas that aren't being used by the "bill to", "ship to", and totals sections. I can't figure out how to tell the report engine "If you're on page 1, use this area of the page for the 'bill to' and 'ship to'; otherwise, use it for detail lines" and "if you're on the last page, use this area of the page for totals; otherwise use it for detail lines".

Any suggestions?

Answers

  • kine
    kine Member Posts: 12,562
    I have hit this already and there is no solution for the "header on first page is different than on the second and third...". This was easy in classic report, but impossible in RDLC. I never find out how to do that, even with Claus help... there are some problems each time like something is not updated when already set (like visibility of the header) etc.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Miklos_Hollender
    Miklos_Hollender Member Posts: 1,629
    @kine is it possible to solve if you make a rule that users cannot print multiple orders in one go? (Or make a tool that runs the report on each header record individually) ? In that case you could use _actual_ headers, not fake headers...
  • SiSt
    SiSt Member Posts: 46
    It is possible to print the ship-to and bill-to information on the first page only. You have to move it to the body of the rdlc layout, and create an additional list with the correct grouping (document number, copy) around everything, so that the header is only shown at the start of each document and copy.
    Simon Stoye
    http://www.sist.biz/en/ [en] | http://www.sist.biz [de]
  • clausl
    clausl Member Posts: 455
    This can easily be done if you redesign the report not to use Page Header.

    In this video I explain the concept you need to implement:
    http://www.youtube.com/watch?v=AZAGzCshKo0

    /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 :-)

Categories