RE: multiple SQL in 1 Crystal report

He could search the lists here ... since the information about Stored Procedures with SQL and/or RPG with Crystal Reports were given to him before this time.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Friday, June 27, 2014 11:07 AM
To: Midrange Systems Technical Discussion
Subject: Re: multiple SQL in 1 Crystal report

LOL Steve - we've been TRYING to get this person to put the code back on the i where it belongs and just consume it with CR!

On 6/27/2014 10:03 AM, Steve Landess wrote:

When did this become a Crystal Reports forum?

http://www.catb.org/esr/faqs/smart-questions.html

"Choose your forum carefully"

(BTW, YOU have broken all of these rules...)

-sjl

"Hoteltravelfundotcom" wrote in message
news:mailman.13.1403820051.8590.midrange-l@xxxxxxxxxxxx...

HI I have replicated functions from RPG program into SQL's.

I can make each sql as a VIEW. But would like to load them into the CR
as one unit. But the CR rejects more than one. But is this a CR issue
or is there syntax needed to run more than 1 CR.
I think I want to keep these separately coded, as we are showing
orders in various forms of progress i.e. Picking, engraving etc. I
want in 1 cr for tedious wise, there are many screens of RPG i have to
do and each time to make a VIEW is time consuming if there is an
alternatives.

SELECT count(*)as Picking
FROM
CCDTA.OEORH48,CCDTA.TRNSTAT2,CCDTA.OETRA99
WHERE OHCOM# = TSCOM# AND OHORD# = TSORD# AND (otCOM# = OHCOM# AND
OTORD#= OHORD# AND ottrnc = 'AQC') AND OHORDT IN('RTR','INT','SAM')
AND TSSTAT IN('ECT','STP') AND OHREQD = replace(char(current date,
iso), '-', '') AND OHHLDC = ' 'AND OHORD# in(SELECT a.TSORD# FROM
ASTCCDTA.TRNSTAT2 a WHERE a.tsstat IN('AEP','BGE','EAS','REL','STP'));


SELECT count(*) as LaserENG FROM
CCDTA.OEORH48,CCDTA.TRNSTAT2,CCDTA.OETRA99
WHERE OHCOM# = TSCOM# AND OHORD# = TSORD# AND (otCOM# = OHCOM# AND
OTORD#= OHORD# AND ottrnc = 'AQC') AND TSSTAT IN('EAS','REL','SCC')
AND OHORDT IN('RTR','INT','SAM') AND OHREQD = replace(char(current
date, iso), '-', '') AND OHHLDC = ' '

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.