Jump to content
We've recently updated our Privacy Statement, available here ×

cgrove

Members
  • Posts

    1
  • Joined

  • Last visited

cgrove's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare

Recent Badges

0

Reputation

  1. Hello, I had this same issue. Collections need to be delt with differently in your sql. Try this: SELECT parameter from table Where $X{ IN, "Data Field" ,"YourParameterName"} In my case my sql is as follows: SELECT REMKL001."RKCTID" AS RKCTID, REMKL001."RKCUST" AS RKCUST, REMKL001."RKJOBN" AS RKJOBN, REMKL001."RKLINE" AS RKLINE, REMKL001."RKRQTY" AS RKRQTY, REMKL001."RKCODE" AS RKCODE, REMKL001."RKEMP1" AS RKEMP1, REMKL001."RKEMP2" AS RKEMP2, REMKL001."RKSUP" AS RKSUP, REMKL001."RKCRMK" AS RKCRMK, REMKL001."RKYRMK" AS RKYRMK, REMKL001."RKMRMK" AS RKMRMK, REMKL001."RKDRMK" AS RKDRMK, REMKL001."RKQTY" AS RKQTY, REMKL001."RKITEM" AS RKITEM, REMKL001."RKISFX" AS RKISFX, REMKL001."RKCOLR" AS RKCOLR, REMKL001."RKTNET" AS RKTNET, REMKL001."RKRNET" AS RKRNET, REMKL001."RKRGN" AS RKRGN, REMKL001."RKPO" AS RKPO, REMKL001."SUPNUM" AS SUPNUM, REMKL001."SUPNAM" AS SUPNAM, REMKL001."SUPCMT" AS SUPCMT, REMKL001."ENTDAT" AS ENTDAT FROM "XXXXXX"."REMKL001" REMKL001 WHERE $X{ IN ,RKCODE,RemakeCode} AND ENTDAT between $P{BeginDate} and $P{EndDate} AND $X{ IN, RKSUP,Supervisor} ORDER BY RKSUP ASC, RKCODE ASC Hope it helps
×
×
  • Create New...