Unions?

[MVisconte]

This is an off-shoot of another problem I'm having
("YASVP - Yet Another Shared Variables Problem..." thread149-309225 in the Crystal Reports 4 Other topics Forum)...

I need to make a master report of record counts from several seperate ODBC DSNs (basically, same tables on geographically remote DBs). The user wants this to be the top level report, and have each site's real report as a sub (a multi-level breakdown of the totals with pretty pictures and stuff like that).

In Access (or just about any other front end) I can do a union SQL and get the data from several tables (from different DBs), but I don't think that Xtal will let me do that. Has anyone done a union in Xtal, or found a better way to get these totals from different DBs?

Tnx

Marc

 

[Naith]

Xtal? That's as tenuous an abbreviation as I've ever heard.

You can support unions with the query expert. (q.e. might be on it's way out in the future.)

Naith

 

[MVisconte]

:->

I used to be a ham (er, more-so than I am... ), an amateur radio enthusiast... so, for us'ns, Xtal was Crystal. How's the WX there?

;-)


Yes, I'm finding that the Union approach is not getting anywhere... not ONLY am I trying to do Unions in a non-standard non-Xtal way, but I'm also trying to define my own fields:


SELECT "Pacific" Arena, Count(database1."Network&quot Tickets
FROM
"ARSystem".dbo"."Action_Request_1" database1
WHERE
(parameter conditions)

UNION

SELECT "Atlantic" Arena, Count(database1."Network&quot Tickets
FROM
"ARSystem".dbo"."Action_Request_2" database2
WHERE
(parameter conditions)

UNION

etc...

Ideally, trying to get JUST the count of tickets matching the conditions along w/ each site's name. I think that IF it were going to work, I'm still doing it backwards... I'd have to use the QUERY to get the (query)field names, rather than use the table and then modify the query -- Xtal (;-)) only recognizes the table field names.

Marc

 

[MVisconte]

AND, I forgot to mention that, even IF I did the query seperately, I don't know how I would link the individual sections to their associated ODBC DSNs..., so I'd STILL be stuck.

I could do this (specific union query) so easily if I could step outside Xtal, but that's not allowed.

Arg.