Databases
StackOverflow2013
Postsdbo
POmulti parameters in SQL for DB2, using SSRS
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmulti parameters in SQL for DB2, using SSRS
    text
    copied!<p>I am very very new to SSRS for Sql Server. Using 2008. My work has asked me to reproduce some legacy reports using this tool -- and I got as far as creating the drop-downs for my parameters and ran into the error that multi parameters were not supported by DB2. We use PeopleSoft tables. My work has now said, find a workaround. I have been reading many forums and I just cannot get anything off the ground. Can anyone provide a resource or walk me through what I'd need to do to force this report to allow my users to select multiple parameters?</p> <pre><code>SELECT AL1.EMPLID, AL1.NAME, AL4.COVERAGE_ELECT, AL4.FLAT_AMOUNT, AL1.JOBTITLE, AL1.JOB_FAMILY, AL3.ANNUAL_RT, AL3.ANNL_BENEF_BASE_RT, AL4.BENEFIT_PLAN FROM TABLEONE AL1, TABLETWO AL2, TABLETHREE AL3, TABLEFOUR AL4 WHERE (AL1.EMPLID = AL3.EMPLID AND AL1.EMPL_RCD = AL3.EMPL_RCD AND AL1.EMPLID = AL2.EMPLID AND AL1.EMPL_RCD = AL2.EMPL_RCD AND AL1.EMPLID = AL4.EMPLID AND AL1.EMPL_RCD = AL4.EMPL_RCD) AND (AL2.EFFDT = (SELECT MAX(LF.effdt) FROM TABLETWO LF WHERE LF.emplid = al2.emplid AND LF.empl_rcd = al2.empl_rcd AND LF.plan_type = al2.plan_type AND LF.benefit_nbr = al2.benefit_nbr AND LF.effdt &lt;= CURRENT Date) AND AL2.PLAN_TYPE = '20' AND AL2.COVERAGE_ELECT = 'E' AND AL3.EFFDT = (SELECT MAX(J.EFFDT) FROM TABLETHREE J WHERE J.EMPLID = AL3.EMPLID AND J.EMPL_RCD = AL3.EMPL_RCD AND J.EFFDT &lt;= CURRENT Date) AND AL3.EFFSEQ = (SELECT MAX(ES.EFFSEQ) FROM TABLETHREE ES WHERE ES.EMPLID = AL3.EMPLID AND ES.EMPL_RCD = AL3.EMPL_RCD AND ES.EFFDT = AL3.EFFDT) AND AL4.EFFDT = (SELECT MAX(L.EFFDT) FROM TABLETWO L WHERE L.EMPLID = AL4.EMPLID AND L.EMPL_RCD = AL4.EMPL_RCD AND L.PLAN_TYPE = AL4.PLAN_TYPE AND L.BENEFIT_NBR = AL4.BENEFIT_NBR AND L.EFFDT &lt;= CURRENT Date) AND AL4.PLAN_TYPE IN (?) AND AL4.COVERAGE_ELECT= ?) </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload