Recent content by Ann28

we re-started the Crystal server & it worked!

Hello all - udb db2 8.2 CR 9 We've changed the instance for the DB2, re-publish the report via the web sphere & here is the message .... com.crystaldecisions.report.web.viewer.CrystalReportInteractiveViewer Logon failed. Details: Unable To Connect to DB2 Server BASYSDW Error in File...

I set the parms to NULL it works THANKS FOR YOUR HELP, Ann [dazed]

Try hiding duplicates by clicking on the field property & selct "suppress duplicates" option Hope it helps, Ann

no results

in CR, but i am testing it first on the command line or running it on the server thanks:)

thank you for your help!

I did, it build w/o error, but does not work for the null parm Thanks all for your help, Ann

Here is the code I've code , e1.empl_name from elg_summary h inner join (select empl, empl_name from UMASS_EMPL) as e1 on h.EMPLOYER = e1.empl , elg_summary s cheers! Ann [morning]

Hello everyone – Any help is appreciated!!! I need to join another table to the following SP with extracts the data from one table based on the change of coverage. I need to add the employer name that comes from a diffirent table I tried to JOIN by did not work Here is my SP: CREATE...

Fetch C1 into ...; ??????

I've got the code for the null input parms from the earlier posts from Ddiamond I am getting an error on variable declaration CREATE PROCEDURE BASYS.UMASS ( IN IN_FROM_DATE DATE, IN_NEW_BEN_PLAN CHAR (6), IN_OLD_BEN_PLAN CHAR (6), IN_EMPL CHAR (9) ) DYNAMIC RESULT SETS 1...

where 1=1 what does it mean? Thank you for your help I've changed the code (it works!!!) There are few more things I have to add: 1. The user requested to do the search by Employer (Enter one employer if none is entered SELECT * ) 2. Add the employer NAME I created a table with EMPL# & NAME...

Dan - The condition is based on the benefit’s date month. The end day of the previous coverage should be one month less than the beginning month of the current coverage My SP is set-up to handle the DOHIGH input parameter. SP: CREATE PROCEDURE BASYS.UMASS ( IN FROM_DATE DATE, BENEFIT_PLAN...

THIS MIGHT WORK AS WELL? MONTH ( STD.END_DATE) = MONTH ( '2005-07-01') - 01 AND YEAR ( STD.END_DATE ) = YEAR ('2005-07-01')