MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2014

Re: multiple SQL in 1 Crystal report



fixed

Yep, Steve - I think we can all benefit from this polite reminder - the other marvelous thing is to find the site with "how to ask question on the internet" - I forget the title - google will find something - and it's definitely not so polite as this summary!

Cheers
Vern

On 6/27/2014 11:28 AM, Steve Landess wrote:

Bill:
See #1:

(he/she is obviously not a very good #7...)

-sjl

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

Before You Ask

Before asking a technical question by e-mail, or in a newsgroup, or on a website chat board, do the following:

1. Try to find an answer by searching the archives of the forum you plan to post to.
2. Try to find an answer by searching the Web.
3. Try to find an answer by reading the manual.
4. Try to find an answer by reading a FAQ.
5. Try to find an answer by inspection or experimentation.
6. Try to find an answer by asking a skilled friend.
7. If you're a programmer, try to find an answer by reading the source code.








"Bill Hopkins" wrote:

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.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact