web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Vendor Balance List SSRS: There is no data available.

(0) ShareShare
ReportReport
Posted on by

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)
  • Blue Wang Profile Picture
    on at
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

  • Community Member Profile Picture
    on at

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

  • Community Member Profile Picture
    on at

    Good day sir,

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

  • udaY-ch Profile Picture
    5,133 on at

    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

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans