EhLib.Com
https://forum.ehlib.com/en/

PivotGrid strange behaviour
https://forum.ehlib.com/en/viewtopic.php?f=5&t=1070
Page 1 of 1

Author:  dirlligafu [ 12 Feb 2021, 04:41 ]
Post subject:  PivotGrid strange behaviour

Hello,

A friend of mine recommended me to try EHLIB for my specific needs. So I downloaded the latest version available on your site and installed it on RAD Studio 10.3.

I was looking for a pivot table and found yours to be quite easy to use and customize.
However, I encountered a strange display behaviour and an error.

1 - The display glitch only affects the first row of the grid (in red on the screenshot) : I don't understrand why the name is truncated (you can see the full name just below on the sum row) and why it is grey instead of black....

Image


2 - The second thing is, this time, an error.

When I want to apply a filter on one of the first 3 columns (Type de projet, Nom du projet, Elément du projet), if I select only one item in the list, I get the error "Type mismatch in expression".

Image

gives

Image

However, if I select 2 or more, no error and the filter works. The filtering works fine with the "data-side" of the grid in any case (green arrow)

As I am using Firedac, my friend advised me to add the ehlibfiredac unit to the use clause, but this did not solve the issue.

Any idea would be greatly appreciated.

Thanks in advance

Sincerely yours

Gilles

Author:  EhLibSupport [ 12 Feb 2021, 18:33 ]
Post subject:  Re: PivotGrid strange behaviour

Hello

Thanks for the detailed error information.

----
About error 1. the name is truncated
We'll fix it in the next build.

----
About error 2. "Type mismatch in expression".
We are unable to reproduce this error on our test projects.
Try to reproduce the error in one of the EhLib Demo projects.
- Demos\PivotGridEh.PivotDataManager
- Demos\PivotGridEh.SimpleDemo

If it doesn't work, then try to make your own Demo project.
It is not required to include the ehlibfiredac module for PivotGridEh. Filtering occurs inside the PivotGrid and does not affect the original DateSet.

Try copying your data to MemTableEh, (TMemTableEh.LoadFromDataSet)
then save the data to a file, TMemTableEh.SaveToFile.

After that, you can write a Test Application that does not depend on the database using the TMemTableEh.LoadFromFile method.

Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/