Hi,I've recently upgraded the PivotGrid Suite to version 2011 vol 2.3 from the build v2.57 and I had to do some changes to fit my own code onto the changes brought by the new version.
I'm using the PivotGrid in OLAP mode and previously all the measures were displayed in the proper format (currency, float etc.) but now it displays the values without any formatting.
I've attached an image showing the behavior and a back up of my OLAP data source (Analysis Services).
Can you kindly explain why is this happening?Am I doing missing something?
I need to know how to get it to work.
Thanks in advance,
best regards
OLAP mode - Pivot does not apply the CrossCells currency format automatically
Answers approved by DevExpress Support
created 12 years ago
(modified 12 years ago)
We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.
Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.
- v13.1.2Download Official Update
- v12.2.4Download Official Update
- v12.1.8Download Official Update
- v11.2.9Download Official Update
Hello,
Thank you for your message. I should say that v2011 vol 2.3 is an old version of our controls that may contain issues fixed in the latest versions (e.g., the Data-aware container controls - Format settings are not applied to cells critical issue). I suggest you consider migrating to the latest version of our controls (VCL 12.2.3). The problem seems to be solved there.
OK, I've spent the entire morning on setting up the projectgroup to build all the sources of the QuantumGrid suite + PivotGrid, building them and recompile my own application.
Guess what? I still can't get the right format for any OLAP measures. Have you tested it prior to tell me to use the new version?
Now, this problem is causing me a lot of trouble with my own customers and I need to solve it urgently!!
I'm waiting for a solution ASAP.
Hello,
Please accept my sincere apologies for not being helpful in my previous post. Of course, I have tested the backup on my demo project. When I set the <MeasureField>.DisplayFormat property to '$,0.00;($,0.00)', display values were immediately formatted (see the attached image). It seems that I have misunderstood the issue. I suspect that you mean the fact that values should be formatted automatically after loading data based on the source cube. Am I right?
Hi Paulo,
thanks for the quick response.
In the development of my OLAP DB structure I'm using "Currency" as FormatString property for the measures. With the last versions of the PivotGrid, this format had always worked out.
Now, if you see my point, my customers have Olap DB with measures formatted like that. Modifying all the DBs deployed because of an upgrade meant to solve a visualization bug of the PivotGrid but introducing changes in the data source, will cost me time and money.
Is there nothing you can do to fix this bug?
Hello,
Thank you for your reply. I have forwarded this ticket to our developers for research. Perhaps, they can find a solution. It can take additional time to completely examine the issue.
We appreciate your patience.
Sorry Paulo but i don't want that any mistake grows on this issue.
When I say "FormatString" I refer to the property of the fields in my Sql Server Analysis Services DB (see the attachment). This is a property unbound to the PivotGrid "DisplayFormat" property.
I can't set the PG "DisplayFormat" property for all the currency measures in a DB because each one of my customers has his own custom measures, so I can't modify my code for every instance of my application.
I've even tried to set "FormatString" with the string you suggested earlier ( '$,0.00;($,0.00)' ) but the problem yet happens.
I'm waiting for a fix.
thank you.
Thank you for your additional information. I understand that the problem lies in handling the Analysis Services FormatString. Our developers will do their best to examine the issue as soon as they can.
Hi Paulo,
thanks to you and to the DevX team for the quick response. I've tested the PG and now is showing currency values properly.
Nevertheless there are some minor deficiencies: the FormatString property retrieved on "MEASURE_DISPLAY_FOLDER" field of my DB schema is still ignored in any other case except "Currency" value.
For example: "Currency" is giving me back values in euros and this is correct but if FormatString is setted to "$ #,##0.00;-$ #,##0.00", the PG still don't gets this information.
So I made some changes…
I created the "DisplayFormat" property directly on the TcxPivotGridOLAPStructureNode class in order to store this information and pass it to the PivotGrid if necessary.
The function "GetActualDisplayFormat" will check if the "DisplayFormat" is valorized and, if so, returns the right format.
If you want I can send you my new source files (cxCustomPivotGrid.pas and cxPivotGridOLAPDataSource.pas).
Thanks
Hello,
Thank you for informing us that the problem is now resolved. Of course, I would appreciate your sending sources to us. It would be even better if you also provide us with a cube (or a DataBase backup) where format is "$ #,##0.00;-$ #,##0.00".