Hi Michael,
Thanks for the suggestion. It occurred to me to try creating the report
without the extension, using the OO wizard instead, and that got an
error stating it could not retrieve the fields from my query. However,
I can open the query and see the records I expected; the only "unusual"
thing about the query is an expression to concatenate last name & first
name:
SELECT Classes.ClassName,
Parents.LastName + ', ' + Parents.FirstName as ParentName,
Parents.ID,
Parents.SSNo
FROM Children, Classes, Parents
WHERE Children.ClassId = Classes.ID
AND Parents.ID = Children.ParentID
and ClassName <> 'Alumni'
and ClassName<>'Inactive'
and ClassName<>'Waiting List'
ORDER BY 1,2,3
I tried changing the expression to just a field name, i.e.
Parents.LastName," and now the OO report wizard and the Sun Report
Builder extension can see the field names, and the report is generated
without errors.
So there appears to be a problem with the reports and expressions in a
SELECT statement.
Btw, my apologies for double posting - I just joined the list and after
posting, I'd gotten a confirmation email that made it appear my first
post had been discarded.
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> /
Michael Adams wrote:
On Tue, 09 Dec 2008 16:34:23 -0800
Came this utterance fomulated by Peter Dow to my mailbox:
Hi Everyone,
I opened an MS Access database, created a query over one of the tables
in that database (which works fine), then created a report using Sun
Report Builder extension. When I try to execute the report I get the
"An error occurred while creating the report" message box. When I
click the More button, I have a list of 4 items - 3 errors and 1 info:
Sending multiple requests for a problem you have is not going to get
your question answered quicker; people are going to see it as spammy
and just filter all your emails to trash. There are thousands of people
on this list and a little patience may be useful here.
