Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • I need the ability to do some string manipulation with calculated fields in the end user designer - so that my customers can do certain things when designing their own reports.

                                    1) I need to be able to concatenate strings, which I can't see to do in a calculated field.
                                    2) I need to be able to change a string to a double, so that I can take two string fields that contain a numeric value and be able to do a numeric caluclation (such as multiply) and get a double as a result.

                                0

                                Hello Charles,

                                1) You can use the Concat function to merge string values. For example:

                                        Concat([dataField1], ' ', [dataField2])

                                2) I'm afraid that there is no standard capability to convert a string type field to the double type in the calculated field. Please use double type fields to be able to perform mathematical operations in them. Anyway, you are welcome to post a suggestion regarding this capability to our Support Center if you really need this feature.

                                Please review a sample project in the attachment and let me know how it goes.

                                Thanks,
                                Alessandro.

                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, ASP.NET, WinForms, HTML5 or Windows 10, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2017 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners