No return results, only red minus long number

[avarela_1]

Hi everyone, I have a problem with Jasper

When I run a report in Jasperstudio, when I see results in Preview, instead of the results it returns a number in red (like -991916224, it changes every time) but it doesn't give me an error. The query would have to return about 36000 records. If I put a LIMIT 5000 it works. The goal is for it to return a report that the user can download in Excel to work with.

Excuse me, but I'm a newbie to Jasper.

I put a screenshot below.

Thank you,

Alberto

 

[jabrown]

Hi Alberto,

It will be helpful to see the error being logged.  Can you please reproduce the error, and paste or attach the log that is generated?

You can check the Jaspersoft Studio log by following these instructions.

[avarela_1]

Thank you very much for the reply.

The strange thing is that no error is generated, neither in the log nor in the execution. Look in the Report State: Errors (0) and in the Console it shows Report Execution Finished. What I get is that numeric code but not the results !!?

[bigalex]

Try to view the results in other formats than Java (e.g. html, pdf, etc.)