| |
Dear RSGuru
By Chavigny Reynolds, Sandy Anders, and Erin Gunn, Account Managers, Atlanta, GA
Dear RSGuru,
I am sending out claim notification letters and the process is so time-consuming. Currently I run a report for claims received in the last four days to get the claimant name and address, then manually input the claimant information into a form letter, then print the letters, and finally verify the information is correct by checking each letter off against the initial report I ran. Is there a spell you can cast to help me save time? —John
Dear John,
Wow, we can definitely help you here. By adding your form letter into Sigma EncoreSM Reports, you can run the report for claims received in the last four days and the information can be populated into the form letter so you can print and mail. Aren't you glad you asked?
Dear RSGuru,
I can't figure out how to make the "Accident Date Month Name" column in my Oracle® Discoverer report display in the sort order I want.
Here's a little background: I created an Oracle® Discoverer report with "Accident Date Year" in the leftmost column of my report. Then I added "Accident Date Month Name," but the months came into my report in alphabetical order. So I added "Accident Date Month Number" to the left of the month name. My months now display from January to December (01-12), but I want them to display in policy period order, October to September. Can you help? —An Intermediate Oracle® Discoverer user
Dear Intermediate OD User,
Instead of adding the "Accident Date Month Number" to the left of the month name, create a calculated define named "MonthOrder." Use this formula in your MonthOrder calculation: DECODE("03-DATE : Accident Date Month Number",'10','a', '11','b', '12','c', '01','d', '02','e', '03','f', '04','g', '05','h', '06','i', '07','j', '08','k', '09','l', 'z').
The decode function searches for the month number in the list of values (10, 11, 12, 01...), and returns the corresponding result (a, b, c, d...). So month number 10 will return the assigned value "a", month number 11 will return the assigned value "b", etc. Sort by Year and then by "MonthOrder" and you should see the results you want.
Hint: You don't want to see the "MonthOrder" calculation column in your report, so make sure you specify that it is a hidden sort.
Dear RSGuru,
I really love the One Line Claim Listing template report; however, it's lacking two critical fields that I need—LocLvl2Name and Adjuster Name. How can I add these to the report template? —Frustrated Freddy
Dear Frustrated Freddy,
No need to fret. Have I got spell for you! Try this:
- Go to the Standard Report Library and open up the One Line Claims Listing Report template.
- Enter the search criteria you desire and tab over to the Sort Options panel.
- Choose the additional items you would like to add to the Report by selecting them from either the Page Sort or Group Sort Fields. (If you do not see the items you need in the drop down box, contact your RSG account manager and ask to have them added.)
- Export the report in to Excel®.
- Select where you want to save the file, and presto, it's magic!
There are many options within Sigma EncoreSM that can alter the format of your reports. Contact your sorcerer (account manager) for assistance.
|
