How to create a new column in Database view for report?

[alvatindra]

HI,

I have created a database view on a table, I need to create a new column in database view without creating in the main table, So that I can use the newly created column in the report which is on database view table.

How this can be achieved?

[alvatindra]

Hi Tony,

I am creating db view only on one table

[The SN Nerd]

You have to add the field to the view table.

Otherwise, add it to the relevant table and then to the database view.

As mentioned, Database Views are for the consumption of data, not for the management of data.