Best way to implement CSV reports

Andrey Kozachuk

Posted on 09/09/2015 16:03:46

Hi,

I need to implement a report generation, where user specify start and end sales dates and obtains report with the most popular products for each country (rows - products, columns - countries).

Currently I am using statistics provider for this, but requirements are becoming more complicated and data I need to generate fits statistics chart format not perfectly.

Maybe there are other tools for this? I am also considering using SSRS, but so far it is too much overhead to switch.

What is the best way to implement CSV reports with filters that are set in UI?

Replies

Nicolai Høeg Pedersen

Posted on 09/09/2015 16:06:40

Not sure I fully understand.

If you cannot use the providers, you can always build a complete custom aspx page that can do whatever you want. See here: http://devierkoeden.com/articles/custom-modules-part-5-building-modules-with-a-module-admin-page.aspx

BR Nicolai

Andrey Kozachuk

Posted on 09/09/2015 16:11:26

Hi Nicolai, I can use statistics provider, just thought that there might be another feature in DymaicWeb that I am not aware of and that fits my needs better.

Morten Snedker

Posted on 14/09/2015 10:15:54

This post has been marked as an answer

As the headline is "CSV report" I'd like to mention Data Integration as an alternative for getting the job done. If you need to extract data across multiple tables, I'd like to point to the provider Dynamicweb Provider with views. Using views you can build your own SQL and join what-ever tables you see fit. This provider is functional-wise the same as Dynamicweb Provider, but also it exposes views for data source. And CSV would the be the natural choice for destination.

Additionally, it is possible to parameterize the calling of an integration job. This means that for any one or more columns, you may put conditionals on the columns and hereby delimiting the data you wish to receive from your view. And these conditionals are set upon calling the job-URL, hence parameterizing it.

Hope the information is useful.

Best regards

/Snedker

Votes for this answer: 1

Andrey Kozachuk

Posted on 14/09/2015 11:38:44

Thank you, Morten. I have almost finished impelementation using statistics providers, but your solution loos more logical. Next time I will consider using Data Integration.

You must be logged in to post in the forum

Developer forum

Best way to implement CSV reports

Replies