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.

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.