RDLC to RDL conversion

thankesh

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<

mohana_cse06

report 322 is already transformed to rdlc..check in Cronus database of 6.0SP1

ara3n

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.

thankesh

mohana_cse06 wrote:

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?

ara3n

No, I'm afraid there isn't.

thankesh

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?

ara3n

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.