Reporting Issue

brijlesh.pbrijlesh.p Member Posts: 32
hi,
I want to create a report inwhich no. of rows and cols. changes at runtime.
and I think this is not possible in navision.
So, I want to use Crystal Report for this.
Can anybody tell me how I import or use Crystal Report Component with Navision?
Thanks [-o< [-o< [-o< [-o< [-o< [-o<
Brijlesh Pandey

Comments

  • DaveTDaveT Member Posts: 1,039
    Hi brijlesh.p,

    It is difficult to give you a full answer without the background but here goes.....
    I want to create a report inwhich no. of rows and cols. changes at runtime.
    and I think this is not possible in navision.

    You can create multiple sections and display the section with the correct no. of columns depending on the report type e.g. CURRREPORT.SHOWOUTPUT( Myoption = 1 ); - see the invoice report
    The rows can be controlled with a CURRREPORT.SKIP in the data item.
    So, I want to use Crystal Report for this.
    Can anybody tell me how I import or use Crystal Report Component with Navision?

    Again a number of options here. You can using SQL ODBC or NODBC depending on the database and write you Crystal report externally. These can be called by Nav as hyperlinks or calling automations. Search the forum and you will find a lot of post e.g.

    http://www.mibuso.com/forum/viewtopic.p ... tal+report

    Hope this helps
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
Sign In or Register to comment.