AutoCAD P&ID

[#1]

Hello

I like to sort a report according to a field: number asc

This is what I get

1

10

11

2

3

4

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

G

[#2]

Hi Guido,

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.

Best regards

Bernd

[#3]

Hello Bernd

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....

Best regards

[#4]

Hi Guido,

Do the following:

• Make a backup of your processpower.dcf of your project (a copy is enough).
• Open the processpower.dcf with SQLite Database Browser. If you still haven't installed it, you can download it from several sites and use it for free.
• Switch to the tab 'Browse Data'.
• Select in the combo box the table 'PnPProperties'
• Search for a row with TableName = HandVentiles  and PropertyName = Number
• Change for this row the values of those columns:
• PropertyType: By default: System.String, now: System.Int64
• Length: By default: 255, now: -1
• Save the processpower.dcf

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.

Regards

Bernd

[#5]

Hi Bernd,

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.

[#6 · Accepted solution]

Hi Guido,

I have created a video here: http://screencast.com/t/fLGPRtMu

Does this help?

[#7]

Hi Bernd

that works fine

Thank you

G

[#8]

Hi Bernd

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?!

Best regards

[#9]

Hi

the reports work now after clearing PLDC

the different declaration is kept

G

[#10]