Last post Jan 08, 2020 06:58 PM by RuthlessRoth
Jan 08, 2020 06:34 PM|RuthlessRoth|LINK
I have a report that is driven by a stored procedure prompting for invoices generated for customers for a specific year. Prompt is Year.
The new request is to select a specific sales reps customers or all.
Easy to make a list of available reps but I would have to maintain the list if we have new reps come on board.
Hoping to make a dynamic prompt using the existing sales rep table. 2 issues came up.
1) need a way to account for All reps which I can't find a way to do using the Crystal Reports dynamic parameter
2) I get prompted for the year the store procedure requires after pressing enter a new screen pops up prompting for the rep select AND the year again which I entered on the first prompt.
I would insert a screen shot here but can't seem to figure out how
Jan 08, 2020 06:58 PM|RuthlessRoth|LINK
found how to get all if no rep is selected. Set Optional Prompt to true.
Now I need to find out how to not be prompted on 2 different screens for the year.