Getting inaccurate data from my report.

[Shiloh917]

I have a report that I have the params set up to show me information from Start Date to End Date by Order Code. Which an Order Code is just really the name of a certain product. I have 3 diff products that I am interested in I set it up in the Edit Selection Record as well like this:

{WORKAREA.WORKAREA} in ["4NI1", "4NI2", "4NIA", "4NIB", "4NIC", "4NID", "4NIE", "4NIF", "4NIG", "4NIH", "4NII", "5PCU"] and
{PATBILLING.ORDERCODE} in ["SVCPM", "VENB", "VEPB"]


and it gives me the same information for any Order Code that I choose. Any hints as to what I should do to make it pull the information for the Ordercode that I am picking in my parm list? This report was a canned report and I saved it under another name so I could make the changes to pull the information that I needed to receive from the params. It should work. Please help!

Thanks!
Shiloh

 

[vidru]

You need to use the parameter in the Record Selection Formula in order for it to restrict the records returned. Your selection formula should look like this:

{WORKAREA.WORKAREA} in ["4NI1", "4NI2", "4NIA", "4NIB", "4NIC", "4NID", "4NIE", "4NIF", "4NIG", "4NIH", "4NII", "5PCU"] and
{PATBILLING.ORDERCODE} in {?YourOrderCodeParameter}

-dave