Finance | Project Operations, Human Resources, ...

Vendor Balance List SSRS: There is no data available.

(0) Share

Report

Posted on by Community Member

Hello everyone,

Good day, is anyone familiar with the issue "There is no data available" when running to screen an SSRS report?

I have the same question (0)

All responses (7)

Answers (0)

Blue Wang on at

Like (0)

Report

community.dynamics.com/.../display-message-there-are-now-rows-to-display-when-ssrs-report-is-empty-in-d365fo

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Charos,

Can you provide us more information especially how you run the report, for which company and whether your vendors have transactions/balances recorded?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Good day sir,

I run the report by inputting the following data:

From date: 2/3/2020

Report period start date: 2/3/2020

To date: 6/25/2020

Group and sort: Vendor

Other fields are blank.

Print destination: Screen

It is weird because on other environments the report is able to run and generate the records very quickly, while on this specific environment which has this issue it just returns the message "There is no data available"

I also made sure that the tables have data in them, and indeed they do have data which puzzles me because the data within the tables are the same with the other environments.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Charos,

Has somebody made modifications to the vendor balance list report?

Can you ask a developer having a look and possibly redeploy the report?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Good day sir,

We have already redeployed the report, but the issue persists.

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report

Hi

Did you check other reports are running fine? Asked to make sure the problem is only with this report.

This report is query based and check if there is modification done to the query.

did you try clearing usage data.

Uday

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Good morning Charos,

Did you try the recommendations from Uday and have you possibly been able to get your issue resolved in the meantime?

Would be great if you could keep us informed.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No