Prompt Parameter in CRXI

[karnd]

Hi,

I have field with 5 records so created dynamic prompt onit.

But my question is out of 5 records into the prompt i need 4 on that report and also i need with the left over 1 record on the another same report.
So how should i filter them in the prompt to get 4 records on the first report and another 1 record on the another report.

Formula field created on that field does not help me out.

Thanks in an advance.

Regards,

 

[amcgreal]

With your report, is it possible to ask for the first 4 values and then base your logic for the first report on 'in' the list then the second report could be based on 'not in' the list?

 

[karnd]

Hi,

The first report required to see only 4 records data so i need only 4 values to see in that Prompt.
And similarly for another report with only 1 record data.

Please let me know if i have not make sense.

Thanks

 

[amcgreal]

I'm assuming you are using the parameter for record selection. If I'm understanding, you can use 1 parm. Here is what I mean.

You can ask for the 4 values and your record selection would be the following:

report 1 - (the one with the 4 vaues):
field in {?parmName}

report 2 - (the one with the value not in the parm list):
field not in {?parmName}

==========================================================
Or you can do it by asking for the single value with the following record selection:

report 1 - (the one with the 4 values not entered)
field <> {?parmName}

report 2 - (the one with the value)
field = {?parmName}

==========================================================

Good luck,
A.

 

[karnd]

Hi,

Does not get what i need.
to be more specific, the Dynamic Prompt which has created on that field (EgeptName contains 5 values like DeptName1, DeptName2 ...DeptName5) required to select only 4 values out of 5 values on the first report.
So should we limit to get only 4 values in the prompt when i run the report.

i hope you got me.

Thanks

 

[karnd]

Hi,

any help !!!!

Thanks