Prev: Creating a report when data exists on two levels of a data hierarchy
Next: Report Viewer -ONLY works once in a while
From: Shan on 9 Jul 2008 16:15
I have two separate reports. I need to combine these into one but only want
to show the result as a graph. Any help is greatly appreciated. Here is the
SQL query.

Thanks

REPORT 1 QUERY

SELECT COUNT(CITY) AS MEMBERCITY, CITY
FROM MR_MEMBER_1
GROUP BY CITY
ORDER BY COUNT(CITY) DESC


REPORT 2 QUERY

SELECT COUNT(FR_FIRM_1.CITY) AS FIRMCITY, FR_FIRM_1.CITY
FROM FR_FIRM_1 INNER JOIN
MR_MEMBER_1 ON FR_FIRM_1.FIRM_CODE = MR_MEMBER_1.FIRM
GROUP BY FR_FIRM_1.CITY
ORDER BY COUNT(FR_FIRM_1.CITY) DESC

 | 
Pages: 1
Prev: Creating a report when data exists on two levels of a data hierarchy
Next: Report Viewer -ONLY works once in a while