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 --
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 --