Transfer filters to classic report from RTC

Roelof
Roelof Member Posts: 377
edited 2014-06-23 in NAV Three Tier
Is it possible to transfer a 'mark' filter to a classic report if the classic report is running from RTC?
I'm trying to run a label print report (yes, with barcodes) in RTC. Since RTC has some difficulties with printing barcodes in RTC I'm using the classic version of the report. The report should run with a filtered table as of MarkedOnly(True). But the table is losing it's filterset when it runs the report.

Note: The report is called from an Item Journal and in classic the call runs just fine. No filters lost.
Version: NAV 2009 SP1.

Thanks,
Roelof
Roelof de Jonghttp://www.wye.com

Comments

  • clausl
    clausl Member Posts: 455
    I don't think this marked filter is supported, when the call is made from RTC to Classic.

    So I think we need to look at upgrading the report. What issues do you have with barcodes in the RDLC report?

    /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 :-)
  • Roelof
    Roelof Member Posts: 377
    Barcodes don't print in RDLC currently. My understanding is that this is going to be fixed in the new version.
    Yes, I figured out that marking records is not supported in RTC. I created a work around by using a physical field on the table as a unique sorting key. That seems to work.
    Roelof de Jonghttp://www.wye.com
  • clausl
    clausl Member Posts: 455
    Barcodes print fine in NAV 2009, you just need to convert your Barcode to a True Type Font, if not already a True Type Font.
    Maybe you are thinking about the issue that fonts are not included in PDF when you save the report as PDF from NAV 2009, Report Viewer 2008.
    So when you share the PDF with others the Barcode is not printed because they don't have your Barcode font installed on their machine.
    Workaround in NAV 2009 is to use a PDF printer i.e. BullZip to have the font included.
    In NAV 2013, Report Viewer 2010 supports embedding fonts =D>
    But barcode printing works just like in NAV 2009, so you should be able to upgrade your report now for NAV 2009.

    /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 :-)
  • Roelof
    Roelof Member Posts: 377
    But is it also printing in RDLC reports that way?
    Roelof de Jonghttp://www.wye.com
  • clausl
    clausl Member Posts: 455
    Not sure what you mean?
    RDLC reports are the reports supported in the RoleTailored client.
    From RTC the Report Viewer is opened and renders the RDLC report when you select "View" on Request Page.

    /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 :-)
  • Roelof
    Roelof Member Posts: 377
    Well, what I want to explain is: barcodes are not able to print in RTC (yet). The latest version of the report designer we use in RTC does not support that. What my understanding is that the next version will support barcode printing. But let me know if I'm wrong.
    Roelof de Jonghttp://www.wye.com
  • clausl
    clausl Member Posts: 455
    Barcode fonts print fine in both NAV 2009 and NAV 2013.

    Example see the report I created here some time ago:http://blogs.msdn.com/b/nav/archive/2011/10/25/embedding-fonts-into-pdf.aspx
    Yes, this report is created in NAV 2013, but I could have created in NAV 2009 as well, but then you would only be able to print the barcodes if you do not have the Barcode font installed on your machine.

    Which Barcode font are you using? Has this been converted to a True Type font?

    /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 :-)
  • Roelof
    Roelof Member Posts: 377
    The barcodes we use in label reports are: 'Free 3 of 9 regular' and 'bc c39 3 to 1 narrow'.
    Roelof de Jonghttp://www.wye.com
  • clausl
    clausl Member Posts: 455
    The "Free 3 of 9" barcode font works perfect in a RDLC report in NAV 2009, see here:

    What exactly is not working for you?

    /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 :-)
  • Roelof
    Roelof Member Posts: 377
    You surprise me. I'll check it out again and let you know. Maybe something else is going on. But this was at least my understanding.
    I'll keep you posted.
    Roelof de Jonghttp://www.wye.com
  • clausl
    clausl Member Posts: 455
    Did you get this working?

    /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 :-)
  • deV.ch
    deV.ch Member Posts: 543
    If you install barcode font's ensure that you restart your machine, otherwise reportviewer will not render them correctly!
    If you use saveaspdf, you need to restart your NST after installing the font! (the whole machine not just NST-Service!)

    I rewrote my barcode solution to create a bitmap just because i wasn't aware of the restart needed and thought the reportviewer is broken!
    (I'am ok with that now, since this solution is able to create different barcode types...)
    My Blog
  • alanda
    alanda Member Posts: 1
    Roelof wrote:
    Is it possible to transfer a 'mark' filter to a classic report if the classic report is running from RTC?
    I'm trying to run a     barcode label print report (yes, with barcodes) in RTC. Since RTC has some difficulties with printing barcodes in RDLC I'm using the classic version of the report. The report should run with a filtered table as of MarkedOnly(True). But the table is losing it's filterset when it runs the report.

    Note: The report is called from an Item Journal and in classic the call runs just fine. No filters lost.
    Version: NAV 2009 SP1.

    Thanks,
    Roelof

    I followed your advice and the guide at
    http://community.dynamics.com/nav/b/arc ... eport.aspx, but I still can not renderbarcode fonts correctly on the RTC reports. Do I need some other configuration?

Categories