The FISYR field in our report (dynamic) is only displaying 2009 in the prompt box when there are 5 years of data in the data set.

I have checked the data and the other years are in there. To mkae it work I made the prompt simple and if you type in the other years it works fine.

Does anyone know how to fix this? My code is below.

TABLE FILE IBI_VIEW_ACHA_NEW
SUM CNT.IBI_VIEW_ACHA_NEW.ACHA_VW.GENDER
BY IBI_VIEW_ACHA_NEW.ACHA_VW.PAYOR
BY IBI_VIEW_ACHA_NEW.ACHA_VW.HOSPITAL
ACROSS IBI_VIEW_ACHA_NEW.ACHA_VW.SERVICELINE
WHERE IBI_VIEW_ACHA_NEW.ACHA_VW.GEOCLUSTER EQ &GEOCLUSTER.(OR(FIND IBI_VIEW_ACHA_NEW.ACHA_VW.GEOCLUSTER IN IBI_VIEW_ACHA_NEW)).Geo Cluster:.;
WHERE IBI_VIEW_ACHA_NEW.ACHA_VW.SERVICELINE EQ &SERVICELINE.(OR(FIND IBI_VIEW_ACHA_NEW.ACHA_VW.SERVICELINE IN IBI_VIEW_ACHA_NEW)).Service Line:.;
WHERE IBI_VIEW_ACHA_NEW.ACHA_VW.PT_CITY EQ &PT_CITY.(OR(FIND IBI_VIEW_ACHA_NEW.ACHA_VW.PT_CITY IN IBI_VIEW_ACHA_NEW)).Patient City:.;
WHERE IBI_VIEW_ACHA_NEW.ACHA_VW.PAYOR EQ &PAYOR.(OR(FIND IBI_VIEW_ACHA_NEW.ACHA_VW.PAYOR IN IBI_VIEW_ACHA_NEW)).Payor:.;
WHERE IBI_VIEW_ACHA_NEW.ACHA_VW.FISYR EQ &FISYR.(OR(FIND IBI_VIEW_ACHA_NEW.ACHA_VW.FISYR IN IBI_VIEW_ACHA_NEW)).FISYR:.;
ON TABLE PCHOLD FORMAT AHTML
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
ENDSTYLE
END

-RUN

This message has been edited. Last edited by: <Kathryn Henning>,

Hi Tara O,

I'd like to recommend opening a case on InfoResponse Online so that we can look at the type of form control being used to determine why only the 2009 data is being presented.

Regards,

Kathryn

Tara,

does it take a lot of time to retrieve all years from your dataset?

We found that ( in dev.studio at least ) it 'timed-out' and then simply didn't show anything...

Does it work when you make the fex less complex?

i.e.

TABLE FILE IBI_VIEW_ACHA_NEW
BY IBI_VIEW_ACHA_NEW.ACHA_VW.FISYR
WHERE IBI_VIEW_ACHA_NEW.ACHA_VW.FISYR EQ &FISYR.(OR(FIND IBI_VIEW_ACHA_NEW.ACHA_VW.FISYR IN IBI_VIEW_ACHA_NEW)).FISYR:.;
ON TABLE PCHOLD FORMAT HTML
ENDSTYLE
END

G'luck, Dave

The report is based on a view and that is not always very fast.
If there is a separate year table with just a few records I would consider using that table for the prompting. Maybe this is the same for the other prompts.

Thanks , I ended up manually typing in the years as static and it worked.