Options

RDLC to RDL conversion

thankeshthankesh Member Posts: 170
Dear pals,

What are all the easy ways to convert nav rdlc(client side) to rdl(sql serverside) report? I would like to run the :"Aged Accounts Payable" (ID - 322) as rdl. [-o<
With warm regards,

Thankesh

***Learn to lead***

Comments

  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,504
    report 322 is already transformed to rdlc..check in Cronus database of 6.0SP1
  • Options
    ara3nara3n Member Posts: 9,256
    It's not possible. It's not the RDL data that is hard but the SQL Statement (Query) that will return the data for you.
    You have to manually write the sql statement to return the dataset.

    I have done this for Inventory Valuation report.

    http://mibuso.com/blogs/ara3n/2009/07/0 ... amics-nav/


    So you have to do the same. The RDL part is easy to develop.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    thankeshthankesh Member Posts: 170
    report 322 is already transformed to rdlc..check in Cronus database of 6.0SP1


    Dear Mohana,

    I need the report 322 in rdl format not in rdlc, I searched in msn but, the query (sql script) is missing and so the fetching the dataset for the rdl report could not show the report preview. From my point of view about changing rdlc to rdl, we can use the layout of the report alone from rdlc. But, the query strings has to be written manually in SQL to produce the dataset for the report.

    Dear Rashed,

    Thank you so much for your reply.


    Is there any other way/tool to automate the conversion of rdlc to rdl report?
    With warm regards,

    Thankesh

    ***Learn to lead***
  • Options
    ara3nara3n Member Posts: 9,256
    No, I'm afraid there isn't.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    thankeshthankesh Member Posts: 170
    Is it possible to get the dataset from the sql query scripts from "sql profiler" while running the report (322) in classic client for converting rdlc to rdl report?
    With warm regards,

    Thankesh

    ***Learn to lead***
  • Options
    ara3nara3n Member Posts: 9,256
    Nav does multiple calls to sql server. It creates sql pointers and then loops through them. to get the data out. It will be much harder to to decipher it.

    I think the easiest way to do is design the nav report. See how the CAL is written and translate that to sql query.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.