Axapta Report Problem...urgent !

mbshinde78
mbshinde78 Member Posts: 14
edited 2009-02-10 in Dynamics AX
Hi,

I have a serious problem while using Axapta 3.0.

I have created a report in Axapta. It takes more than 2 hours to fetch the data. This is not the problem. Actually the report is inconsistent with data. For example, If we see the report it will show you 5 pages, next time it shows 7 pages. This happens because, in the first case it leaves some data out of report and picks up the data second time.

I don't see any issues with report as it is picking up data second time. Is it a BUG in axapta?

Urgent help needed please. It will be appreciated.

Thanks

Manoj

Comments

  • AdamRoue
    AdamRoue Member Posts: 1,283
    If the report is inconsistent with the data and the data is correct then clearly the error is in the report you have written. So no this is not a bug :D
    The art of teaching is clarity and the art of learning is to listen
  • mbshinde78
    mbshinde78 Member Posts: 14
    Thanks for reply.

    Then how come the report shows data correct next time without making any changes to it. I have another question. If the report takes more than 3 hours to appear then whether this could be the cause of data lose?

    Thanks for support

    Manoj
  • AdamRoue
    AdamRoue Member Posts: 1,283
    If running the report is deleting data you have a bigger problem.

    Take a snapshot of the data, run teh report and then check the data.

    The issue is still with your report, you simply need to sort it out, because my guess is the data is correct it is how you are interrogating it and presenting it on the report.
    The art of teaching is clarity and the art of learning is to listen
  • mbshinde78
    mbshinde78 Member Posts: 14
    Thanks again.

    The situation here is getting difficult. The data is there and not getting deleted. The report is fetching data into a temporary table from several tables. Now while fetching data from original tables...the "reportengine" cannot fetch it (I think) and store it in temp table. This happens for few records which are not identifiable. Same code next time can fetch the data.

    I am not trying to cross your suggestions but just explaining the situation.

    Taking snapshot is very difficult because there is no guarantee that report will miss the data. It might fetch all data or might not and it will take a huge amount of time to do so because of length of time taken by report to appear.

    I was in search of a solution which will save my time.

    Regards,
  • AdamRoue
    AdamRoue Member Posts: 1,283
    How can you find a solution when you do not know what the problem is. You cannot run the report to enable analysis of the issue, and you believe this is data related when it is clearly an issue with the report whereby the report is incorrectly bringing data into temporary tables.

    Here is your solution - fix the report!
    The art of teaching is clarity and the art of learning is to listen
  • mbshinde78
    mbshinde78 Member Posts: 14
    Hats off to you man. You won.

    It was a problem with my report and not Axapta. It is fixed now. I just overlooked a flag. Thats all !

    Thanks for support and guidance.

    Regards,

    Manoj
  • AdamRoue
    AdamRoue Member Posts: 1,283
    No winning here :D I am not a developer so I could offer you no assistance on that front, just used common sense.

    Glad it is resolved for you!
    The art of teaching is clarity and the art of learning is to listen

Categories