Skip to main content

Notifications

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? 

  • Ludwig Reinhard Profile Picture
    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
    4,643 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
    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
    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
    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
    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
    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 the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

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

#1
Martin Dráb Profile Picture

Martin Dráb 487 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 310

#3
Saalim Ansari Profile Picture

Saalim Ansari 291

Overall leaderboard

Product updates

Dynamics 365 release plans