Daddio,
Currently it looks at CLOSED issue status for burndown charting rendering. We will look into if this can be implemented.
Custom Reports. Yes, documentation is not good on this topic. To be honest, we have planned to do a Webcast that would show how to Create Custom Reports. In the meantime:
- Create a new WebApp Project in Visual Studio (.NET 3.5)
- Reference CounterSoft.Gemini.Commons assembly.
- Remove all files from this Project and add a User Control (.ASCX).
- In the code-behind for this User Control ensure you inherit from BaseReportControl (as this will expose things like ProjectID so your User Control knows which project you should report upon.
- Write code to pull in your data (e.g. pull issue data + anything else you need from Gemini SQL Database. Note: your code can read the Gemini Database Connection from the Gemini web.config at runtime using code snippet at the bottom of this post.
- Render your report data as required. Note: you can use Microsoft ASP.NET Charting Controls as they are FREE and we also use them.
- Then, place you .ASCX file somewhere inside Gemini web application folder, and place your ASCX.CS compiled code DLL into Gemini's "bin" folder.
- Go to Administration --> Reports and add your Report to the list.
- Go to Project Administration --> Reports and determine who can see your Report.
public static string GetDatabaseConnectionString()
{
NHibernate.Cfg.ConfigurationSchema.HibernateConfiguration nhibernateConfig = (NHibernate.Cfg.ConfigurationSchema.HibernateConfiguration)ConfigurationManager.GetSection("hibernate-configuration");
return nhibernateConfig.SessionFactory.Properties["connection.connection_string"];
}