Forums

F1 Reporting

Last post 02-16-2009, 8:19 PM by jcox. 26 replies.
Page 2 of 2 (27 items)   < Previous 1 2
Sort Posts: Previous Next

     01-07-2009, 10:48 AM 13416 in reply to 13410

    Re: F1 Reporting

    Todd,

    How long does it take on average for you to get a report created by the design team? We gave up requesting new reports about a year and a half ago because it was taking so long to get reports created. We had one custom report that we requested that took 6 months and never really gave us the info we needed it to. It sounds like things must have gotten better on that front.


    Rob Guilliams
    Director of Computer Services
    Highview Baptist Church
    Louisville, KY

     01-07-2009, 10:56 AM 13417 in reply to 13416

    • Sherryd is not online. Last active: 11-20-2009, 10:48 AM Sherryd
    • Top 10 Contributor
    • Joined on 11-01-2007
    • Shoreline Christian Center - Austin, TX
    • Posts 111

    Re: F1 Reporting

    Lately, It has taken about a month or longer to get a report created.  This is longer than it used to be.  In the past there was a two week turn around but, something must have changed or more people are requesting reports...?  I really enjoy working with the design team once it is in process.  It just takes a long time to get to that point.
    Sherry Donaldson

    Database Manager
    Shoreline Christian Center

     01-07-2009, 12:32 PM 13419 in reply to 13417

    Re: F1 Reporting

    It took us about 2 months.  The process reminds me of that song called I’m just a Bill from Schoolhouse Rock. 



    Yes I'm only a bill,
    And I got as far as Capitol Hill.
    Well, now I'm stuck in committee
    And I'll sit here and wait
    While a few key Congressmen discuss
    and debate”

     

    There’s some time type of review process, and then once it gets pass that, it gets released to the design team.  But they’re also backlogged, so it takes a couple of weeks before they contact you. 

     

    “Well, then I'm off to the White House
    Where I'll wait in a line
    With a lot of other bills
    For the president to sign
    And if he signs me, then I'll be a law.
    How I hope and pray that he will,
    But today I am still just a bill.”

     

    Sorry, I couldn't help it.

    Todd

     01-21-2009, 10:43 AM 13513 in reply to 13419

    Re: F1 Reporting

    Reporting is our biggest issue with F1. When we signed we were told that they were working on a tool to allow users to create customized reports. 3 years later we still have promises of the tool coming "in the next quarter". We were also told that if we needed a report that didn't exist there would be a 3-5 day turnaround on getting it created. I don't know for sure but I think the shortest turnaround I've seen is more like 3-5 weeks.

    F1 has become almost useless for our church. It is so hard to get the information you want out of the system once it is entered that many of our staff members have gone to keeping records in other programs or gone back to pen and paper. F1 has become nothing more than a very expensive Address Book for us.


    Rob Guilliams
    Director of Computer Services
    Highview Baptist Church
    Louisville, KY

     01-21-2009, 11:21 AM 13514 in reply to 13513

    • Sherryd is not online. Last active: 11-20-2009, 10:48 AM Sherryd
    • Top 10 Contributor
    • Joined on 11-01-2007
    • Shoreline Christian Center - Austin, TX
    • Posts 111

    Re: F1 Reporting

    Although I do agree that waiting for months for a report to come back is very frustrating the F1 reporting team has created every report that we requested and it has revolutionized how we are getting the members of our congregation involved.  I have been extremely pleased with the quality of the reports that I have received.  My reccomendation is to think of every report that you might possibly need.  Then, submit all the requests and wait.  It may take some time but once they get back you will be happy with the results.  The reporting team is very friendly and easy to work with.
    Sherry Donaldson

    Database Manager
    Shoreline Christian Center

     01-21-2009, 11:51 AM 13516 in reply to 13514

    Re: F1 Reporting

    I do not agree with the negative comments regarding reports.  We have about 20,000 households in our F1 database.  About 100 portal users per week are logged in.  We are using all functions except relationships and volunteering.  There are nearly 2000 reports with multiple filters in each.  We have found most of our needs in existing reports.  When we find a report that needs slight change (ie.additional filter) the reporting team has been very responsive.  We have had a number of complex reports that we needed.  Even with a report builder it would be unlikely that we could get those done.  We provided clear specifications for what we needed.  In the cases where we had an urgent need the F1 reporting team was very responsive.  I suggest that you get on the phone with Brian Vinson and talk about your reporting needs.  F1 in far more than an address book for us.
    Dan

     01-22-2009, 4:56 PM 13543 in reply to 13516

    Re: F1 Reporting

    Praise God. I'm glad to hear that someone is happy with the reporting tool. Things must have changed drastically. Like I said in an earlier post, we gave up on requesting new reports a long time ago because it had become such a painful process. The last one that I remember requesting was about a year and a half ago. I wanted an excel report that displayed a list of names down the side and a list of data points across the top with an "X" in the corresponding cell for each data point the person had. This is a very simplified explanation but you get the gist. I even included an example spreadsheet formatted to look exactly the way I wanted it to. After about a month I got an email that my report was complete. What they gave me was a PDF report with a separate page for each person and a list of their corresponding data points. I finally got the report I wanted after several more weeks, but that was one of the last, if not THE last report that I requested. Maybe I'll have to try again now that things seem to have improved.

    Rob Guilliams
    Director of Computer Services
    Highview Baptist Church
    Louisville, KY

     02-07-2009, 3:17 PM 13714 in reply to 13543

    Re: F1 Reporting

    I think the issue is that there is a steep initial learning curve. Once you learn it, the reporting tool is very flexible. When you're new, flexibility looks like outrageous complexity. I would make a couple of recommendations to the F1 development staff:

     (1) Remove all the suffix reports (i.e. -E). If it is a seperate report, give it a seperate number. If it is a seperate format, that should be handled using the format drop down list. I understand that sometimes an excel format requires an extra option, so put those into the regular report and say that they only apply to the excel format or the PDF format or the HTML format, as the case may be. This would drastically reduce the number of available reports and make it simpler to find what you needed.

     (2) Provide a PDF sample of EVERY report, that you can click on and view without going to look at the full description. It should also have some sort of actual demo data, not just the header titles.

    (3) Provide a summary of the report layout at the top of the description. For example, what information is shown in the columns, what information is shown in the rows, and how is that information grouped (by RLC, by ZIP Code, by Household Status, etc). This should be searchable.

     (4) A more expansive tool for finding people. As other people have mentioned, this should be very similar to query builder, and should have two parts, include people, and exclude people. The include section should have the ability to select to include people based on household information, attributes, activities, assignments, contacts, etc, etc. and the same information should be in exclude. I would think that this would be completely seperate from the reporting feature.After each selection, F1 should run an AJAX calculator that will tell you how many records are included in your selection, then you can click a button to get a spreadsheet of the results..

     (5) Improve the RLC selection process, including but not limited to, being able to set a default RLC for reports. In my case, I am a department head under children's ministry. When I run reports that require an RLC selection, I use the same selections every time I am running a report for my ministry. With the way that we have this set up, I have to select 3 service types, then 5 Rs out of about 20, about 12 Ls out of 30 or so, and about 30 Cs out of 50. I have saved reports that help, but I am constantly finding new reports that have a different information display that is helpful for particular projects, and every time I go into run those reports, I have to go through and select my RLCs all over again. 

     


    ==================
    Matt Beeman
    Website Project Manager, Marketing Ministries

     02-08-2009, 9:39 AM 13717 in reply to 13714

    • ddoell is not online. Last active: 11-20-2009, 10:59 PM ddoell
    • Top 10 Contributor
    • Joined on 11-01-2007
    • Cornerstone Fellowship, Livermore, CA
    • Posts 184

    Re: F1 Reporting

    Matt - I absolutely agree with you! Point #1 would definitely help to cut down the number of reports. Please submit all the above as ideas so that we can vote on them.

    Thank you! -D Doell, Cornerstone Fellowship


    Debbie Doell
    Fellowship One Coordinator
    Cornerstone Fellowship 348 North Canyons Parkway Livermore, CA 94551
    www.cornerstoneweb.org

     02-09-2009, 1:26 PM 13728 in reply to 13717

    _TopReports

    Thank you for the feedback on reports, we really value it! After doing some statistical research, we found that 20% of our Report Library accounts for more than 80% of the total reports run. This lead us to create a new tag, _TopReports, for our FT Reports. This is the quickest way to narrow down our entire library to the reports that are used most often by you all, our users.

     You may use this tag in conjunction with other tags. For example, I could select _TopReports and Contacts to see a smaller set of report candidates for what I am trying to accomplish.

     Since there is an underscore at the begining of the tag, _TopReports will always be the first tag at the top of the screen. Let us know what you think.

    Thanks!

    Brian Vinson


    In His grip-
    BV

     02-16-2009, 8:01 PM 13776 in reply to 536

    Re: F1 Reporting

    I agree that find the report you want is very frustrating.. that is my number one complaint from staff here.  However,  you can attach a file in group email.  I do it all the time.  I'm not sure if I missed exactly what you are saying, but when I compose a new group email, there is a attachment link in the edit bar.  We attach .pdf's and send them out all the time.  Hope this hleps with that exact problem, but reports are still very difficult.
    Jeff Cox
    Business Administrator
    Church on the Hill
    McMinnville, OR
    www.hillchurch.com
    jcox@hillchurch.com

     02-16-2009, 8:19 PM 13777 in reply to 13776

    Re: F1 Reporting - quick and simple solution for report builder

    Our biggest frustration is that there are sooooo many reports it's hard to find what you want.  And then often you find 2 reports that if combined is more what you want.  However the F1 tool is so good we have put up with the aggravation.  But I think reports are sort of like the volume level of music or the temp of the worship center.  There are so many preferences. 

    It may take a while to build a UI for a built in report writer.  I know I saw a cool video under the title of analytics which shows great promise.  But a simple and fast solution for those that have the resources and skills and want to do it, would be crystal reports.

    Why not just setup a crystal reports gateway server with a DB read-only connection and let customer buy crystal reports and learn it, or some of us already are pretty good with it. 

    Publish the DB relationship MAP and boom, those who want to can write their own reports now.  Has this been considered?

    -Jeff

     


    Jeff Cox
    Business Administrator
    Church on the Hill
    McMinnville, OR
    www.hillchurch.com
    jcox@hillchurch.com
Page 2 of 2 (27 items)   < Previous 1 2
View as RSS news feed in XML