Martin Yergeau Posted March 15, 2021 Share Posted March 15, 2021 Please share your code or at least try to reproduce using IBI sample file such as CAR Link to comment Share on other sites More sharing options...
Tom Evans 2 Posted March 15, 2021 Author Share Posted March 15, 2021 I receive the following error message when trying to use the over command. i am migrating from 7.7.05 and 7.7.05 has no problem with these commands. This is used in a PDF STYLESHEETS CAN NOT SEQUENCE ACROSS OR OVER COLUMNS TABLE FILE FOC_LCPPF21R_6 SUM COMPUTE COUNT1/I5 = 1; NOPRINT BY FOC_LCPPF21R_6.SEG01.DEFENDANT_LAST_NAME NOPRINT BY FOC_LCPPF21R_6.SEG01.DEFENDANT_FIRST_NAME NOPRINT BY FOC_LCPPF21R_6.SEG01.CASE_NUMBER NOPRINT BY FOC_LCPPF21R_6.SEG01.FILING_DATE_CCYYMMDD NOPRINT PRINT FOC_LCPPF21R_6.SEG01.DEFENDANT_LAST_NAME NOPRINT FOC_LCPPF21R_6.SEG01.CASE_NUMBER NOPRINT FOC_LCPPF21R_6.SEG01.CASE_NUM_SUB SKIP-LINE AS ARREST NUMBER: FOC_LCPPF21R_6.SEG01.CASE_DEF_SUBS NOPRINT FOC_LCPPF21R_6.SEG01.CHRG_DEF_SUBS NOPRINT FOC_LCPPF21R_6.SEG01.LOWER_COURT_NUMBER_10_20 AS CASE NUMBER: FOC_LCPPF21R_6.SEG01.DRUG_TYPE AS OVER FOC_LCPPF21R_6.SEG01.DEFENDANT_NAME AS NAME: FOC_LCPPF21R_6.SEG01.FILING_DATE_CCYYMMDD AS FILING DATE: FOC_LCPPF21R_6.SEG01.CLOSING_DATE_CCYYMMDD AS CLOSING DATE: OVER FOC_LCPPF21R_6.SEG01.STATUTE_ID AS FILED: FOC_LCPPF21R_6.SEG01.STATE_CODE AS FOC_LCPPF21R_6.SEG01.STATUTE_CLASSIFICATION AS FOC_LCPPF21R_6.SEG01.STATUTE_MEDIUM_DESCRIPTION#1 AS OVER FOC_LCPPF21R_6.SEG01.FINAL_STATUTE AS FINAL: FOC_LCPPF21R_6.SEG01.AMMENDED_STATE_CODE AS FOC_LCPPF21R_6.SEG01.AMMENDED_STATUTE_CLASSIFICATION AS FOC_LCPPF21R_6.SEG01.AMMENDED_STATUTE_MEDIUM_DESCRIPTION#1 AS OVER FOC_LCPPF21R_6.SEG01.PROS_ATTY AS PROSECUTOR: FOC_LCPPF21R_6.SEG01.DEF_ATTY AS DEFENSE: OVER FOC_LCPPF21R_6.SEG01.JUDGE_NAME AS JUDGE: FOC_LCPPF21R_6.SEG01.DISPOSITION_TYPE NOPRINT AS DISPOSITION,TYPE OVER FOC_LCPPF21R_6.SEG01.DISPOSITION_DESCRIPTION AS DISPOSITION: OVER FOC_LCPPF21R_6.SEG01.CLOSING_DATE NOPRINT AS CLOSING,DATE FOC_LCPPF21R_6.SEG01.RECORD_STAT_OPEN_CLOSED_HISTOR NOPRINT FOC_LCPPF21R_6.SEG01.SENTENCE_CONCAT AS SENTENCE: FOC_LCPPF21R_6.SEG01.CONSEC_CONCUR AS BY FOC_LCPPF21R_6.SEG01.DEFENDANT_LAST_NAME NOPRINT BY FOC_LCPPF21R_6.SEG01.DEFENDANT_FIRST_NAME NOPRINT BY FOC_LCPPF21R_6.SEG01.CASE_NUMBER NOPRINT BY FOC_LCPPF21R_6.SEG01.FILING_DATE_CCYYMMDD NOPRINT ON FOC_LCPPF21R_6.SEG01.CASE_NUMBER RECAP CASE_NUMBER/I6 = COUNT1; TOTAL_CASES/I6 = COUNT1; ON FOC_LCPPF21R_6.SEG01.CASE_NUMBER SUBFOOT WITHIN " " ON FOC_LCPPF21R_6.SEG01.CASE_NUMBER NOSPLIT HEADING " " City Prosecutor Full Case Description Crime Category &CATEGORY &CASEDROPDOWN6<+0> CASES "From <+0>&START_RPT6<+0> Through <+0>&END_RPT6<+0> " "&DATEtrMDYY <+0> " FOOTING LCPPF20R_FULL_CASE_BY_CRIME_TYPE ON TABLE SUBFOOT " " Total Cases: <CT.COUNT1 ON TABLE SET PAGE-NUM ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, PAGESIZE=Letter, LEFTMARGIN=0.638889, RIGHTMARGIN=0.430556, TOPMARGIN=0.750000, BOTTOMMARGIN=0.138889, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ DEFMACRO=HEADING1, FONT=TIMES NEW ROMAN, SIZE=12, COLOR=BLUE, STYLE=BOLD+ITALIC, $ DEFMACRO=HEADING2, FONT=TIMES NEW ROMAN, SIZE=12, COLOR=BLUE, STYLE=BOLD+ITALIC, $ DEFMACRO=TITLES, FONT=TIMES NEW ROMAN, SIZE=8, COLOR=BLUE, STYLE=BOLD+ITALIC, $ DEFMACRO=BODY, FONT=IBIDEFAULT, SIZE=8, $ DEFMACRO=FOOTING, FONT=IBIDEFAULT, SIZE=6, $ TYPE=REPORT, GRID=OFF, TOPGAP=0.000000, MACRO=BODY, $ TYPE=SUBFOOT, BACKCOLOR=SILVER, STYLE=BOLD, MACRO=BODY, $ TYPE=SUBTOTAL, BACKCOLOR=SILVER, STYLE=BOLD, MACRO=BODY, $ TYPE=GRANDTOTAL, BACKCOLOR=SILVER, STYLE=BOLD, MACRO=BODY, $ ENDSTYLE END Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now