can't do a union from access in a crystal report...help

can't do a union from access in a crystal report...help

Post by Ryan Gallaghe » Thu, 23 Apr 1998 04:00:00



I have two very simple tables in an access database that I want to combine
into a union and display as  a report.

The query itself works just fine in access, and looks something like this

GCC1    NULL    TS1_FAILURE    TRUE        FALSE       /* these two are
GCC2    NULL    TS2_FAILURE    TRUE        FALSE           the first table
in the union*/
GCC3    HTC1    TEMP_SEN         FALSE     FALSE
GCC1    HTC1    TS3_FAILURE    TRUE        FALSE

 but when I create a crystal report on the query, I get the right number of
records, but get a bunch of
'7''s where the strings in the query were. It looks something like this

7            7                7                        1                0
7            7                7                        1                0
7            7                7                        0                1
7            7                7                        1                0

Anyone know a way around this?

Please HELP!
Mail Me if possible. Thanks


========================

 
 
 

can't do a union from access in a crystal report...help

Post by Craig Buchana » Fri, 24 Apr 1998 04:00:00


Ryan-

Quote:> I have two very simple tables in an access database that I want to
combine
> into a union and display as  a report.

> Anyone know a way around this?

Try this:
*  Copy you SQL statement from the Crystal Query.
*  Open the report
*  Select "Show SQL Query..." from the Database menu (you may have to
create a new report, as this option may not be available if you base a
report on a Crystal Query
*  Paste the SQL
*  Run the report

Hope this helps,

--
Craig Buchanan, President
Cogniza, Inc.
Seagate Software Partner
http://www.cogniza.com
+1.612.649.4947

 
 
 

can't do a union from access in a crystal report...help

Post by CMB » Fri, 24 Apr 1998 04:00:00



>Ryan-

>> I have two very simple tables in an access database that I want to
>combine
>> into a union and display as  a report.

>> Anyone know a way around this?
>Try this:
>*  Copy you SQL statement from the Crystal Query.
>*  Open the report
>*  Select "Show SQL Query..." from the Database menu (you may have to
>create a new report, as this option may not be available if you base a
>report on a Crystal Query
>*  Paste the SQL
>*  Run the report

>Hope this helps,

Can do a union THAT WAY in Crystal with SQL server but not ACCESS. To do it
in access - make a union querydef that takes no parms and use the record
selection formula to filter records.  Report might be a little slow but it
works.
 
 
 

1. Access 2.0/Crystal Reports 4.0 - Can't Open Database Error

I have a problem that I hope somebody has a sugestion for me.  I have an old
application written in VB3.0/Jet 2.0/Crystal Reports 4.0.  I modify all the
reports to reflect some new change (I changed a label not a database field)
and now every time I try to print a report, I get an Error "Can Not Open
Database".  If I use the old reports everithing works OK.  I would appreciate
any help/sugestions

Thank you

Armando A. Duer

2. Distributed transactions between Sql Server and Oracle

3. Help for Crystal Report's totalpage alculate?

4. Object dependencies

5. Help:Crystal Report's files for Paradox database deployment

6. Restoring Records

7. HELP: Crystal reports and DLL's

8. INGRES CONTRACTORS WANTED

9. HELP:- Can't register crystal16.ocx Windows 3.11 Crystal Reports 5 Visual Basic 4

10. Good Reporting Tool for VB to SQL (Currently Use Crystal) or Crystal w/SQL Help Appreciated

11. Crystal Reports 4.5 ... Help Access Security

12. Editing Crystal reports without Crystal Reports

13. Help with Crystal Reports and Access DB