[rundyz]

Hi,

Using PM 2.5.2, and now it seems report tables are no longer in rp_<Workflow> and my report_table table is also empty.
I can see that the report tables are created as a variation of a PM Table (PMTReportTable) but I cannot determine which of these PMT* are report tables and which are not.

Please advise.

[liliana]

Hi,

You have the option to define where your report tables will be stored (see image attached), by default they are stored inside your wf_workflow database, choose REPORT to have them stored inside your rp_workflow database. There is no way to determine which one is a PM table and which one a report table, I suggest you to create your report tables by using the REPORT word.


Regards,

[rundyz]

Thankyou that helps me, I can just put them in the report db,

Just not sure how PM knows though, inside the designer it only shows the report tables, maybe in the process definition?

Anyhow, Thankyou very very much for your assistance

[liliana]

In the process definition, that's why you have your report tables definition either in your designer and inside your admin.

Glad the information helps you.

Regards,

[stsrh456]

HI,

Regarding this post, how to select data from report table? I already put query in SQL part in dynaform field. But it doesnt work.