Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Results from Picklist Prompt in Report

Status
Not open for further replies.

jjb373

MIS
Feb 4, 2005
95
US
Hello all - I have read through a few examples but none seem to quite fit my problem.

First a few details about my report:
I have a report asking for a Rep, Opened Issues, Closed Issues, and Total Issues. I am having any problems getting the correct results. The Issues are conditional totals.
I have a Picklist Prompt in my report asking the user to select one of multiple Reps. This prompt looks at a .txt file.

My Issue: I want the ?Rep? prompt to be a Picklist prompt which it is set-up to do but it only gives me a dropdown list when I run the report.

About the ?Rep? Prompt:
In the details of my report as I mentioned is Rep, Opened, Closed, and Total Issues.
Rep is a calculated formula with the expression being my Picklist Prompt ?Rep?.

Currently my detail filter - filters out all products but 3. Which is what I want.
My only grouping is by Rep. Rep being a calculated field with the expression ?Rep? (my picklist prompt)

I understand for a Picklist Prompt you need the "In" statement but I am not sure how to go about adding that to my report.

I need to have the calculated field Rep because the user community wants to see which Rep the Issues are for. My problem with using a field from the Catalog is the Reps Issues can be from 3 different fields. Example:
Opened Issues is a date and associated with that is Opened By which is the rep name. The same goes for Closed Issues only it is - Closed Issues - date and Closed By - Rep.

Any suggestions. I can clarify more if I lost anyone. Thank you so much for your patience and time.








-- JJB373 --
 
Taking a new approach to this report. Please disregard post


-- JJB373 --
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top