Jump to content
Changes to the Jaspersoft community edition download ×

problem with sql queries


2004 IR Help

Recommended Posts

By: Chalk S. Bareng - chalksb

problem with sql queries

2002-10-29 19:34

I cannot generate a report because according to the error message, my report has no pages. this is my SQL statement:

 

SELECT

cashierhist.ranum,

cashierhist.remittername,

cashierhist.bennum,

beneficiary.firstname,

cashierhist.amount

FROM cashierhist, beneficiary

WHERE cashierhist.txndate='10/30/2002' AND

(txncode=5001 OR txncode=5002) AND

cashierhist.bennum=beneficiary.ban

 

But I tried running this query at my SQL Server Query Analyzer, and I got 14 records in my resultset, so therefore it is not due to a syntax error. I am just wondering why this exact same statement does not work with iReport.

I can successfully retrieve the columns for the wizard, and I can successfully generate the XML file, but when the time comes for viewing the pdf report, Acrobat Reader starts, but it does not load successfully because "This file cannot be opened because it has no pages".

 

 

 

 

By: Giulio Toffoli - gt78

RE: problem with sql queries

2002-10-30 00:43

I don't have idea which it could be the problem.

I would make these tests:

1. try the query without the where clause

2. try to hardcode the query in the IReportCompiler.

 

Good look... :-)

 

Giulio

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...