Axapta Report Problem...urgent !

mbshinde78

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

AdamRoue

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

mbshinde78

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

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.

mbshinde78

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

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!

mbshinde78

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

No winning here 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!