Database View - Default Columns in Reports

Elizabeth26
Tera Contributor

I have a database view that I created with 3 table and no fields specified (so it shows all fields from each table).

When I go to reports and pull up the database view it has 7 fields defaulted. These fields are useless to my users. How can I change the default for all users for the columns in reports?

 

Thank you.

1 ACCEPTED SOLUTION

Hi,
Same way. Open your db view from the Application Navigator filter: <db_view>.LIST
The from the list, right click column headers to get the menu. Then
Configure -> List Layout

NiklasPeterson_0-1692643708535.png

 



Regards,
Niklas

View solution in original post

4 REPLIES 4

Niklas Peterson
Mega Sage
Mega Sage

Hi @Elizabeth26 ,

A database view list can be modified as any other list using

Configure -> List Layout

Regards,
Niklas

Where do I do that from?

I know where for a regular table but not sure for a DB view?

Hi,
Same way. Open your db view from the Application Navigator filter: <db_view>.LIST
The from the list, right click column headers to get the menu. Then
Configure -> List Layout

NiklasPeterson_0-1692643708535.png

 



Regards,
Niklas

Thank you. I didn't realize you could open DB view the same way as a table 🙂 I appreciate the help.