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 Microsoft Employee

Hello everyone, 

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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor Balance List SSRS: There is no data available.

    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

  • udaY-ch Profile Picture
    udaY-ch 4,624 on at
    RE: Vendor Balance List SSRS: There is no data available.

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor Balance List SSRS: There is no data available.

    Good day sir,

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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor Balance List SSRS: There is no data available.

    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
    Community Member Microsoft Employee on at
    RE: Vendor Balance List SSRS: There is no data available.

    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
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor Balance List SSRS: There is no data available.

    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

  • Blue Wang Profile Picture
    Blue Wang on at

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,309 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans