Hi All
I have a report in which I need to select the sales person for 1 perticular section. I have added a prompt – sales rep name in list ‘enter sales rep name’. If I say show list of values it shows me all sales reps belonging to all 5 sections.
What i want is I specify section 1 and the sales rep prompt should show me only the sales rep belonging to section 1.
How do i do this ? do i need to make changes to designer or is it possible to do in the reporter ?
Thanks
Meettaurus
meettaurus (BOB member since 2005-03-10)
(BOB member since 2002-06-20)