ChallengeNH Prof Exporting Reports

time to read 3 min | 590 words

One of the things that I am working on right now is exporting NH Prof reports. This isn’t an earth shattering feature, the idea is to take a report like this:

image

And give you the ability to save it in a format that you can send to your DBA, or maybe just put it away for later perusal.

I started with the simplest thing that could possibly work, exporting the reports to XML. Using Linq to XML, that has been a true pleasure, and got me this:

<?xml version="1.0" encoding="utf-8"?>
<unique-queries xmlns="http://nhprof.com/reports/2009/09">
<query average-duration="0.1" count="10" is-cached="false" is-ddl="false">
<duration database-only="0" nhibernate="0" />
<short-sql>SELECT ... FROM Comments comments0_ WHERE comments0_.PostId = 1</short-sql>
<formatted-sql>SELECT comments0_.PostId as PostId1_,
comments0_.Id as Id1_,
comments0_.Id as Id5_0_,
comments0_.Name as Name5_0_,
comments0_.Email as Email5_0_,
comments0_.HomePage as HomePage5_0_,
comments0_.Ip as Ip5_0_,
comments0_.Text as Text5_0_,
comments0_.PostId as PostId5_0_
FROM Comments comments0_
WHERE comments0_.PostId = 1 /* @p0 */</formatted-sql>
</query>
</unique-queries>

That is pretty easy to do, but then I hit a wall. This is good, but it isn’t nearly enough. I can imagine that most of NH Prof users will want access to the raw data in this format, so they can slice & dice it as they see fit, but I believe that I also need to provide a more readable form.

I started to look at how I can generate PDFs from this, and I run into a problem. I don’t have any experience doing such things, and while I don’t doubt that I could learn it, I don’t think that what is very likely to be a one off requirement is worth spending the time to really learn the topic.

Therefore, I decided to try something a little bit different. I uploaded four sample reports here. I want to see if someone can provide me with solution to convert those to a nice PDF format. 

I am going to give away one NH Prof license to the first one that can show me a solution that I can use with NH Prof.

The selected solution will also be featured in this blog, of course.

The small print: Just to be clear, some variation on the selected solution is going to end up within NH Prof. I don’t think it is a big task for someone who know what they are doing, and I believe that the NH Prof license offer is adequate compensation for that.

More posts in "Challenge" series:

  1. (13 Oct 2023) Fastest node selection metastable error state–answer
  2. (12 Oct 2023) Fastest node selection metastable error state
  3. (19 Sep 2023) Spot the bug
  4. (04 Jan 2023) what does this code print?
  5. (14 Dec 2022) What does this code print?
  6. (01 Jul 2022) Find the stack smash bug… – answer
  7. (30 Jun 2022) Find the stack smash bug…
  8. (03 Jun 2022) Spot the data corruption
  9. (06 May 2022) Spot the optimization–solution
  10. (05 May 2022) Spot the optimization
  11. (06 Apr 2022) Why is this code broken?
  12. (16 Dec 2021) Find the slow down–answer
  13. (15 Dec 2021) Find the slow down
  14. (03 Nov 2021) The code review bug that gives me nightmares–The fix
  15. (02 Nov 2021) The code review bug that gives me nightmares–the issue
  16. (01 Nov 2021) The code review bug that gives me nightmares
  17. (16 Jun 2021) Detecting livelihood in a distributed cluster
  18. (21 Apr 2020) Generate matching shard id–answer
  19. (20 Apr 2020) Generate matching shard id
  20. (02 Jan 2020) Spot the bug in the stream
  21. (28 Sep 2018) The loop that leaks–Answer
  22. (27 Sep 2018) The loop that leaks
  23. (03 Apr 2018) The invisible concurrency bug–Answer
  24. (02 Apr 2018) The invisible concurrency bug
  25. (31 Jan 2018) Find the bug in the fix–answer
  26. (30 Jan 2018) Find the bug in the fix
  27. (19 Jan 2017) What does this code do?
  28. (26 Jul 2016) The race condition in the TCP stack, answer
  29. (25 Jul 2016) The race condition in the TCP stack
  30. (28 Apr 2015) What is the meaning of this change?
  31. (26 Sep 2013) Spot the bug
  32. (27 May 2013) The problem of locking down tasks…
  33. (17 Oct 2011) Minimum number of round trips
  34. (23 Aug 2011) Recent Comments with Future Posts
  35. (02 Aug 2011) Modifying execution approaches
  36. (29 Apr 2011) Stop the leaks
  37. (23 Dec 2010) This code should never hit production
  38. (17 Dec 2010) Your own ThreadLocal
  39. (03 Dec 2010) Querying relative information with RavenDB
  40. (29 Jun 2010) Find the bug
  41. (23 Jun 2010) Dynamically dynamic
  42. (28 Apr 2010) What killed the application?
  43. (19 Mar 2010) What does this code do?
  44. (04 Mar 2010) Robust enumeration over external code
  45. (16 Feb 2010) Premature optimization, and all of that…
  46. (12 Feb 2010) Efficient querying
  47. (10 Feb 2010) Find the resource leak
  48. (21 Oct 2009) Can you spot the bug?
  49. (18 Oct 2009) Why is this wrong?
  50. (17 Oct 2009) Write the check in comment
  51. (15 Sep 2009) NH Prof Exporting Reports
  52. (02 Sep 2009) The lazy loaded inheritance many to one association OR/M conundrum
  53. (01 Sep 2009) Why isn’t select broken?
  54. (06 Aug 2009) Find the bug fixes
  55. (26 May 2009) Find the bug
  56. (14 May 2009) multi threaded test failure
  57. (11 May 2009) The regex that doesn’t match
  58. (24 Mar 2009) probability based selection
  59. (13 Mar 2009) C# Rewriting
  60. (18 Feb 2009) write a self extracting program
  61. (04 Sep 2008) Don't stop with the first DSL abstraction
  62. (02 Aug 2008) What is the problem?
  63. (28 Jul 2008) What does this code do?
  64. (26 Jul 2008) Find the bug fix
  65. (05 Jul 2008) Find the deadlock
  66. (03 Jul 2008) Find the bug
  67. (02 Jul 2008) What is wrong with this code
  68. (05 Jun 2008) why did the tests fail?
  69. (27 May 2008) Striving for better syntax
  70. (13 Apr 2008) calling generics without the generic type
  71. (12 Apr 2008) The directory tree
  72. (24 Mar 2008) Find the version
  73. (21 Jan 2008) Strongly typing weakly typed code
  74. (28 Jun 2007) Windsor Null Object Dependency Facility