Database view creation for report generation

[Manu143]

Hi Community,

   I have one query on:  how to create the database view for generating the report.I need to generate the report for :

1.I have created yes/no type varaible for specific catalog item .

2.If the total amount filed on catalog form will be >= 100k dollar need to flag that yes /no time variable  for reporting purpose.

3.For newly created RITMS I have achieved this using client script but for existing RITMS need to create data base view .Specifically what should be the tables, prefix, and where clause while creating the database to achieve this ?

4.Please guide me how to achieve this one?

Thanks,

Manu

[Dr Atul G- LNG]

Hi @Manu143 

1.I have created yes/no type varaible for specific catalog item .

Atul: Okay, understood.

2.If the total amount filed on catalog form will be >= 100k dollar need to flag that yes /no time variable  for reporting purpose.

Atul: Report will give you the result based on data has been entered. In your case seems you want to change the variable Yes or NO in report which is not possible.

3.For newly created RITMS I have achieved this using client script but for existing RITMS need to create data base view .Specifically what should be the tables, prefix, and where clause while creating the database to achieve this ?

Atul: NO Database view is required. You can report variables on report as well.

4.Please guide me how to achieve this one?