I like to sort a report according to a field: number asc
This is what I get
How can I change this? I can't find a function like val(number) or format the numbers to 01, 02...
Thanks for any help
Solved! Go to Solution.
What for a field do you want to order here? When I look to your list it seems that this field is defined as a string field but not a number field. You can look for the definition of the field in the project configuration. Switch to the Plant 3D class definition of your class and look for the property which you want to use. There is a column called 'property type'. Look for the value of this column.
I like to order the field 'Number' from the class valves in the PID properties.
It is formatted as 'char' and I can't change this. So I look for an function or something that changes the field into a value in the report creator....
Do the following:
Now re-open your project in the report creator and you are able to sort the column 'Number' 'correctly'. I have attached a result of my test: Number is sorted now with 1, 2, 10 instead of 1, 10, 2.
Please, mark this case as solved if I could help you but don't hesitate to ask for further information here.
recently I had the problem of not being able to change the data type of my attributes.
Could you please post, how to change the value to other data types? (eg. boolean, string, etc..)
I am sure, this would be helpfull for a lot of users.
today I've tried to generate the report again. But all I get is the error message in the attachm.
When I look with sqlite database browser into the processpower, so there is 'number' declared as int64, like I've changed it some days ago. But in the project properties there is 'number' declared as string.
Something is wrong?!
Access a broad range of knowledge to help get the most out of your products and services.
Start with some of our most frequented solutions to get help installing your software.
The AutoCAD P&ID forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.
Upgrading to a 2015 product? Make sure to check these out 1st!