ReportServer Forum

dudley.megaport

Member

Registered: 2016-10-06

Complex data manipulation/querying

Hi guys,

We have a need to report from our prod db, thats all fine.
I produced the reports, now business wants conditional logic, like....if customer 'A' bought but then cancelled but then reordered, mark the new order as a REORDER. From my experience, no reporting/analytics tool does this, we probably need to build that dataset as a view or plsql then report of the resulting data?
Or can tools nowadays help with filtering this type of data via scripts or something?

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: Complex data manipulation/querying

Hi Dudley,

this is really difficult to say without additional information. Depending on the choice of reporting engine you can do conditional logic in the report. For example, jasper, BIRT or Crystal reports would support conditional logic to some extend. In Dynamic Lists you can use computed columns for that purpose but the logic that can be implemented there is rather limited. If you have a dedicated data warehouse then such logic might be best placed there as this allows you to then access it from any report and also in ad-hoc queries. So, it really depends on the particular use case where to best place the conditional logic.

Cheers,
Thomas

jar

Member

Registered: 2013-08-08

Re: Complex data manipulation/querying

With OpenRefine (http://openrefine.org) it is very easy to make that kind of transformation on a datafile but is has to be repeated with every update...

You could use R (https://www.r-project.org) to do this with relative ease and it is reproducable with daily or weekly updates.

Jeroen