web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... SSRS Report D365 takin...

Microsoft Dynamics 365 | Integration, Dataverse...

Unanswered

SSRS Report D365 taking long to run and end with error

(0) Share

Report

Report

Posted on by Sabri Alsaheb

35

in my report I have data provider class linked with query. the query is right because I try it in SQL MS and it brings data.

I debug my data provider and when the debugger needs to fill the Tmp table ( while (QueryRun.next())) the debugger skip the while.

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Muhammad Uzair Shah 201 on at

Like (0)

Report

Are you applying any range or using addlink for joining tables before query run? You can go to the query object and see the query generating during the debugging before QueryRun.next call. There must be some wrong query generating that's why code is not going into while loop of QueryRun.

Was this reply helpful? Yes No
Sabri Alsaheb 35 on at

Like (0)

Report

yes I put range and addlink to join other table

Was this reply helpful? Yes No
Muhammad Uzair Shah 201 on at

Like (0)

Report

Could you please share the code so that I can look into it?

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

#1

Siv Sagar 93 Super User 2025 Season 2

#3

Martin Dráb 62 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans