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

RDLC report with SQL Report Builder

(4) Share

Report

Posted on by Juliem

377

Hi,

I had to reinstall my PC and now I can't open RDLC report using SQL Report Builder anymore.

It only works with RDL files. What am I missing?

I know I was able to prior to reinstalling.

All our custom extensions are using RLDC as report layout extensions.

Thanks

-Julie

Categories:

Dynamics 365 Business Central

I have the same question (1)

All responses (6)

Answers (0)

Suggested answer

Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Can you please help me understand which version of BC your using

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Juliem 377 on at

Like (1)

Report

Does not really matter.

We have SaaS clients but also onPrem clients with different BC versions

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

This is standard behavior.

rdl can be opened with Report Builder, rdlc can only be opened through VS. But rdl can also be uploaded to BC, where it is exactly the same as rdlc.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Juliem 377 on at

Like (2)

Report

It's possible, we've been doing it for months already.

I just don't know why I can't do it anymore since I reinstalled Windows compared to my co-workers who can still do it

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-ext-object

https://businesscentralgeek.com/reports-and-report-extensions-in-business-central#google_vignette

https://stackoverflow.com/questions/55596506/rdlc-files-in-reportbuilder

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (1)

Report

RDL files are used for server-based reporting and can be opened in SQL Report Builder or Visual Studio, while RDLC files are for local reporting and can only be opened in Visual Studio. In Business Central, both RDL and RDLC can be used as report layouts, with RDL being preferred for server-based reporting, although once uploaded to BC, they function similarly.

Was this reply helpful? Yes No