FishKiller
IS-IT--Management
LB this is probably for you. I am running CR9 and SQL2K. The report that I am tring to create allows the user to select each level of grouping and from their selection allows them to select exactly which values they want in the parameter.
This is what I have so far:
In the first group I have a formula that looks like this-
// GROUP 1 PICK FROM PARAMETER {GROUP1}
IF
{?Group1} = "Referring Physician"
then
{NDC_VR.REFERRING_PMIS}
ELSE
IF
{?Group1} = "Specialty Code"
then
{NDC_VR.SPECIALTY}
ELSE
IF
{?Group1} = "Referring Zip Code"
then
{NDC_VR.ADDR_ZIP}
ELSE
IF
{?Group1} = "Modality"
then
{NDC_VR.Modality}
This works fine. However some of these choices require additional filtering such as "Modality" I do not want all Modalities returned only those from a pick list and only when "Modality" is selected from {?Group1}.
I created a parameter called {?Select Modality} and added the following values "which come directly from {NDC_VR.Modality}"
2 HD, 3 HD, BD, CARD, CT, HOTLAB, MAM 1, MAM 2, MR1, MR2, PET HOT LAB, PET/CT, STEREO, US1, US2, X-RAY
I believe this is called an array [please excuse my ignorance for not understanding syntax]
If the user selects 3 HD and CARD I only want those records to be returned.
I was tring to do the following to the above sample with no success:
IF
{?Group1} = "Modality"
then
{?Select Modality}={NDC_VR.Modality}
Any help would be much helpful
This is what I have so far:
In the first group I have a formula that looks like this-
// GROUP 1 PICK FROM PARAMETER {GROUP1}
IF
{?Group1} = "Referring Physician"
then
{NDC_VR.REFERRING_PMIS}
ELSE
IF
{?Group1} = "Specialty Code"
then
{NDC_VR.SPECIALTY}
ELSE
IF
{?Group1} = "Referring Zip Code"
then
{NDC_VR.ADDR_ZIP}
ELSE
IF
{?Group1} = "Modality"
then
{NDC_VR.Modality}
This works fine. However some of these choices require additional filtering such as "Modality" I do not want all Modalities returned only those from a pick list and only when "Modality" is selected from {?Group1}.
I created a parameter called {?Select Modality} and added the following values "which come directly from {NDC_VR.Modality}"
2 HD, 3 HD, BD, CARD, CT, HOTLAB, MAM 1, MAM 2, MR1, MR2, PET HOT LAB, PET/CT, STEREO, US1, US2, X-RAY
I believe this is called an array [please excuse my ignorance for not understanding syntax]
If the user selects 3 HD and CARD I only want those records to be returned.
I was tring to do the following to the above sample with no success:
IF
{?Group1} = "Modality"
then
{?Select Modality}={NDC_VR.Modality}
Any help would be much helpful