It's possible to use WebDataRocks for simples reports?


It’s possible to use WebDataRocks for simples reports without pivot?
I’d like to use WDR to make simple reports from my system, however, I’m having a hard time understanding how to do this as it always works by aggregating the data.

11 answers

WebDataRocks Team WebDataRocks June 3, 2019

Hello, Vagner Le Roy,

Thank you for writing to us!

WebDataRocks provides three types of layout which help you present the data in different ways:

  • Classic
  • Compact
  • Flat

For your case, the best option is to use the flat form of the pivot table. It displays the raw (non-aggregated) data on the grid. You can add as many fields as you need, define their order and generate simple reports.
We’ve prepared a list of demos which you, hopefully, may find useful:
Displaying the data on the flat grid

The flat table with conditional formatting
Additionally, to look at your data from multiple angles simultaneously, you can create a dashboard with two instances of the pivot table – one in a compact form, the other in a flat form and make the flat grid react to the changes of the report from the first instance.
You are welcome to read more about the pivot table’s options and how to set them in our documentation.
Hope this is helpful for you.
Best regards,
WebDataRocks Team

Vagner Le Roy June 7, 2019

Thank you so much for your answer!
However, the system is experiencing this error when Angular 4 compiles the code:
error TS2345: Argument of type ‘{ “dataSource”: { “data”: any; }; “slice”: { “rows”: { “uniqueName”: string; “sort”: string; }[];…’ is not assignable to parameter of type ‘Report’
Here in the compiler the error appears when you add the string “sort: ‘unsorted'” to the rows object (see attached image).
Thank you so much again!


WebDataRocks Team WebDataRocks June 13, 2019

Hello Vagner Le Roy,
Thank you for giving us some time.
We have updated webdatarocks.d.ts to support sort property in the slice, so you are welcome to update types file and the issue should be resolved.
WebDataRocks Team

Vagner Le Roy June 13, 2019

The attached error is now appearing!


WebDataRocks Team WebDataRocks June 14, 2019

Hello Vagner,
Could you please share your project sample, so that we can investigate it and recommend the fix?
WebDataRocks Team

Vagner Le Roy June 21, 2019

Of course, the files are attached


WebDataRocks Team WebDataRocks June 24, 2019

Hello Vagner,
It seems that flatOrder property was missing in .d.ts.
You can get an updated .d.ts file from our GitHub.
WebDataRocks Team

Vagner Le Roy June 24, 2019

First, thanks for the support!
After updating the project with the latest version, it has the following error attached!


WebDataRocks Team WebDataRocks July 1, 2019

Hello Vagner,
Thank you for the screenshot.
Actually, we have double checked latest d.ts with your code and it seems working as expected.
Could you please share an updated sample to reproduce the issue on our side?
WebDataRocks Team

Vagner Le Roy July 2, 2019

The files are attached!


WebDataRocks Team WebDataRocks July 5, 2019

Hello Vagner,
We have looked through your report sample and everything works as expected.
Here is the example with our sample angular project.
WebDataRocks Team