How to create custom reports?

Discussion in 'Customization & add-ons' started by bobrandklev, Aug 3, 2009.

  1. bobrandklev

    bobrandklev New Member

    Joined:
    Jun 2, 2009
    Messages:
    3
    I've searched and there aren't a lot of answers or suggestions on how to create custom reports?

    I see MISO is keeping busy but I don't find any suggestions, help files or direction on how to create or even get started with custom reports??

    Can anyone get me going in the right direction? What are the best tools to use or where/how to get started?

    Thanks in advance
  2. miso

    miso aMember Pro Customer

    Joined:
    Aug 22, 2006
    Messages:
    542
    What kind of reports do you need? Can you be more specific?

    There are no suggestions because most of the custom reporting requires you to know mysql/php and how to create custom mysql queries, as well the knowledge of how amember data is stored in mysql and how to pull out exactly what you need in a report from it and then how to show it in the existing (or new) admin smarty templates.
  3. jimmarsh

    jimmarsh New Member

    Joined:
    Jul 1, 2009
    Messages:
    2
    I have a similar question on getting some better reporting. Out of all the users hasn't someone had some custom programming done that creates additional reports?

    Hell I cannot even get my exports to work right now.

    Looking for reports that give me things like.

    Active Members
    New subscribers this month
    Canceled subscribers this week, this month, etc...
    Current billings due this month.
    List of declined charges this week, month, etc...
    Rentention

    Is anything like this available?

    thanks,

    Jim
  4. duncan_m1

    duncan_m1 Challenge Media Group LLC

    Joined:
    Aug 22, 2006
    Messages:
    12
    I would be VERY interested in these features as well.
  5. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,435
    I'm working with Ken Gary to create such a service.

    These are good things to have:
    Active Members
    New subscribers this month
    Canceled subscribers this week, this month, etc...
    Current billings due this month.
    List of declined charges this week, month, etc...
    Rentention - maybe a chart or graoh to show how long people stay, which month theirs a big drop off, etc..

    Any other things you think are crucial?

    David
  6. story

    story New Member

    Joined:
    Aug 29, 2006
    Messages:
    21
    ditto on interest in these features here, too!
  7. brandon515

    brandon515 Member

    Joined:
    Dec 9, 2006
    Messages:
    47
    Looking for these types of reports as well.
  8. erwinvdb

    erwinvdb aMember Pro Customer

    Joined:
    Aug 30, 2007
    Messages:
    253
    Ken Gary's amExports plugin is the answer ;)
  9. ianternet

    ianternet aMember Pro Customer

    Joined:
    Jun 26, 2009
    Messages:
    52
    are these readily available and if so where can I purchase thse plugins?

    and does ken script make one that doesnt email you the csv? like I can populate it on screen within the amember interface?

  10. erwinvdb

    erwinvdb aMember Pro Customer

    Joined:
    Aug 30, 2007
    Messages:
    253
  11. ianternet

    ianternet aMember Pro Customer

    Joined:
    Jun 26, 2009
    Messages:
    52
    awesome just bought it but where can I view the reports within amember? I do not want it to be emailed it to me all the time. I rather just check via amember. its not in the reports section and the configurations seems it needs to be emailed to you instead of viewing it via amember itself
  12. erwinvdb

    erwinvdb aMember Pro Customer

    Joined:
    Aug 30, 2007
    Messages:
    253
    ehr... crap I misread your question. Reports are send via email... and aren't within aMember.
  13. jazzedge

    jazzedge Member

    Joined:
    Aug 11, 2007
    Messages:
    54
    I'm currently working on some reporting functions for aMember using some nice flash charts. What other types of reports would people want? I can try adding them to what I already have.

    Right now, I have both flash based reports for aMember and x-cart (since I use both)

    When I log into aMember, I get a flash line-chart that shows me how much I have made month-over-month for the year. I also have another that tells me how much I've made this month to date.

    It is nice to have these reports right on the main screen so that I can stay on top of where my business is going!
  14. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    @JazzEdge: Would you mind posting a screenshot or youtube video to give us an idea of what your setup looks like?
  15. ianternet

    ianternet aMember Pro Customer

    Joined:
    Jun 26, 2009
    Messages:
    52
    @jazz that is whats up!

    I would like an amember interface would be great. would you be bale to post screenshot?

    what do you have so far - so far kens script is great but would like an admin interface as well.

  16. jazzedge

    jazzedge Member

    Joined:
    Aug 11, 2007
    Messages:
    54
    Sure,no prob. Give me a few days to get some more data together.

Share This Page