Reporting question (RDLC) - invoice

Nav7User
Nav7User Member Posts: 3
edited 2014-04-03 in NAV Three Tier
Hello,
i try to design a report (invoice) which should have following behaviour:

If the customer gets a line discount for a specific item, the line (position) should get a second line.

For example the invoice has 4 item-lines, for the 3rd line he get's a discount with 10%,
then a line should be inserted (between line 3 and 4) with the discount percentage and the discount amount.

What do i have to change in the tablix? Insert a row / group / group hiden property? With which setting?
I hope, that i get a tip, otherwise i'll go crazy...

Best regards
Nav7User

Comments

  • clausl
    clausl Member Posts: 455
    Maybe me, but why can you not just use the standard functionality in 206, where Line Discount is a column and the Amount column shows the discount amount?

    /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 :-)
  • Nav7User
    Nav7User Member Posts: 3
    I know, that would be the normal / comfortable way.
    But it is a question of place (description column is broad) and dedicated whish of the Manager ;-))
    /Nav7User
  • clausl
    clausl Member Posts: 455
    Then I suggest that you create a couple of new rows and change the visiblity based on the Discount.

    I have modified Report 206 the Danish version since this was close at hand, if you cannot compile, just use the offline files.

    I have modified the rows with the color LightBlue and LigtGreen. LightBlue is the existing row, and LighGreen are the new rows.
    So no need to create any new grouping.

    You can find the objects here on my OneDrive: http://1drv.ms/1dPByvu

    If you need the OfflineProject for NAV 2013 R2, please find this here on my OneDrive: http://1drv.ms/1dPCn7z

    /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