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

RDLC report with SQL Report Builder

(4) Share

Report

Posted on by Juliem

415

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,547 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 415 on at

Like (1)

Report
Copy link

Link copied!

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 99,055 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 415 on at

Like (2)

Report
Copy link

Link copied!

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,732 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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. 22,128 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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