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, ...
Answered

while generating Report sql server reporting services issue error only for 2 Reports

(0) ShareShare
ReportReport
Posted on by 3,110

dailySaleReportError.png

Hi Experts,

Why i am facing this issue even i checked some blogs as well. But this issue i am facing with 2 Reports and Tmp Table.

Best Regards,

Shabir Ahmad

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Shabir Ahmad,

    Can you let us know for what report you receive this error message?

    Is this a standard report or one that has been created for your company?

    Best regards,

    Ludwig

  • Shabir Ahmad Profile Picture
    3,110 on at

    Hello Dr. Ludwig Reinhard ,

    This Report is developed not standard report.

    Best Regards,

    Shabir Ahmad

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Shabir,

    Many thanks for the feedback.

    In this case, have a talk with the developer who designed the report.

    There might have been something overlooked in the design / deployment of the report.

    Best regards,

    Ludwig

  • Verified answer
    Shabir Ahmad Profile Picture
    3,110 on at

    Hi Dr. Ludwig Reinhard,

    I resolved this issue by increasing field size of this temp table as the system is mentioning in the error("InventItemOnHandTemp) table

    and refering the below link

    stackoverflow.com/.../error-string-or-binary-data-would-be-truncated-when-trying-to-insert

    Best Regards,

    Shabir Ahmad

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 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans