Correct Way of Creating Commerce Reports

Vote:
 

Hi

We have a requirement to create some bespoke products/orders related reports in our commerce website.

We have used the following process in the past

https://world.episerver.com/documentation/developer-guides/commerce/reports/Creating-custom-reports/

https://world.episerver.com/articles/Items/Reporting-options-in-EPiServer-Commerce-Manager/

However the above has been marked as [Legacy] in the documenation.

Could you please guide me towards the latest/correct way of creating the above reports.

Do we now use the following way mentioned in the CMS documentation -

https://world.episerver.com/documentation/developer-guides/CMS/creating-custom-reports/

Thanks

Kind regards

Sandeep

#197791
Oct 13, 2018 0:59
Vote:
 

You can continue using the reports in Commerce Manager. However they are not the best - both in term of UI or customization to use. We are working on a new report system which is much better, but it will take a while 

#197792
Oct 13, 2018 7:44
Vote:
 

DO you recomend using the method specified in this post

https://world.episerver.com/documentation/developer-guides/CMS/creating-custom-reports/

or is it for cms reports not commerce

#197798
Oct 13, 2018 22:07
Vote:
 

Commerce reports, are they are right now, are different with CMS reports and therefore different from the link you posted. You can only do it by 

https://world.episerver.com/articles/Items/Reporting-options-in-EPiServer-Commerce-Manager/ 

#197811
Oct 15, 2018 6:55
Vote:
 

Thank you very much for confirming. 

Kind Regards

Sandeep

#197828
Oct 15, 2018 11:20
Vote:
 

Hi Quan

I have finally got my head around creating custom report and got a few new ones to work. 

I had a quick query. Is there any way to get the code behind files for all the default reports which are available in Commerce manager. 

We are particularly looking for the Sale report - 

Mediachase.Commerce.Manager.Apps.Reporting.SalesReport

SalesReport.ascx

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="SalesReport.ascx.cs"
Inherits="Mediachase.Commerce.Manager.Apps.Reporting.SalesReport" %>

We can write all ourselves but we just need to make a slight modfication and it would be a lot of effort to wrtie it from scratch.

Kind Regards

Sandeep

#198082
Oct 20, 2018 9:25
Vote:
 

Hi Quan

I have managed to get the code using dot peek.

Thanks

Sandeep

#198084
Oct 20, 2018 9:40
Vote:
 

Hi Quan

There are three default tempaltes provided in the sample project which are hidden by default. Once un-commented they show in the left menu.

They use the following stored procs - 

ecf_reporting_NewAccounts
ecf_reporting_CustomerOrderTotals
ecf_reporting_CustomerNumOrders

These stored procedures do not seem to be present in the DB. Do we need to create these our selves or can we get these from somewhere.

Kind Regards

Sandeep

#198088
Oct 21, 2018 21:17
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.