Reports in K2 Blackpearl - Not workflow reports


Hi All,

Is it possible in K2 blackpearl 4.7 to build a report using a smartbox smartobject as a data source ? I found some articles on reports but they are workflow reports but not on a general smartobjects.

For example : The smartobject I am using is similar to the below:

Employee Name      Department    Region

Ben                              HR                     Melbourne

Alex                            Finance             Sydney

John                           HR                      Sydney

 

Reports of type (Bar and Pie charts).

 

Please let me know if there is any alternative approach to build such reports.

 

Thanks

Govind


4 replies

Good day  @GovindSurnidi;


 


Please check out with this link for SmartBox Best Practices(https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/SmartBox-Best-Practices/td-p/58895?nobounce=)


 


Should you find the above information kindly mark such as "Kudo and/or Accepted Solution" .


 


Thanks & Regards;


Widson.

Good day @GovindSurnidi,


Please follow these links on how to fully create custom reports in K2 black pearl.


https://help.k2.com/files/7175
http://help.k2.com/k2lm-300uky.aspx


Kindly feel free to mark as “Accepted solution, kudo and/me too


If you find this information answered your question or leads to your answer.


Thank you and kind regards,


Dumisani


K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.


 


 


 

Userlevel 2

Hello  @GovindSurnidi,


 


I found a link with an alternative/more suitable way for you to do this in blackpearl: https://help.k2.com/onlinetraining/tutorials/default.htm#Resources/Projects/ReportingForK2/ReportingForK2CustP3Excel.htm%3FTocPath%3DReporting%2520in%2520K2%7CCustom%2520Reports%2520in%2520K2%7C_____3


 


Hope this works for you...


 


Should you find the above information useful kindly mark as "Accepted Solution and/or Kudo", as this will assist other community members looking for related information.


 


Regards,
BesM


 


[K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member]

Hi GovindSurnidi,


 


Sounds like you are looking for OData in Custom Reporting . OData Exposes SmartObjects as OData data feeds, which you can use in other applications such as Microsoft Excel and PowerPivot. This allows you to use these tools to build rich reports that include workflow reporting data (and any other SmartObject data).


 


You Can check out the below link for more information 


http://help.k2.com/onlinehelp/K2Five/UserGuide/5.3/default.htm#Create/SmartObjects/UsingSmOCustomReports.htm


 


OData Configuration & Use Data With MS Excel in Blackpearl 4.7


http://help.k2.com/onlinehelp/K2blackpearl/UserGuide/4.7/default.htm#Resources/Projects/ReportingForK2/ReportingForK2CustP4ExcelOData.htm


 


Hope this helps


 


Should you feel that this post is of use and or an accurate solution to the raised question, I kindly encourage you to mark it as such using the 'Mark as Solution', 'Kudo' andor ‘Me Too’ options.


 


Cheers,


Kate


 


K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.


 

Reply