Need to restrict data selections to Particular Values

[computerlady143]

I have a report that does everything I want but .... I am using Inventory Items. I want to use only certain ones. I can't do a range because there would be some Items ID that I don't need. So, I created a Parameter. I imported the values that I wanted to use. However, It picking up other Items ID but not all. Some of the Id on the report is not one of the Values I imported. So the problem is I want the report to only use certain Items ID. Other than that the report list the correct information.

Thanks in Advance for your help

 

[lbass]

You can either manually delete unwanted IDs from the picklist, or you could add a command that selects the desired IDs, and then reference that to create the picklist. You wouldn't link the command to any tables (ignore the warning), and don't reference it in the main report. Go to database->database expert->add command (above the table list). Set it up like this:

Select table.itemID
from table
where table.itemID in ('a','b','c')

Then in the parameter set up screen in the main report, you would select {command.itemID} to populate the picklist.

-LB

 

[computerlady143]

NO my pick list is correct, but it seems to be Ignoring it

 

[lbass]

Did you reference the parameter in your record selection formula?

{table.itemID} = {?ItemID}

If you did, then there is probably something wrong with your selection formula (missing parens, e.g.) that is causing the clause to be ignored. In that case, please copy and paste the entire selection formula into the thread (report->selection formula->record).

-LB