This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Hello all,
I am looking into employess that are traveling over 10k miles per year. Does anyone know of a way to get a listing of the employess that are going over a certain mileage during a 12 month timeframe?
Right now I am running the excessive personal car mileage report from intelligence. There isn't a way to run it by number of miles using that report. So I am downloading all drivers to Excel and manually add the miles using the spreadsheet.
If someone knows of an easier way I would appreciate the help.
Thank you,
Kelli
Solved! Go to Solution.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
@wardkj yes, you would need the Business Author or Professional Author role to build this report.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
@wardkj you should be able to build the report you need by adding Expense Type (group this column), Employee and Business Distance data items. Create a filter on Business Distance that shows amounts greater than what ever the amount is you are looking at as a minimum.
Then, from the Commonly Used fields area, right-click on Sent for Payment Date and use the Filter for Report option to create a date range filter for Jan. 1 to December 31st. This will show you all employees who have a total distance over the amount you specify.
Give it a try and let me know if it works.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Would I need report studio in order to do this? I only have acces to intelligence - standard reports.Thank you,
Kelli
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
@wardkj yes, you would need the Business Author or Professional Author role to build this report.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
@KevinD would this report be made from scratch? And is there any tutorials to help with creating reports?
Thank you,
Kelli
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
@KevinD Actually would I be able to do this by editing the standard excessive personal car mileage report?
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
@wardkj it would likely be easier and faster to build the report yourself. Editing Standard reports can be tricky.
As for tutorials, not for this specific report you are looking for.
Have you taken our free classes on using the reporting tool? You might find the class helpful. Here is a link about this: https://community.concur.com/t5/Reporting-Hub/Business-Intelligence-Training-Sessions-Now-Available/...
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
thank you @KevinD
I have Professional Author role. Would I need other credientials in order to create reports? I don't show that I have report Studio or anything like that.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
@wardkj nope, no other credentials needed. Be sure you are using Firefox as the browser.