Small and medium business | Business Central, N...

Options to convert C/AL to AL report

(0) Share

Report

Posted on by InsertX

450

So in standard BC14 there is a report "Customer - Balance to Date" (ID 121). Now i copied the layout file in the hope to modify it to my own wishes. Now also i copied the C/AL file of the report and attempted to manually convert it to an AL file. Now thinking this would all be in order i wanted to test it first without chaning anything about the layout. With that i kept getting errors that some captionfields don't exist, i don't know the exact reason since the message was vague to me. Now those captions that it gave errors about, i removed those from the layoutfile so those errors were gone.

Now through an evensubscriber is replaced the default report with my own.

Now when i run this report the result isn't what i was hoping for, left is the default report, right is the one i "created":

So i was wondering unless there is a simple solution,

Is there a way to convert the C/AL report to an AL one using a tool or so to make sure i don't make any mistake when converting it and i also would technically be able to use the default layout it copied?

Thanks in advance.

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Robert B. 257 on at

Like (0)

Report

Hi InsertX,

One of the best tools I know about is ForNAV.

Cheers,

Robert

Please verify my answer, if you find it useful, that way others can find this solution easier!

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

There is the standard Txt2Al function from Microsoft. You can also user ForNav.

Both are not perfect, so use whichever comfortable for you.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

For the convert C/AL object to AL you can use Txt2Al Tool.

Check below link to help out

simplanova.com/.../

Was this reply helpful? Yes No
Suggested answer

Olister Rumao 3,967 on at

Like (0)

Report

Hi,

I best way of Customizing an existing report is creating the copy of the standard report and modify it.

Although with Business Central Wave 2 release all the Standard Objects are available in AL you will need to find your report in Base Applications App provided to your by Microsoft with BC Wave 2.

You can simply make change to the report and them redeploy with a different ID.

If you are trying to port a report from CSIDE to AL, you can use this www.cloudfronts.com/.../

And just as others suggested, ForNAV is also a good tool but you should be comfortable with it.

Let us know if you need further help.

Was this reply helpful? Yes No
InsertX 450 on at

Like (0)

Report

Hi again, so i tried to use ForNav to convert the report. I created the txt file of the report i want to convert. Entered to what file it should be saved to (.al). For the baseline file i used the same file as the txt of the report i previously created. Now when i try to convert it, it give the the errormessage : "Table UnknowTable18 does not exist".

Is there any reason for this?

Was this reply helpful? Yes No
Suggested answer

Olister Rumao 3,967 on at

Like (0)

Report

Hi,

Please share your files so I can take a look.

Importantly share your objects and the code that your running in the CMD.

Was this reply helpful? Yes No
Suggested answer

InsertX 450 on at

Like (0)

Report

Had the files already removed but i got it working another way. I copied the existing AL code from BC15 for that report and exported the BC15 report layout and next implemented it in my project. Seems to work so far.

Was this reply helpful? Yes No
Suggested answer

Robert B. 257 on at

Like (1)

Report

When you export your report in text export all the objects /tables related to it.

There may be a trial version of fornav, check the instructions but I am pretty sure that ForNav is working as a tool to design reports the way you did in old c/Al, although it's not a free tool for reports. I used it successfully for other object types a while back, now I just work in AL.

Baseline should contain an export of all the objects in c/al database before they are changed from memory, check instructions/videos on YouTube or their official site. The idea is that the tool needs to know how to make it's Delta files.

Text2al is also a free option.

Please verify my answer, if you find it useful, that way others can find this solution easier!

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Can we convert C/AL report to Business central cloud using the Text2AL tool?

Was this reply helpful? Yes No