[RBASE-L] - Re: Extracting values for a report

Sun, 09 Feb 2003 19:46:51 -0800

Thanks Alastair,
 
That basically worked as is.
 
We converted the production of court memos, including judgments, to RBase forms running off a sub-menu calling small commands files with most of the info for the forms being supplied by the each case record we call up.
 
 
JIM VAN DILLEN
Attorney at Law
1505 S. Big Bend Blvd.
St. Louis, MO. 63117
(314) 645-8008; Fax (314) 645-8016
 
-------Original Message-------
 
Date: Sunday, February 09, 2003 02:23:47
Subject: [RBASE-L] - Re: Extracting values for a report
 
Jim,
 
If I'm reading your code correctly it looks as if you've simply got the syntax muddled for the select command.
Try this:
 
set var vCourtCnty text = null
 
SELECT CTCNTY INTO vCourtCnty from TableName WHERE columnname = .whval1
 
set var COUNTY  text = null
IF vCourtCnty CONT "CITY" THEN
SET VAR COUNTY = "CITY"
ELSE
SET VAR COUNTY =  "COUNTY"
ENDIF
 
Regards,
Alastair.
 
----- Original Message -----
Sent: Sunday, February 09, 2003 3:45 AM
Subject: [RBASE-L] - Extracting values for a report

I managed to get my report going using a LISTOF command and printing the report only once by using LIMIT = 1.
 
I am now trying to come up with reports specific to print for a particular court and county to be selected based on a search of a column  which contains the word "city" or "county".  In other words, a different layout of report based on what county you are in.
 
Presently we are trying a select command like: 
FILLIN WHVAL1 "Using ....:" at 1 1
 
SELECT t1.CTCNTY INTO varname WHERE columnname = .whval1
IF CTCNTY CONT "CITY" THEN
SET VAR COUNTY  TO "CITY"
ELSE
SET VAR COUNTY TO  "COUNTY"
ENDIF
 
PRINT DOCKET_MEMO WHERE FILENO = .WHVAL1 AND LIMIT = 1
 
The report would then use the value of CTCNTY to fill in the proper "County" in on the proper report.
 
We have been unable to get beyond the SELECT statement.
 
The report works just fine if we just FILLIN a value for COUNTY before going into the report.
 
Any help?
 
 
JIM VAN DILLEN
Attorney at Law
1505 S. Big Bend Blvd.
St. Louis, MO. 63117
(314) 645-8008; Fax (314) 645-8016
 
 

Reply via email to