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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS Report
Finance | Project Operations, Human Resources, ...
Unanswered

SSRS Report

(0) ShareShare
ReportReport
Posted on by Luis Pascual 356

pastedimage1656619167797v1.png 

I have 3 arrays whose size is declared with variables as seen in the image, when I put a small value in my arrays, for example a size of 1, it works fine for me, but if I put a size greater than 5 it shows me this error

pastedimage1656620206002v2.png 

in the past they told me to increase the time, I did 2 tests, the first was 2 hours and the second 15 hours, but it gives me the same error, instead of setting 10 minutes, I set 2 hours and then 15 hours respectively

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,697 Most Valuable Professional on at

    What did you find when you debug your code? At what line of code does it get stuck? What do you do with those arrays?

    Also, why the title is "SSRS Report" and the category "Management Reporter" if you never mentioned any of these technologies in the body? If it's somehow related to one of them, please explain how, and remove the reference to the other. And don't use generic titles such as "SSRS Report". That would work as a tag classifying your question, but it's not a good title of a particular question.

  • Luis Pascual Profile Picture
    Luis Pascual 356 on at

    the code is debugged without errors, it doesn't get stuck, the problem comes when the report is generated, which in the VS stays loading and never ends, but if I put a smaller number in the arrays, it works fine but that way it doesn't give me all the results I need. These matrices load the projects that the company has and the categories of the projects in a general way, what the third matrix does is to load the amount of each project with each category.

  • Martin Dráb Profile Picture
    Martin Dráb 237,697 Most Valuable Professional on at

    Let me ask more specifically.

    What do you do with those arrays?

    Is is about an SSRS report or Management Reporter? Your options for debugging depends on what you're talking about.

    If it's an SSRS report, what is the source of data? If it's an RDP class, what did you find when you debugged it? Note that "when the report is generated" is too vague; you can find out at which phase it fails.

    Also, what do you mean by sauong thay VS stays loading? VS is a development environment, but SSRS reports are processed by SSRS.

  • Luis Pascual Profile Picture
    Luis Pascual 356 on at

    the company is a civil construction company, which works with different types of projects, the project matrix saves the projects and the items of the projects, the items are sub-projects of the same main project (It is a one-dimensional matrix), the matrix of categories saves the categories that are used at the accounting level, these categories are different groups of items or services that are acquired to carry out the project (It is a one-dimensional matrix) and the third matrix saves the amount of each project or sub-project with its category (It is a two-dimensional matrix relating the first 2 arrays).

    It is an SSRS report. The data source is an RDP. When I debug it everything works fine.

    You are right when you say that the reports are processed by ssrs but where the data is displayed is Microsoft Visual Studio (VS), the error gives me when I run it in VS that it keeps loading as if it had a lot of data, but really it only has 18 pages, so if I put the arrays of a small size it works fine for me, but I really need the arrays to be at least 15 positions. 

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans