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 :
Microsoft Dynamics AX (Archived)

ssrs report run wrong report.

(0) ShareShare
ReportReport
Posted on by

Hello,

I have two report with almost the same logic.

I used for the two report - same data controller, same data contract and same data provider.

In the data controller I chose the right report (by a flag parameter).

I did some debug, and find out that the controller set the right report, but when I run the report, the second report is running and not the right one.

I presume there is connection between dataprovider and report in ssrs server, so I duplicated the dataprovider class, build the cil + deploy of new report + restart the ssrs reporting service.

(Otherwise, how when running "computer" knows which datacontract, when running the datacontroller ? so, there must be a link between the report name and the dataprovider (in report design, I set the dataprovider, so here is the link, but probably that link is mapped somewhere when doing deployment. - Am I right?)

I have the problem, that wrong report is running.

Any ideas?

Thanks :)

*This post is locked for comments

I have the same question (0)
  • Umesh Pandit Profile Picture
    9,315 User Group Leader on at

    did you cleared the auc files as well?

  • Community Member Profile Picture
    on at

    Yes, I did that.

    Whether there was something in cache, there was a problem when first design datacontroller+dataprovider+datacontract (before splitting dataprovider to two classes - that fix the problem? I don't know), otherwise, I don't have any clue for the reason that I run the wrong report.

    Now I can see, that for some records I run the right report, and for the others I run the wrong report, but when debugging - datacontroller set the right reportname, but actually the report that is running is the wrong one, and I don't know how to debug beyond sense - That's seems to be server issue of SSRS (maybe map, that I must clear, etc.). Caching is another problem.

    Thanks :)

  • Verified answer
    Community Member Profile Picture
    on at

    OK.

    I deleted the report directly from server and deploy again (That's the cache mapping problem) - That solved the problem, so my assumption about map between DP+reportname may be right.

    Splitting to two dataprovider solved the problem, indeed.

    About other behavior when for some record run the correct report, while other are not - I think I made a mistake. All the records run the wrong report.

    Problem solved.

    Thanks, anyway :)

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans