Custom reports
Results 1 to 3 of 3

Thread: Custom reports

  1. #1
    Junior Member
    Join Date
    Jun 2011
    Posts
    5

    Default Custom reports

    Hello,

    I'm loving HM 2.0 so far, but I do have some feedback for the reports section:

    In the 'old' HM 1.0 i could use my own raw SQL syntax within reports. This was useful for custom reporting.

    For example: I made a report which shows my results against different type of players (how do i perform versus TAG players, how do I perform versus Loose Passive players etc etc).

    In order to do this i wrote a custom stored procedure 'getvillainplayertype' in Postgresql, which i then used in the report (see 'grouping' tag in code example below):

    Code:
    <Report Name="Analysis - Villain Player Types" Version="1.1">
    	<Groupings>
    		<Grouping FieldExpression="case when getvillainplayertype(ph.pokerhand_id, ph.player_id) is null then -1 else getvillainplayertype(ph.pokerhand_id, ph.player_id) end" ColumnName="VillainPlayerType" ColumnHeader="VillainPlayerType">
    			<Ranges>
    				<Range In="1" RangeName="A) Nit" />
    				<Range In="2" RangeName="B) Tight Agressive" />
    				<Range In="3" RangeName="C) Loose Agressive" />
    				<Range In="4" RangeName="D) Drunk" />
    				<Range In="5" RangeName="E) Loose Passive" />
    				<Range In="0" RangeName="F) Other" />
    				<Range In="-1" RangeName="G) Unknown (less than 20 hands)" />
    			</Ranges>
    		</Grouping>
    	</Groupings>
    I noticed that HM 2.0 uses an entirely new format for the .REPORT files. My old custom reports aren't working anymore. The new .REPORT files don't seem to accept raw SQL anymore. Is there anyway for me to still use raw SQL for these kind of purposes? Or are there any good alternatives?

    Keep up the good work!

    Sincerely,
    BulldozerPP

  2. #2
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,888

    Default

    Hi currently its not possible to create your own reports. We do have plans to build a GUI to let you build your own powerful reports but since this is quite a big project initially we plan to dedicate some developer time each week for adding useful reports like the one you suggested until such time we can develop the new custom stats creator. So were going to add your report as a feature request #1869 for now and feel free to suggest any new reports also you would like to see.
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  3. #3
    Junior Member
    Join Date
    Nov 2008
    Posts
    27

    Default

    Hi Bulldozer
    Looks like an interesting report
    Are you willing to share your stored procedure as well?

Similar Threads

  1. Custom 3bet reports
    By husker in forum Manager General
    Replies: 7
    Last Post: 05-18-2010, 10:56 AM
  2. Can i add a custom key figure to the reports?
    By fifilein in forum Manager General
    Replies: 1
    Last Post: 05-09-2010, 12:09 PM
  3. Custom reports for stoxpoker
    By Diamond3322 in forum Manager General
    Replies: 8
    Last Post: 08-02-2009, 05:37 PM
  4. Custom Reports
    By Skesis in forum Manager General
    Replies: 6
    Last Post: 09-11-2008, 10:36 AM
  5. custom reports?
    By frogp07 in forum Manager General
    Replies: 6
    Last Post: 07-17-2008, 09:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •